[Home] [Help]
PACKAGE: APPS.ICX_REQ_SUBMIT
Source
1 PACKAGE ICX_REQ_SUBMIT AUTHID CURRENT_USER as
2 /* $Header: ICXRQSMS.pls 115.4 99/07/17 03:23:26 porting ship $ */
3
4
5 type defaultParamType is table of varchar2(250)
6 index by BINARY_INTEGER;
7
8 empty_table defaultParamType;
9
10
11 procedure show_end(n_cart_id varchar2,
12 v_emergency varchar2,
13 user_action varchar2);
14
15 procedure finalSubmit(user_action IN varchar2,
16 icx_cart_id varchar2,
17 emergency IN varchar2 default NULL,
18 icx_approver_id varchar2 default FND_API.G_MISS_CHAR,
19 icx_approver_name varchar2 default FND_API.G_MISS_CHAR,
20 icx_deliver_to_location_id varchar2 default FND_API.G_MISS_CHAR,
21 icx_deliver_to_requestor_id varchar2 default FND_API.G_MISS_CHAR,
22 icx_dest_org_id varchar2 default FND_API.G_MISS_CHAR,
23 icx_shopper_id varchar2 default FND_API.G_MISS_CHAR,
24 icx_deliver_to_location varchar2 default FND_API.G_MISS_CHAR,
25 icx_deliver_to_requestor varchar2 default FND_API.G_MISS_CHAR,
26 icx_need_by_date varchar2 default FND_API.G_MISS_CHAR,
27 icx_note_to_approver varchar2 default FND_API.G_MISS_CHAR,
28 icx_note_to_buyer varchar2 default FND_API.G_MISS_CHAR,
29 icx_header_description varchar2 default FND_API.G_MISS_CHAR,
30 icx_req_org_id varchar2 default FND_API.G_MISS_CHAR,
31 icx_req_loc_id varchar2 default FND_API.G_MISS_CHAR,
32 icx_req_loc_cd varchar2 default FND_API.G_MISS_CHAR,
33 icx_header_attribute1 varchar2 default FND_API.G_MISS_CHAR,
34 icx_header_attribute2 varchar2 default FND_API.G_MISS_CHAR,
35 icx_header_attribute3 varchar2 default FND_API.G_MISS_CHAR,
36 icx_header_attribute4 varchar2 default FND_API.G_MISS_CHAR,
37 icx_header_attribute5 varchar2 default FND_API.G_MISS_CHAR,
38 icx_header_attribute6 varchar2 default FND_API.G_MISS_CHAR,
39 icx_header_attribute7 varchar2 default FND_API.G_MISS_CHAR,
40 icx_header_attribute8 varchar2 default FND_API.G_MISS_CHAR,
41 icx_header_attribute9 varchar2 default FND_API.G_MISS_CHAR,
42 icx_header_attribute10 varchar2 default FND_API.G_MISS_CHAR,
43 icx_header_attribute11 varchar2 default FND_API.G_MISS_CHAR,
44 icx_header_attribute12 varchar2 default FND_API.G_MISS_CHAR,
45 icx_header_attribute13 varchar2 default FND_API.G_MISS_CHAR,
46 icx_header_attribute14 varchar2 default FND_API.G_MISS_CHAR,
47 icx_header_attribute15 varchar2 default FND_API.G_MISS_CHAR,
48 icx_charge_acct_seg1 varchar2 default FND_API.G_MISS_CHAR,
49 icx_charge_acct_seg2 varchar2 default FND_API.G_MISS_CHAR,
50 icx_charge_acct_seg3 varchar2 default FND_API.G_MISS_CHAR,
51 icx_charge_acct_seg4 varchar2 default FND_API.G_MISS_CHAR,
52 icx_charge_acct_seg5 varchar2 default FND_API.G_MISS_CHAR,
53 icx_charge_acct_seg6 varchar2 default FND_API.G_MISS_CHAR,
54 icx_charge_acct_seg7 varchar2 default FND_API.G_MISS_CHAR,
55 icx_charge_acct_seg8 varchar2 default FND_API.G_MISS_CHAR,
56 icx_charge_acct_seg9 varchar2 default FND_API.G_MISS_CHAR,
57 icx_charge_acct_seg10 varchar2 default FND_API.G_MISS_CHAR,
58 icx_charge_acct_seg11 varchar2 default FND_API.G_MISS_CHAR,
59 icx_charge_acct_seg12 varchar2 default FND_API.G_MISS_CHAR,
60 icx_charge_acct_seg13 varchar2 default FND_API.G_MISS_CHAR,
61 icx_charge_acct_seg14 varchar2 default FND_API.G_MISS_CHAR,
62 icx_charge_acct_seg15 varchar2 default FND_API.G_MISS_CHAR,
63 icx_charge_acct_seg16 varchar2 default FND_API.G_MISS_CHAR,
64 icx_charge_acct_seg17 varchar2 default FND_API.G_MISS_CHAR,
65 icx_charge_acct_seg18 varchar2 default FND_API.G_MISS_CHAR,
66 icx_charge_acct_seg19 varchar2 default FND_API.G_MISS_CHAR,
67 icx_charge_acct_seg20 varchar2 default FND_API.G_MISS_CHAR,
68 icx_charge_acct_seg21 varchar2 default FND_API.G_MISS_CHAR,
69 icx_charge_acct_seg22 varchar2 default FND_API.G_MISS_CHAR,
70 icx_charge_acct_seg23 varchar2 default FND_API.G_MISS_CHAR,
71 icx_charge_acct_seg24 varchar2 default FND_API.G_MISS_CHAR,
72 icx_charge_acct_seg25 varchar2 default FND_API.G_MISS_CHAR,
73 icx_charge_acct_seg26 varchar2 default FND_API.G_MISS_CHAR,
74 icx_charge_acct_seg27 varchar2 default FND_API.G_MISS_CHAR,
75 icx_charge_acct_seg28 varchar2 default FND_API.G_MISS_CHAR,
76 icx_charge_acct_seg29 varchar2 default FND_API.G_MISS_CHAR,
77 icx_charge_acct_seg30 varchar2 default FND_API.G_MISS_CHAR,
78 icx_cart_line_ida IN defaultParamType default empty_table,
79 icx_category_ida IN defaultParamType default empty_table,
80 icx_category_namea IN defaultParamType default empty_table,
81 icx_item_ida IN defaultParamType default empty_table,
82 icx_item_reva IN defaultParamType default empty_table,
83 icx_need_by_datea IN defaultParamType default empty_table,
84 icx_item_descriptiona IN defaultParamType default empty_table,
85 icx_expend_item_datea IN defaultParamType default empty_table,
86 icx_expend_orga IN defaultParamType default empty_table,
87 icx_qty_va IN defaultParamType default empty_table,
88 icx_suggested_buyer_ida IN defaultParamType default empty_table,
89 icx_project_ida IN defaultParamType default empty_table,
90 icx_suggested_vendor_contacta IN defaultParamType default empty_table,
91 icx_suggested_vendor_item_numa IN defaultParamType default empty_table,
92 icx_suggested_vendor_namea IN defaultParamType default empty_table,
93 icx_suggested_vendor_phonea IN defaultParamType default empty_table,
94 icx_suggested_vendor_sitea IN defaultParamType default empty_table,
95 icx_task_ida IN defaultParamType default empty_table,
96 icx_unit_of_measurementa IN defaultParamType default empty_table,
97 icx_unit_pricea IN defaultParamType default empty_table,
98 icx_deliver_to_location_id_la IN defaultParamType default empty_table,
99 icx_dest_org_id_la IN defaultParamType default empty_table,
100 icx_deliver_to_location_la IN defaultParamType default empty_table,
101 icx_line_attribute_1a IN defaultParamType default empty_table,
102 icx_line_attribute_2a IN defaultParamType default empty_table,
103 icx_line_attribute_3a IN defaultParamType default empty_table,
104 icx_line_attribute_4a IN defaultParamType default empty_table,
105 icx_line_attribute_5a IN defaultParamType default empty_table,
106 icx_line_attribute_6a IN defaultParamType default empty_table,
107 icx_line_attribute_7a IN defaultParamType default empty_table,
108 icx_line_attribute_8a IN defaultParamType default empty_table,
109 icx_line_attribute_9a IN defaultParamType default empty_table,
110 icx_line_attribute_10a IN defaultParamType default empty_table,
111 icx_line_attribute_11a IN defaultParamType default empty_table,
112 icx_line_attribute_12a IN defaultParamType default empty_table,
113 icx_line_attribute_13a IN defaultParamType default empty_table,
114 icx_line_attribute_14a IN defaultParamType default empty_table,
115 icx_line_attribute_15a IN defaultParamType default empty_table,
116 icx_charge_acct_seg1a IN defaultParamType default empty_table,
117 icx_charge_acct_seg2a IN defaultParamType default empty_table,
118 icx_charge_acct_seg3a IN defaultParamType default empty_table,
119 icx_charge_acct_seg4a IN defaultParamType default empty_table,
120 icx_charge_acct_seg5a IN defaultParamType default empty_table,
121 icx_charge_acct_seg6a IN defaultParamType default empty_table,
122 icx_charge_acct_seg7a IN defaultParamType default empty_table,
123 icx_charge_acct_seg8a IN defaultParamType default empty_table,
124 icx_charge_acct_seg9a IN defaultParamType default empty_table,
125 icx_charge_acct_seg10a IN defaultParamType default empty_table,
126 icx_charge_acct_seg11a IN defaultParamType default empty_table,
127 icx_charge_acct_seg12a IN defaultParamType default empty_table,
128 icx_charge_acct_seg13a IN defaultParamType default empty_table,
129 icx_charge_acct_seg14a IN defaultParamType default empty_table,
130 icx_charge_acct_seg15a IN defaultParamType default empty_table,
131 icx_charge_acct_seg16a IN defaultParamType default empty_table,
132 icx_charge_acct_seg17a IN defaultParamType default empty_table,
133 icx_charge_acct_seg18a IN defaultParamType default empty_table,
134 icx_charge_acct_seg19a IN defaultParamType default empty_table,
135 icx_charge_acct_seg20a IN defaultParamType default empty_table,
136 icx_charge_acct_seg21a IN defaultParamType default empty_table,
137 icx_charge_acct_seg22a IN defaultParamType default empty_table,
138 icx_charge_acct_seg23a IN defaultParamType default empty_table,
139 icx_charge_acct_seg24a IN defaultParamType default empty_table,
140 icx_charge_acct_seg25a IN defaultParamType default empty_table,
141 icx_charge_acct_seg26a IN defaultParamType default empty_table,
142 icx_charge_acct_seg27a IN defaultParamType default empty_table,
143 icx_charge_acct_seg28a IN defaultParamType default empty_table,
144 icx_charge_acct_seg29a IN defaultParamType default empty_table,
145 icx_charge_acct_seg30a IN defaultParamType default empty_table,
146 entity_name IN varchar2 default NULL,
147 pk1 IN varchar2 default NULL,
148 pk2 IN varchar2 default NULL,
149 pk3 IN varchar2 default NULL,
150 from_url IN varchar2 default NULL,
151 query_only IN varchar2 default 'N');
152
153 procedure storeError(v_cart_id IN NUMBER, v_message IN VARCHAR2, v_distribution_num IN NUMBER default NULL,v_cart_line_id IN NUMBER default NULL);
154
155
156 end ICX_REQ_SUBMIT;