APPS.OKE_DELIVERABLE_PVT dependencies on OKE_API

Line 7: DELIVERABLE_ID NUMBER := OKE_API.G_MISS_NUM,

3:
4: -- GLOBAL DATA STRUCTURES
5:
6: TYPE del_rec_type IS RECORD(
7: DELIVERABLE_ID NUMBER := OKE_API.G_MISS_NUM,
8: DELIVERABLE_NUM VARCHAR2(150) := OKE_API.G_MISS_CHAR,
9: PROJECT_ID NUMBER := OKE_API.G_MISS_NUM,
10: TASK_ID NUMBER := OKE_API.G_MISS_NUM,
11: ITEM_ID NUMBER := OKE_API.G_MISS_NUM,

Line 8: DELIVERABLE_NUM VARCHAR2(150) := OKE_API.G_MISS_CHAR,

4: -- GLOBAL DATA STRUCTURES
5:
6: TYPE del_rec_type IS RECORD(
7: DELIVERABLE_ID NUMBER := OKE_API.G_MISS_NUM,
8: DELIVERABLE_NUM VARCHAR2(150) := OKE_API.G_MISS_CHAR,
9: PROJECT_ID NUMBER := OKE_API.G_MISS_NUM,
10: TASK_ID NUMBER := OKE_API.G_MISS_NUM,
11: ITEM_ID NUMBER := OKE_API.G_MISS_NUM,
12: K_HEADER_ID NUMBER := OKE_API.G_MISS_NUM,

Line 9: PROJECT_ID NUMBER := OKE_API.G_MISS_NUM,

5:
6: TYPE del_rec_type IS RECORD(
7: DELIVERABLE_ID NUMBER := OKE_API.G_MISS_NUM,
8: DELIVERABLE_NUM VARCHAR2(150) := OKE_API.G_MISS_CHAR,
9: PROJECT_ID NUMBER := OKE_API.G_MISS_NUM,
10: TASK_ID NUMBER := OKE_API.G_MISS_NUM,
11: ITEM_ID NUMBER := OKE_API.G_MISS_NUM,
12: K_HEADER_ID NUMBER := OKE_API.G_MISS_NUM,
13: K_LINE_ID NUMBER := OKE_API.G_MISS_NUM,

Line 10: TASK_ID NUMBER := OKE_API.G_MISS_NUM,

6: TYPE del_rec_type IS RECORD(
7: DELIVERABLE_ID NUMBER := OKE_API.G_MISS_NUM,
8: DELIVERABLE_NUM VARCHAR2(150) := OKE_API.G_MISS_CHAR,
9: PROJECT_ID NUMBER := OKE_API.G_MISS_NUM,
10: TASK_ID NUMBER := OKE_API.G_MISS_NUM,
11: ITEM_ID NUMBER := OKE_API.G_MISS_NUM,
12: K_HEADER_ID NUMBER := OKE_API.G_MISS_NUM,
13: K_LINE_ID NUMBER := OKE_API.G_MISS_NUM,
14: DELIVERY_DATE DATE := OKE_API.G_MISS_DATE,

Line 11: ITEM_ID NUMBER := OKE_API.G_MISS_NUM,

7: DELIVERABLE_ID NUMBER := OKE_API.G_MISS_NUM,
8: DELIVERABLE_NUM VARCHAR2(150) := OKE_API.G_MISS_CHAR,
9: PROJECT_ID NUMBER := OKE_API.G_MISS_NUM,
10: TASK_ID NUMBER := OKE_API.G_MISS_NUM,
11: ITEM_ID NUMBER := OKE_API.G_MISS_NUM,
12: K_HEADER_ID NUMBER := OKE_API.G_MISS_NUM,
13: K_LINE_ID NUMBER := OKE_API.G_MISS_NUM,
14: DELIVERY_DATE DATE := OKE_API.G_MISS_DATE,
15: STATUS_CODE VARCHAR2(30) := OKE_API.G_MISS_CHAR,

Line 12: K_HEADER_ID NUMBER := OKE_API.G_MISS_NUM,

8: DELIVERABLE_NUM VARCHAR2(150) := OKE_API.G_MISS_CHAR,
9: PROJECT_ID NUMBER := OKE_API.G_MISS_NUM,
10: TASK_ID NUMBER := OKE_API.G_MISS_NUM,
11: ITEM_ID NUMBER := OKE_API.G_MISS_NUM,
12: K_HEADER_ID NUMBER := OKE_API.G_MISS_NUM,
13: K_LINE_ID NUMBER := OKE_API.G_MISS_NUM,
14: DELIVERY_DATE DATE := OKE_API.G_MISS_DATE,
15: STATUS_CODE VARCHAR2(30) := OKE_API.G_MISS_CHAR,
16: PARENT_DELIVERABLE_ID NUMBER := OKE_API.G_MISS_NUM,

Line 13: K_LINE_ID NUMBER := OKE_API.G_MISS_NUM,

9: PROJECT_ID NUMBER := OKE_API.G_MISS_NUM,
10: TASK_ID NUMBER := OKE_API.G_MISS_NUM,
11: ITEM_ID NUMBER := OKE_API.G_MISS_NUM,
12: K_HEADER_ID NUMBER := OKE_API.G_MISS_NUM,
13: K_LINE_ID NUMBER := OKE_API.G_MISS_NUM,
14: DELIVERY_DATE DATE := OKE_API.G_MISS_DATE,
15: STATUS_CODE VARCHAR2(30) := OKE_API.G_MISS_CHAR,
16: PARENT_DELIVERABLE_ID NUMBER := OKE_API.G_MISS_NUM,
17: SHIP_TO_ORG_ID NUMBER := OKE_API.G_MISS_NUM,

Line 14: DELIVERY_DATE DATE := OKE_API.G_MISS_DATE,

10: TASK_ID NUMBER := OKE_API.G_MISS_NUM,
11: ITEM_ID NUMBER := OKE_API.G_MISS_NUM,
12: K_HEADER_ID NUMBER := OKE_API.G_MISS_NUM,
13: K_LINE_ID NUMBER := OKE_API.G_MISS_NUM,
14: DELIVERY_DATE DATE := OKE_API.G_MISS_DATE,
15: STATUS_CODE VARCHAR2(30) := OKE_API.G_MISS_CHAR,
16: PARENT_DELIVERABLE_ID NUMBER := OKE_API.G_MISS_NUM,
17: SHIP_TO_ORG_ID NUMBER := OKE_API.G_MISS_NUM,
18: SHIP_TO_LOCATION_ID NUMBER := OKE_API.G_MISS_NUM,

Line 15: STATUS_CODE VARCHAR2(30) := OKE_API.G_MISS_CHAR,

11: ITEM_ID NUMBER := OKE_API.G_MISS_NUM,
12: K_HEADER_ID NUMBER := OKE_API.G_MISS_NUM,
13: K_LINE_ID NUMBER := OKE_API.G_MISS_NUM,
14: DELIVERY_DATE DATE := OKE_API.G_MISS_DATE,
15: STATUS_CODE VARCHAR2(30) := OKE_API.G_MISS_CHAR,
16: PARENT_DELIVERABLE_ID NUMBER := OKE_API.G_MISS_NUM,
17: SHIP_TO_ORG_ID NUMBER := OKE_API.G_MISS_NUM,
18: SHIP_TO_LOCATION_ID NUMBER := OKE_API.G_MISS_NUM,
19: SHIP_FROM_ORG_ID NUMBER := OKE_API.G_MISS_NUM,

Line 16: PARENT_DELIVERABLE_ID NUMBER := OKE_API.G_MISS_NUM,

12: K_HEADER_ID NUMBER := OKE_API.G_MISS_NUM,
13: K_LINE_ID NUMBER := OKE_API.G_MISS_NUM,
14: DELIVERY_DATE DATE := OKE_API.G_MISS_DATE,
15: STATUS_CODE VARCHAR2(30) := OKE_API.G_MISS_CHAR,
16: PARENT_DELIVERABLE_ID NUMBER := OKE_API.G_MISS_NUM,
17: SHIP_TO_ORG_ID NUMBER := OKE_API.G_MISS_NUM,
18: SHIP_TO_LOCATION_ID NUMBER := OKE_API.G_MISS_NUM,
19: SHIP_FROM_ORG_ID NUMBER := OKE_API.G_MISS_NUM,
20: SHIP_FROM_LOCATION_ID NUMBER := OKE_API.G_MISS_NUM,

Line 17: SHIP_TO_ORG_ID NUMBER := OKE_API.G_MISS_NUM,

13: K_LINE_ID NUMBER := OKE_API.G_MISS_NUM,
14: DELIVERY_DATE DATE := OKE_API.G_MISS_DATE,
15: STATUS_CODE VARCHAR2(30) := OKE_API.G_MISS_CHAR,
16: PARENT_DELIVERABLE_ID NUMBER := OKE_API.G_MISS_NUM,
17: SHIP_TO_ORG_ID NUMBER := OKE_API.G_MISS_NUM,
18: SHIP_TO_LOCATION_ID NUMBER := OKE_API.G_MISS_NUM,
19: SHIP_FROM_ORG_ID NUMBER := OKE_API.G_MISS_NUM,
20: SHIP_FROM_LOCATION_ID NUMBER := OKE_API.G_MISS_NUM,
21: DIRECTION VARCHAR2(3) := OKE_API.G_MISS_CHAR,

Line 18: SHIP_TO_LOCATION_ID NUMBER := OKE_API.G_MISS_NUM,

14: DELIVERY_DATE DATE := OKE_API.G_MISS_DATE,
15: STATUS_CODE VARCHAR2(30) := OKE_API.G_MISS_CHAR,
16: PARENT_DELIVERABLE_ID NUMBER := OKE_API.G_MISS_NUM,
17: SHIP_TO_ORG_ID NUMBER := OKE_API.G_MISS_NUM,
18: SHIP_TO_LOCATION_ID NUMBER := OKE_API.G_MISS_NUM,
19: SHIP_FROM_ORG_ID NUMBER := OKE_API.G_MISS_NUM,
20: SHIP_FROM_LOCATION_ID NUMBER := OKE_API.G_MISS_NUM,
21: DIRECTION VARCHAR2(3) := OKE_API.G_MISS_CHAR,
22: INVENTORY_ORG_ID NUMBER := OKE_API.G_MISS_NUM,

Line 19: SHIP_FROM_ORG_ID NUMBER := OKE_API.G_MISS_NUM,

15: STATUS_CODE VARCHAR2(30) := OKE_API.G_MISS_CHAR,
16: PARENT_DELIVERABLE_ID NUMBER := OKE_API.G_MISS_NUM,
17: SHIP_TO_ORG_ID NUMBER := OKE_API.G_MISS_NUM,
18: SHIP_TO_LOCATION_ID NUMBER := OKE_API.G_MISS_NUM,
19: SHIP_FROM_ORG_ID NUMBER := OKE_API.G_MISS_NUM,
20: SHIP_FROM_LOCATION_ID NUMBER := OKE_API.G_MISS_NUM,
21: DIRECTION VARCHAR2(3) := OKE_API.G_MISS_CHAR,
22: INVENTORY_ORG_ID NUMBER := OKE_API.G_MISS_NUM,
23: DEFAULTED_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,

Line 20: SHIP_FROM_LOCATION_ID NUMBER := OKE_API.G_MISS_NUM,

16: PARENT_DELIVERABLE_ID NUMBER := OKE_API.G_MISS_NUM,
17: SHIP_TO_ORG_ID NUMBER := OKE_API.G_MISS_NUM,
18: SHIP_TO_LOCATION_ID NUMBER := OKE_API.G_MISS_NUM,
19: SHIP_FROM_ORG_ID NUMBER := OKE_API.G_MISS_NUM,
20: SHIP_FROM_LOCATION_ID NUMBER := OKE_API.G_MISS_NUM,
21: DIRECTION VARCHAR2(3) := OKE_API.G_MISS_CHAR,
22: INVENTORY_ORG_ID NUMBER := OKE_API.G_MISS_NUM,
23: DEFAULTED_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
24: IN_PROCESS_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,

Line 21: DIRECTION VARCHAR2(3) := OKE_API.G_MISS_CHAR,

17: SHIP_TO_ORG_ID NUMBER := OKE_API.G_MISS_NUM,
18: SHIP_TO_LOCATION_ID NUMBER := OKE_API.G_MISS_NUM,
19: SHIP_FROM_ORG_ID NUMBER := OKE_API.G_MISS_NUM,
20: SHIP_FROM_LOCATION_ID NUMBER := OKE_API.G_MISS_NUM,
21: DIRECTION VARCHAR2(3) := OKE_API.G_MISS_CHAR,
22: INVENTORY_ORG_ID NUMBER := OKE_API.G_MISS_NUM,
23: DEFAULTED_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
24: IN_PROCESS_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
25: WF_ITEM_KEY VARCHAR2(240) := OKE_API.G_MISS_CHAR,

Line 22: INVENTORY_ORG_ID NUMBER := OKE_API.G_MISS_NUM,

18: SHIP_TO_LOCATION_ID NUMBER := OKE_API.G_MISS_NUM,
19: SHIP_FROM_ORG_ID NUMBER := OKE_API.G_MISS_NUM,
20: SHIP_FROM_LOCATION_ID NUMBER := OKE_API.G_MISS_NUM,
21: DIRECTION VARCHAR2(3) := OKE_API.G_MISS_CHAR,
22: INVENTORY_ORG_ID NUMBER := OKE_API.G_MISS_NUM,
23: DEFAULTED_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
24: IN_PROCESS_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
25: WF_ITEM_KEY VARCHAR2(240) := OKE_API.G_MISS_CHAR,
26: SUB_REF_ID NUMBER := OKE_API.G_MISS_NUM,

Line 23: DEFAULTED_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,

19: SHIP_FROM_ORG_ID NUMBER := OKE_API.G_MISS_NUM,
20: SHIP_FROM_LOCATION_ID NUMBER := OKE_API.G_MISS_NUM,
21: DIRECTION VARCHAR2(3) := OKE_API.G_MISS_CHAR,
22: INVENTORY_ORG_ID NUMBER := OKE_API.G_MISS_NUM,
23: DEFAULTED_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
24: IN_PROCESS_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
25: WF_ITEM_KEY VARCHAR2(240) := OKE_API.G_MISS_CHAR,
26: SUB_REF_ID NUMBER := OKE_API.G_MISS_NUM,
27: START_DATE DATE := OKE_API.G_MISS_DATE,

Line 24: IN_PROCESS_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,

20: SHIP_FROM_LOCATION_ID NUMBER := OKE_API.G_MISS_NUM,
21: DIRECTION VARCHAR2(3) := OKE_API.G_MISS_CHAR,
22: INVENTORY_ORG_ID NUMBER := OKE_API.G_MISS_NUM,
23: DEFAULTED_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
24: IN_PROCESS_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
25: WF_ITEM_KEY VARCHAR2(240) := OKE_API.G_MISS_CHAR,
26: SUB_REF_ID NUMBER := OKE_API.G_MISS_NUM,
27: START_DATE DATE := OKE_API.G_MISS_DATE,
28: END_DATE DATE := OKE_API.G_MISS_DATE,

Line 25: WF_ITEM_KEY VARCHAR2(240) := OKE_API.G_MISS_CHAR,

21: DIRECTION VARCHAR2(3) := OKE_API.G_MISS_CHAR,
22: INVENTORY_ORG_ID NUMBER := OKE_API.G_MISS_NUM,
23: DEFAULTED_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
24: IN_PROCESS_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
25: WF_ITEM_KEY VARCHAR2(240) := OKE_API.G_MISS_CHAR,
26: SUB_REF_ID NUMBER := OKE_API.G_MISS_NUM,
27: START_DATE DATE := OKE_API.G_MISS_DATE,
28: END_DATE DATE := OKE_API.G_MISS_DATE,
29: PRIORITY_CODE VARCHAR2(30) := OKE_API.G_MISS_CHAR,

Line 26: SUB_REF_ID NUMBER := OKE_API.G_MISS_NUM,

22: INVENTORY_ORG_ID NUMBER := OKE_API.G_MISS_NUM,
23: DEFAULTED_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
24: IN_PROCESS_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
25: WF_ITEM_KEY VARCHAR2(240) := OKE_API.G_MISS_CHAR,
26: SUB_REF_ID NUMBER := OKE_API.G_MISS_NUM,
27: START_DATE DATE := OKE_API.G_MISS_DATE,
28: END_DATE DATE := OKE_API.G_MISS_DATE,
29: PRIORITY_CODE VARCHAR2(30) := OKE_API.G_MISS_CHAR,
30: CURRENCY_CODE VARCHAR2(15) := OKE_API.G_MISS_CHAR,

Line 27: START_DATE DATE := OKE_API.G_MISS_DATE,

23: DEFAULTED_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
24: IN_PROCESS_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
25: WF_ITEM_KEY VARCHAR2(240) := OKE_API.G_MISS_CHAR,
26: SUB_REF_ID NUMBER := OKE_API.G_MISS_NUM,
27: START_DATE DATE := OKE_API.G_MISS_DATE,
28: END_DATE DATE := OKE_API.G_MISS_DATE,
29: PRIORITY_CODE VARCHAR2(30) := OKE_API.G_MISS_CHAR,
30: CURRENCY_CODE VARCHAR2(15) := OKE_API.G_MISS_CHAR,
31: UNIT_PRICE NUMBER := OKE_API.G_MISS_NUM,

Line 28: END_DATE DATE := OKE_API.G_MISS_DATE,

24: IN_PROCESS_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
25: WF_ITEM_KEY VARCHAR2(240) := OKE_API.G_MISS_CHAR,
26: SUB_REF_ID NUMBER := OKE_API.G_MISS_NUM,
27: START_DATE DATE := OKE_API.G_MISS_DATE,
28: END_DATE DATE := OKE_API.G_MISS_DATE,
29: PRIORITY_CODE VARCHAR2(30) := OKE_API.G_MISS_CHAR,
30: CURRENCY_CODE VARCHAR2(15) := OKE_API.G_MISS_CHAR,
31: UNIT_PRICE NUMBER := OKE_API.G_MISS_NUM,
32: UOM_CODE VARCHAR2(30) := OKE_API.G_MISS_CHAR,

Line 29: PRIORITY_CODE VARCHAR2(30) := OKE_API.G_MISS_CHAR,

25: WF_ITEM_KEY VARCHAR2(240) := OKE_API.G_MISS_CHAR,
26: SUB_REF_ID NUMBER := OKE_API.G_MISS_NUM,
27: START_DATE DATE := OKE_API.G_MISS_DATE,
28: END_DATE DATE := OKE_API.G_MISS_DATE,
29: PRIORITY_CODE VARCHAR2(30) := OKE_API.G_MISS_CHAR,
30: CURRENCY_CODE VARCHAR2(15) := OKE_API.G_MISS_CHAR,
31: UNIT_PRICE NUMBER := OKE_API.G_MISS_NUM,
32: UOM_CODE VARCHAR2(30) := OKE_API.G_MISS_CHAR,
33: QUANTITY NUMBER := OKE_API.G_MISS_NUM,

Line 30: CURRENCY_CODE VARCHAR2(15) := OKE_API.G_MISS_CHAR,

26: SUB_REF_ID NUMBER := OKE_API.G_MISS_NUM,
27: START_DATE DATE := OKE_API.G_MISS_DATE,
28: END_DATE DATE := OKE_API.G_MISS_DATE,
29: PRIORITY_CODE VARCHAR2(30) := OKE_API.G_MISS_CHAR,
30: CURRENCY_CODE VARCHAR2(15) := OKE_API.G_MISS_CHAR,
31: UNIT_PRICE NUMBER := OKE_API.G_MISS_NUM,
32: UOM_CODE VARCHAR2(30) := OKE_API.G_MISS_CHAR,
33: QUANTITY NUMBER := OKE_API.G_MISS_NUM,
34: COUNTRY_OF_ORIGIN_CODE VARCHAR2(30) := OKE_API.G_MISS_CHAR,

Line 31: UNIT_PRICE NUMBER := OKE_API.G_MISS_NUM,

27: START_DATE DATE := OKE_API.G_MISS_DATE,
28: END_DATE DATE := OKE_API.G_MISS_DATE,
29: PRIORITY_CODE VARCHAR2(30) := OKE_API.G_MISS_CHAR,
30: CURRENCY_CODE VARCHAR2(15) := OKE_API.G_MISS_CHAR,
31: UNIT_PRICE NUMBER := OKE_API.G_MISS_NUM,
32: UOM_CODE VARCHAR2(30) := OKE_API.G_MISS_CHAR,
33: QUANTITY NUMBER := OKE_API.G_MISS_NUM,
34: COUNTRY_OF_ORIGIN_CODE VARCHAR2(30) := OKE_API.G_MISS_CHAR,
35: SUBCONTRACTED_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,

Line 32: UOM_CODE VARCHAR2(30) := OKE_API.G_MISS_CHAR,

28: END_DATE DATE := OKE_API.G_MISS_DATE,
29: PRIORITY_CODE VARCHAR2(30) := OKE_API.G_MISS_CHAR,
30: CURRENCY_CODE VARCHAR2(15) := OKE_API.G_MISS_CHAR,
31: UNIT_PRICE NUMBER := OKE_API.G_MISS_NUM,
32: UOM_CODE VARCHAR2(30) := OKE_API.G_MISS_CHAR,
33: QUANTITY NUMBER := OKE_API.G_MISS_NUM,
34: COUNTRY_OF_ORIGIN_CODE VARCHAR2(30) := OKE_API.G_MISS_CHAR,
35: SUBCONTRACTED_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
36: DEPENDENCY_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,

Line 33: QUANTITY NUMBER := OKE_API.G_MISS_NUM,

29: PRIORITY_CODE VARCHAR2(30) := OKE_API.G_MISS_CHAR,
30: CURRENCY_CODE VARCHAR2(15) := OKE_API.G_MISS_CHAR,
31: UNIT_PRICE NUMBER := OKE_API.G_MISS_NUM,
32: UOM_CODE VARCHAR2(30) := OKE_API.G_MISS_CHAR,
33: QUANTITY NUMBER := OKE_API.G_MISS_NUM,
34: COUNTRY_OF_ORIGIN_CODE VARCHAR2(30) := OKE_API.G_MISS_CHAR,
35: SUBCONTRACTED_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
36: DEPENDENCY_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
37: BILLABLE_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,

Line 34: COUNTRY_OF_ORIGIN_CODE VARCHAR2(30) := OKE_API.G_MISS_CHAR,

30: CURRENCY_CODE VARCHAR2(15) := OKE_API.G_MISS_CHAR,
31: UNIT_PRICE NUMBER := OKE_API.G_MISS_NUM,
32: UOM_CODE VARCHAR2(30) := OKE_API.G_MISS_CHAR,
33: QUANTITY NUMBER := OKE_API.G_MISS_NUM,
34: COUNTRY_OF_ORIGIN_CODE VARCHAR2(30) := OKE_API.G_MISS_CHAR,
35: SUBCONTRACTED_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
36: DEPENDENCY_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
37: BILLABLE_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
38: BILLING_EVENT_ID NUMBER := OKE_API.G_MISS_NUM,

Line 35: SUBCONTRACTED_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,

31: UNIT_PRICE NUMBER := OKE_API.G_MISS_NUM,
32: UOM_CODE VARCHAR2(30) := OKE_API.G_MISS_CHAR,
33: QUANTITY NUMBER := OKE_API.G_MISS_NUM,
34: COUNTRY_OF_ORIGIN_CODE VARCHAR2(30) := OKE_API.G_MISS_CHAR,
35: SUBCONTRACTED_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
36: DEPENDENCY_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
37: BILLABLE_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
38: BILLING_EVENT_ID NUMBER := OKE_API.G_MISS_NUM,
39: DROP_SHIPPED_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,

Line 36: DEPENDENCY_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,

32: UOM_CODE VARCHAR2(30) := OKE_API.G_MISS_CHAR,
33: QUANTITY NUMBER := OKE_API.G_MISS_NUM,
34: COUNTRY_OF_ORIGIN_CODE VARCHAR2(30) := OKE_API.G_MISS_CHAR,
35: SUBCONTRACTED_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
36: DEPENDENCY_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
37: BILLABLE_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
38: BILLING_EVENT_ID NUMBER := OKE_API.G_MISS_NUM,
39: DROP_SHIPPED_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
40: COMPLETED_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,

Line 37: BILLABLE_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,

33: QUANTITY NUMBER := OKE_API.G_MISS_NUM,
34: COUNTRY_OF_ORIGIN_CODE VARCHAR2(30) := OKE_API.G_MISS_CHAR,
35: SUBCONTRACTED_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
36: DEPENDENCY_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
37: BILLABLE_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
38: BILLING_EVENT_ID NUMBER := OKE_API.G_MISS_NUM,
39: DROP_SHIPPED_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
40: COMPLETED_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
41: AVAILABLE_FOR_SHIP_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,

Line 38: BILLING_EVENT_ID NUMBER := OKE_API.G_MISS_NUM,

34: COUNTRY_OF_ORIGIN_CODE VARCHAR2(30) := OKE_API.G_MISS_CHAR,
35: SUBCONTRACTED_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
36: DEPENDENCY_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
37: BILLABLE_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
38: BILLING_EVENT_ID NUMBER := OKE_API.G_MISS_NUM,
39: DROP_SHIPPED_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
40: COMPLETED_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
41: AVAILABLE_FOR_SHIP_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
42: CREATE_DEMAND VARCHAR2(1) := OKE_API.G_MISS_CHAR,

Line 39: DROP_SHIPPED_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,

35: SUBCONTRACTED_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
36: DEPENDENCY_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
37: BILLABLE_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
38: BILLING_EVENT_ID NUMBER := OKE_API.G_MISS_NUM,
39: DROP_SHIPPED_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
40: COMPLETED_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
41: AVAILABLE_FOR_SHIP_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
42: CREATE_DEMAND VARCHAR2(1) := OKE_API.G_MISS_CHAR,
43: READY_TO_BILL VARCHAR2(1) := OKE_API.G_MISS_CHAR,

Line 40: COMPLETED_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,

36: DEPENDENCY_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
37: BILLABLE_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
38: BILLING_EVENT_ID NUMBER := OKE_API.G_MISS_NUM,
39: DROP_SHIPPED_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
40: COMPLETED_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
41: AVAILABLE_FOR_SHIP_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
42: CREATE_DEMAND VARCHAR2(1) := OKE_API.G_MISS_CHAR,
43: READY_TO_BILL VARCHAR2(1) := OKE_API.G_MISS_CHAR,
44: NEED_BY_DATE DATE := OKE_API.G_MISS_DATE,

Line 41: AVAILABLE_FOR_SHIP_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,

37: BILLABLE_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
38: BILLING_EVENT_ID NUMBER := OKE_API.G_MISS_NUM,
39: DROP_SHIPPED_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
40: COMPLETED_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
41: AVAILABLE_FOR_SHIP_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
42: CREATE_DEMAND VARCHAR2(1) := OKE_API.G_MISS_CHAR,
43: READY_TO_BILL VARCHAR2(1) := OKE_API.G_MISS_CHAR,
44: NEED_BY_DATE DATE := OKE_API.G_MISS_DATE,
45: READY_TO_PROCURE VARCHAR2(1) := OKE_API.G_MISS_CHAR,

Line 42: CREATE_DEMAND VARCHAR2(1) := OKE_API.G_MISS_CHAR,

38: BILLING_EVENT_ID NUMBER := OKE_API.G_MISS_NUM,
39: DROP_SHIPPED_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
40: COMPLETED_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
41: AVAILABLE_FOR_SHIP_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
42: CREATE_DEMAND VARCHAR2(1) := OKE_API.G_MISS_CHAR,
43: READY_TO_BILL VARCHAR2(1) := OKE_API.G_MISS_CHAR,
44: NEED_BY_DATE DATE := OKE_API.G_MISS_DATE,
45: READY_TO_PROCURE VARCHAR2(1) := OKE_API.G_MISS_CHAR,
46: MPS_TRANSACTION_ID NUMBER := OKE_API.G_MISS_NUM,

Line 43: READY_TO_BILL VARCHAR2(1) := OKE_API.G_MISS_CHAR,

39: DROP_SHIPPED_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
40: COMPLETED_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
41: AVAILABLE_FOR_SHIP_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
42: CREATE_DEMAND VARCHAR2(1) := OKE_API.G_MISS_CHAR,
43: READY_TO_BILL VARCHAR2(1) := OKE_API.G_MISS_CHAR,
44: NEED_BY_DATE DATE := OKE_API.G_MISS_DATE,
45: READY_TO_PROCURE VARCHAR2(1) := OKE_API.G_MISS_CHAR,
46: MPS_TRANSACTION_ID NUMBER := OKE_API.G_MISS_NUM,
47: PO_REF_1 NUMBER := OKE_API.G_MISS_NUM,

Line 44: NEED_BY_DATE DATE := OKE_API.G_MISS_DATE,

40: COMPLETED_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
41: AVAILABLE_FOR_SHIP_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
42: CREATE_DEMAND VARCHAR2(1) := OKE_API.G_MISS_CHAR,
43: READY_TO_BILL VARCHAR2(1) := OKE_API.G_MISS_CHAR,
44: NEED_BY_DATE DATE := OKE_API.G_MISS_DATE,
45: READY_TO_PROCURE VARCHAR2(1) := OKE_API.G_MISS_CHAR,
46: MPS_TRANSACTION_ID NUMBER := OKE_API.G_MISS_NUM,
47: PO_REF_1 NUMBER := OKE_API.G_MISS_NUM,
48: PO_REF_2 NUMBER := OKE_API.G_MISS_NUM,

Line 45: READY_TO_PROCURE VARCHAR2(1) := OKE_API.G_MISS_CHAR,

41: AVAILABLE_FOR_SHIP_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
42: CREATE_DEMAND VARCHAR2(1) := OKE_API.G_MISS_CHAR,
43: READY_TO_BILL VARCHAR2(1) := OKE_API.G_MISS_CHAR,
44: NEED_BY_DATE DATE := OKE_API.G_MISS_DATE,
45: READY_TO_PROCURE VARCHAR2(1) := OKE_API.G_MISS_CHAR,
46: MPS_TRANSACTION_ID NUMBER := OKE_API.G_MISS_NUM,
47: PO_REF_1 NUMBER := OKE_API.G_MISS_NUM,
48: PO_REF_2 NUMBER := OKE_API.G_MISS_NUM,
49: PO_REF_3 NUMBER := OKE_API.G_MISS_NUM,

Line 46: MPS_TRANSACTION_ID NUMBER := OKE_API.G_MISS_NUM,

42: CREATE_DEMAND VARCHAR2(1) := OKE_API.G_MISS_CHAR,
43: READY_TO_BILL VARCHAR2(1) := OKE_API.G_MISS_CHAR,
44: NEED_BY_DATE DATE := OKE_API.G_MISS_DATE,
45: READY_TO_PROCURE VARCHAR2(1) := OKE_API.G_MISS_CHAR,
46: MPS_TRANSACTION_ID NUMBER := OKE_API.G_MISS_NUM,
47: PO_REF_1 NUMBER := OKE_API.G_MISS_NUM,
48: PO_REF_2 NUMBER := OKE_API.G_MISS_NUM,
49: PO_REF_3 NUMBER := OKE_API.G_MISS_NUM,
50: SHIPPING_REQUEST_ID NUMBER := OKE_API.G_MISS_NUM,

Line 47: PO_REF_1 NUMBER := OKE_API.G_MISS_NUM,

43: READY_TO_BILL VARCHAR2(1) := OKE_API.G_MISS_CHAR,
44: NEED_BY_DATE DATE := OKE_API.G_MISS_DATE,
45: READY_TO_PROCURE VARCHAR2(1) := OKE_API.G_MISS_CHAR,
46: MPS_TRANSACTION_ID NUMBER := OKE_API.G_MISS_NUM,
47: PO_REF_1 NUMBER := OKE_API.G_MISS_NUM,
48: PO_REF_2 NUMBER := OKE_API.G_MISS_NUM,
49: PO_REF_3 NUMBER := OKE_API.G_MISS_NUM,
50: SHIPPING_REQUEST_ID NUMBER := OKE_API.G_MISS_NUM,
51: UNIT_NUMBER VARCHAR2(80) := OKE_API.G_MISS_CHAR,

Line 48: PO_REF_2 NUMBER := OKE_API.G_MISS_NUM,

44: NEED_BY_DATE DATE := OKE_API.G_MISS_DATE,
45: READY_TO_PROCURE VARCHAR2(1) := OKE_API.G_MISS_CHAR,
46: MPS_TRANSACTION_ID NUMBER := OKE_API.G_MISS_NUM,
47: PO_REF_1 NUMBER := OKE_API.G_MISS_NUM,
48: PO_REF_2 NUMBER := OKE_API.G_MISS_NUM,
49: PO_REF_3 NUMBER := OKE_API.G_MISS_NUM,
50: SHIPPING_REQUEST_ID NUMBER := OKE_API.G_MISS_NUM,
51: UNIT_NUMBER VARCHAR2(80) := OKE_API.G_MISS_CHAR,
52: NDB_SCHEDULE_DESIGNATOR VARCHAR2(10) := OKE_API.G_MISS_CHAR,

Line 49: PO_REF_3 NUMBER := OKE_API.G_MISS_NUM,

45: READY_TO_PROCURE VARCHAR2(1) := OKE_API.G_MISS_CHAR,
46: MPS_TRANSACTION_ID NUMBER := OKE_API.G_MISS_NUM,
47: PO_REF_1 NUMBER := OKE_API.G_MISS_NUM,
48: PO_REF_2 NUMBER := OKE_API.G_MISS_NUM,
49: PO_REF_3 NUMBER := OKE_API.G_MISS_NUM,
50: SHIPPING_REQUEST_ID NUMBER := OKE_API.G_MISS_NUM,
51: UNIT_NUMBER VARCHAR2(80) := OKE_API.G_MISS_CHAR,
52: NDB_SCHEDULE_DESIGNATOR VARCHAR2(10) := OKE_API.G_MISS_CHAR,
53: SHIPPABLE_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,

Line 50: SHIPPING_REQUEST_ID NUMBER := OKE_API.G_MISS_NUM,

46: MPS_TRANSACTION_ID NUMBER := OKE_API.G_MISS_NUM,
47: PO_REF_1 NUMBER := OKE_API.G_MISS_NUM,
48: PO_REF_2 NUMBER := OKE_API.G_MISS_NUM,
49: PO_REF_3 NUMBER := OKE_API.G_MISS_NUM,
50: SHIPPING_REQUEST_ID NUMBER := OKE_API.G_MISS_NUM,
51: UNIT_NUMBER VARCHAR2(80) := OKE_API.G_MISS_CHAR,
52: NDB_SCHEDULE_DESIGNATOR VARCHAR2(10) := OKE_API.G_MISS_CHAR,
53: SHIPPABLE_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
54: CFE_REQ_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,

Line 51: UNIT_NUMBER VARCHAR2(80) := OKE_API.G_MISS_CHAR,

47: PO_REF_1 NUMBER := OKE_API.G_MISS_NUM,
48: PO_REF_2 NUMBER := OKE_API.G_MISS_NUM,
49: PO_REF_3 NUMBER := OKE_API.G_MISS_NUM,
50: SHIPPING_REQUEST_ID NUMBER := OKE_API.G_MISS_NUM,
51: UNIT_NUMBER VARCHAR2(80) := OKE_API.G_MISS_CHAR,
52: NDB_SCHEDULE_DESIGNATOR VARCHAR2(10) := OKE_API.G_MISS_CHAR,
53: SHIPPABLE_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
54: CFE_REQ_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
55: INSPECTION_REQ_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,

Line 52: NDB_SCHEDULE_DESIGNATOR VARCHAR2(10) := OKE_API.G_MISS_CHAR,

48: PO_REF_2 NUMBER := OKE_API.G_MISS_NUM,
49: PO_REF_3 NUMBER := OKE_API.G_MISS_NUM,
50: SHIPPING_REQUEST_ID NUMBER := OKE_API.G_MISS_NUM,
51: UNIT_NUMBER VARCHAR2(80) := OKE_API.G_MISS_CHAR,
52: NDB_SCHEDULE_DESIGNATOR VARCHAR2(10) := OKE_API.G_MISS_CHAR,
53: SHIPPABLE_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
54: CFE_REQ_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
55: INSPECTION_REQ_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
56: INTERIM_RPT_REQ_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,

Line 53: SHIPPABLE_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,

49: PO_REF_3 NUMBER := OKE_API.G_MISS_NUM,
50: SHIPPING_REQUEST_ID NUMBER := OKE_API.G_MISS_NUM,
51: UNIT_NUMBER VARCHAR2(80) := OKE_API.G_MISS_CHAR,
52: NDB_SCHEDULE_DESIGNATOR VARCHAR2(10) := OKE_API.G_MISS_CHAR,
53: SHIPPABLE_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
54: CFE_REQ_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
55: INSPECTION_REQ_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
56: INTERIM_RPT_REQ_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
57: LOT_APPLIES_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,

Line 54: CFE_REQ_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,

50: SHIPPING_REQUEST_ID NUMBER := OKE_API.G_MISS_NUM,
51: UNIT_NUMBER VARCHAR2(80) := OKE_API.G_MISS_CHAR,
52: NDB_SCHEDULE_DESIGNATOR VARCHAR2(10) := OKE_API.G_MISS_CHAR,
53: SHIPPABLE_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
54: CFE_REQ_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
55: INSPECTION_REQ_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
56: INTERIM_RPT_REQ_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
57: LOT_APPLIES_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
58: CUSTOMER_APPROVAL_REQ_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,

Line 55: INSPECTION_REQ_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,

51: UNIT_NUMBER VARCHAR2(80) := OKE_API.G_MISS_CHAR,
52: NDB_SCHEDULE_DESIGNATOR VARCHAR2(10) := OKE_API.G_MISS_CHAR,
53: SHIPPABLE_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
54: CFE_REQ_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
55: INSPECTION_REQ_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
56: INTERIM_RPT_REQ_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
57: LOT_APPLIES_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
58: CUSTOMER_APPROVAL_REQ_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
59: EXPECTED_SHIPMENT_DATE DATE := OKE_API.G_MISS_DATE,

Line 56: INTERIM_RPT_REQ_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,

52: NDB_SCHEDULE_DESIGNATOR VARCHAR2(10) := OKE_API.G_MISS_CHAR,
53: SHIPPABLE_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
54: CFE_REQ_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
55: INSPECTION_REQ_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
56: INTERIM_RPT_REQ_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
57: LOT_APPLIES_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
58: CUSTOMER_APPROVAL_REQ_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
59: EXPECTED_SHIPMENT_DATE DATE := OKE_API.G_MISS_DATE,
60: INITIATE_SHIPMENT_DATE DATE := OKE_API.G_MISS_DATE,

Line 57: LOT_APPLIES_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,

53: SHIPPABLE_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
54: CFE_REQ_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
55: INSPECTION_REQ_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
56: INTERIM_RPT_REQ_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
57: LOT_APPLIES_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
58: CUSTOMER_APPROVAL_REQ_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
59: EXPECTED_SHIPMENT_DATE DATE := OKE_API.G_MISS_DATE,
60: INITIATE_SHIPMENT_DATE DATE := OKE_API.G_MISS_DATE,
61: PROMISED_SHIPMENT_DATE DATE := OKE_API.G_MISS_DATE,

Line 58: CUSTOMER_APPROVAL_REQ_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,

54: CFE_REQ_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
55: INSPECTION_REQ_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
56: INTERIM_RPT_REQ_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
57: LOT_APPLIES_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
58: CUSTOMER_APPROVAL_REQ_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
59: EXPECTED_SHIPMENT_DATE DATE := OKE_API.G_MISS_DATE,
60: INITIATE_SHIPMENT_DATE DATE := OKE_API.G_MISS_DATE,
61: PROMISED_SHIPMENT_DATE DATE := OKE_API.G_MISS_DATE,
62: AS_OF_DATE DATE := OKE_API.G_MISS_DATE,

Line 59: EXPECTED_SHIPMENT_DATE DATE := OKE_API.G_MISS_DATE,

55: INSPECTION_REQ_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
56: INTERIM_RPT_REQ_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
57: LOT_APPLIES_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
58: CUSTOMER_APPROVAL_REQ_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
59: EXPECTED_SHIPMENT_DATE DATE := OKE_API.G_MISS_DATE,
60: INITIATE_SHIPMENT_DATE DATE := OKE_API.G_MISS_DATE,
61: PROMISED_SHIPMENT_DATE DATE := OKE_API.G_MISS_DATE,
62: AS_OF_DATE DATE := OKE_API.G_MISS_DATE,
63: DATE_OF_FIRST_SUBMISSION DATE := OKE_API.G_MISS_DATE,

Line 60: INITIATE_SHIPMENT_DATE DATE := OKE_API.G_MISS_DATE,

56: INTERIM_RPT_REQ_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
57: LOT_APPLIES_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
58: CUSTOMER_APPROVAL_REQ_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
59: EXPECTED_SHIPMENT_DATE DATE := OKE_API.G_MISS_DATE,
60: INITIATE_SHIPMENT_DATE DATE := OKE_API.G_MISS_DATE,
61: PROMISED_SHIPMENT_DATE DATE := OKE_API.G_MISS_DATE,
62: AS_OF_DATE DATE := OKE_API.G_MISS_DATE,
63: DATE_OF_FIRST_SUBMISSION DATE := OKE_API.G_MISS_DATE,
64: FREQUENCY VARCHAR2(30) := OKE_API.G_MISS_CHAR,

Line 61: PROMISED_SHIPMENT_DATE DATE := OKE_API.G_MISS_DATE,

57: LOT_APPLIES_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
58: CUSTOMER_APPROVAL_REQ_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
59: EXPECTED_SHIPMENT_DATE DATE := OKE_API.G_MISS_DATE,
60: INITIATE_SHIPMENT_DATE DATE := OKE_API.G_MISS_DATE,
61: PROMISED_SHIPMENT_DATE DATE := OKE_API.G_MISS_DATE,
62: AS_OF_DATE DATE := OKE_API.G_MISS_DATE,
63: DATE_OF_FIRST_SUBMISSION DATE := OKE_API.G_MISS_DATE,
64: FREQUENCY VARCHAR2(30) := OKE_API.G_MISS_CHAR,
65: ACQ_DOC_NUMBER VARCHAR2(30) := OKE_API.G_MISS_CHAR,

Line 62: AS_OF_DATE DATE := OKE_API.G_MISS_DATE,

58: CUSTOMER_APPROVAL_REQ_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
59: EXPECTED_SHIPMENT_DATE DATE := OKE_API.G_MISS_DATE,
60: INITIATE_SHIPMENT_DATE DATE := OKE_API.G_MISS_DATE,
61: PROMISED_SHIPMENT_DATE DATE := OKE_API.G_MISS_DATE,
62: AS_OF_DATE DATE := OKE_API.G_MISS_DATE,
63: DATE_OF_FIRST_SUBMISSION DATE := OKE_API.G_MISS_DATE,
64: FREQUENCY VARCHAR2(30) := OKE_API.G_MISS_CHAR,
65: ACQ_DOC_NUMBER VARCHAR2(30) := OKE_API.G_MISS_CHAR,
66: SUBMISSION_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,

Line 63: DATE_OF_FIRST_SUBMISSION DATE := OKE_API.G_MISS_DATE,

59: EXPECTED_SHIPMENT_DATE DATE := OKE_API.G_MISS_DATE,
60: INITIATE_SHIPMENT_DATE DATE := OKE_API.G_MISS_DATE,
61: PROMISED_SHIPMENT_DATE DATE := OKE_API.G_MISS_DATE,
62: AS_OF_DATE DATE := OKE_API.G_MISS_DATE,
63: DATE_OF_FIRST_SUBMISSION DATE := OKE_API.G_MISS_DATE,
64: FREQUENCY VARCHAR2(30) := OKE_API.G_MISS_CHAR,
65: ACQ_DOC_NUMBER VARCHAR2(30) := OKE_API.G_MISS_CHAR,
66: SUBMISSION_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
67: DATA_ITEM_SUBTITLE VARCHAR2(30) := OKE_API.G_MISS_CHAR,

Line 64: FREQUENCY VARCHAR2(30) := OKE_API.G_MISS_CHAR,

60: INITIATE_SHIPMENT_DATE DATE := OKE_API.G_MISS_DATE,
61: PROMISED_SHIPMENT_DATE DATE := OKE_API.G_MISS_DATE,
62: AS_OF_DATE DATE := OKE_API.G_MISS_DATE,
63: DATE_OF_FIRST_SUBMISSION DATE := OKE_API.G_MISS_DATE,
64: FREQUENCY VARCHAR2(30) := OKE_API.G_MISS_CHAR,
65: ACQ_DOC_NUMBER VARCHAR2(30) := OKE_API.G_MISS_CHAR,
66: SUBMISSION_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
67: DATA_ITEM_SUBTITLE VARCHAR2(30) := OKE_API.G_MISS_CHAR,
68: TOTAL_NUM_OF_COPIES NUMBER := OKE_API.G_MISS_NUM,

Line 65: ACQ_DOC_NUMBER VARCHAR2(30) := OKE_API.G_MISS_CHAR,

61: PROMISED_SHIPMENT_DATE DATE := OKE_API.G_MISS_DATE,
62: AS_OF_DATE DATE := OKE_API.G_MISS_DATE,
63: DATE_OF_FIRST_SUBMISSION DATE := OKE_API.G_MISS_DATE,
64: FREQUENCY VARCHAR2(30) := OKE_API.G_MISS_CHAR,
65: ACQ_DOC_NUMBER VARCHAR2(30) := OKE_API.G_MISS_CHAR,
66: SUBMISSION_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
67: DATA_ITEM_SUBTITLE VARCHAR2(30) := OKE_API.G_MISS_CHAR,
68: TOTAL_NUM_OF_COPIES NUMBER := OKE_API.G_MISS_NUM,
69: CDRL_CATEGORY VARCHAR2(30) := OKE_API.G_MISS_CHAR,

Line 66: SUBMISSION_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,

62: AS_OF_DATE DATE := OKE_API.G_MISS_DATE,
63: DATE_OF_FIRST_SUBMISSION DATE := OKE_API.G_MISS_DATE,
64: FREQUENCY VARCHAR2(30) := OKE_API.G_MISS_CHAR,
65: ACQ_DOC_NUMBER VARCHAR2(30) := OKE_API.G_MISS_CHAR,
66: SUBMISSION_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
67: DATA_ITEM_SUBTITLE VARCHAR2(30) := OKE_API.G_MISS_CHAR,
68: TOTAL_NUM_OF_COPIES NUMBER := OKE_API.G_MISS_NUM,
69: CDRL_CATEGORY VARCHAR2(30) := OKE_API.G_MISS_CHAR,
70: DATA_ITEM_NAME VARCHAR2(30) := OKE_API.G_MISS_CHAR,

Line 67: DATA_ITEM_SUBTITLE VARCHAR2(30) := OKE_API.G_MISS_CHAR,

63: DATE_OF_FIRST_SUBMISSION DATE := OKE_API.G_MISS_DATE,
64: FREQUENCY VARCHAR2(30) := OKE_API.G_MISS_CHAR,
65: ACQ_DOC_NUMBER VARCHAR2(30) := OKE_API.G_MISS_CHAR,
66: SUBMISSION_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
67: DATA_ITEM_SUBTITLE VARCHAR2(30) := OKE_API.G_MISS_CHAR,
68: TOTAL_NUM_OF_COPIES NUMBER := OKE_API.G_MISS_NUM,
69: CDRL_CATEGORY VARCHAR2(30) := OKE_API.G_MISS_CHAR,
70: DATA_ITEM_NAME VARCHAR2(30) := OKE_API.G_MISS_CHAR,
71: EXPORT_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,

Line 68: TOTAL_NUM_OF_COPIES NUMBER := OKE_API.G_MISS_NUM,

64: FREQUENCY VARCHAR2(30) := OKE_API.G_MISS_CHAR,
65: ACQ_DOC_NUMBER VARCHAR2(30) := OKE_API.G_MISS_CHAR,
66: SUBMISSION_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
67: DATA_ITEM_SUBTITLE VARCHAR2(30) := OKE_API.G_MISS_CHAR,
68: TOTAL_NUM_OF_COPIES NUMBER := OKE_API.G_MISS_NUM,
69: CDRL_CATEGORY VARCHAR2(30) := OKE_API.G_MISS_CHAR,
70: DATA_ITEM_NAME VARCHAR2(30) := OKE_API.G_MISS_CHAR,
71: EXPORT_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
72: EXPORT_LICENSE_NUM VARCHAR2(30) := OKE_API.G_MISS_CHAR,

Line 69: CDRL_CATEGORY VARCHAR2(30) := OKE_API.G_MISS_CHAR,

65: ACQ_DOC_NUMBER VARCHAR2(30) := OKE_API.G_MISS_CHAR,
66: SUBMISSION_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
67: DATA_ITEM_SUBTITLE VARCHAR2(30) := OKE_API.G_MISS_CHAR,
68: TOTAL_NUM_OF_COPIES NUMBER := OKE_API.G_MISS_NUM,
69: CDRL_CATEGORY VARCHAR2(30) := OKE_API.G_MISS_CHAR,
70: DATA_ITEM_NAME VARCHAR2(30) := OKE_API.G_MISS_CHAR,
71: EXPORT_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
72: EXPORT_LICENSE_NUM VARCHAR2(30) := OKE_API.G_MISS_CHAR,
73: EXPORT_LICENSE_RES VARCHAR2(30) := OKE_API.G_MISS_CHAR,

Line 70: DATA_ITEM_NAME VARCHAR2(30) := OKE_API.G_MISS_CHAR,

66: SUBMISSION_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
67: DATA_ITEM_SUBTITLE VARCHAR2(30) := OKE_API.G_MISS_CHAR,
68: TOTAL_NUM_OF_COPIES NUMBER := OKE_API.G_MISS_NUM,
69: CDRL_CATEGORY VARCHAR2(30) := OKE_API.G_MISS_CHAR,
70: DATA_ITEM_NAME VARCHAR2(30) := OKE_API.G_MISS_CHAR,
71: EXPORT_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
72: EXPORT_LICENSE_NUM VARCHAR2(30) := OKE_API.G_MISS_CHAR,
73: EXPORT_LICENSE_RES VARCHAR2(30) := OKE_API.G_MISS_CHAR,
74: CREATED_BY NUMBER := OKE_API.G_MISS_NUM,

Line 71: EXPORT_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,

67: DATA_ITEM_SUBTITLE VARCHAR2(30) := OKE_API.G_MISS_CHAR,
68: TOTAL_NUM_OF_COPIES NUMBER := OKE_API.G_MISS_NUM,
69: CDRL_CATEGORY VARCHAR2(30) := OKE_API.G_MISS_CHAR,
70: DATA_ITEM_NAME VARCHAR2(30) := OKE_API.G_MISS_CHAR,
71: EXPORT_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
72: EXPORT_LICENSE_NUM VARCHAR2(30) := OKE_API.G_MISS_CHAR,
73: EXPORT_LICENSE_RES VARCHAR2(30) := OKE_API.G_MISS_CHAR,
74: CREATED_BY NUMBER := OKE_API.G_MISS_NUM,
75: CREATION_DATE DATE := OKE_API.G_MISS_DATE,

Line 72: EXPORT_LICENSE_NUM VARCHAR2(30) := OKE_API.G_MISS_CHAR,

68: TOTAL_NUM_OF_COPIES NUMBER := OKE_API.G_MISS_NUM,
69: CDRL_CATEGORY VARCHAR2(30) := OKE_API.G_MISS_CHAR,
70: DATA_ITEM_NAME VARCHAR2(30) := OKE_API.G_MISS_CHAR,
71: EXPORT_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
72: EXPORT_LICENSE_NUM VARCHAR2(30) := OKE_API.G_MISS_CHAR,
73: EXPORT_LICENSE_RES VARCHAR2(30) := OKE_API.G_MISS_CHAR,
74: CREATED_BY NUMBER := OKE_API.G_MISS_NUM,
75: CREATION_DATE DATE := OKE_API.G_MISS_DATE,
76: LAST_UPDATED_BY NUMBER := OKE_API.G_MISS_NUM,

Line 73: EXPORT_LICENSE_RES VARCHAR2(30) := OKE_API.G_MISS_CHAR,

69: CDRL_CATEGORY VARCHAR2(30) := OKE_API.G_MISS_CHAR,
70: DATA_ITEM_NAME VARCHAR2(30) := OKE_API.G_MISS_CHAR,
71: EXPORT_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
72: EXPORT_LICENSE_NUM VARCHAR2(30) := OKE_API.G_MISS_CHAR,
73: EXPORT_LICENSE_RES VARCHAR2(30) := OKE_API.G_MISS_CHAR,
74: CREATED_BY NUMBER := OKE_API.G_MISS_NUM,
75: CREATION_DATE DATE := OKE_API.G_MISS_DATE,
76: LAST_UPDATED_BY NUMBER := OKE_API.G_MISS_NUM,
77: LAST_UPDATE_LOGIN NUMBER := OKE_API.G_MISS_NUM,

Line 74: CREATED_BY NUMBER := OKE_API.G_MISS_NUM,

70: DATA_ITEM_NAME VARCHAR2(30) := OKE_API.G_MISS_CHAR,
71: EXPORT_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
72: EXPORT_LICENSE_NUM VARCHAR2(30) := OKE_API.G_MISS_CHAR,
73: EXPORT_LICENSE_RES VARCHAR2(30) := OKE_API.G_MISS_CHAR,
74: CREATED_BY NUMBER := OKE_API.G_MISS_NUM,
75: CREATION_DATE DATE := OKE_API.G_MISS_DATE,
76: LAST_UPDATED_BY NUMBER := OKE_API.G_MISS_NUM,
77: LAST_UPDATE_LOGIN NUMBER := OKE_API.G_MISS_NUM,
78: LAST_UPDATE_DATE DATE := OKE_API.G_MISS_DATE,

Line 75: CREATION_DATE DATE := OKE_API.G_MISS_DATE,

71: EXPORT_FLAG VARCHAR2(1) := OKE_API.G_MISS_CHAR,
72: EXPORT_LICENSE_NUM VARCHAR2(30) := OKE_API.G_MISS_CHAR,
73: EXPORT_LICENSE_RES VARCHAR2(30) := OKE_API.G_MISS_CHAR,
74: CREATED_BY NUMBER := OKE_API.G_MISS_NUM,
75: CREATION_DATE DATE := OKE_API.G_MISS_DATE,
76: LAST_UPDATED_BY NUMBER := OKE_API.G_MISS_NUM,
77: LAST_UPDATE_LOGIN NUMBER := OKE_API.G_MISS_NUM,
78: LAST_UPDATE_DATE DATE := OKE_API.G_MISS_DATE,
79: ATTRIBUTE_CATEGORY VARCHAR2(30) := OKE_API.G_MISS_CHAR,

Line 76: LAST_UPDATED_BY NUMBER := OKE_API.G_MISS_NUM,

72: EXPORT_LICENSE_NUM VARCHAR2(30) := OKE_API.G_MISS_CHAR,
73: EXPORT_LICENSE_RES VARCHAR2(30) := OKE_API.G_MISS_CHAR,
74: CREATED_BY NUMBER := OKE_API.G_MISS_NUM,
75: CREATION_DATE DATE := OKE_API.G_MISS_DATE,
76: LAST_UPDATED_BY NUMBER := OKE_API.G_MISS_NUM,
77: LAST_UPDATE_LOGIN NUMBER := OKE_API.G_MISS_NUM,
78: LAST_UPDATE_DATE DATE := OKE_API.G_MISS_DATE,
79: ATTRIBUTE_CATEGORY VARCHAR2(30) := OKE_API.G_MISS_CHAR,
80: ATTRIBUTE1 VARCHAR2(150) := OKE_API.G_MISS_CHAR,

Line 77: LAST_UPDATE_LOGIN NUMBER := OKE_API.G_MISS_NUM,

73: EXPORT_LICENSE_RES VARCHAR2(30) := OKE_API.G_MISS_CHAR,
74: CREATED_BY NUMBER := OKE_API.G_MISS_NUM,
75: CREATION_DATE DATE := OKE_API.G_MISS_DATE,
76: LAST_UPDATED_BY NUMBER := OKE_API.G_MISS_NUM,
77: LAST_UPDATE_LOGIN NUMBER := OKE_API.G_MISS_NUM,
78: LAST_UPDATE_DATE DATE := OKE_API.G_MISS_DATE,
79: ATTRIBUTE_CATEGORY VARCHAR2(30) := OKE_API.G_MISS_CHAR,
80: ATTRIBUTE1 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
81: ATTRIBUTE2 VARCHAR2(150) := OKE_API.G_MISS_CHAR,

Line 78: LAST_UPDATE_DATE DATE := OKE_API.G_MISS_DATE,

74: CREATED_BY NUMBER := OKE_API.G_MISS_NUM,
75: CREATION_DATE DATE := OKE_API.G_MISS_DATE,
76: LAST_UPDATED_BY NUMBER := OKE_API.G_MISS_NUM,
77: LAST_UPDATE_LOGIN NUMBER := OKE_API.G_MISS_NUM,
78: LAST_UPDATE_DATE DATE := OKE_API.G_MISS_DATE,
79: ATTRIBUTE_CATEGORY VARCHAR2(30) := OKE_API.G_MISS_CHAR,
80: ATTRIBUTE1 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
81: ATTRIBUTE2 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
82: ATTRIBUTE3 VARCHAR2(150) := OKE_API.G_MISS_CHAR,

Line 79: ATTRIBUTE_CATEGORY VARCHAR2(30) := OKE_API.G_MISS_CHAR,

75: CREATION_DATE DATE := OKE_API.G_MISS_DATE,
76: LAST_UPDATED_BY NUMBER := OKE_API.G_MISS_NUM,
77: LAST_UPDATE_LOGIN NUMBER := OKE_API.G_MISS_NUM,
78: LAST_UPDATE_DATE DATE := OKE_API.G_MISS_DATE,
79: ATTRIBUTE_CATEGORY VARCHAR2(30) := OKE_API.G_MISS_CHAR,
80: ATTRIBUTE1 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
81: ATTRIBUTE2 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
82: ATTRIBUTE3 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
83: ATTRIBUTE4 VARCHAR2(150) := OKE_API.G_MISS_CHAR,

Line 80: ATTRIBUTE1 VARCHAR2(150) := OKE_API.G_MISS_CHAR,

76: LAST_UPDATED_BY NUMBER := OKE_API.G_MISS_NUM,
77: LAST_UPDATE_LOGIN NUMBER := OKE_API.G_MISS_NUM,
78: LAST_UPDATE_DATE DATE := OKE_API.G_MISS_DATE,
79: ATTRIBUTE_CATEGORY VARCHAR2(30) := OKE_API.G_MISS_CHAR,
80: ATTRIBUTE1 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
81: ATTRIBUTE2 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
82: ATTRIBUTE3 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
83: ATTRIBUTE4 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
84: ATTRIBUTE5 VARCHAR2(150) := OKE_API.G_MISS_CHAR,

Line 81: ATTRIBUTE2 VARCHAR2(150) := OKE_API.G_MISS_CHAR,

77: LAST_UPDATE_LOGIN NUMBER := OKE_API.G_MISS_NUM,
78: LAST_UPDATE_DATE DATE := OKE_API.G_MISS_DATE,
79: ATTRIBUTE_CATEGORY VARCHAR2(30) := OKE_API.G_MISS_CHAR,
80: ATTRIBUTE1 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
81: ATTRIBUTE2 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
82: ATTRIBUTE3 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
83: ATTRIBUTE4 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
84: ATTRIBUTE5 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
85: ATTRIBUTE6 VARCHAR2(150) := OKE_API.G_MISS_CHAR,

Line 82: ATTRIBUTE3 VARCHAR2(150) := OKE_API.G_MISS_CHAR,

78: LAST_UPDATE_DATE DATE := OKE_API.G_MISS_DATE,
79: ATTRIBUTE_CATEGORY VARCHAR2(30) := OKE_API.G_MISS_CHAR,
80: ATTRIBUTE1 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
81: ATTRIBUTE2 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
82: ATTRIBUTE3 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
83: ATTRIBUTE4 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
84: ATTRIBUTE5 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
85: ATTRIBUTE6 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
86: ATTRIBUTE7 VARCHAR2(150) := OKE_API.G_MISS_CHAR,

Line 83: ATTRIBUTE4 VARCHAR2(150) := OKE_API.G_MISS_CHAR,

79: ATTRIBUTE_CATEGORY VARCHAR2(30) := OKE_API.G_MISS_CHAR,
80: ATTRIBUTE1 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
81: ATTRIBUTE2 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
82: ATTRIBUTE3 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
83: ATTRIBUTE4 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
84: ATTRIBUTE5 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
85: ATTRIBUTE6 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
86: ATTRIBUTE7 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
87: ATTRIBUTE8 VARCHAR2(150) := OKE_API.G_MISS_CHAR,

Line 84: ATTRIBUTE5 VARCHAR2(150) := OKE_API.G_MISS_CHAR,

80: ATTRIBUTE1 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
81: ATTRIBUTE2 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
82: ATTRIBUTE3 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
83: ATTRIBUTE4 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
84: ATTRIBUTE5 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
85: ATTRIBUTE6 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
86: ATTRIBUTE7 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
87: ATTRIBUTE8 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
88: ATTRIBUTE9 VARCHAR2(150) := OKE_API.G_MISS_CHAR,

Line 85: ATTRIBUTE6 VARCHAR2(150) := OKE_API.G_MISS_CHAR,

81: ATTRIBUTE2 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
82: ATTRIBUTE3 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
83: ATTRIBUTE4 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
84: ATTRIBUTE5 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
85: ATTRIBUTE6 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
86: ATTRIBUTE7 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
87: ATTRIBUTE8 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
88: ATTRIBUTE9 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
89: ATTRIBUTE10 VARCHAR2(150) := OKE_API.G_MISS_CHAR,

Line 86: ATTRIBUTE7 VARCHAR2(150) := OKE_API.G_MISS_CHAR,

82: ATTRIBUTE3 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
83: ATTRIBUTE4 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
84: ATTRIBUTE5 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
85: ATTRIBUTE6 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
86: ATTRIBUTE7 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
87: ATTRIBUTE8 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
88: ATTRIBUTE9 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
89: ATTRIBUTE10 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
90: ATTRIBUTE11 VARCHAR2(150) := OKE_API.G_MISS_CHAR,

Line 87: ATTRIBUTE8 VARCHAR2(150) := OKE_API.G_MISS_CHAR,

83: ATTRIBUTE4 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
84: ATTRIBUTE5 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
85: ATTRIBUTE6 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
86: ATTRIBUTE7 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
87: ATTRIBUTE8 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
88: ATTRIBUTE9 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
89: ATTRIBUTE10 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
90: ATTRIBUTE11 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
91: ATTRIBUTE12 VARCHAR2(150) := OKE_API.G_MISS_CHAR,

Line 88: ATTRIBUTE9 VARCHAR2(150) := OKE_API.G_MISS_CHAR,

84: ATTRIBUTE5 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
85: ATTRIBUTE6 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
86: ATTRIBUTE7 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
87: ATTRIBUTE8 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
88: ATTRIBUTE9 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
89: ATTRIBUTE10 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
90: ATTRIBUTE11 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
91: ATTRIBUTE12 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
92: ATTRIBUTE13 VARCHAR2(150) := OKE_API.G_MISS_CHAR,

Line 89: ATTRIBUTE10 VARCHAR2(150) := OKE_API.G_MISS_CHAR,

85: ATTRIBUTE6 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
86: ATTRIBUTE7 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
87: ATTRIBUTE8 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
88: ATTRIBUTE9 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
89: ATTRIBUTE10 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
90: ATTRIBUTE11 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
91: ATTRIBUTE12 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
92: ATTRIBUTE13 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
93: ATTRIBUTE14 VARCHAR2(150) := OKE_API.G_MISS_CHAR,

Line 90: ATTRIBUTE11 VARCHAR2(150) := OKE_API.G_MISS_CHAR,

86: ATTRIBUTE7 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
87: ATTRIBUTE8 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
88: ATTRIBUTE9 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
89: ATTRIBUTE10 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
90: ATTRIBUTE11 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
91: ATTRIBUTE12 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
92: ATTRIBUTE13 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
93: ATTRIBUTE14 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
94: ATTRIBUTE15 VARCHAR2(150) := OKE_API.G_MISS_CHAR,

Line 91: ATTRIBUTE12 VARCHAR2(150) := OKE_API.G_MISS_CHAR,

87: ATTRIBUTE8 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
88: ATTRIBUTE9 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
89: ATTRIBUTE10 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
90: ATTRIBUTE11 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
91: ATTRIBUTE12 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
92: ATTRIBUTE13 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
93: ATTRIBUTE14 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
94: ATTRIBUTE15 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
95: DESCRIPTION VARCHAR2(240) := OKE_API.G_MISS_CHAR,

Line 92: ATTRIBUTE13 VARCHAR2(150) := OKE_API.G_MISS_CHAR,

88: ATTRIBUTE9 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
89: ATTRIBUTE10 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
90: ATTRIBUTE11 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
91: ATTRIBUTE12 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
92: ATTRIBUTE13 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
93: ATTRIBUTE14 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
94: ATTRIBUTE15 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
95: DESCRIPTION VARCHAR2(240) := OKE_API.G_MISS_CHAR,
96: COMMENTS VARCHAR2(2000) := OKE_API.G_MISS_CHAR,

Line 93: ATTRIBUTE14 VARCHAR2(150) := OKE_API.G_MISS_CHAR,

89: ATTRIBUTE10 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
90: ATTRIBUTE11 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
91: ATTRIBUTE12 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
92: ATTRIBUTE13 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
93: ATTRIBUTE14 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
94: ATTRIBUTE15 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
95: DESCRIPTION VARCHAR2(240) := OKE_API.G_MISS_CHAR,
96: COMMENTS VARCHAR2(2000) := OKE_API.G_MISS_CHAR,
97: SFWT_FLAG VARCHAR2(3) := OKE_API.G_MISS_CHAR,

Line 94: ATTRIBUTE15 VARCHAR2(150) := OKE_API.G_MISS_CHAR,

90: ATTRIBUTE11 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
91: ATTRIBUTE12 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
92: ATTRIBUTE13 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
93: ATTRIBUTE14 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
94: ATTRIBUTE15 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
95: DESCRIPTION VARCHAR2(240) := OKE_API.G_MISS_CHAR,
96: COMMENTS VARCHAR2(2000) := OKE_API.G_MISS_CHAR,
97: SFWT_FLAG VARCHAR2(3) := OKE_API.G_MISS_CHAR,
98: WEIGHT NUMBER := OKE_API.G_MISS_NUM,

Line 95: DESCRIPTION VARCHAR2(240) := OKE_API.G_MISS_CHAR,

91: ATTRIBUTE12 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
92: ATTRIBUTE13 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
93: ATTRIBUTE14 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
94: ATTRIBUTE15 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
95: DESCRIPTION VARCHAR2(240) := OKE_API.G_MISS_CHAR,
96: COMMENTS VARCHAR2(2000) := OKE_API.G_MISS_CHAR,
97: SFWT_FLAG VARCHAR2(3) := OKE_API.G_MISS_CHAR,
98: WEIGHT NUMBER := OKE_API.G_MISS_NUM,
99: WEIGHT_UOM_CODE VARCHAR2(10) := OKE_API.G_MISS_CHAR,

Line 96: COMMENTS VARCHAR2(2000) := OKE_API.G_MISS_CHAR,

92: ATTRIBUTE13 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
93: ATTRIBUTE14 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
94: ATTRIBUTE15 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
95: DESCRIPTION VARCHAR2(240) := OKE_API.G_MISS_CHAR,
96: COMMENTS VARCHAR2(2000) := OKE_API.G_MISS_CHAR,
97: SFWT_FLAG VARCHAR2(3) := OKE_API.G_MISS_CHAR,
98: WEIGHT NUMBER := OKE_API.G_MISS_NUM,
99: WEIGHT_UOM_CODE VARCHAR2(10) := OKE_API.G_MISS_CHAR,
100: VOLUME NUMBER := OKE_API.G_MISS_NUM,

Line 97: SFWT_FLAG VARCHAR2(3) := OKE_API.G_MISS_CHAR,

93: ATTRIBUTE14 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
94: ATTRIBUTE15 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
95: DESCRIPTION VARCHAR2(240) := OKE_API.G_MISS_CHAR,
96: COMMENTS VARCHAR2(2000) := OKE_API.G_MISS_CHAR,
97: SFWT_FLAG VARCHAR2(3) := OKE_API.G_MISS_CHAR,
98: WEIGHT NUMBER := OKE_API.G_MISS_NUM,
99: WEIGHT_UOM_CODE VARCHAR2(10) := OKE_API.G_MISS_CHAR,
100: VOLUME NUMBER := OKE_API.G_MISS_NUM,
101: VOLUME_UOM_CODE VARCHAR2(10) := OKE_API.G_MISS_CHAR,

Line 98: WEIGHT NUMBER := OKE_API.G_MISS_NUM,

94: ATTRIBUTE15 VARCHAR2(150) := OKE_API.G_MISS_CHAR,
95: DESCRIPTION VARCHAR2(240) := OKE_API.G_MISS_CHAR,
96: COMMENTS VARCHAR2(2000) := OKE_API.G_MISS_CHAR,
97: SFWT_FLAG VARCHAR2(3) := OKE_API.G_MISS_CHAR,
98: WEIGHT NUMBER := OKE_API.G_MISS_NUM,
99: WEIGHT_UOM_CODE VARCHAR2(10) := OKE_API.G_MISS_CHAR,
100: VOLUME NUMBER := OKE_API.G_MISS_NUM,
101: VOLUME_UOM_CODE VARCHAR2(10) := OKE_API.G_MISS_CHAR,
102: EXPENDITURE_ORGANIZATION_ID NUMBER := OKE_API.G_MISS_NUM,

Line 99: WEIGHT_UOM_CODE VARCHAR2(10) := OKE_API.G_MISS_CHAR,

95: DESCRIPTION VARCHAR2(240) := OKE_API.G_MISS_CHAR,
96: COMMENTS VARCHAR2(2000) := OKE_API.G_MISS_CHAR,
97: SFWT_FLAG VARCHAR2(3) := OKE_API.G_MISS_CHAR,
98: WEIGHT NUMBER := OKE_API.G_MISS_NUM,
99: WEIGHT_UOM_CODE VARCHAR2(10) := OKE_API.G_MISS_CHAR,
100: VOLUME NUMBER := OKE_API.G_MISS_NUM,
101: VOLUME_UOM_CODE VARCHAR2(10) := OKE_API.G_MISS_CHAR,
102: EXPENDITURE_ORGANIZATION_ID NUMBER := OKE_API.G_MISS_NUM,
103: EXPENDITURE_TYPE VARCHAR2(30) := OKE_API.G_MISS_CHAR,

Line 100: VOLUME NUMBER := OKE_API.G_MISS_NUM,

96: COMMENTS VARCHAR2(2000) := OKE_API.G_MISS_CHAR,
97: SFWT_FLAG VARCHAR2(3) := OKE_API.G_MISS_CHAR,
98: WEIGHT NUMBER := OKE_API.G_MISS_NUM,
99: WEIGHT_UOM_CODE VARCHAR2(10) := OKE_API.G_MISS_CHAR,
100: VOLUME NUMBER := OKE_API.G_MISS_NUM,
101: VOLUME_UOM_CODE VARCHAR2(10) := OKE_API.G_MISS_CHAR,
102: EXPENDITURE_ORGANIZATION_ID NUMBER := OKE_API.G_MISS_NUM,
103: EXPENDITURE_TYPE VARCHAR2(30) := OKE_API.G_MISS_CHAR,
104: EXPENDITURE_ITEM_DATE DATE := OKE_API.G_MISS_DATE,

Line 101: VOLUME_UOM_CODE VARCHAR2(10) := OKE_API.G_MISS_CHAR,

97: SFWT_FLAG VARCHAR2(3) := OKE_API.G_MISS_CHAR,
98: WEIGHT NUMBER := OKE_API.G_MISS_NUM,
99: WEIGHT_UOM_CODE VARCHAR2(10) := OKE_API.G_MISS_CHAR,
100: VOLUME NUMBER := OKE_API.G_MISS_NUM,
101: VOLUME_UOM_CODE VARCHAR2(10) := OKE_API.G_MISS_CHAR,
102: EXPENDITURE_ORGANIZATION_ID NUMBER := OKE_API.G_MISS_NUM,
103: EXPENDITURE_TYPE VARCHAR2(30) := OKE_API.G_MISS_CHAR,
104: EXPENDITURE_ITEM_DATE DATE := OKE_API.G_MISS_DATE,
105: DESTINATION_TYPE_CODE VARCHAR2(30) := OKE_API.G_MISS_CHAR,

Line 102: EXPENDITURE_ORGANIZATION_ID NUMBER := OKE_API.G_MISS_NUM,

98: WEIGHT NUMBER := OKE_API.G_MISS_NUM,
99: WEIGHT_UOM_CODE VARCHAR2(10) := OKE_API.G_MISS_CHAR,
100: VOLUME NUMBER := OKE_API.G_MISS_NUM,
101: VOLUME_UOM_CODE VARCHAR2(10) := OKE_API.G_MISS_CHAR,
102: EXPENDITURE_ORGANIZATION_ID NUMBER := OKE_API.G_MISS_NUM,
103: EXPENDITURE_TYPE VARCHAR2(30) := OKE_API.G_MISS_CHAR,
104: EXPENDITURE_ITEM_DATE DATE := OKE_API.G_MISS_DATE,
105: DESTINATION_TYPE_CODE VARCHAR2(30) := OKE_API.G_MISS_CHAR,
106: RATE_TYPE VARCHAR2(30) := OKE_API.G_MISS_CHAR,

Line 103: EXPENDITURE_TYPE VARCHAR2(30) := OKE_API.G_MISS_CHAR,

99: WEIGHT_UOM_CODE VARCHAR2(10) := OKE_API.G_MISS_CHAR,
100: VOLUME NUMBER := OKE_API.G_MISS_NUM,
101: VOLUME_UOM_CODE VARCHAR2(10) := OKE_API.G_MISS_CHAR,
102: EXPENDITURE_ORGANIZATION_ID NUMBER := OKE_API.G_MISS_NUM,
103: EXPENDITURE_TYPE VARCHAR2(30) := OKE_API.G_MISS_CHAR,
104: EXPENDITURE_ITEM_DATE DATE := OKE_API.G_MISS_DATE,
105: DESTINATION_TYPE_CODE VARCHAR2(30) := OKE_API.G_MISS_CHAR,
106: RATE_TYPE VARCHAR2(30) := OKE_API.G_MISS_CHAR,
107: RATE_DATE DATE := OKE_API.G_MISS_DATE,

Line 104: EXPENDITURE_ITEM_DATE DATE := OKE_API.G_MISS_DATE,

100: VOLUME NUMBER := OKE_API.G_MISS_NUM,
101: VOLUME_UOM_CODE VARCHAR2(10) := OKE_API.G_MISS_CHAR,
102: EXPENDITURE_ORGANIZATION_ID NUMBER := OKE_API.G_MISS_NUM,
103: EXPENDITURE_TYPE VARCHAR2(30) := OKE_API.G_MISS_CHAR,
104: EXPENDITURE_ITEM_DATE DATE := OKE_API.G_MISS_DATE,
105: DESTINATION_TYPE_CODE VARCHAR2(30) := OKE_API.G_MISS_CHAR,
106: RATE_TYPE VARCHAR2(30) := OKE_API.G_MISS_CHAR,
107: RATE_DATE DATE := OKE_API.G_MISS_DATE,
108: EXCHANGE_RATE NUMBER := OKE_API.G_MISS_NUM,

Line 105: DESTINATION_TYPE_CODE VARCHAR2(30) := OKE_API.G_MISS_CHAR,

101: VOLUME_UOM_CODE VARCHAR2(10) := OKE_API.G_MISS_CHAR,
102: EXPENDITURE_ORGANIZATION_ID NUMBER := OKE_API.G_MISS_NUM,
103: EXPENDITURE_TYPE VARCHAR2(30) := OKE_API.G_MISS_CHAR,
104: EXPENDITURE_ITEM_DATE DATE := OKE_API.G_MISS_DATE,
105: DESTINATION_TYPE_CODE VARCHAR2(30) := OKE_API.G_MISS_CHAR,
106: RATE_TYPE VARCHAR2(30) := OKE_API.G_MISS_CHAR,
107: RATE_DATE DATE := OKE_API.G_MISS_DATE,
108: EXCHANGE_RATE NUMBER := OKE_API.G_MISS_NUM,
109: REQUISITION_LINE_TYPE_ID NUMBER := OKE_API.G_MISS_NUM,

Line 106: RATE_TYPE VARCHAR2(30) := OKE_API.G_MISS_CHAR,

102: EXPENDITURE_ORGANIZATION_ID NUMBER := OKE_API.G_MISS_NUM,
103: EXPENDITURE_TYPE VARCHAR2(30) := OKE_API.G_MISS_CHAR,
104: EXPENDITURE_ITEM_DATE DATE := OKE_API.G_MISS_DATE,
105: DESTINATION_TYPE_CODE VARCHAR2(30) := OKE_API.G_MISS_CHAR,
106: RATE_TYPE VARCHAR2(30) := OKE_API.G_MISS_CHAR,
107: RATE_DATE DATE := OKE_API.G_MISS_DATE,
108: EXCHANGE_RATE NUMBER := OKE_API.G_MISS_NUM,
109: REQUISITION_LINE_TYPE_ID NUMBER := OKE_API.G_MISS_NUM,
110: PO_CATEGORY_ID NUMBER := OKE_API.G_MISS_NUM);

Line 107: RATE_DATE DATE := OKE_API.G_MISS_DATE,

103: EXPENDITURE_TYPE VARCHAR2(30) := OKE_API.G_MISS_CHAR,
104: EXPENDITURE_ITEM_DATE DATE := OKE_API.G_MISS_DATE,
105: DESTINATION_TYPE_CODE VARCHAR2(30) := OKE_API.G_MISS_CHAR,
106: RATE_TYPE VARCHAR2(30) := OKE_API.G_MISS_CHAR,
107: RATE_DATE DATE := OKE_API.G_MISS_DATE,
108: EXCHANGE_RATE NUMBER := OKE_API.G_MISS_NUM,
109: REQUISITION_LINE_TYPE_ID NUMBER := OKE_API.G_MISS_NUM,
110: PO_CATEGORY_ID NUMBER := OKE_API.G_MISS_NUM);
111:

Line 108: EXCHANGE_RATE NUMBER := OKE_API.G_MISS_NUM,

104: EXPENDITURE_ITEM_DATE DATE := OKE_API.G_MISS_DATE,
105: DESTINATION_TYPE_CODE VARCHAR2(30) := OKE_API.G_MISS_CHAR,
106: RATE_TYPE VARCHAR2(30) := OKE_API.G_MISS_CHAR,
107: RATE_DATE DATE := OKE_API.G_MISS_DATE,
108: EXCHANGE_RATE NUMBER := OKE_API.G_MISS_NUM,
109: REQUISITION_LINE_TYPE_ID NUMBER := OKE_API.G_MISS_NUM,
110: PO_CATEGORY_ID NUMBER := OKE_API.G_MISS_NUM);
111:
112: TYPE del_tbl_type IS TABLE OF del_rec_type

Line 109: REQUISITION_LINE_TYPE_ID NUMBER := OKE_API.G_MISS_NUM,

105: DESTINATION_TYPE_CODE VARCHAR2(30) := OKE_API.G_MISS_CHAR,
106: RATE_TYPE VARCHAR2(30) := OKE_API.G_MISS_CHAR,
107: RATE_DATE DATE := OKE_API.G_MISS_DATE,
108: EXCHANGE_RATE NUMBER := OKE_API.G_MISS_NUM,
109: REQUISITION_LINE_TYPE_ID NUMBER := OKE_API.G_MISS_NUM,
110: PO_CATEGORY_ID NUMBER := OKE_API.G_MISS_NUM);
111:
112: TYPE del_tbl_type IS TABLE OF del_rec_type
113: INDEX BY BINARY_INTEGER;

Line 110: PO_CATEGORY_ID NUMBER := OKE_API.G_MISS_NUM);

106: RATE_TYPE VARCHAR2(30) := OKE_API.G_MISS_CHAR,
107: RATE_DATE DATE := OKE_API.G_MISS_DATE,
108: EXCHANGE_RATE NUMBER := OKE_API.G_MISS_NUM,
109: REQUISITION_LINE_TYPE_ID NUMBER := OKE_API.G_MISS_NUM,
110: PO_CATEGORY_ID NUMBER := OKE_API.G_MISS_NUM);
111:
112: TYPE del_tbl_type IS TABLE OF del_rec_type
113: INDEX BY BINARY_INTEGER;
114:

Line 117: G_FND_APP CONSTANT VARCHAR2(200) := OKE_API.G_FND_APP;

113: INDEX BY BINARY_INTEGER;
114:
115: -- GLOBAL MESSAGE CONSTANTS
116:
117: G_FND_APP CONSTANT VARCHAR2(200) := OKE_API.G_FND_APP;
118:
119: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKE_API.G_FORM_UNABLE_TO_RESERVE_REC;
120: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKE_API.G_FORM_RECORD_DELETED;
121:

Line 119: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKE_API.G_FORM_UNABLE_TO_RESERVE_REC;

115: -- GLOBAL MESSAGE CONSTANTS
116:
117: G_FND_APP CONSTANT VARCHAR2(200) := OKE_API.G_FND_APP;
118:
119: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKE_API.G_FORM_UNABLE_TO_RESERVE_REC;
120: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKE_API.G_FORM_RECORD_DELETED;
121:
122: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKE_API.G_FORM_RECORD_CHANGED;
123:

Line 120: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKE_API.G_FORM_RECORD_DELETED;

116:
117: G_FND_APP CONSTANT VARCHAR2(200) := OKE_API.G_FND_APP;
118:
119: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKE_API.G_FORM_UNABLE_TO_RESERVE_REC;
120: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKE_API.G_FORM_RECORD_DELETED;
121:
122: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKE_API.G_FORM_RECORD_CHANGED;
123:
124: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKE_API.G_RECORD_LOGICALLY_DELETED;

Line 122: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKE_API.G_FORM_RECORD_CHANGED;

118:
119: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKE_API.G_FORM_UNABLE_TO_RESERVE_REC;
120: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKE_API.G_FORM_RECORD_DELETED;
121:
122: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKE_API.G_FORM_RECORD_CHANGED;
123:
124: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKE_API.G_RECORD_LOGICALLY_DELETED;
125: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_REQUIRED_VALUE;
126: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_INVALID_VALUE;

Line 124: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKE_API.G_RECORD_LOGICALLY_DELETED;

120: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKE_API.G_FORM_RECORD_DELETED;
121:
122: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKE_API.G_FORM_RECORD_CHANGED;
123:
124: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKE_API.G_RECORD_LOGICALLY_DELETED;
125: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_REQUIRED_VALUE;
126: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_INVALID_VALUE;
127: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_COL_NAME_TOKEN;
128: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_PARENT_TABLE_TOKEN;

Line 125: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_REQUIRED_VALUE;

121:
122: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKE_API.G_FORM_RECORD_CHANGED;
123:
124: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKE_API.G_RECORD_LOGICALLY_DELETED;
125: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_REQUIRED_VALUE;
126: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_INVALID_VALUE;
127: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_COL_NAME_TOKEN;
128: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_PARENT_TABLE_TOKEN;
129: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_CHILD_TABLE_TOKEN;

Line 126: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_INVALID_VALUE;

122: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKE_API.G_FORM_RECORD_CHANGED;
123:
124: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKE_API.G_RECORD_LOGICALLY_DELETED;
125: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_REQUIRED_VALUE;
126: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_INVALID_VALUE;
127: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_COL_NAME_TOKEN;
128: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_PARENT_TABLE_TOKEN;
129: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_CHILD_TABLE_TOKEN;
130: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKE_DELIVERABLE_PVT';

Line 127: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_COL_NAME_TOKEN;

123:
124: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKE_API.G_RECORD_LOGICALLY_DELETED;
125: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_REQUIRED_VALUE;
126: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_INVALID_VALUE;
127: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_COL_NAME_TOKEN;
128: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_PARENT_TABLE_TOKEN;
129: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_CHILD_TABLE_TOKEN;
130: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKE_DELIVERABLE_PVT';
131: G_APP_NAME CONSTANT VARCHAR2(3) := OKE_API.G_APP_NAME;

Line 128: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_PARENT_TABLE_TOKEN;

124: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKE_API.G_RECORD_LOGICALLY_DELETED;
125: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_REQUIRED_VALUE;
126: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_INVALID_VALUE;
127: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_COL_NAME_TOKEN;
128: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_PARENT_TABLE_TOKEN;
129: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_CHILD_TABLE_TOKEN;
130: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKE_DELIVERABLE_PVT';
131: G_APP_NAME CONSTANT VARCHAR2(3) := OKE_API.G_APP_NAME;
132: G_FALSE CONSTANT VARCHAR2(1) := 'F';

Line 129: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_CHILD_TABLE_TOKEN;

125: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_REQUIRED_VALUE;
126: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_INVALID_VALUE;
127: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_COL_NAME_TOKEN;
128: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_PARENT_TABLE_TOKEN;
129: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_CHILD_TABLE_TOKEN;
130: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKE_DELIVERABLE_PVT';
131: G_APP_NAME CONSTANT VARCHAR2(3) := OKE_API.G_APP_NAME;
132: G_FALSE CONSTANT VARCHAR2(1) := 'F';
133:

Line 131: G_APP_NAME CONSTANT VARCHAR2(3) := OKE_API.G_APP_NAME;

127: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_COL_NAME_TOKEN;
128: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_PARENT_TABLE_TOKEN;
129: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_CHILD_TABLE_TOKEN;
130: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKE_DELIVERABLE_PVT';
131: G_APP_NAME CONSTANT VARCHAR2(3) := OKE_API.G_APP_NAME;
132: G_FALSE CONSTANT VARCHAR2(1) := 'F';
133:
134: -- Procedures and functions
135: