1 PACKAGE icx_po_req_acct2 AUTHID CURRENT_USER AS
2 /* $Header: ICXRQA3S.pls 115.1 99/07/17 03:22:22 porting ship $ */
3
4 TYPE custom_validate_values IS RECORD (
5 employee_default_account_id NUMBER := NULL,
6 employee_org_id NUMBER := NULL,
7 employee_bus_group_id NUMBER := NULL,
8 po_org_id NUMBER := NULL,
9 NEED_BY_DATE DATE := NULL,
10 DESTINATION_TYPE_CODE VARCHAR2(25) := NULL,
11 DESTINATION_ORGANIZATION_ID NUMBER := NULL,
12 DELIVER_TO_LOCATION_ID NUMBER := NULL,
13 set_of_books_id NUMBER(15) := NULL,
14 ITEM_ID NUMBER := NULL,
15 ITEM_REVISION VARCHAR2(3) := NULL,
16 item_description VARCHAR2(240) := NULL,
17 expense_account NUMBER := NULL,
18 UNIT_MEAS_LOOKUP_CODE VARCHAR2(25) := NULL,
19 QUANTITY NUMBER := NULL,
20 UNIT_PRICE NUMBER := NULL,
21 CATEGORY_ID NUMBER := NULL,
22 LINE_TYPE_ID NUMBER := NULL,
23 SUGGESTED_VENDOR_NAME VARCHAR2(80) := NULL,
24 SUGGESTED_VENDOR_LOCATION VARCHAR2(240) := NULL);
25
26 v_empty_custom_value_rec custom_validate_values;
27
28 PROCEDURE validate_charge_account(v_cart_id IN NUMBER,
29 v_cart_line_id IN NUMBER,
30 v_line_number IN NUMBER default NULL,
31 v_account_id IN NUMBER default NULL,
32 v_oo_id IN NUMBER default NULL);
33
34 PROCEDURE insert_row(v_cart_line_id IN NUMBER,
35 v_oo_id IN NUMBER,
36 v_cart_id IN NUMBER,
37 v_account_id IN NUMBER default NULL,
38 v_n_segments IN NUMBER default NULL,
39 v_segments IN fnd_flex_ext.SegmentArray,
40 v_account_num IN varchar2 default NULL,
41 v_allocation_type IN VARCHAR2 default NULL,
42 v_allocation_value IN NUMBER default NULL,
43 v_line_quantity IN NUMBER default NULL);
44
45 PROCEDURE update_row(v_cart_line_id IN NUMBER,
46 v_oo_id IN NUMBER,
47 v_cart_id IN NUMBER,
48 v_distribution_id IN NUMBER,
49 v_line_number IN NUMBER,
50 v_account_id IN NUMBER default NULL,
51 v_n_segments IN NUMBER default NULL,
52 v_segments IN fnd_flex_ext.SegmentArray,
53 v_account_num IN varchar2 default NULL,
54 v_allocation_type IN varchar2 default NULL,
55 v_allocation_value IN number default NULL,
56 v_line_quantity IN NUMBER default NULL);
57
58 PROCEDURE get_acct_by_segs(v_cart_id IN NUMBER,
59 v_line_number IN NUMBER,
60 v_segments IN fnd_flex_ext.SegmentArray,
61 v_structure IN NUMBER,
62 v_cart_line_id IN NUMBER,
63 v_cart_line_number IN NUMBER default NULL,
64 v_n_segments OUT NUMBER,
65 v_account_num OUT VARCHAR2,
66 v_account_id OUT NUMBER);
67
68 PROCEDURE get_acct_by_con(v_cart_id IN NUMBER,
69 v_line_number IN NUMBER,
70 v_account_num IN VARCHAR2,
71 v_structure IN NUMBER,
72 v_cart_line_id IN NUMBER,
73 v_cart_line_number IN NUMBER default NULL,
74 v_n_segments OUT NUMBER,
75 v_segments OUT fnd_flex_ext.SegmentArray,
76 v_account_id OUT NUMBER);
77
78 PROCEDURE get_account_segments(v_cart_id IN NUMBER,
79 v_line_number IN NUMBER,
80 v_account_id IN NUMBER,
81 v_structure IN NUMBER,
82 v_cart_line_id IN NUMBER,
83 v_cart_line_number IN NUMBER default NULL,
84 v_n_segments OUT NUMBER,
85 v_segments OUT fnd_flex_ext.SegmentArray,
86 v_account_num OUT VARCHAR2);
87
88 PROCEDURE update_account_num(v_cart_id IN NUMBER,
89 v_cart_line_id IN NUMBER,
90 v_oo_id IN NUMBER,
91 v_account_num IN VARCHAR2,
92 v_distribution_id IN NUMBER default NULL,
93 v_line_number IN NUMBER default NULL,
94 v_allocation_type IN VARCHAR2 default NULL,
95 v_allocation_value IN NUMBER default NULL,
96 v_validate_flag IN VARCHAR2 default 'Y',
97 v_line_quantity IN VARCHAR2 default NULL);
98
99 PROCEDURE update_account(v_cart_id IN NUMBER,
100 v_cart_line_id IN NUMBER,
101 v_oo_id IN NUMBER,
102 v_segments IN fnd_flex_ext.SegmentArray,
103 v_distribution_id IN NUMBER default NULL,
104 v_line_number IN NUMBER default NULL,
105 v_allocation_type IN VARCHAR2 default NULL,
106 v_allocation_value IN NUMBER default NULL,
107 v_validate_flag IN VARCHAR2 default 'Y',
108 v_line_quantity IN VARCHAR2 default NULL);
109
110 PROCEDURE get_default_account (v_cart_id IN NUMBER,
111 v_cart_line_id IN NUMBER,
112 v_emp_id IN NUMBER,
113 v_oo_id IN NUMBER,
114 v_account_id IN OUT NUMBER,
115 v_account_num IN OUT VARCHAR2
116 );
117
118 PROCEDURE get_default_segs (v_cart_id IN NUMBER,
119 v_cart_line_id IN NUMBER,
120 v_emp_id IN NUMBER,
121 v_oo_id IN NUMBER,
122 v_segments OUT fnd_flex_ext.SegmentArray);
123
124
125 PROCEDURE update_account_by_id(v_cart_id IN NUMBER,
126 v_cart_line_id IN NUMBER,
127 v_oo_id IN NUMBER,
128 v_distribution_id IN NUMBER,
129 v_line_number IN NUMBER);
130
131 END icx_po_req_acct2;