DBA Data[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;