PACKAGE: APPS.POS_SBD_TBL_PKG

Source

1 PACKAGE POS_SBD_TBL_PKG as
2 /*$Header: POSSBDTS.pls 120.0 2005/08/21 08:48:07 gdwivedi noship $ */
3 
4 /* This procedure create a row in POS_ACNT_GEN_REQ
5  *
6  */
7 PROCEDURE insert_row_pos_acnt_gen_req (
8   p_mapping_id	   IN NUMBER
9 , p_temp_ext_bank_account_id IN NUMBER
10 , p_ext_bank_account_id IN NUMBER
11 , x_account_request_id out nocopy number
12 , x_status        out nocopy VARCHAR2
13 , x_exception_msg out nocopy VARCHAR2
14 );
15 
16 /* This procedure create a row in POS_ACNT_ADDR_REQ
17  *
18  */
19 PROCEDURE insert_row_pos_acnt_addr_req (
20   p_mapping_id	   in NUMBER
21 , p_request_type   in varchar2
22 , p_party_site_id  in number
23 , p_address_request_id in number
24 , x_assignment_request_id out nocopy number
25 , x_status        out nocopy VARCHAR2
26 , x_exception_msg out nocopy VARCHAR2
27 );
28 
29 /* This procedure create a row in POS_ACNT_ADDR_SUMM_REQ
30  *
31  */
32 PROCEDURE insert_row_pos_acnt_summ_req (
33   p_assignment_request_id in number
34 , p_ext_bank_account_id IN NUMBER
35 , p_account_request_id in number
36 , p_start_date in date
37 , p_end_date in date
38 , p_priority in number
39 , p_assignment_status in varchar2
40 , x_assignment_id out nocopy number
41 , x_status        out nocopy VARCHAR2
42 , x_exception_msg out nocopy VARCHAR2
43 );
44 
45 /* This procedure removes a row in POS_ACNT_ADDR_SUMM_REQ
46  *
47  */
48 
49 PROCEDURE del_row_pos_acnt_summ_req (
50   p_assignment_id	   IN NUMBER
51 , x_status        out nocopy VARCHAR2
52 , x_exception_msg out nocopy VARCHAR2
53 );
54 
55 /* This procedure removes a row in POS_ACNT_ADDR_REQ
56  *
57  */
58 
59 PROCEDURE del_row_pos_acnt_addr_req (
60   p_assignment_request_id	   IN NUMBER
61 , x_status        out nocopy VARCHAR2
62 , x_exception_msg out nocopy VARCHAR2
63 );
64 
65 /* This procedure removes a row in POS_ACNT_GEN_REQ
66  *
67  */
68 PROCEDURE del_row_pos_acnt_gen_req (
69   p_account_request_id	   IN NUMBER
70 , x_status        out nocopy VARCHAR2
71 , x_exception_msg out nocopy VARCHAR2
72 );
73 
74 /* This procedure updates a row in POS_ACNT_ADDR_SUMM_REQ
75  *
76  */
77 
78 PROCEDURE update_row_pos_acnt_summ_req (
79   p_assignment_id	   IN NUMBER
80 , p_assignment_request_id  IN NUMBER
81 , p_ext_bank_account_id    IN NUMBER
82 , p_account_request_id     IN NUMBER
83 , p_start_date             IN DATE
84 , p_end_date               IN DATE
85 , p_priority               IN NUMBER
86 , p_assignment_status      IN VARCHAR2
87 , x_status        out nocopy VARCHAR2
88 , x_exception_msg out nocopy VARCHAR2
89 );
90 
91 
92 /* This procedure updates a row in POS_ACNT_ADDR_REQ
93  *
94  */
95 
96 PROCEDURE update_row_pos_acnt_addr_req (
97   p_assignment_request_id  IN NUMBER
98 , p_request_status in varchar2
99 , p_party_site_id  in number
100 , p_address_request_id in number
101 , p_object_version_number in number
102 , x_status        out nocopy VARCHAR2
103 , x_exception_msg out nocopy VARCHAR2
104 );
105 
106 END POS_SBD_TBL_PKG;