APPS.IGI_ITR_APPROVAL_PKG dependencies on IGI_ITR_CHARGE_LINES

Line 93: UPDATE igi_itr_charge_lines

89:
90:
91: -- Update the status of the service line to 'W'
92: -- Awaiting creation approval
93: UPDATE igi_itr_charge_lines
94: SET status_flag = 'W'
95: ,submit_date = sysdate
96: WHERE it_header_id = p_cc_id
97: AND it_line_num = p_cc_line_num;

Line 442: FROM igi_itr_charge_lines itrl

438: INTO l_cc_line_tot
439: ,l_service_line_id
440: ,l_charge_center_name
441: ,l_charge_service_name
442: FROM igi_itr_charge_lines itrl
443: ,igi_itr_service servi
444: ,igi_itr_charge_center cc
445: ,igi_itr_charge_service serv
446: WHERE itrl.it_header_id = l_cross_charge_id

Line 814: UPDATE IGI_ITR_CHARGE_LINES

810:
811: --
812: -- Set status of Cross Charge Line to 'V' for 'Awaiting Receiver Approval'
813:
814: UPDATE IGI_ITR_CHARGE_LINES
815: SET status_flag = 'V'
816: WHERE it_header_id = l_cross_charge_id
817: AND it_line_num = l_cc_line_num;
818:

Line 869: UPDATE IGI_ITR_CHARGE_LINES

865:
866: --
867: -- Set status of Cross Charge Line to 'J' for 'Rejected in Creation'
868:
869: UPDATE IGI_ITR_CHARGE_LINES
870: SET status_flag = 'J'
871: WHERE it_header_id = l_cross_charge_id
872: AND it_line_num = l_cc_line_num;
873:

Line 941: ,igi_itr_charge_lines itrl

937:
938: SELECT auth.authoriser_id
939: INTO l_rec_fnd_user_id
940: FROM igi_itr_charge_ranges auth
941: ,igi_itr_charge_lines itrl
942: WHERE itrl.it_header_id = l_cross_charge_id
943: AND itrl.it_line_num = l_cc_line_num
944: AND itrl.charge_range_id = auth.charge_range_id;
945:

Line 1307: UPDATE IGI_ITR_CHARGE_LINES

1303:
1304: --
1305: -- Set status of Cross Charge Line to 'A' for 'Approved'
1306:
1307: UPDATE IGI_ITR_CHARGE_LINES
1308: SET status_flag = 'A'
1309: WHERE it_header_id = l_cross_charge_id
1310: AND it_line_num = l_cc_line_num;
1311:

Line 1367: UPDATE IGI_ITR_CHARGE_LINES

1363: aname => 'CC_LINE_NUM');
1364:
1365: -- change status of cross charge line to 'R' for 'Rejected by Receiver'
1366:
1367: UPDATE IGI_ITR_CHARGE_LINES
1368: SET status_flag = 'R'
1369: WHERE it_header_id = l_cross_charge_id
1370: AND it_line_num = l_cc_line_num;
1371: