1 PACKAGE icx_req_acct2 AUTHID CURRENT_USER AS
2 /* $Header: ICXRQA2S.pls 115.1 99/07/17 03:22:17 porting ship $ */
3
4
5 PROCEDURE validate_charge_account(v_cart_id IN NUMBER,
6 v_cart_line_id IN NUMBER,
7 v_line_number IN NUMBER default NULL,
8 v_account_id IN NUMBER default NULL);
9
10 PROCEDURE insert_row(v_cart_line_id IN NUMBER,
11 v_oo_id IN NUMBER,
12 v_cart_id IN NUMBER,
13 v_account_id IN NUMBER default NULL,
14 v_n_segments IN NUMBER default NULL,
15 v_segments IN fnd_flex_ext.SegmentArray,
16 v_account_num IN varchar2 default NULL,
17 v_allocation_type IN VARCHAR2 default NULL,
18 v_allocation_value IN NUMBER default NULL);
19
20 PROCEDURE update_row(v_cart_line_id IN NUMBER,
21 v_oo_id IN NUMBER,
22 v_cart_id IN NUMBER,
23 v_distribution_id IN NUMBER,
24 v_line_number IN NUMBER,
25 v_account_id IN NUMBER default NULL,
26 v_n_segments IN NUMBER default NULL,
27 v_segments IN fnd_flex_ext.SegmentArray,
28 v_account_num IN varchar2 default NULL,
29 v_allocation_type IN varchar2 default NULL,
30 v_allocation_value IN number default NULL);
31
32 PROCEDURE get_acct_by_segs(v_cart_id IN NUMBER,
33 v_line_number IN NUMBER,
34 v_segments IN fnd_flex_ext.SegmentArray,
35 v_structure IN NUMBER,
36 v_cart_line_id IN NUMBER,
37 v_cart_line_number IN NUMBER default NULL,
38 v_n_segments OUT NUMBER,
39 v_account_num OUT VARCHAR2,
40 v_account_id OUT NUMBER);
41
42 PROCEDURE get_acct_by_con(v_cart_id IN NUMBER,
43 v_line_number IN NUMBER,
44 v_account_num IN VARCHAR2,
45 v_structure IN NUMBER,
46 v_cart_line_id IN NUMBER,
47 v_cart_line_number IN NUMBER default NULL,
48 v_n_segments OUT NUMBER,
49 v_segments OUT fnd_flex_ext.SegmentArray,
50 v_account_id OUT NUMBER);
51
52 PROCEDURE get_account_segments(v_cart_id IN NUMBER,
53 v_line_number IN NUMBER,
54 v_account_id IN NUMBER,
55 v_structure IN NUMBER,
56 v_cart_line_id IN NUMBER,
57 v_cart_line_number IN NUMBER default NULL,
58 v_n_segments OUT NUMBER,
59 v_segments OUT fnd_flex_ext.SegmentArray,
60 v_account_num OUT VARCHAR2);
61
62 PROCEDURE update_account_num(v_cart_id IN NUMBER,
63 v_cart_line_id IN NUMBER,
64 v_oo_id IN NUMBER,
65 v_account_num IN VARCHAR2,
66 v_distribution_id IN NUMBER default NULL,
67 v_line_number IN NUMBER default NULL,
68 v_allocation_type IN VARCHAR2 default NULL,
69 v_allocation_value IN NUMBER default NULL,
70 v_validate_flag IN VARCHAR2 default 'Y');
71
72 PROCEDURE update_account(v_cart_id IN NUMBER,
73 v_cart_line_id IN NUMBER,
74 v_oo_id IN NUMBER,
75 v_segments IN fnd_flex_ext.SegmentArray,
76 v_distribution_id IN NUMBER default NULL,
77 v_line_number IN NUMBER default NULL,
78 v_allocation_type IN VARCHAR2 default NULL,
79 v_allocation_value IN NUMBER default NULL,
80 v_validate_flag IN VARCHAR2 default 'Y');
81
82 PROCEDURE get_default_account (v_cart_id IN NUMBER,
83 v_cart_line_id IN NUMBER,
84 v_emp_id IN NUMBER,
85 v_oo_id IN NUMBER,
86 v_account_id IN OUT NUMBER,
87 v_account_num IN OUT VARCHAR2
88 );
89
90 PROCEDURE get_default_segs (v_cart_id IN NUMBER,
91 v_cart_line_id IN NUMBER,
92 v_emp_id IN NUMBER,
93 v_oo_id IN NUMBER,
94 v_segments OUT fnd_flex_ext.SegmentArray);
95
96
97 PROCEDURE update_account_by_id(v_cart_id IN NUMBER,
98 v_cart_line_id IN NUMBER,
99 v_oo_id IN NUMBER,
100 v_distribution_id IN NUMBER,
101 v_line_number IN NUMBER);
102
103 END icx_req_acct2;