PACKAGE: APPS.ARP_MAINTAIN_PS2

Source

1 PACKAGE arp_maintain_ps2 AUTHID CURRENT_USER AS
2 /* $Header: ARTEMP2S.pls 120.4.12010000.1 2008/07/24 16:56:22 appldev ship $ */
3 
4 --
5 -- Public cursors
6 --
7 ips_insert_ps_c		INTEGER;
8 ips_select_c		INTEGER;
9 
10 ira_insert_ps_c		INTEGER;
11 ira_insert_ra_c		INTEGER;
12 ira_update_ps_c		INTEGER;
13 ira_select_c		INTEGER;
14 
15 ups_insert_adj_c	INTEGER;
16 ups_update_ps_c		INTEGER;
17 ups_select_c		INTEGER;
18 
19 iad_insert_adj_c	INTEGER;
20 iad_update_ps_c		INTEGER;
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 
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);
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;
54 PROCEDURE test_build_ups_sql;
55 PROCEDURE test_build_iad_sql;
56 PROCEDURE test_insert_inv_ps(
57 	p_customer_trx_id BINARY_INTEGER,
58 	p_reversed_cash_receipt_id	IN BINARY_INTEGER );
59 PROCEDURE test_ai_insert_inv_ps(
60 		p_request_id BINARY_INTEGER,
61 		p_select_sql VARCHAR2 );
62 PROCEDURE test_insert_cm_ps( p_customer_trx_id BINARY_INTEGER );
63 PROCEDURE test_ai_insert_cm_ps(
64 		p_request_id BINARY_INTEGER,
65 		p_select_sql VARCHAR2 );
66 PROCEDURE test_insert_child_adj( p_customer_trx_id BINARY_INTEGER );
67 PROCEDURE test_ai_insert_child_adj(
68 		p_request_id BINARY_INTEGER,
69 		p_select_sql VARCHAR2 );
70 PROCEDURE test_insert_cm_child_adj( p_customer_trx_id BINARY_INTEGER );
71 PROCEDURE test_ai_insert_cm_child_adj(
72 		p_request_id BINARY_INTEGER,
73 		p_select_sql VARCHAR2 );
74 
75 PROCEDURE init;
76 
77 END arp_maintain_ps2;