APPS.ARP_MAINTAIN_PS dependencies on ARP_MAINTAIN_PS2

Line 139: close_cursor( arp_maintain_ps2.ips_insert_ps_c );

135:
136: PROCEDURE close_cursors IS
137: BEGIN
138:
139: close_cursor( arp_maintain_ps2.ips_insert_ps_c );
140: close_cursor( arp_maintain_ps2.ips_select_c );
141:
142: close_cursor( arp_maintain_ps2.ira_insert_ps_c );
143: close_cursor( arp_maintain_ps2.ira_insert_ra_c );

Line 140: close_cursor( arp_maintain_ps2.ips_select_c );

136: PROCEDURE close_cursors IS
137: BEGIN
138:
139: close_cursor( arp_maintain_ps2.ips_insert_ps_c );
140: close_cursor( arp_maintain_ps2.ips_select_c );
141:
142: close_cursor( arp_maintain_ps2.ira_insert_ps_c );
143: close_cursor( arp_maintain_ps2.ira_insert_ra_c );
144: close_cursor( arp_maintain_ps2.ira_update_ps_c );

Line 142: close_cursor( arp_maintain_ps2.ira_insert_ps_c );

138:
139: close_cursor( arp_maintain_ps2.ips_insert_ps_c );
140: close_cursor( arp_maintain_ps2.ips_select_c );
141:
142: close_cursor( arp_maintain_ps2.ira_insert_ps_c );
143: close_cursor( arp_maintain_ps2.ira_insert_ra_c );
144: close_cursor( arp_maintain_ps2.ira_update_ps_c );
145: close_cursor( arp_maintain_ps2.ira_select_c );
146:

Line 143: close_cursor( arp_maintain_ps2.ira_insert_ra_c );

139: close_cursor( arp_maintain_ps2.ips_insert_ps_c );
140: close_cursor( arp_maintain_ps2.ips_select_c );
141:
142: close_cursor( arp_maintain_ps2.ira_insert_ps_c );
143: close_cursor( arp_maintain_ps2.ira_insert_ra_c );
144: close_cursor( arp_maintain_ps2.ira_update_ps_c );
145: close_cursor( arp_maintain_ps2.ira_select_c );
146:
147: close_cursor( arp_maintain_ps2.ups_insert_adj_c );

Line 144: close_cursor( arp_maintain_ps2.ira_update_ps_c );

140: close_cursor( arp_maintain_ps2.ips_select_c );
141:
142: close_cursor( arp_maintain_ps2.ira_insert_ps_c );
143: close_cursor( arp_maintain_ps2.ira_insert_ra_c );
144: close_cursor( arp_maintain_ps2.ira_update_ps_c );
145: close_cursor( arp_maintain_ps2.ira_select_c );
146:
147: close_cursor( arp_maintain_ps2.ups_insert_adj_c );
148: close_cursor( arp_maintain_ps2.ups_update_ps_c );

Line 145: close_cursor( arp_maintain_ps2.ira_select_c );

141:
142: close_cursor( arp_maintain_ps2.ira_insert_ps_c );
143: close_cursor( arp_maintain_ps2.ira_insert_ra_c );
144: close_cursor( arp_maintain_ps2.ira_update_ps_c );
145: close_cursor( arp_maintain_ps2.ira_select_c );
146:
147: close_cursor( arp_maintain_ps2.ups_insert_adj_c );
148: close_cursor( arp_maintain_ps2.ups_update_ps_c );
149: close_cursor( arp_maintain_ps2.ups_select_c );

Line 147: close_cursor( arp_maintain_ps2.ups_insert_adj_c );

143: close_cursor( arp_maintain_ps2.ira_insert_ra_c );
144: close_cursor( arp_maintain_ps2.ira_update_ps_c );
145: close_cursor( arp_maintain_ps2.ira_select_c );
146:
147: close_cursor( arp_maintain_ps2.ups_insert_adj_c );
148: close_cursor( arp_maintain_ps2.ups_update_ps_c );
149: close_cursor( arp_maintain_ps2.ups_select_c );
150:
151: close_cursor( arp_maintain_ps2.iad_insert_adj_c );

Line 148: close_cursor( arp_maintain_ps2.ups_update_ps_c );

144: close_cursor( arp_maintain_ps2.ira_update_ps_c );
145: close_cursor( arp_maintain_ps2.ira_select_c );
146:
147: close_cursor( arp_maintain_ps2.ups_insert_adj_c );
148: close_cursor( arp_maintain_ps2.ups_update_ps_c );
149: close_cursor( arp_maintain_ps2.ups_select_c );
150:
151: close_cursor( arp_maintain_ps2.iad_insert_adj_c );
152: close_cursor( arp_maintain_ps2.iad_update_ps_c );

Line 149: close_cursor( arp_maintain_ps2.ups_select_c );

145: close_cursor( arp_maintain_ps2.ira_select_c );
146:
147: close_cursor( arp_maintain_ps2.ups_insert_adj_c );
148: close_cursor( arp_maintain_ps2.ups_update_ps_c );
149: close_cursor( arp_maintain_ps2.ups_select_c );
150:
151: close_cursor( arp_maintain_ps2.iad_insert_adj_c );
152: close_cursor( arp_maintain_ps2.iad_update_ps_c );
153: close_cursor( arp_maintain_ps2.iad_select_c );

Line 151: close_cursor( arp_maintain_ps2.iad_insert_adj_c );

147: close_cursor( arp_maintain_ps2.ups_insert_adj_c );
148: close_cursor( arp_maintain_ps2.ups_update_ps_c );
149: close_cursor( arp_maintain_ps2.ups_select_c );
150:
151: close_cursor( arp_maintain_ps2.iad_insert_adj_c );
152: close_cursor( arp_maintain_ps2.iad_update_ps_c );
153: close_cursor( arp_maintain_ps2.iad_select_c );
154:
155: END;

Line 152: close_cursor( arp_maintain_ps2.iad_update_ps_c );

148: close_cursor( arp_maintain_ps2.ups_update_ps_c );
149: close_cursor( arp_maintain_ps2.ups_select_c );
150:
151: close_cursor( arp_maintain_ps2.iad_insert_adj_c );
152: close_cursor( arp_maintain_ps2.iad_update_ps_c );
153: close_cursor( arp_maintain_ps2.iad_select_c );
154:
155: END;
156:

Line 153: close_cursor( arp_maintain_ps2.iad_select_c );

149: close_cursor( arp_maintain_ps2.ups_select_c );
150:
151: close_cursor( arp_maintain_ps2.iad_insert_adj_c );
152: close_cursor( arp_maintain_ps2.iad_update_ps_c );
153: close_cursor( arp_maintain_ps2.iad_select_c );
154:
155: END;
156:
157:

Line 3247: arp_maintain_ps2.insert_inv_ps_private(

3243:
3244: --------------------------------------------------------------
3245: -- araips: call raaips
3246: --------------------------------------------------------------
3247: arp_maintain_ps2.insert_inv_ps_private(
3248: system_info,
3249: profile_info,
3250: l_control_rec.customer_trx_id,
3251: l_control_rec.reversed_cash_receipt_id );

Line 3260: arp_maintain_ps2.insert_child_adj_private(

3256: ----------------------------------------------------------
3257: -- araips: call raaups to insert adjustments for
3258: -- commitment invoices
3259: ----------------------------------------------------------
3260: arp_maintain_ps2.insert_child_adj_private(
3261: system_info,
3262: profile_info,
3263: l_control_rec.customer_trx_id );
3264:

Line 3422: arp_standard.debug(' arp_maintain_ps2.insert_cm_child_adj_private+');

3418:
3419: ----------------------------------------------------------
3420: -- araiad: create adj, update ps
3421: ----------------------------------------------------------
3422: arp_standard.debug(' arp_maintain_ps2.insert_cm_child_adj_private+');
3423: arp_maintain_ps2.insert_cm_child_adj_private(
3424: system_info,
3425: profile_info,
3426: l_control_rec.customer_trx_id );

Line 3423: arp_maintain_ps2.insert_cm_child_adj_private(

3419: ----------------------------------------------------------
3420: -- araiad: create adj, update ps
3421: ----------------------------------------------------------
3422: arp_standard.debug(' arp_maintain_ps2.insert_cm_child_adj_private+');
3423: arp_maintain_ps2.insert_cm_child_adj_private(
3424: system_info,
3425: profile_info,
3426: l_control_rec.customer_trx_id );
3427: arp_standard.debug(' arp_maintain_ps2.insert_cm_child_adj_private-');

Line 3427: arp_standard.debug(' arp_maintain_ps2.insert_cm_child_adj_private-');

3423: arp_maintain_ps2.insert_cm_child_adj_private(
3424: system_info,
3425: profile_info,
3426: l_control_rec.customer_trx_id );
3427: arp_standard.debug(' arp_maintain_ps2.insert_cm_child_adj_private-');
3428:
3429:
3430: ----------------------------------------------------------
3431: -- Update adjustments with document number

Line 3486: arp_standard.debug(' arp_maintain_ps2.insert_cm_ps_private+');

3482:
3483: END IF;
3484:
3485: -- araira: create cm ps, apps
3486: arp_standard.debug(' arp_maintain_ps2.insert_cm_ps_private+');
3487: arp_maintain_ps2.insert_cm_ps_private(
3488: system_info,
3489: profile_info,
3490: l_control_rec.customer_trx_id );

Line 3487: arp_maintain_ps2.insert_cm_ps_private(

3483: END IF;
3484:
3485: -- araira: create cm ps, apps
3486: arp_standard.debug(' arp_maintain_ps2.insert_cm_ps_private+');
3487: arp_maintain_ps2.insert_cm_ps_private(
3488: system_info,
3489: profile_info,
3490: l_control_rec.customer_trx_id );
3491: arp_standard.debug(' arp_maintain_ps2.insert_cm_ps_private-');

Line 3491: arp_standard.debug(' arp_maintain_ps2.insert_cm_ps_private-');

3487: arp_maintain_ps2.insert_cm_ps_private(
3488: system_info,
3489: profile_info,
3490: l_control_rec.customer_trx_id );
3491: arp_standard.debug(' arp_maintain_ps2.insert_cm_ps_private-');
3492:
3493:
3494: END IF;
3495: