Advertisement
Guest User

Untitled

a guest
Oct 26th, 2016
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.40 KB | None | 0 0
  1. for i in 1 .. p_in_util_data_list(j).factlist.count LOOP
  2. SELECT count(*)
  3. INTO v_non_factor_exists
  4. FROM engine_usage_factors
  5. WHERE usage_month = v_usage_month
  6. AND contract_seq_id = p_in_contractId
  7. AND engine_serial_number = p_in_util_data_list(j).esn
  8. AND nvl(upper(subfleet_id), 'X') =
  9. nvl(upper(p_in_util_data_list(j).fleet), 'X')
  10. AND nvl(upper(tail_number), 'X') =
  11. nvl(upper(p_in_util_data_list(j).tail), 'X')
  12. AND nvl(upper(factor_name), 'X') =
  13. nvl(upper(p_in_util_data_list(j).factlist(i).name), 'X')
  14. AND avg_flag = 'N'
  15. AND recon_ind = 0;
  16.  
  17. IF v_non_factor_exists > 0 THEN
  18. DELETE FROM engine_usage_factors
  19. WHERE usage_month = v_usage_month
  20. AND contract_seq_id = p_in_contractId
  21. AND engine_serial_number = p_in_util_data_list(j).esn
  22. AND nvl(upper(subfleet_id), 'X') =
  23. nvl(upper(p_in_util_data_list(j).fleet), 'X')
  24. AND nvl(upper(tail_number), 'X') =
  25. nvl(upper(p_in_util_data_list(j).tail), 'X')
  26. AND nvl(upper(factor_name), 'X') =
  27. nvl(upper(p_in_util_data_list(j).factlist(i).name),
  28. 'X')
  29. AND avg_flag = 'N'
  30. AND recon_ind = 0;
  31. COMMIT;
  32. END IF;
  33.  
  34. IF UPPER(P_IN_UTIL_DATA_LIST(J).FACTLIST(I).NAME) = 'THRUST' THEN
  35. V_VALUE := 0;
  36. ELSE
  37. V_VALUE := P_IN_UTIL_DATA_LIST(J).FACTLIST(I).VALUE;
  38. END IF;
  39.  
  40.  
  41. IF UPPER(p_in_util_data_list(j).factlist(i).name) = 'THRUST' THEN
  42.  
  43.  
  44.  
  45. UPDATE engine_usage
  46. SET THRUST_RATING = p_in_util_data_list(j).factlist(i)
  47. .value,
  48. last_updated_by = p_in_login_id,
  49. last_update_date = sysdate
  50. WHERE usage_month = v_usage_month
  51. AND engine_serial_number =
  52. trim(p_in_util_data_list(j).esn)
  53. AND recon_ind = 0
  54. AND from_date = v_from_date
  55. AND contract_seq_id = p_in_contractId
  56. AND hybrid_payment_type = p_in_billingType;
  57. COMMIT;
  58.  
  59.  
  60.  
  61. v_value := 0;
  62.  
  63. END IF;
  64.  
  65. INSERT INTO engine_usage_factors
  66. (usage_month,
  67. contract_seq_id,
  68. engine_serial_number,
  69. subfleet_id,
  70. tail_number,
  71. factor_name,
  72. factor_value,
  73. recon_ind,
  74. from_date,
  75. avg_flag,
  76. created_by,
  77. created_date,
  78. last_updated_by,
  79. last_update_date)
  80. values
  81. (v_usage_month,
  82. p_in_contractId,
  83. p_in_util_data_list(j).esn,
  84. p_in_util_data_list(j).fleet,
  85. NVL(p_in_util_data_list(j).tail, 'DUMMY'),
  86. p_in_util_data_list(j).factlist(i).name,
  87. v_value,
  88. 0,
  89. v_from_date,
  90. 'N',
  91. p_in_login_id,
  92. sysdate,
  93. p_in_login_id,
  94. sysdate);
  95.  
  96. commit;
  97. END LOOP;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement