APPS.IGI_ITR_TIMEOUT_PKG dependencies on IGI_ITR_CHARGE_LINES

Line 120: FROM igi_itr_charge_lines lines

116: p_timeout_days NUMBER,
117: p_header_id igi_itr_charge_headers.it_header_id%type )--shsaxena
118: IS
119: SELECT it_service_line_id
120: FROM igi_itr_charge_lines lines
121: WHERE lines.set_of_books_id = p_set_of_books_id
122: AND sysdate > (lines.submit_date + p_timeout_days)
123: AND lines.status_flag = 'V'
124: AND lines.it_header_id=p_header_id;

Line 130: SELECT Distinct it_header_id from igi_itr_charge_lines lines

126: /*shsaxena for bug no 2782312*/
127: CURSOR c_header_id (p_set_of_books_id NUMBER,
128: p_timeout_days NUMBER)
129: IS
130: SELECT Distinct it_header_id from igi_itr_charge_lines lines
131: WHERE lines.set_of_books_id = p_set_of_books_id
132: AND sysdate > (lines.submit_date + p_timeout_days)
133: AND lines.status_flag = 'V';
134: /*shsaxena for bug no 2782312*/

Line 138: l_it_header_id igi_itr_charge_lines.it_header_id%type; --shsaxena for bug 2782312

134: /*shsaxena for bug no 2782312*/
135:
136:
137: l_it_service_line_id NUMBER;
138: l_it_header_id igi_itr_charge_lines.it_header_id%type; --shsaxena for bug 2782312
139: l_sequence_num NUMBER;
140: l_rec_fnd_user_id NUMBER;
141: l_user_id NUMBER := fnd_global.user_id;
142: l_conc_login_id NUMBER := fnd_global.conc_login_id;

Line 210: UPDATE igi_itr_charge_lines

206: FETCH c_get_waiting_services INTO l_it_service_line_id;
207: EXIT WHEN c_get_waiting_services%NOTFOUND;
208:
209:
210: UPDATE igi_itr_charge_lines
211: SET status_flag = 'A'
212: ,last_updated_by = l_user_id
213: ,last_update_login = l_conc_login_id
214: ,last_update_date = sysdate

Line 237: ,igi_itr_charge_lines itrl

233:
234: SELECT auth.authoriser_id
235: INTO l_rec_fnd_user_id
236: FROM igi_itr_charge_ranges auth
237: ,igi_itr_charge_lines itrl
238: WHERE itrl.it_service_line_id = l_it_service_line_id
239: AND itrl.charge_range_id = auth.charge_range_id;
240:
241: