21: iad_select_c INTEGER;
22:
23:
24: PROCEDURE insert_inv_ps_private(
25: p_system_info IN arp_trx_global.system_info_rec_type,
26: p_profile_info IN arp_trx_global.profile_rec_type,
27: p_customer_trx_id IN BINARY_INTEGER,
28: p_reversed_cash_receipt_id IN BINARY_INTEGER );
29:
22:
23:
24: PROCEDURE insert_inv_ps_private(
25: p_system_info IN arp_trx_global.system_info_rec_type,
26: p_profile_info IN arp_trx_global.profile_rec_type,
27: p_customer_trx_id IN BINARY_INTEGER,
28: p_reversed_cash_receipt_id IN BINARY_INTEGER );
29:
30: PROCEDURE insert_cm_ps_private(
27: p_customer_trx_id IN BINARY_INTEGER,
28: p_reversed_cash_receipt_id IN BINARY_INTEGER );
29:
30: PROCEDURE insert_cm_ps_private(
31: p_system_info IN arp_trx_global.system_info_rec_type,
32: p_profile_info IN arp_trx_global.profile_rec_type,
33: p_customer_trx_id IN BINARY_INTEGER );
34:
35: PROCEDURE insert_child_adj_private(
28: p_reversed_cash_receipt_id IN BINARY_INTEGER );
29:
30: PROCEDURE insert_cm_ps_private(
31: p_system_info IN arp_trx_global.system_info_rec_type,
32: p_profile_info IN arp_trx_global.profile_rec_type,
33: p_customer_trx_id IN BINARY_INTEGER );
34:
35: PROCEDURE insert_child_adj_private(
36: p_customer_trx_id IN BINARY_INTEGER,
37: p_adj_date IN DATE DEFAULT NULL,
38: p_gl_date IN DATE DEFAULT NULL);
39:
40: PROCEDURE insert_child_adj_private(
41: p_system_info IN arp_trx_global.system_info_rec_type,
42: p_profile_info IN arp_trx_global.profile_rec_type,
43: p_customer_trx_id IN BINARY_INTEGER,
44: p_adj_date IN DATE DEFAULT NULL,
45: p_gl_date IN DATE DEFAULT NULL);
38: p_gl_date IN DATE DEFAULT NULL);
39:
40: PROCEDURE insert_child_adj_private(
41: p_system_info IN arp_trx_global.system_info_rec_type,
42: p_profile_info IN arp_trx_global.profile_rec_type,
43: p_customer_trx_id IN BINARY_INTEGER,
44: p_adj_date IN DATE DEFAULT NULL,
45: p_gl_date IN DATE DEFAULT NULL);
46:
44: p_adj_date IN DATE DEFAULT NULL,
45: p_gl_date IN DATE DEFAULT NULL);
46:
47: PROCEDURE insert_cm_child_adj_private(
48: p_system_info IN arp_trx_global.system_info_rec_type,
49: p_profile_info IN arp_trx_global.profile_rec_type,
50: p_customer_trx_id IN BINARY_INTEGER );
51:
52: PROCEDURE test_build_ips_sql;
45: p_gl_date IN DATE DEFAULT NULL);
46:
47: PROCEDURE insert_cm_child_adj_private(
48: p_system_info IN arp_trx_global.system_info_rec_type,
49: p_profile_info IN arp_trx_global.profile_rec_type,
50: p_customer_trx_id IN BINARY_INTEGER );
51:
52: PROCEDURE test_build_ips_sql;
53: PROCEDURE test_build_ira_sql;