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 3198: arp_maintain_ps2.insert_inv_ps_private(

3194:
3195: --------------------------------------------------------------
3196: -- araips: call raaips
3197: --------------------------------------------------------------
3198: arp_maintain_ps2.insert_inv_ps_private(
3199: system_info,
3200: profile_info,
3201: l_control_rec.customer_trx_id,
3202: l_control_rec.reversed_cash_receipt_id );

Line 3211: arp_maintain_ps2.insert_child_adj_private(

3207: ----------------------------------------------------------
3208: -- araips: call raaups to insert adjustments for
3209: -- commitment invoices
3210: ----------------------------------------------------------
3211: arp_maintain_ps2.insert_child_adj_private(
3212: system_info,
3213: profile_info,
3214: l_control_rec.customer_trx_id );
3215:

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

3352:
3353: ----------------------------------------------------------
3354: -- araiad: create adj, update ps
3355: ----------------------------------------------------------
3356: arp_standard.debug(' arp_maintain_ps2.insert_cm_child_adj_private+');
3357: arp_maintain_ps2.insert_cm_child_adj_private(
3358: system_info,
3359: profile_info,
3360: l_control_rec.customer_trx_id );

Line 3357: arp_maintain_ps2.insert_cm_child_adj_private(

3353: ----------------------------------------------------------
3354: -- araiad: create adj, update ps
3355: ----------------------------------------------------------
3356: arp_standard.debug(' arp_maintain_ps2.insert_cm_child_adj_private+');
3357: arp_maintain_ps2.insert_cm_child_adj_private(
3358: system_info,
3359: profile_info,
3360: l_control_rec.customer_trx_id );
3361: arp_standard.debug(' arp_maintain_ps2.insert_cm_child_adj_private-');

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

3357: arp_maintain_ps2.insert_cm_child_adj_private(
3358: system_info,
3359: profile_info,
3360: l_control_rec.customer_trx_id );
3361: arp_standard.debug(' arp_maintain_ps2.insert_cm_child_adj_private-');
3362:
3363:
3364: ----------------------------------------------------------
3365: -- Update adjustments with document number

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

3416:
3417: END IF;
3418:
3419: -- araira: create cm ps, apps
3420: arp_standard.debug(' arp_maintain_ps2.insert_cm_ps_private+');
3421: arp_maintain_ps2.insert_cm_ps_private(
3422: system_info,
3423: profile_info,
3424: l_control_rec.customer_trx_id );

Line 3421: arp_maintain_ps2.insert_cm_ps_private(

3417: END IF;
3418:
3419: -- araira: create cm ps, apps
3420: arp_standard.debug(' arp_maintain_ps2.insert_cm_ps_private+');
3421: arp_maintain_ps2.insert_cm_ps_private(
3422: system_info,
3423: profile_info,
3424: l_control_rec.customer_trx_id );
3425: arp_standard.debug(' arp_maintain_ps2.insert_cm_ps_private-');

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

3421: arp_maintain_ps2.insert_cm_ps_private(
3422: system_info,
3423: profile_info,
3424: l_control_rec.customer_trx_id );
3425: arp_standard.debug(' arp_maintain_ps2.insert_cm_ps_private-');
3426:
3427:
3428: END IF;
3429: