8: -- Bug 6369687: Adding variable to get the action on the delivery
9: G_ACTION VARCHAR2(30) := NULL;
10:
11: TYPE Delivery_Pub_Rec_Type IS RECORD (
12: DELIVERY_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
13: NAME VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
14: DELIVERY_TYPE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
15: LOADING_SEQUENCE NUMBER DEFAULT FND_API.G_MISS_NUM,
16: LOADING_ORDER_FLAG VARCHAR2(2) DEFAULT FND_API.G_MISS_CHAR,
9: G_ACTION VARCHAR2(30) := NULL;
10:
11: TYPE Delivery_Pub_Rec_Type IS RECORD (
12: DELIVERY_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
13: NAME VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
14: DELIVERY_TYPE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
15: LOADING_SEQUENCE NUMBER DEFAULT FND_API.G_MISS_NUM,
16: LOADING_ORDER_FLAG VARCHAR2(2) DEFAULT FND_API.G_MISS_CHAR,
17: LOADING_ORDER_DESC VARCHAR2(20) DEFAULT FND_API.G_MISS_CHAR,
10:
11: TYPE Delivery_Pub_Rec_Type IS RECORD (
12: DELIVERY_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
13: NAME VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
14: DELIVERY_TYPE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
15: LOADING_SEQUENCE NUMBER DEFAULT FND_API.G_MISS_NUM,
16: LOADING_ORDER_FLAG VARCHAR2(2) DEFAULT FND_API.G_MISS_CHAR,
17: LOADING_ORDER_DESC VARCHAR2(20) DEFAULT FND_API.G_MISS_CHAR,
18: INITIAL_PICKUP_DATE DATE DEFAULT FND_API.G_MISS_DATE,
11: TYPE Delivery_Pub_Rec_Type IS RECORD (
12: DELIVERY_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
13: NAME VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
14: DELIVERY_TYPE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
15: LOADING_SEQUENCE NUMBER DEFAULT FND_API.G_MISS_NUM,
16: LOADING_ORDER_FLAG VARCHAR2(2) DEFAULT FND_API.G_MISS_CHAR,
17: LOADING_ORDER_DESC VARCHAR2(20) DEFAULT FND_API.G_MISS_CHAR,
18: INITIAL_PICKUP_DATE DATE DEFAULT FND_API.G_MISS_DATE,
19: INITIAL_PICKUP_LOCATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
12: DELIVERY_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
13: NAME VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
14: DELIVERY_TYPE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
15: LOADING_SEQUENCE NUMBER DEFAULT FND_API.G_MISS_NUM,
16: LOADING_ORDER_FLAG VARCHAR2(2) DEFAULT FND_API.G_MISS_CHAR,
17: LOADING_ORDER_DESC VARCHAR2(20) DEFAULT FND_API.G_MISS_CHAR,
18: INITIAL_PICKUP_DATE DATE DEFAULT FND_API.G_MISS_DATE,
19: INITIAL_PICKUP_LOCATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
20: INITIAL_PICKUP_LOCATION_CODE VARCHAR2(20) DEFAULT FND_API.G_MISS_CHAR,
13: NAME VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
14: DELIVERY_TYPE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
15: LOADING_SEQUENCE NUMBER DEFAULT FND_API.G_MISS_NUM,
16: LOADING_ORDER_FLAG VARCHAR2(2) DEFAULT FND_API.G_MISS_CHAR,
17: LOADING_ORDER_DESC VARCHAR2(20) DEFAULT FND_API.G_MISS_CHAR,
18: INITIAL_PICKUP_DATE DATE DEFAULT FND_API.G_MISS_DATE,
19: INITIAL_PICKUP_LOCATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
20: INITIAL_PICKUP_LOCATION_CODE VARCHAR2(20) DEFAULT FND_API.G_MISS_CHAR,
21: ORGANIZATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
14: DELIVERY_TYPE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
15: LOADING_SEQUENCE NUMBER DEFAULT FND_API.G_MISS_NUM,
16: LOADING_ORDER_FLAG VARCHAR2(2) DEFAULT FND_API.G_MISS_CHAR,
17: LOADING_ORDER_DESC VARCHAR2(20) DEFAULT FND_API.G_MISS_CHAR,
18: INITIAL_PICKUP_DATE DATE DEFAULT FND_API.G_MISS_DATE,
19: INITIAL_PICKUP_LOCATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
20: INITIAL_PICKUP_LOCATION_CODE VARCHAR2(20) DEFAULT FND_API.G_MISS_CHAR,
21: ORGANIZATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
22: ORGANIZATION_CODE VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
15: LOADING_SEQUENCE NUMBER DEFAULT FND_API.G_MISS_NUM,
16: LOADING_ORDER_FLAG VARCHAR2(2) DEFAULT FND_API.G_MISS_CHAR,
17: LOADING_ORDER_DESC VARCHAR2(20) DEFAULT FND_API.G_MISS_CHAR,
18: INITIAL_PICKUP_DATE DATE DEFAULT FND_API.G_MISS_DATE,
19: INITIAL_PICKUP_LOCATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
20: INITIAL_PICKUP_LOCATION_CODE VARCHAR2(20) DEFAULT FND_API.G_MISS_CHAR,
21: ORGANIZATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
22: ORGANIZATION_CODE VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
23: ULTIMATE_DROPOFF_LOCATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
16: LOADING_ORDER_FLAG VARCHAR2(2) DEFAULT FND_API.G_MISS_CHAR,
17: LOADING_ORDER_DESC VARCHAR2(20) DEFAULT FND_API.G_MISS_CHAR,
18: INITIAL_PICKUP_DATE DATE DEFAULT FND_API.G_MISS_DATE,
19: INITIAL_PICKUP_LOCATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
20: INITIAL_PICKUP_LOCATION_CODE VARCHAR2(20) DEFAULT FND_API.G_MISS_CHAR,
21: ORGANIZATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
22: ORGANIZATION_CODE VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
23: ULTIMATE_DROPOFF_LOCATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
24: ULTIMATE_DROPOFF_LOCATION_CODE VARCHAR2(20) DEFAULT FND_API.G_MISS_CHAR,
17: LOADING_ORDER_DESC VARCHAR2(20) DEFAULT FND_API.G_MISS_CHAR,
18: INITIAL_PICKUP_DATE DATE DEFAULT FND_API.G_MISS_DATE,
19: INITIAL_PICKUP_LOCATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
20: INITIAL_PICKUP_LOCATION_CODE VARCHAR2(20) DEFAULT FND_API.G_MISS_CHAR,
21: ORGANIZATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
22: ORGANIZATION_CODE VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
23: ULTIMATE_DROPOFF_LOCATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
24: ULTIMATE_DROPOFF_LOCATION_CODE VARCHAR2(20) DEFAULT FND_API.G_MISS_CHAR,
25: ULTIMATE_DROPOFF_DATE DATE DEFAULT FND_API.G_MISS_DATE,
18: INITIAL_PICKUP_DATE DATE DEFAULT FND_API.G_MISS_DATE,
19: INITIAL_PICKUP_LOCATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
20: INITIAL_PICKUP_LOCATION_CODE VARCHAR2(20) DEFAULT FND_API.G_MISS_CHAR,
21: ORGANIZATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
22: ORGANIZATION_CODE VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
23: ULTIMATE_DROPOFF_LOCATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
24: ULTIMATE_DROPOFF_LOCATION_CODE VARCHAR2(20) DEFAULT FND_API.G_MISS_CHAR,
25: ULTIMATE_DROPOFF_DATE DATE DEFAULT FND_API.G_MISS_DATE,
26: CUSTOMER_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
19: INITIAL_PICKUP_LOCATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
20: INITIAL_PICKUP_LOCATION_CODE VARCHAR2(20) DEFAULT FND_API.G_MISS_CHAR,
21: ORGANIZATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
22: ORGANIZATION_CODE VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
23: ULTIMATE_DROPOFF_LOCATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
24: ULTIMATE_DROPOFF_LOCATION_CODE VARCHAR2(20) DEFAULT FND_API.G_MISS_CHAR,
25: ULTIMATE_DROPOFF_DATE DATE DEFAULT FND_API.G_MISS_DATE,
26: CUSTOMER_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
27: CUSTOMER_NUMBER VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
20: INITIAL_PICKUP_LOCATION_CODE VARCHAR2(20) DEFAULT FND_API.G_MISS_CHAR,
21: ORGANIZATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
22: ORGANIZATION_CODE VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
23: ULTIMATE_DROPOFF_LOCATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
24: ULTIMATE_DROPOFF_LOCATION_CODE VARCHAR2(20) DEFAULT FND_API.G_MISS_CHAR,
25: ULTIMATE_DROPOFF_DATE DATE DEFAULT FND_API.G_MISS_DATE,
26: CUSTOMER_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
27: CUSTOMER_NUMBER VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
28: INTMED_SHIP_TO_LOCATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
21: ORGANIZATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
22: ORGANIZATION_CODE VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
23: ULTIMATE_DROPOFF_LOCATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
24: ULTIMATE_DROPOFF_LOCATION_CODE VARCHAR2(20) DEFAULT FND_API.G_MISS_CHAR,
25: ULTIMATE_DROPOFF_DATE DATE DEFAULT FND_API.G_MISS_DATE,
26: CUSTOMER_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
27: CUSTOMER_NUMBER VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
28: INTMED_SHIP_TO_LOCATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
29: INTMED_SHIP_TO_LOCATION_CODE VARCHAR2(20) DEFAULT FND_API.G_MISS_CHAR,
22: ORGANIZATION_CODE VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
23: ULTIMATE_DROPOFF_LOCATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
24: ULTIMATE_DROPOFF_LOCATION_CODE VARCHAR2(20) DEFAULT FND_API.G_MISS_CHAR,
25: ULTIMATE_DROPOFF_DATE DATE DEFAULT FND_API.G_MISS_DATE,
26: CUSTOMER_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
27: CUSTOMER_NUMBER VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
28: INTMED_SHIP_TO_LOCATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
29: INTMED_SHIP_TO_LOCATION_CODE VARCHAR2(20) DEFAULT FND_API.G_MISS_CHAR,
30: POOLED_SHIP_TO_LOCATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
23: ULTIMATE_DROPOFF_LOCATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
24: ULTIMATE_DROPOFF_LOCATION_CODE VARCHAR2(20) DEFAULT FND_API.G_MISS_CHAR,
25: ULTIMATE_DROPOFF_DATE DATE DEFAULT FND_API.G_MISS_DATE,
26: CUSTOMER_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
27: CUSTOMER_NUMBER VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
28: INTMED_SHIP_TO_LOCATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
29: INTMED_SHIP_TO_LOCATION_CODE VARCHAR2(20) DEFAULT FND_API.G_MISS_CHAR,
30: POOLED_SHIP_TO_LOCATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
31: POOLED_SHIP_TO_LOCATION_CODE VARCHAR2(20) DEFAULT FND_API.G_MISS_CHAR,
24: ULTIMATE_DROPOFF_LOCATION_CODE VARCHAR2(20) DEFAULT FND_API.G_MISS_CHAR,
25: ULTIMATE_DROPOFF_DATE DATE DEFAULT FND_API.G_MISS_DATE,
26: CUSTOMER_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
27: CUSTOMER_NUMBER VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
28: INTMED_SHIP_TO_LOCATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
29: INTMED_SHIP_TO_LOCATION_CODE VARCHAR2(20) DEFAULT FND_API.G_MISS_CHAR,
30: POOLED_SHIP_TO_LOCATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
31: POOLED_SHIP_TO_LOCATION_CODE VARCHAR2(20) DEFAULT FND_API.G_MISS_CHAR,
32: CARRIER_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
25: ULTIMATE_DROPOFF_DATE DATE DEFAULT FND_API.G_MISS_DATE,
26: CUSTOMER_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
27: CUSTOMER_NUMBER VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
28: INTMED_SHIP_TO_LOCATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
29: INTMED_SHIP_TO_LOCATION_CODE VARCHAR2(20) DEFAULT FND_API.G_MISS_CHAR,
30: POOLED_SHIP_TO_LOCATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
31: POOLED_SHIP_TO_LOCATION_CODE VARCHAR2(20) DEFAULT FND_API.G_MISS_CHAR,
32: CARRIER_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
33: CARRIER_CODE VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
26: CUSTOMER_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
27: CUSTOMER_NUMBER VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
28: INTMED_SHIP_TO_LOCATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
29: INTMED_SHIP_TO_LOCATION_CODE VARCHAR2(20) DEFAULT FND_API.G_MISS_CHAR,
30: POOLED_SHIP_TO_LOCATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
31: POOLED_SHIP_TO_LOCATION_CODE VARCHAR2(20) DEFAULT FND_API.G_MISS_CHAR,
32: CARRIER_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
33: CARRIER_CODE VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
34: SHIP_METHOD_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
27: CUSTOMER_NUMBER VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
28: INTMED_SHIP_TO_LOCATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
29: INTMED_SHIP_TO_LOCATION_CODE VARCHAR2(20) DEFAULT FND_API.G_MISS_CHAR,
30: POOLED_SHIP_TO_LOCATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
31: POOLED_SHIP_TO_LOCATION_CODE VARCHAR2(20) DEFAULT FND_API.G_MISS_CHAR,
32: CARRIER_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
33: CARRIER_CODE VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
34: SHIP_METHOD_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
35: SHIP_METHOD_NAME VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
28: INTMED_SHIP_TO_LOCATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
29: INTMED_SHIP_TO_LOCATION_CODE VARCHAR2(20) DEFAULT FND_API.G_MISS_CHAR,
30: POOLED_SHIP_TO_LOCATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
31: POOLED_SHIP_TO_LOCATION_CODE VARCHAR2(20) DEFAULT FND_API.G_MISS_CHAR,
32: CARRIER_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
33: CARRIER_CODE VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
34: SHIP_METHOD_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
35: SHIP_METHOD_NAME VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
36: FREIGHT_TERMS_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
29: INTMED_SHIP_TO_LOCATION_CODE VARCHAR2(20) DEFAULT FND_API.G_MISS_CHAR,
30: POOLED_SHIP_TO_LOCATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
31: POOLED_SHIP_TO_LOCATION_CODE VARCHAR2(20) DEFAULT FND_API.G_MISS_CHAR,
32: CARRIER_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
33: CARRIER_CODE VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
34: SHIP_METHOD_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
35: SHIP_METHOD_NAME VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
36: FREIGHT_TERMS_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
37: FREIGHT_TERMS_NAME VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
30: POOLED_SHIP_TO_LOCATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
31: POOLED_SHIP_TO_LOCATION_CODE VARCHAR2(20) DEFAULT FND_API.G_MISS_CHAR,
32: CARRIER_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
33: CARRIER_CODE VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
34: SHIP_METHOD_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
35: SHIP_METHOD_NAME VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
36: FREIGHT_TERMS_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
37: FREIGHT_TERMS_NAME VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
38: FOB_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
31: POOLED_SHIP_TO_LOCATION_CODE VARCHAR2(20) DEFAULT FND_API.G_MISS_CHAR,
32: CARRIER_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
33: CARRIER_CODE VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
34: SHIP_METHOD_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
35: SHIP_METHOD_NAME VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
36: FREIGHT_TERMS_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
37: FREIGHT_TERMS_NAME VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
38: FOB_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
39: FOB_NAME VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
32: CARRIER_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
33: CARRIER_CODE VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
34: SHIP_METHOD_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
35: SHIP_METHOD_NAME VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
36: FREIGHT_TERMS_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
37: FREIGHT_TERMS_NAME VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
38: FOB_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
39: FOB_NAME VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
40: FOB_LOCATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
33: CARRIER_CODE VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
34: SHIP_METHOD_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
35: SHIP_METHOD_NAME VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
36: FREIGHT_TERMS_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
37: FREIGHT_TERMS_NAME VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
38: FOB_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
39: FOB_NAME VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
40: FOB_LOCATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
41: FOB_LOCATION_CODE VARCHAR2(20) DEFAULT FND_API.G_MISS_CHAR,
34: SHIP_METHOD_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
35: SHIP_METHOD_NAME VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
36: FREIGHT_TERMS_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
37: FREIGHT_TERMS_NAME VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
38: FOB_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
39: FOB_NAME VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
40: FOB_LOCATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
41: FOB_LOCATION_CODE VARCHAR2(20) DEFAULT FND_API.G_MISS_CHAR,
42: WAYBILL VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
35: SHIP_METHOD_NAME VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
36: FREIGHT_TERMS_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
37: FREIGHT_TERMS_NAME VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
38: FOB_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
39: FOB_NAME VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
40: FOB_LOCATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
41: FOB_LOCATION_CODE VARCHAR2(20) DEFAULT FND_API.G_MISS_CHAR,
42: WAYBILL VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
43: DOCK_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
36: FREIGHT_TERMS_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
37: FREIGHT_TERMS_NAME VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
38: FOB_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
39: FOB_NAME VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
40: FOB_LOCATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
41: FOB_LOCATION_CODE VARCHAR2(20) DEFAULT FND_API.G_MISS_CHAR,
42: WAYBILL VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
43: DOCK_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
44: ACCEPTANCE_FLAG VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
37: FREIGHT_TERMS_NAME VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
38: FOB_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
39: FOB_NAME VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
40: FOB_LOCATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
41: FOB_LOCATION_CODE VARCHAR2(20) DEFAULT FND_API.G_MISS_CHAR,
42: WAYBILL VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
43: DOCK_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
44: ACCEPTANCE_FLAG VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
45: ACCEPTED_BY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
38: FOB_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
39: FOB_NAME VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
40: FOB_LOCATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
41: FOB_LOCATION_CODE VARCHAR2(20) DEFAULT FND_API.G_MISS_CHAR,
42: WAYBILL VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
43: DOCK_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
44: ACCEPTANCE_FLAG VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
45: ACCEPTED_BY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
46: ACCEPTED_DATE DATE DEFAULT FND_API.G_MISS_DATE,
39: FOB_NAME VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
40: FOB_LOCATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
41: FOB_LOCATION_CODE VARCHAR2(20) DEFAULT FND_API.G_MISS_CHAR,
42: WAYBILL VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
43: DOCK_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
44: ACCEPTANCE_FLAG VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
45: ACCEPTED_BY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
46: ACCEPTED_DATE DATE DEFAULT FND_API.G_MISS_DATE,
47: ACKNOWLEDGED_BY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
40: FOB_LOCATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
41: FOB_LOCATION_CODE VARCHAR2(20) DEFAULT FND_API.G_MISS_CHAR,
42: WAYBILL VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
43: DOCK_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
44: ACCEPTANCE_FLAG VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
45: ACCEPTED_BY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
46: ACCEPTED_DATE DATE DEFAULT FND_API.G_MISS_DATE,
47: ACKNOWLEDGED_BY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
48: CONFIRMED_BY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
41: FOB_LOCATION_CODE VARCHAR2(20) DEFAULT FND_API.G_MISS_CHAR,
42: WAYBILL VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
43: DOCK_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
44: ACCEPTANCE_FLAG VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
45: ACCEPTED_BY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
46: ACCEPTED_DATE DATE DEFAULT FND_API.G_MISS_DATE,
47: ACKNOWLEDGED_BY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
48: CONFIRMED_BY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
49: CONFIRM_DATE DATE DEFAULT FND_API.G_MISS_DATE,
42: WAYBILL VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
43: DOCK_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
44: ACCEPTANCE_FLAG VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
45: ACCEPTED_BY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
46: ACCEPTED_DATE DATE DEFAULT FND_API.G_MISS_DATE,
47: ACKNOWLEDGED_BY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
48: CONFIRMED_BY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
49: CONFIRM_DATE DATE DEFAULT FND_API.G_MISS_DATE,
50: ASN_DATE_SENT DATE DEFAULT FND_API.G_MISS_DATE,
43: DOCK_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
44: ACCEPTANCE_FLAG VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
45: ACCEPTED_BY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
46: ACCEPTED_DATE DATE DEFAULT FND_API.G_MISS_DATE,
47: ACKNOWLEDGED_BY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
48: CONFIRMED_BY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
49: CONFIRM_DATE DATE DEFAULT FND_API.G_MISS_DATE,
50: ASN_DATE_SENT DATE DEFAULT FND_API.G_MISS_DATE,
51: ASN_STATUS_CODE VARCHAR2(15) DEFAULT FND_API.G_MISS_CHAR,
44: ACCEPTANCE_FLAG VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
45: ACCEPTED_BY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
46: ACCEPTED_DATE DATE DEFAULT FND_API.G_MISS_DATE,
47: ACKNOWLEDGED_BY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
48: CONFIRMED_BY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
49: CONFIRM_DATE DATE DEFAULT FND_API.G_MISS_DATE,
50: ASN_DATE_SENT DATE DEFAULT FND_API.G_MISS_DATE,
51: ASN_STATUS_CODE VARCHAR2(15) DEFAULT FND_API.G_MISS_CHAR,
52: ASN_SEQ_NUMBER NUMBER DEFAULT FND_API.G_MISS_NUM,
45: ACCEPTED_BY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
46: ACCEPTED_DATE DATE DEFAULT FND_API.G_MISS_DATE,
47: ACKNOWLEDGED_BY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
48: CONFIRMED_BY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
49: CONFIRM_DATE DATE DEFAULT FND_API.G_MISS_DATE,
50: ASN_DATE_SENT DATE DEFAULT FND_API.G_MISS_DATE,
51: ASN_STATUS_CODE VARCHAR2(15) DEFAULT FND_API.G_MISS_CHAR,
52: ASN_SEQ_NUMBER NUMBER DEFAULT FND_API.G_MISS_NUM,
53: GROSS_WEIGHT NUMBER DEFAULT FND_API.G_MISS_NUM,
46: ACCEPTED_DATE DATE DEFAULT FND_API.G_MISS_DATE,
47: ACKNOWLEDGED_BY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
48: CONFIRMED_BY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
49: CONFIRM_DATE DATE DEFAULT FND_API.G_MISS_DATE,
50: ASN_DATE_SENT DATE DEFAULT FND_API.G_MISS_DATE,
51: ASN_STATUS_CODE VARCHAR2(15) DEFAULT FND_API.G_MISS_CHAR,
52: ASN_SEQ_NUMBER NUMBER DEFAULT FND_API.G_MISS_NUM,
53: GROSS_WEIGHT NUMBER DEFAULT FND_API.G_MISS_NUM,
54: NET_WEIGHT NUMBER DEFAULT FND_API.G_MISS_NUM,
47: ACKNOWLEDGED_BY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
48: CONFIRMED_BY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
49: CONFIRM_DATE DATE DEFAULT FND_API.G_MISS_DATE,
50: ASN_DATE_SENT DATE DEFAULT FND_API.G_MISS_DATE,
51: ASN_STATUS_CODE VARCHAR2(15) DEFAULT FND_API.G_MISS_CHAR,
52: ASN_SEQ_NUMBER NUMBER DEFAULT FND_API.G_MISS_NUM,
53: GROSS_WEIGHT NUMBER DEFAULT FND_API.G_MISS_NUM,
54: NET_WEIGHT NUMBER DEFAULT FND_API.G_MISS_NUM,
55: WEIGHT_UOM_CODE VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
48: CONFIRMED_BY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
49: CONFIRM_DATE DATE DEFAULT FND_API.G_MISS_DATE,
50: ASN_DATE_SENT DATE DEFAULT FND_API.G_MISS_DATE,
51: ASN_STATUS_CODE VARCHAR2(15) DEFAULT FND_API.G_MISS_CHAR,
52: ASN_SEQ_NUMBER NUMBER DEFAULT FND_API.G_MISS_NUM,
53: GROSS_WEIGHT NUMBER DEFAULT FND_API.G_MISS_NUM,
54: NET_WEIGHT NUMBER DEFAULT FND_API.G_MISS_NUM,
55: WEIGHT_UOM_CODE VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
56: WEIGHT_UOM_DESC VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
49: CONFIRM_DATE DATE DEFAULT FND_API.G_MISS_DATE,
50: ASN_DATE_SENT DATE DEFAULT FND_API.G_MISS_DATE,
51: ASN_STATUS_CODE VARCHAR2(15) DEFAULT FND_API.G_MISS_CHAR,
52: ASN_SEQ_NUMBER NUMBER DEFAULT FND_API.G_MISS_NUM,
53: GROSS_WEIGHT NUMBER DEFAULT FND_API.G_MISS_NUM,
54: NET_WEIGHT NUMBER DEFAULT FND_API.G_MISS_NUM,
55: WEIGHT_UOM_CODE VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
56: WEIGHT_UOM_DESC VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
57: VOLUME NUMBER DEFAULT FND_API.G_MISS_NUM,
50: ASN_DATE_SENT DATE DEFAULT FND_API.G_MISS_DATE,
51: ASN_STATUS_CODE VARCHAR2(15) DEFAULT FND_API.G_MISS_CHAR,
52: ASN_SEQ_NUMBER NUMBER DEFAULT FND_API.G_MISS_NUM,
53: GROSS_WEIGHT NUMBER DEFAULT FND_API.G_MISS_NUM,
54: NET_WEIGHT NUMBER DEFAULT FND_API.G_MISS_NUM,
55: WEIGHT_UOM_CODE VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
56: WEIGHT_UOM_DESC VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
57: VOLUME NUMBER DEFAULT FND_API.G_MISS_NUM,
58: VOLUME_UOM_CODE VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
51: ASN_STATUS_CODE VARCHAR2(15) DEFAULT FND_API.G_MISS_CHAR,
52: ASN_SEQ_NUMBER NUMBER DEFAULT FND_API.G_MISS_NUM,
53: GROSS_WEIGHT NUMBER DEFAULT FND_API.G_MISS_NUM,
54: NET_WEIGHT NUMBER DEFAULT FND_API.G_MISS_NUM,
55: WEIGHT_UOM_CODE VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
56: WEIGHT_UOM_DESC VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
57: VOLUME NUMBER DEFAULT FND_API.G_MISS_NUM,
58: VOLUME_UOM_CODE VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
59: VOLUME_UOM_DESC VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
52: ASN_SEQ_NUMBER NUMBER DEFAULT FND_API.G_MISS_NUM,
53: GROSS_WEIGHT NUMBER DEFAULT FND_API.G_MISS_NUM,
54: NET_WEIGHT NUMBER DEFAULT FND_API.G_MISS_NUM,
55: WEIGHT_UOM_CODE VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
56: WEIGHT_UOM_DESC VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
57: VOLUME NUMBER DEFAULT FND_API.G_MISS_NUM,
58: VOLUME_UOM_CODE VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
59: VOLUME_UOM_DESC VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
60: ADDITIONAL_SHIPMENT_INFO VARCHAR2(500) DEFAULT FND_API.G_MISS_CHAR,
53: GROSS_WEIGHT NUMBER DEFAULT FND_API.G_MISS_NUM,
54: NET_WEIGHT NUMBER DEFAULT FND_API.G_MISS_NUM,
55: WEIGHT_UOM_CODE VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
56: WEIGHT_UOM_DESC VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
57: VOLUME NUMBER DEFAULT FND_API.G_MISS_NUM,
58: VOLUME_UOM_CODE VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
59: VOLUME_UOM_DESC VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
60: ADDITIONAL_SHIPMENT_INFO VARCHAR2(500) DEFAULT FND_API.G_MISS_CHAR,
61: CURRENCY_CODE VARCHAR2(15) DEFAULT FND_API.G_MISS_CHAR,
54: NET_WEIGHT NUMBER DEFAULT FND_API.G_MISS_NUM,
55: WEIGHT_UOM_CODE VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
56: WEIGHT_UOM_DESC VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
57: VOLUME NUMBER DEFAULT FND_API.G_MISS_NUM,
58: VOLUME_UOM_CODE VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
59: VOLUME_UOM_DESC VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
60: ADDITIONAL_SHIPMENT_INFO VARCHAR2(500) DEFAULT FND_API.G_MISS_CHAR,
61: CURRENCY_CODE VARCHAR2(15) DEFAULT FND_API.G_MISS_CHAR,
62: CURRENCY_NAME VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
55: WEIGHT_UOM_CODE VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
56: WEIGHT_UOM_DESC VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
57: VOLUME NUMBER DEFAULT FND_API.G_MISS_NUM,
58: VOLUME_UOM_CODE VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
59: VOLUME_UOM_DESC VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
60: ADDITIONAL_SHIPMENT_INFO VARCHAR2(500) DEFAULT FND_API.G_MISS_CHAR,
61: CURRENCY_CODE VARCHAR2(15) DEFAULT FND_API.G_MISS_CHAR,
62: CURRENCY_NAME VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
63: ATTRIBUTE_CATEGORY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
56: WEIGHT_UOM_DESC VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
57: VOLUME NUMBER DEFAULT FND_API.G_MISS_NUM,
58: VOLUME_UOM_CODE VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
59: VOLUME_UOM_DESC VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
60: ADDITIONAL_SHIPMENT_INFO VARCHAR2(500) DEFAULT FND_API.G_MISS_CHAR,
61: CURRENCY_CODE VARCHAR2(15) DEFAULT FND_API.G_MISS_CHAR,
62: CURRENCY_NAME VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
63: ATTRIBUTE_CATEGORY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
64: ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
57: VOLUME NUMBER DEFAULT FND_API.G_MISS_NUM,
58: VOLUME_UOM_CODE VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
59: VOLUME_UOM_DESC VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
60: ADDITIONAL_SHIPMENT_INFO VARCHAR2(500) DEFAULT FND_API.G_MISS_CHAR,
61: CURRENCY_CODE VARCHAR2(15) DEFAULT FND_API.G_MISS_CHAR,
62: CURRENCY_NAME VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
63: ATTRIBUTE_CATEGORY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
64: ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
65: ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
58: VOLUME_UOM_CODE VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
59: VOLUME_UOM_DESC VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
60: ADDITIONAL_SHIPMENT_INFO VARCHAR2(500) DEFAULT FND_API.G_MISS_CHAR,
61: CURRENCY_CODE VARCHAR2(15) DEFAULT FND_API.G_MISS_CHAR,
62: CURRENCY_NAME VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
63: ATTRIBUTE_CATEGORY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
64: ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
65: ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
66: ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
59: VOLUME_UOM_DESC VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
60: ADDITIONAL_SHIPMENT_INFO VARCHAR2(500) DEFAULT FND_API.G_MISS_CHAR,
61: CURRENCY_CODE VARCHAR2(15) DEFAULT FND_API.G_MISS_CHAR,
62: CURRENCY_NAME VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
63: ATTRIBUTE_CATEGORY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
64: ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
65: ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
66: ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
67: ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
60: ADDITIONAL_SHIPMENT_INFO VARCHAR2(500) DEFAULT FND_API.G_MISS_CHAR,
61: CURRENCY_CODE VARCHAR2(15) DEFAULT FND_API.G_MISS_CHAR,
62: CURRENCY_NAME VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
63: ATTRIBUTE_CATEGORY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
64: ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
65: ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
66: ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
67: ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
68: ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
61: CURRENCY_CODE VARCHAR2(15) DEFAULT FND_API.G_MISS_CHAR,
62: CURRENCY_NAME VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
63: ATTRIBUTE_CATEGORY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
64: ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
65: ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
66: ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
67: ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
68: ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
69: ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
62: CURRENCY_NAME VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
63: ATTRIBUTE_CATEGORY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
64: ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
65: ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
66: ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
67: ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
68: ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
69: ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
70: ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
63: ATTRIBUTE_CATEGORY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
64: ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
65: ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
66: ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
67: ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
68: ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
69: ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
70: ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
71: ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
64: ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
65: ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
66: ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
67: ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
68: ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
69: ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
70: ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
71: ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
72: ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
65: ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
66: ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
67: ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
68: ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
69: ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
70: ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
71: ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
72: ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
73: ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
66: ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
67: ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
68: ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
69: ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
70: ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
71: ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
72: ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
73: ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
74: ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
67: ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
68: ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
69: ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
70: ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
71: ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
72: ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
73: ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
74: ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
75: ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
68: ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
69: ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
70: ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
71: ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
72: ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
73: ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
74: ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
75: ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
76: ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
69: ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
70: ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
71: ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
72: ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
73: ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
74: ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
75: ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
76: ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
77: ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
70: ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
71: ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
72: ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
73: ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
74: ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
75: ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
76: ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
77: ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
78: ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
71: ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
72: ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
73: ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
74: ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
75: ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
76: ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
77: ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
78: ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
79: TP_ATTRIBUTE_CATEGORY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
72: ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
73: ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
74: ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
75: ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
76: ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
77: ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
78: ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
79: TP_ATTRIBUTE_CATEGORY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
80: TP_ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
73: ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
74: ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
75: ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
76: ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
77: ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
78: ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
79: TP_ATTRIBUTE_CATEGORY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
80: TP_ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
81: TP_ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
74: ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
75: ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
76: ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
77: ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
78: ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
79: TP_ATTRIBUTE_CATEGORY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
80: TP_ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
81: TP_ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
82: TP_ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
75: ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
76: ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
77: ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
78: ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
79: TP_ATTRIBUTE_CATEGORY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
80: TP_ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
81: TP_ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
82: TP_ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
83: TP_ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
76: ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
77: ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
78: ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
79: TP_ATTRIBUTE_CATEGORY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
80: TP_ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
81: TP_ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
82: TP_ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
83: TP_ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
84: TP_ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
77: ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
78: ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
79: TP_ATTRIBUTE_CATEGORY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
80: TP_ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
81: TP_ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
82: TP_ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
83: TP_ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
84: TP_ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
85: TP_ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
78: ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
79: TP_ATTRIBUTE_CATEGORY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
80: TP_ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
81: TP_ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
82: TP_ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
83: TP_ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
84: TP_ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
85: TP_ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
86: TP_ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
79: TP_ATTRIBUTE_CATEGORY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
80: TP_ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
81: TP_ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
82: TP_ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
83: TP_ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
84: TP_ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
85: TP_ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
86: TP_ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
87: TP_ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
80: TP_ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
81: TP_ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
82: TP_ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
83: TP_ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
84: TP_ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
85: TP_ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
86: TP_ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
87: TP_ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
88: TP_ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
81: TP_ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
82: TP_ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
83: TP_ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
84: TP_ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
85: TP_ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
86: TP_ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
87: TP_ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
88: TP_ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
89: TP_ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
82: TP_ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
83: TP_ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
84: TP_ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
85: TP_ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
86: TP_ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
87: TP_ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
88: TP_ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
89: TP_ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
90: TP_ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
83: TP_ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
84: TP_ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
85: TP_ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
86: TP_ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
87: TP_ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
88: TP_ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
89: TP_ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
90: TP_ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
91: TP_ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
84: TP_ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
85: TP_ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
86: TP_ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
87: TP_ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
88: TP_ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
89: TP_ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
90: TP_ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
91: TP_ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
92: TP_ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
85: TP_ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
86: TP_ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
87: TP_ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
88: TP_ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
89: TP_ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
90: TP_ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
91: TP_ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
92: TP_ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
93: TP_ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
86: TP_ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
87: TP_ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
88: TP_ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
89: TP_ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
90: TP_ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
91: TP_ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
92: TP_ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
93: TP_ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
94: TP_ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
87: TP_ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
88: TP_ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
89: TP_ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
90: TP_ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
91: TP_ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
92: TP_ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
93: TP_ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
94: TP_ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
95: GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
88: TP_ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
89: TP_ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
90: TP_ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
91: TP_ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
92: TP_ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
93: TP_ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
94: TP_ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
95: GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
96: GLOBAL_ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
89: TP_ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
90: TP_ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
91: TP_ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
92: TP_ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
93: TP_ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
94: TP_ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
95: GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
96: GLOBAL_ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
97: GLOBAL_ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
90: TP_ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
91: TP_ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
92: TP_ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
93: TP_ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
94: TP_ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
95: GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
96: GLOBAL_ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
97: GLOBAL_ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
98: GLOBAL_ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
91: TP_ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
92: TP_ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
93: TP_ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
94: TP_ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
95: GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
96: GLOBAL_ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
97: GLOBAL_ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
98: GLOBAL_ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
99: GLOBAL_ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
92: TP_ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
93: TP_ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
94: TP_ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
95: GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
96: GLOBAL_ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
97: GLOBAL_ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
98: GLOBAL_ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
99: GLOBAL_ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
100: GLOBAL_ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
93: TP_ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
94: TP_ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
95: GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
96: GLOBAL_ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
97: GLOBAL_ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
98: GLOBAL_ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
99: GLOBAL_ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
100: GLOBAL_ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
101: GLOBAL_ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
94: TP_ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
95: GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
96: GLOBAL_ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
97: GLOBAL_ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
98: GLOBAL_ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
99: GLOBAL_ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
100: GLOBAL_ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
101: GLOBAL_ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
102: GLOBAL_ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
95: GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
96: GLOBAL_ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
97: GLOBAL_ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
98: GLOBAL_ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
99: GLOBAL_ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
100: GLOBAL_ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
101: GLOBAL_ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
102: GLOBAL_ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
103: GLOBAL_ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
96: GLOBAL_ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
97: GLOBAL_ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
98: GLOBAL_ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
99: GLOBAL_ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
100: GLOBAL_ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
101: GLOBAL_ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
102: GLOBAL_ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
103: GLOBAL_ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
104: GLOBAL_ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
97: GLOBAL_ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
98: GLOBAL_ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
99: GLOBAL_ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
100: GLOBAL_ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
101: GLOBAL_ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
102: GLOBAL_ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
103: GLOBAL_ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
104: GLOBAL_ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
105: GLOBAL_ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
98: GLOBAL_ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
99: GLOBAL_ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
100: GLOBAL_ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
101: GLOBAL_ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
102: GLOBAL_ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
103: GLOBAL_ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
104: GLOBAL_ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
105: GLOBAL_ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
106: GLOBAL_ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
99: GLOBAL_ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
100: GLOBAL_ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
101: GLOBAL_ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
102: GLOBAL_ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
103: GLOBAL_ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
104: GLOBAL_ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
105: GLOBAL_ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
106: GLOBAL_ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
107: GLOBAL_ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
100: GLOBAL_ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
101: GLOBAL_ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
102: GLOBAL_ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
103: GLOBAL_ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
104: GLOBAL_ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
105: GLOBAL_ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
106: GLOBAL_ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
107: GLOBAL_ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
108: GLOBAL_ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
101: GLOBAL_ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
102: GLOBAL_ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
103: GLOBAL_ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
104: GLOBAL_ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
105: GLOBAL_ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
106: GLOBAL_ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
107: GLOBAL_ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
108: GLOBAL_ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
109: GLOBAL_ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
102: GLOBAL_ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
103: GLOBAL_ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
104: GLOBAL_ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
105: GLOBAL_ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
106: GLOBAL_ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
107: GLOBAL_ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
108: GLOBAL_ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
109: GLOBAL_ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
110: GLOBAL_ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
103: GLOBAL_ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
104: GLOBAL_ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
105: GLOBAL_ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
106: GLOBAL_ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
107: GLOBAL_ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
108: GLOBAL_ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
109: GLOBAL_ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
110: GLOBAL_ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
111: GLOBAL_ATTRIBUTE16 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
104: GLOBAL_ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
105: GLOBAL_ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
106: GLOBAL_ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
107: GLOBAL_ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
108: GLOBAL_ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
109: GLOBAL_ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
110: GLOBAL_ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
111: GLOBAL_ATTRIBUTE16 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
112: GLOBAL_ATTRIBUTE17 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
105: GLOBAL_ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
106: GLOBAL_ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
107: GLOBAL_ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
108: GLOBAL_ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
109: GLOBAL_ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
110: GLOBAL_ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
111: GLOBAL_ATTRIBUTE16 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
112: GLOBAL_ATTRIBUTE17 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
113: GLOBAL_ATTRIBUTE18 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
106: GLOBAL_ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
107: GLOBAL_ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
108: GLOBAL_ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
109: GLOBAL_ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
110: GLOBAL_ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
111: GLOBAL_ATTRIBUTE16 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
112: GLOBAL_ATTRIBUTE17 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
113: GLOBAL_ATTRIBUTE18 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
114: GLOBAL_ATTRIBUTE19 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
107: GLOBAL_ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
108: GLOBAL_ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
109: GLOBAL_ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
110: GLOBAL_ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
111: GLOBAL_ATTRIBUTE16 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
112: GLOBAL_ATTRIBUTE17 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
113: GLOBAL_ATTRIBUTE18 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
114: GLOBAL_ATTRIBUTE19 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
115: GLOBAL_ATTRIBUTE20 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
108: GLOBAL_ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
109: GLOBAL_ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
110: GLOBAL_ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
111: GLOBAL_ATTRIBUTE16 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
112: GLOBAL_ATTRIBUTE17 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
113: GLOBAL_ATTRIBUTE18 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
114: GLOBAL_ATTRIBUTE19 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
115: GLOBAL_ATTRIBUTE20 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
116: CREATION_DATE DATE DEFAULT FND_API.G_MISS_DATE,
109: GLOBAL_ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
110: GLOBAL_ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
111: GLOBAL_ATTRIBUTE16 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
112: GLOBAL_ATTRIBUTE17 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
113: GLOBAL_ATTRIBUTE18 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
114: GLOBAL_ATTRIBUTE19 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
115: GLOBAL_ATTRIBUTE20 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
116: CREATION_DATE DATE DEFAULT FND_API.G_MISS_DATE,
117: CREATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,
110: GLOBAL_ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
111: GLOBAL_ATTRIBUTE16 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
112: GLOBAL_ATTRIBUTE17 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
113: GLOBAL_ATTRIBUTE18 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
114: GLOBAL_ATTRIBUTE19 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
115: GLOBAL_ATTRIBUTE20 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
116: CREATION_DATE DATE DEFAULT FND_API.G_MISS_DATE,
117: CREATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,
118: LAST_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
111: GLOBAL_ATTRIBUTE16 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
112: GLOBAL_ATTRIBUTE17 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
113: GLOBAL_ATTRIBUTE18 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
114: GLOBAL_ATTRIBUTE19 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
115: GLOBAL_ATTRIBUTE20 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
116: CREATION_DATE DATE DEFAULT FND_API.G_MISS_DATE,
117: CREATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,
118: LAST_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
119: LAST_UPDATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,
112: GLOBAL_ATTRIBUTE17 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
113: GLOBAL_ATTRIBUTE18 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
114: GLOBAL_ATTRIBUTE19 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
115: GLOBAL_ATTRIBUTE20 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
116: CREATION_DATE DATE DEFAULT FND_API.G_MISS_DATE,
117: CREATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,
118: LAST_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
119: LAST_UPDATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,
120: LAST_UPDATE_LOGIN NUMBER DEFAULT FND_API.G_MISS_NUM,
113: GLOBAL_ATTRIBUTE18 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
114: GLOBAL_ATTRIBUTE19 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
115: GLOBAL_ATTRIBUTE20 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
116: CREATION_DATE DATE DEFAULT FND_API.G_MISS_DATE,
117: CREATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,
118: LAST_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
119: LAST_UPDATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,
120: LAST_UPDATE_LOGIN NUMBER DEFAULT FND_API.G_MISS_NUM,
121: PROGRAM_APPLICATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
114: GLOBAL_ATTRIBUTE19 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
115: GLOBAL_ATTRIBUTE20 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
116: CREATION_DATE DATE DEFAULT FND_API.G_MISS_DATE,
117: CREATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,
118: LAST_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
119: LAST_UPDATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,
120: LAST_UPDATE_LOGIN NUMBER DEFAULT FND_API.G_MISS_NUM,
121: PROGRAM_APPLICATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
122: PROGRAM_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
115: GLOBAL_ATTRIBUTE20 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
116: CREATION_DATE DATE DEFAULT FND_API.G_MISS_DATE,
117: CREATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,
118: LAST_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
119: LAST_UPDATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,
120: LAST_UPDATE_LOGIN NUMBER DEFAULT FND_API.G_MISS_NUM,
121: PROGRAM_APPLICATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
122: PROGRAM_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
123: PROGRAM_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
116: CREATION_DATE DATE DEFAULT FND_API.G_MISS_DATE,
117: CREATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,
118: LAST_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
119: LAST_UPDATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,
120: LAST_UPDATE_LOGIN NUMBER DEFAULT FND_API.G_MISS_NUM,
121: PROGRAM_APPLICATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
122: PROGRAM_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
123: PROGRAM_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
124: REQUEST_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
117: CREATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,
118: LAST_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
119: LAST_UPDATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,
120: LAST_UPDATE_LOGIN NUMBER DEFAULT FND_API.G_MISS_NUM,
121: PROGRAM_APPLICATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
122: PROGRAM_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
123: PROGRAM_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
124: REQUEST_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
125: /* Changes done for the shipping data model Bugfix#1918342*/
118: LAST_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
119: LAST_UPDATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,
120: LAST_UPDATE_LOGIN NUMBER DEFAULT FND_API.G_MISS_NUM,
121: PROGRAM_APPLICATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
122: PROGRAM_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
123: PROGRAM_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
124: REQUEST_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
125: /* Changes done for the shipping data model Bugfix#1918342*/
126: COD_AMOUNT NUMBER DEFAULT FND_API.G_MISS_NUM,
119: LAST_UPDATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,
120: LAST_UPDATE_LOGIN NUMBER DEFAULT FND_API.G_MISS_NUM,
121: PROGRAM_APPLICATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
122: PROGRAM_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
123: PROGRAM_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
124: REQUEST_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
125: /* Changes done for the shipping data model Bugfix#1918342*/
126: COD_AMOUNT NUMBER DEFAULT FND_API.G_MISS_NUM,
127: COD_CURRENCY_CODE VARCHAR2(15) DEFAULT FND_API.G_MISS_CHAR,
120: LAST_UPDATE_LOGIN NUMBER DEFAULT FND_API.G_MISS_NUM,
121: PROGRAM_APPLICATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
122: PROGRAM_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
123: PROGRAM_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
124: REQUEST_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
125: /* Changes done for the shipping data model Bugfix#1918342*/
126: COD_AMOUNT NUMBER DEFAULT FND_API.G_MISS_NUM,
127: COD_CURRENCY_CODE VARCHAR2(15) DEFAULT FND_API.G_MISS_CHAR,
128: COD_REMIT_TO VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
122: PROGRAM_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
123: PROGRAM_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
124: REQUEST_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
125: /* Changes done for the shipping data model Bugfix#1918342*/
126: COD_AMOUNT NUMBER DEFAULT FND_API.G_MISS_NUM,
127: COD_CURRENCY_CODE VARCHAR2(15) DEFAULT FND_API.G_MISS_CHAR,
128: COD_REMIT_TO VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
129: COD_CHARGE_PAID_BY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
130: PROBLEM_CONTACT_REFERENCE VARCHAR2(500) DEFAULT FND_API.G_MISS_CHAR,
123: PROGRAM_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
124: REQUEST_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
125: /* Changes done for the shipping data model Bugfix#1918342*/
126: COD_AMOUNT NUMBER DEFAULT FND_API.G_MISS_NUM,
127: COD_CURRENCY_CODE VARCHAR2(15) DEFAULT FND_API.G_MISS_CHAR,
128: COD_REMIT_TO VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
129: COD_CHARGE_PAID_BY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
130: PROBLEM_CONTACT_REFERENCE VARCHAR2(500) DEFAULT FND_API.G_MISS_CHAR,
131: PORT_OF_LOADING VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
124: REQUEST_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
125: /* Changes done for the shipping data model Bugfix#1918342*/
126: COD_AMOUNT NUMBER DEFAULT FND_API.G_MISS_NUM,
127: COD_CURRENCY_CODE VARCHAR2(15) DEFAULT FND_API.G_MISS_CHAR,
128: COD_REMIT_TO VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
129: COD_CHARGE_PAID_BY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
130: PROBLEM_CONTACT_REFERENCE VARCHAR2(500) DEFAULT FND_API.G_MISS_CHAR,
131: PORT_OF_LOADING VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
132: PORT_OF_DISCHARGE VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
125: /* Changes done for the shipping data model Bugfix#1918342*/
126: COD_AMOUNT NUMBER DEFAULT FND_API.G_MISS_NUM,
127: COD_CURRENCY_CODE VARCHAR2(15) DEFAULT FND_API.G_MISS_CHAR,
128: COD_REMIT_TO VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
129: COD_CHARGE_PAID_BY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
130: PROBLEM_CONTACT_REFERENCE VARCHAR2(500) DEFAULT FND_API.G_MISS_CHAR,
131: PORT_OF_LOADING VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
132: PORT_OF_DISCHARGE VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
133: FTZ_NUMBER VARCHAR2(35) DEFAULT FND_API.G_MISS_CHAR,
126: COD_AMOUNT NUMBER DEFAULT FND_API.G_MISS_NUM,
127: COD_CURRENCY_CODE VARCHAR2(15) DEFAULT FND_API.G_MISS_CHAR,
128: COD_REMIT_TO VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
129: COD_CHARGE_PAID_BY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
130: PROBLEM_CONTACT_REFERENCE VARCHAR2(500) DEFAULT FND_API.G_MISS_CHAR,
131: PORT_OF_LOADING VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
132: PORT_OF_DISCHARGE VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
133: FTZ_NUMBER VARCHAR2(35) DEFAULT FND_API.G_MISS_CHAR,
134: ROUTED_EXPORT_TXN VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
127: COD_CURRENCY_CODE VARCHAR2(15) DEFAULT FND_API.G_MISS_CHAR,
128: COD_REMIT_TO VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
129: COD_CHARGE_PAID_BY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
130: PROBLEM_CONTACT_REFERENCE VARCHAR2(500) DEFAULT FND_API.G_MISS_CHAR,
131: PORT_OF_LOADING VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
132: PORT_OF_DISCHARGE VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
133: FTZ_NUMBER VARCHAR2(35) DEFAULT FND_API.G_MISS_CHAR,
134: ROUTED_EXPORT_TXN VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
135: ENTRY_NUMBER VARCHAR2(35) DEFAULT FND_API.G_MISS_CHAR,
128: COD_REMIT_TO VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
129: COD_CHARGE_PAID_BY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
130: PROBLEM_CONTACT_REFERENCE VARCHAR2(500) DEFAULT FND_API.G_MISS_CHAR,
131: PORT_OF_LOADING VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
132: PORT_OF_DISCHARGE VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
133: FTZ_NUMBER VARCHAR2(35) DEFAULT FND_API.G_MISS_CHAR,
134: ROUTED_EXPORT_TXN VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
135: ENTRY_NUMBER VARCHAR2(35) DEFAULT FND_API.G_MISS_CHAR,
136: ROUTING_INSTRUCTIONS VARCHAR2(120) DEFAULT FND_API.G_MISS_CHAR,
129: COD_CHARGE_PAID_BY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
130: PROBLEM_CONTACT_REFERENCE VARCHAR2(500) DEFAULT FND_API.G_MISS_CHAR,
131: PORT_OF_LOADING VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
132: PORT_OF_DISCHARGE VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
133: FTZ_NUMBER VARCHAR2(35) DEFAULT FND_API.G_MISS_CHAR,
134: ROUTED_EXPORT_TXN VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
135: ENTRY_NUMBER VARCHAR2(35) DEFAULT FND_API.G_MISS_CHAR,
136: ROUTING_INSTRUCTIONS VARCHAR2(120) DEFAULT FND_API.G_MISS_CHAR,
137: IN_BOND_CODE VARCHAR2(35) DEFAULT FND_API.G_MISS_CHAR,
130: PROBLEM_CONTACT_REFERENCE VARCHAR2(500) DEFAULT FND_API.G_MISS_CHAR,
131: PORT_OF_LOADING VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
132: PORT_OF_DISCHARGE VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
133: FTZ_NUMBER VARCHAR2(35) DEFAULT FND_API.G_MISS_CHAR,
134: ROUTED_EXPORT_TXN VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
135: ENTRY_NUMBER VARCHAR2(35) DEFAULT FND_API.G_MISS_CHAR,
136: ROUTING_INSTRUCTIONS VARCHAR2(120) DEFAULT FND_API.G_MISS_CHAR,
137: IN_BOND_CODE VARCHAR2(35) DEFAULT FND_API.G_MISS_CHAR,
138: SHIPPING_MARKS VARCHAR2(100) DEFAULT FND_API.G_MISS_CHAR,
131: PORT_OF_LOADING VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
132: PORT_OF_DISCHARGE VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
133: FTZ_NUMBER VARCHAR2(35) DEFAULT FND_API.G_MISS_CHAR,
134: ROUTED_EXPORT_TXN VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
135: ENTRY_NUMBER VARCHAR2(35) DEFAULT FND_API.G_MISS_CHAR,
136: ROUTING_INSTRUCTIONS VARCHAR2(120) DEFAULT FND_API.G_MISS_CHAR,
137: IN_BOND_CODE VARCHAR2(35) DEFAULT FND_API.G_MISS_CHAR,
138: SHIPPING_MARKS VARCHAR2(100) DEFAULT FND_API.G_MISS_CHAR,
139: SERVICE_LEVEL VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
132: PORT_OF_DISCHARGE VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
133: FTZ_NUMBER VARCHAR2(35) DEFAULT FND_API.G_MISS_CHAR,
134: ROUTED_EXPORT_TXN VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
135: ENTRY_NUMBER VARCHAR2(35) DEFAULT FND_API.G_MISS_CHAR,
136: ROUTING_INSTRUCTIONS VARCHAR2(120) DEFAULT FND_API.G_MISS_CHAR,
137: IN_BOND_CODE VARCHAR2(35) DEFAULT FND_API.G_MISS_CHAR,
138: SHIPPING_MARKS VARCHAR2(100) DEFAULT FND_API.G_MISS_CHAR,
139: SERVICE_LEVEL VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
140: MODE_OF_TRANSPORT VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
133: FTZ_NUMBER VARCHAR2(35) DEFAULT FND_API.G_MISS_CHAR,
134: ROUTED_EXPORT_TXN VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
135: ENTRY_NUMBER VARCHAR2(35) DEFAULT FND_API.G_MISS_CHAR,
136: ROUTING_INSTRUCTIONS VARCHAR2(120) DEFAULT FND_API.G_MISS_CHAR,
137: IN_BOND_CODE VARCHAR2(35) DEFAULT FND_API.G_MISS_CHAR,
138: SHIPPING_MARKS VARCHAR2(100) DEFAULT FND_API.G_MISS_CHAR,
139: SERVICE_LEVEL VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
140: MODE_OF_TRANSPORT VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
141: ASSIGNED_TO_FTE_TRIPS VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
134: ROUTED_EXPORT_TXN VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
135: ENTRY_NUMBER VARCHAR2(35) DEFAULT FND_API.G_MISS_CHAR,
136: ROUTING_INSTRUCTIONS VARCHAR2(120) DEFAULT FND_API.G_MISS_CHAR,
137: IN_BOND_CODE VARCHAR2(35) DEFAULT FND_API.G_MISS_CHAR,
138: SHIPPING_MARKS VARCHAR2(100) DEFAULT FND_API.G_MISS_CHAR,
139: SERVICE_LEVEL VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
140: MODE_OF_TRANSPORT VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
141: ASSIGNED_TO_FTE_TRIPS VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
142: /*BUG 3667348*/
135: ENTRY_NUMBER VARCHAR2(35) DEFAULT FND_API.G_MISS_CHAR,
136: ROUTING_INSTRUCTIONS VARCHAR2(120) DEFAULT FND_API.G_MISS_CHAR,
137: IN_BOND_CODE VARCHAR2(35) DEFAULT FND_API.G_MISS_CHAR,
138: SHIPPING_MARKS VARCHAR2(100) DEFAULT FND_API.G_MISS_CHAR,
139: SERVICE_LEVEL VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
140: MODE_OF_TRANSPORT VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
141: ASSIGNED_TO_FTE_TRIPS VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
142: /*BUG 3667348*/
143: REASON_OF_TRANSPORT VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
136: ROUTING_INSTRUCTIONS VARCHAR2(120) DEFAULT FND_API.G_MISS_CHAR,
137: IN_BOND_CODE VARCHAR2(35) DEFAULT FND_API.G_MISS_CHAR,
138: SHIPPING_MARKS VARCHAR2(100) DEFAULT FND_API.G_MISS_CHAR,
139: SERVICE_LEVEL VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
140: MODE_OF_TRANSPORT VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
141: ASSIGNED_TO_FTE_TRIPS VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
142: /*BUG 3667348*/
143: REASON_OF_TRANSPORT VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
144: DESCRIPTION VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
137: IN_BOND_CODE VARCHAR2(35) DEFAULT FND_API.G_MISS_CHAR,
138: SHIPPING_MARKS VARCHAR2(100) DEFAULT FND_API.G_MISS_CHAR,
139: SERVICE_LEVEL VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
140: MODE_OF_TRANSPORT VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
141: ASSIGNED_TO_FTE_TRIPS VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
142: /*BUG 3667348*/
143: REASON_OF_TRANSPORT VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
144: DESCRIPTION VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
145: --Non Database field added for "Proration of weight from Delivery to delivery lines" Project(Bug#4254552).
139: SERVICE_LEVEL VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
140: MODE_OF_TRANSPORT VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
141: ASSIGNED_TO_FTE_TRIPS VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
142: /*BUG 3667348*/
143: REASON_OF_TRANSPORT VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
144: DESCRIPTION VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
145: --Non Database field added for "Proration of weight from Delivery to delivery lines" Project(Bug#4254552).
146: PRORATE_WT_FLAG VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR
147: );
140: MODE_OF_TRANSPORT VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
141: ASSIGNED_TO_FTE_TRIPS VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
142: /*BUG 3667348*/
143: REASON_OF_TRANSPORT VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
144: DESCRIPTION VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
145: --Non Database field added for "Proration of weight from Delivery to delivery lines" Project(Bug#4254552).
146: PRORATE_WT_FLAG VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR
147: );
148:
142: /*BUG 3667348*/
143: REASON_OF_TRANSPORT VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
144: DESCRIPTION VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
145: --Non Database field added for "Proration of weight from Delivery to delivery lines" Project(Bug#4254552).
146: PRORATE_WT_FLAG VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR
147: );
148:
149: -- I Harmonization: rvishnuv ******* Actions ******
150:
243: -- PROCEDURE : Delivery_Action Must be called only by the Form
244: -- and the Wrapper Group API.
245: --
246: -- PARAMETERS: p_api_version known api version error number
247: -- p_init_msg_list FND_API.G_TRUE to reset list
248: -- x_return_status return status
249: -- x_msg_count number of messages in the list
250: -- x_msg_data text of messages
251: -- p_action_prms Record of caller, phase, action_code and other
270: --========================================================================
271: PROCEDURE Delivery_Action
272: ( p_api_version_number IN NUMBER,
273: p_init_msg_list IN VARCHAR2,
274: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
275: p_action_prms IN action_parameters_rectype,
276: p_rec_attr_tab IN WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type ,
277: x_delivery_out_rec OUT NOCOPY Delivery_Action_Out_Rec_Type,
278: x_defaults_rec OUT NOCOPY default_parameters_rectype,
288: -- PROCEDURE : Create_Update_Delivery Must be called only by the Form
289: -- and the Wrapper Group API.
290: --
291: -- PARAMETERS: p_api_version known api version error buffer
292: -- p_init_msg_list FND_API.G_TRUE to reset list
293: -- x_return_status return status
294: -- x_msg_count number of messages in the list
295: -- x_msg_data text of messages
296: -- p_in_rec Record for caller, phase
304: --========================================================================
305: PROCEDURE Create_Update_Delivery
306: ( p_api_version_number IN NUMBER,
307: p_init_msg_list IN VARCHAR2,
308: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
309: p_in_rec IN del_In_Rec_Type,
310: p_rec_attr_tab IN WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type,
311: x_del_out_rec_tab OUT NOCOPY Del_Out_Tbl_Type,
312: x_return_status OUT NOCOPY VARCHAR2,
321: --========================================================================
322: -- PROCEDURE : Create_Update_Delivery PUBLIC
323: --
324: -- PARAMETERS: p_api_version_number known api versionerror buffer
325: -- p_init_msg_list FND_API.G_TRUE to reset list
326: -- x_return_status return status
327: -- x_msg_count number of messages in the list
328: -- x_msg_data text of messages
329: -- p_delivery_info Attributes for the delivery entity
342: x_msg_count OUT NOCOPY NUMBER,
343: x_msg_data OUT NOCOPY VARCHAR2,
344: p_action_code IN VARCHAR2,
345: p_delivery_info IN OUT NOCOPY Delivery_Pub_Rec_Type,
346: p_delivery_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
347: x_delivery_id OUT NOCOPY NUMBER,
348: x_name OUT NOCOPY VARCHAR2);
349:
350:
354: --========================================================================
355: -- PROCEDURE : Delivery_Action PUBLIC
356: --
357: -- PARAMETERS: p_api_version_number known api version error number
358: -- p_init_msg_list FND_API.G_TRUE to reset list
359: -- x_return_status return status
360: -- x_msg_count number of messages in the list
361: -- x_msg_data text of messages
362: -- p_action_code Delivery action code. Valid action codes are
439: -- PROCEDURE : Get_Delivery_Status PUBLIC
440: --
441: -- PARAMETERS:
442: -- p_api_version_number known api version error number
443: -- p_init_msg_list FND_API.G_TRUE to reset list
444: -- p_entity_type either DELIVERY/DELIVERY DETAIL/LPN
445: -- p_entity_id either delivery_id/delivery_detail_id/lpn_id
446: -- x_status_code Status of delivery for the entity_type and
447: -- entity id passed