[Home] [Help]
PACKAGE: APPS.AK$ICX_PO_REQUISITION_LINES_IN
Source
1 PACKAGE "AK$ICX_PO_REQUISITION_LINES_IN" AUTHID CURRENT_USER AS
2 /* $Header: ICXAKPLS.pls 115.2 99/10/28 15:22:19 porting ship $ */
3
4 TYPE REC IS RECORD (
5 "AGENT_ID$178" NUMBER,
6 "ICX_AGENT_RETURN_NOTE$178" VARCHAR(240),
7 "ICX_AUTOSOURCE_DOC_HEADER_$178" NUMBER,
8 "ICX_AUTOSOURCE_DOC_LINE_NU$178" NUMBER,
9 "ICX_BOM_RESOURCE_ID$178" NUMBER,
10 "ICX_BUYER$178" VARCHAR(2000),
11 "ICX_CANCEL_DATE$178" VARCHAR(20),
12 "ICX_CANCEL_FLAG$178" VARCHAR(1),
13 "ICX_CANCEL_REASON$178" VARCHAR(240),
14 "ICX_CATEGORY_ID$178" NUMBER,
15 "ICX_CATEGORY_V$178" VARCHAR(81),
16 "ICX_CLOSED_CODE$178" VARCHAR(30),
17 "ICX_CLOSED_DATE$178" VARCHAR(20),
18 "ICX_CLOSED_REASON$178" VARCHAR(240),
19 "ICX_CREATION_DATE_V$178" DATE,
20 "ICX_CURRENCY$178" VARCHAR(15),
21 "ICX_CURR_UNIT_PRICE$178" NUMBER,
22 "ICX_DELIVER_TO_LOCATION$178" VARCHAR(20),
23 "ICX_DELIVER_TO_LOCATION_ID$178" NUMBER,
24 "ICX_DESC$178" VARCHAR(240),
25 "ICX_DESTINATION_TYPE_CODE$178" VARCHAR(25),
26 "ICX_DEST_CONTEXT$178" VARCHAR(30),
27 "ICX_DEST_ORG_ID$178" NUMBER,
28 "ICX_DEST_SUBINVENTORY$178" VARCHAR(10),
29 "ICX_DOCUMENT_TYPE$178" VARCHAR(80),
30 "ICX_ENCUMBERED_FLAG$178" VARCHAR(5),
31 "ICX_GOV_CONTEXT$178" VARCHAR(30),
32 "ICX_HAZARD_CLASS_ID$178" NUMBER,
33 "ICX_INV_SOURCE_CONTEXT$178" VARCHAR(30),
34 "ICX_ITEM$178" VARCHAR(40),
35 "ICX_JUSTIFICATION$178" VARCHAR(240),
36 "ICX_LINE_ATTRIBUTE_1$178" VARCHAR(150),
37 "ICX_LINE_ATTRIBUTE_10$178" VARCHAR(150),
38 "ICX_LINE_ATTRIBUTE_11$178" VARCHAR(150),
39 "ICX_LINE_ATTRIBUTE_12$178" VARCHAR(150),
40 "ICX_LINE_ATTRIBUTE_13$178" VARCHAR(150),
41 "ICX_LINE_ATTRIBUTE_14$178" VARCHAR(150),
42 "ICX_LINE_ATTRIBUTE_15$178" VARCHAR(150),
43 "ICX_LINE_ATTRIBUTE_2$178" VARCHAR(150),
44 "ICX_LINE_ATTRIBUTE_3$178" VARCHAR(150),
45 "ICX_LINE_ATTRIBUTE_4$178" VARCHAR(150),
46 "ICX_LINE_ATTRIBUTE_5$178" VARCHAR(150),
47 "ICX_LINE_ATTRIBUTE_6$178" VARCHAR(150),
48 "ICX_LINE_ATTRIBUTE_7$178" VARCHAR(150),
49 "ICX_LINE_ATTRIBUTE_8$178" VARCHAR(150),
50 "ICX_LINE_ATTRIBUTE_9$178" VARCHAR(150),
51 "ICX_LINE_ATTRIBUTE_CATEGOR$178" VARCHAR(30),
52 "ICX_LINE_TYPE_ID_V$178" NUMBER,
53 "ICX_LINE_V$178" NUMBER,
54 "ICX_MOD_BY_AGENT_FLAG$178" VARCHAR(1),
55 "ICX_NOTE_TO_BUYER$178" VARCHAR(240),
56 "ICX_NOTE_TO_RECEIVER$178" VARCHAR(240),
57 "ICX_NUM_V$178" VARCHAR(30),
58 "ICX_ON_LINE_FLAG$178" VARCHAR(1),
59 "ICX_ON_RFQ_FLAG$178" VARCHAR(1),
60 "ICX_ORDER_NUM$178" VARCHAR(30),
61 "ICX_PARENT_REQ_LINE_ID$178" NUMBER,
62 "ICX_PONUM_V$178" VARCHAR(30),
63 "ICX_PREPARER_NAME$178" VARCHAR(2000),
64 "ICX_PRICE_V$178" NUMBER,
65 "ICX_QTY_CANCELLED$178" NUMBER,
66 "ICX_QTY_DELIVERY$178" NUMBER,
67 "ICX_QTY_RECEIVED$178" NUMBER,
68 "ICX_QTY_V$178" NUMBER,
69 "ICX_RATE$178" NUMBER,
70 "ICX_RATE_DATE$178" VARCHAR(20),
71 "ICX_RATE_TYPE$178" VARCHAR(30),
72 "ICX_REF_NUM$178" VARCHAR(30),
73 "ICX_REQUESTOR$178" VARCHAR(2000),
74 "ICX_REQ_DATE$178" VARCHAR(20),
75 "ICX_REQ_HEADER_ID$178" NUMBER,
76 "ICX_REQ_LINE_ID$178" NUMBER,
77 "ICX_REQ_NUM$178" VARCHAR(30),
78 "ICX_RFQ_REQUIRED$178" VARCHAR(5),
79 "ICX_SOURCE_ORGANIZATION_ID$178" NUMBER,
80 "ICX_SOURCE_REQ_LINE_ID$178" NUMBER,
81 "ICX_SOURCE_SUBINVENTORY$178" VARCHAR(10),
82 "ICX_SOURCE_TYPE_CODE$178" VARCHAR(25),
83 "ICX_STATUS$178" VARCHAR(25),
84 "ICX_SUGGESTED_BUYER_ID$178" NUMBER,
85 "ICX_SUGGESTED_VENDOR_CONTA$178" VARCHAR(37),
86 "ICX_SUGGESTED_VENDOR_ITEM_$178" VARCHAR(25),
87 "ICX_SUGGESTED_VENDOR_PHONE$178" VARCHAR(20),
88 "ICX_SUPPLIER$178" VARCHAR(80),
89 "ICX_SUPSITE$178" VARCHAR(240),
90 "ICX_TRAN_REASON_CODE$178" VARCHAR(25),
91 "ICX_UN_NUMBER_ID$178" NUMBER,
92 "ICX_UOM$178" VARCHAR(25),
93 "ICX_URGENT_FLAG$178" VARCHAR(1),
94 "ICX_USSGL_TRAN_CODE$178" VARCHAR(30),
95 "ICX_VENDOR_SOURCE_CONTEXT$178" VARCHAR(30),
96 "LINE_LOCATION_ID$178" NUMBER,
97 "TO_PERSON_ID$178" NUMBER,
98 "VENDOR_ID$178" NUMBER);
99 PROCEDURE DEFAULT_MISSING (P_REC IN OUT REC);
100 END "AK$ICX_PO_REQUISITION_LINES_IN";