12: G_RES_COMPLETE VARCHAR2(30) := 'COMPLETE';
13: G_RES_ONHOLD VARCHAR2(30) := 'ONHOLD';
14:
15: TYPE Drop_Ship_Line_Rec_Type IS RECORD
16: (header_id NUMBER := FND_API.G_MISS_NUM,
17: order_type_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
18: order_number NUMBER := FND_API.G_MISS_NUM,
19: line_number NUMBER := FND_API.G_MISS_NUM,
20: line_id NUMBER := FND_API.G_MISS_NUM,
13: G_RES_ONHOLD VARCHAR2(30) := 'ONHOLD';
14:
15: TYPE Drop_Ship_Line_Rec_Type IS RECORD
16: (header_id NUMBER := FND_API.G_MISS_NUM,
17: order_type_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
18: order_number NUMBER := FND_API.G_MISS_NUM,
19: line_number NUMBER := FND_API.G_MISS_NUM,
20: line_id NUMBER := FND_API.G_MISS_NUM,
21: item_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
14:
15: TYPE Drop_Ship_Line_Rec_Type IS RECORD
16: (header_id NUMBER := FND_API.G_MISS_NUM,
17: order_type_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
18: order_number NUMBER := FND_API.G_MISS_NUM,
19: line_number NUMBER := FND_API.G_MISS_NUM,
20: line_id NUMBER := FND_API.G_MISS_NUM,
21: item_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
22: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
15: TYPE Drop_Ship_Line_Rec_Type IS RECORD
16: (header_id NUMBER := FND_API.G_MISS_NUM,
17: order_type_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
18: order_number NUMBER := FND_API.G_MISS_NUM,
19: line_number NUMBER := FND_API.G_MISS_NUM,
20: line_id NUMBER := FND_API.G_MISS_NUM,
21: item_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
22: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
23: ship_from_org_id NUMBER := FND_API.G_MISS_NUM,
16: (header_id NUMBER := FND_API.G_MISS_NUM,
17: order_type_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
18: order_number NUMBER := FND_API.G_MISS_NUM,
19: line_number NUMBER := FND_API.G_MISS_NUM,
20: line_id NUMBER := FND_API.G_MISS_NUM,
21: item_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
22: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
23: ship_from_org_id NUMBER := FND_API.G_MISS_NUM,
24: open_quantity NUMBER := FND_API.G_MISS_NUM,
17: order_type_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
18: order_number NUMBER := FND_API.G_MISS_NUM,
19: line_number NUMBER := FND_API.G_MISS_NUM,
20: line_id NUMBER := FND_API.G_MISS_NUM,
21: item_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
22: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
23: ship_from_org_id NUMBER := FND_API.G_MISS_NUM,
24: open_quantity NUMBER := FND_API.G_MISS_NUM,
25: open_quantity2 NUMBER := FND_API.G_MISS_NUM,
18: order_number NUMBER := FND_API.G_MISS_NUM,
19: line_number NUMBER := FND_API.G_MISS_NUM,
20: line_id NUMBER := FND_API.G_MISS_NUM,
21: item_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
22: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
23: ship_from_org_id NUMBER := FND_API.G_MISS_NUM,
24: open_quantity NUMBER := FND_API.G_MISS_NUM,
25: open_quantity2 NUMBER := FND_API.G_MISS_NUM,
26: project_id NUMBER := FND_API.G_MISS_NUM,
19: line_number NUMBER := FND_API.G_MISS_NUM,
20: line_id NUMBER := FND_API.G_MISS_NUM,
21: item_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
22: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
23: ship_from_org_id NUMBER := FND_API.G_MISS_NUM,
24: open_quantity NUMBER := FND_API.G_MISS_NUM,
25: open_quantity2 NUMBER := FND_API.G_MISS_NUM,
26: project_id NUMBER := FND_API.G_MISS_NUM,
27: task_id NUMBER := FND_API.G_MISS_NUM,
20: line_id NUMBER := FND_API.G_MISS_NUM,
21: item_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
22: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
23: ship_from_org_id NUMBER := FND_API.G_MISS_NUM,
24: open_quantity NUMBER := FND_API.G_MISS_NUM,
25: open_quantity2 NUMBER := FND_API.G_MISS_NUM,
26: project_id NUMBER := FND_API.G_MISS_NUM,
27: task_id NUMBER := FND_API.G_MISS_NUM,
28: end_item_unit_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
21: item_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
22: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
23: ship_from_org_id NUMBER := FND_API.G_MISS_NUM,
24: open_quantity NUMBER := FND_API.G_MISS_NUM,
25: open_quantity2 NUMBER := FND_API.G_MISS_NUM,
26: project_id NUMBER := FND_API.G_MISS_NUM,
27: task_id NUMBER := FND_API.G_MISS_NUM,
28: end_item_unit_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
29: user_name VARCHAR2(100) := FND_API.G_MISS_CHAR, -- Bug# 4189838
22: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
23: ship_from_org_id NUMBER := FND_API.G_MISS_NUM,
24: open_quantity NUMBER := FND_API.G_MISS_NUM,
25: open_quantity2 NUMBER := FND_API.G_MISS_NUM,
26: project_id NUMBER := FND_API.G_MISS_NUM,
27: task_id NUMBER := FND_API.G_MISS_NUM,
28: end_item_unit_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
29: user_name VARCHAR2(100) := FND_API.G_MISS_CHAR, -- Bug# 4189838
30: employee_id NUMBER := FND_API.G_MISS_NUM,
23: ship_from_org_id NUMBER := FND_API.G_MISS_NUM,
24: open_quantity NUMBER := FND_API.G_MISS_NUM,
25: open_quantity2 NUMBER := FND_API.G_MISS_NUM,
26: project_id NUMBER := FND_API.G_MISS_NUM,
27: task_id NUMBER := FND_API.G_MISS_NUM,
28: end_item_unit_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
29: user_name VARCHAR2(100) := FND_API.G_MISS_CHAR, -- Bug# 4189838
30: employee_id NUMBER := FND_API.G_MISS_NUM,
31: request_date DATE := FND_API.G_MISS_DATE,
24: open_quantity NUMBER := FND_API.G_MISS_NUM,
25: open_quantity2 NUMBER := FND_API.G_MISS_NUM,
26: project_id NUMBER := FND_API.G_MISS_NUM,
27: task_id NUMBER := FND_API.G_MISS_NUM,
28: end_item_unit_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
29: user_name VARCHAR2(100) := FND_API.G_MISS_CHAR, -- Bug# 4189838
30: employee_id NUMBER := FND_API.G_MISS_NUM,
31: request_date DATE := FND_API.G_MISS_DATE,
32: schedule_ship_date DATE := FND_API.G_MISS_DATE,
25: open_quantity2 NUMBER := FND_API.G_MISS_NUM,
26: project_id NUMBER := FND_API.G_MISS_NUM,
27: task_id NUMBER := FND_API.G_MISS_NUM,
28: end_item_unit_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
29: user_name VARCHAR2(100) := FND_API.G_MISS_CHAR, -- Bug# 4189838
30: employee_id NUMBER := FND_API.G_MISS_NUM,
31: request_date DATE := FND_API.G_MISS_DATE,
32: schedule_ship_date DATE := FND_API.G_MISS_DATE,
33: source_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
26: project_id NUMBER := FND_API.G_MISS_NUM,
27: task_id NUMBER := FND_API.G_MISS_NUM,
28: end_item_unit_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
29: user_name VARCHAR2(100) := FND_API.G_MISS_CHAR, -- Bug# 4189838
30: employee_id NUMBER := FND_API.G_MISS_NUM,
31: request_date DATE := FND_API.G_MISS_DATE,
32: schedule_ship_date DATE := FND_API.G_MISS_DATE,
33: source_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
34: charge_account_id NUMBER := FND_API.G_MISS_NUM,
27: task_id NUMBER := FND_API.G_MISS_NUM,
28: end_item_unit_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
29: user_name VARCHAR2(100) := FND_API.G_MISS_CHAR, -- Bug# 4189838
30: employee_id NUMBER := FND_API.G_MISS_NUM,
31: request_date DATE := FND_API.G_MISS_DATE,
32: schedule_ship_date DATE := FND_API.G_MISS_DATE,
33: source_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
34: charge_account_id NUMBER := FND_API.G_MISS_NUM,
35: accrual_account_id NUMBER := FND_API.G_MISS_NUM,
28: end_item_unit_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
29: user_name VARCHAR2(100) := FND_API.G_MISS_CHAR, -- Bug# 4189838
30: employee_id NUMBER := FND_API.G_MISS_NUM,
31: request_date DATE := FND_API.G_MISS_DATE,
32: schedule_ship_date DATE := FND_API.G_MISS_DATE,
33: source_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
34: charge_account_id NUMBER := FND_API.G_MISS_NUM,
35: accrual_account_id NUMBER := FND_API.G_MISS_NUM,
36: ship_to_org_id NUMBER := FND_API.G_MISS_NUM,
29: user_name VARCHAR2(100) := FND_API.G_MISS_CHAR, -- Bug# 4189838
30: employee_id NUMBER := FND_API.G_MISS_NUM,
31: request_date DATE := FND_API.G_MISS_DATE,
32: schedule_ship_date DATE := FND_API.G_MISS_DATE,
33: source_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
34: charge_account_id NUMBER := FND_API.G_MISS_NUM,
35: accrual_account_id NUMBER := FND_API.G_MISS_NUM,
36: ship_to_org_id NUMBER := FND_API.G_MISS_NUM,
37: deliver_to_location_id NUMBER := FND_API.G_MISS_NUM,
30: employee_id NUMBER := FND_API.G_MISS_NUM,
31: request_date DATE := FND_API.G_MISS_DATE,
32: schedule_ship_date DATE := FND_API.G_MISS_DATE,
33: source_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
34: charge_account_id NUMBER := FND_API.G_MISS_NUM,
35: accrual_account_id NUMBER := FND_API.G_MISS_NUM,
36: ship_to_org_id NUMBER := FND_API.G_MISS_NUM,
37: deliver_to_location_id NUMBER := FND_API.G_MISS_NUM,
38: return_status VARCHAR2(1) := FND_API.G_MISS_CHAR,
31: request_date DATE := FND_API.G_MISS_DATE,
32: schedule_ship_date DATE := FND_API.G_MISS_DATE,
33: source_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
34: charge_account_id NUMBER := FND_API.G_MISS_NUM,
35: accrual_account_id NUMBER := FND_API.G_MISS_NUM,
36: ship_to_org_id NUMBER := FND_API.G_MISS_NUM,
37: deliver_to_location_id NUMBER := FND_API.G_MISS_NUM,
38: return_status VARCHAR2(1) := FND_API.G_MISS_CHAR,
39: result VARCHAR2(30) := FND_API.G_MISS_CHAR,
32: schedule_ship_date DATE := FND_API.G_MISS_DATE,
33: source_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
34: charge_account_id NUMBER := FND_API.G_MISS_NUM,
35: accrual_account_id NUMBER := FND_API.G_MISS_NUM,
36: ship_to_org_id NUMBER := FND_API.G_MISS_NUM,
37: deliver_to_location_id NUMBER := FND_API.G_MISS_NUM,
38: return_status VARCHAR2(1) := FND_API.G_MISS_CHAR,
39: result VARCHAR2(30) := FND_API.G_MISS_CHAR,
40: uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR,
33: source_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
34: charge_account_id NUMBER := FND_API.G_MISS_NUM,
35: accrual_account_id NUMBER := FND_API.G_MISS_NUM,
36: ship_to_org_id NUMBER := FND_API.G_MISS_NUM,
37: deliver_to_location_id NUMBER := FND_API.G_MISS_NUM,
38: return_status VARCHAR2(1) := FND_API.G_MISS_CHAR,
39: result VARCHAR2(30) := FND_API.G_MISS_CHAR,
40: uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR,
41: uom2_code VARCHAR2(3) := FND_API.G_MISS_CHAR,
34: charge_account_id NUMBER := FND_API.G_MISS_NUM,
35: accrual_account_id NUMBER := FND_API.G_MISS_NUM,
36: ship_to_org_id NUMBER := FND_API.G_MISS_NUM,
37: deliver_to_location_id NUMBER := FND_API.G_MISS_NUM,
38: return_status VARCHAR2(1) := FND_API.G_MISS_CHAR,
39: result VARCHAR2(30) := FND_API.G_MISS_CHAR,
40: uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR,
41: uom2_code VARCHAR2(3) := FND_API.G_MISS_CHAR,
42: preferred_grade VARCHAR2(150) := FND_API.G_MISS_CHAR, -- INVCONV 4091955
35: accrual_account_id NUMBER := FND_API.G_MISS_NUM,
36: ship_to_org_id NUMBER := FND_API.G_MISS_NUM,
37: deliver_to_location_id NUMBER := FND_API.G_MISS_NUM,
38: return_status VARCHAR2(1) := FND_API.G_MISS_CHAR,
39: result VARCHAR2(30) := FND_API.G_MISS_CHAR,
40: uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR,
41: uom2_code VARCHAR2(3) := FND_API.G_MISS_CHAR,
42: preferred_grade VARCHAR2(150) := FND_API.G_MISS_CHAR, -- INVCONV 4091955
43: unit_list_price NUMBER := FND_API.G_MISS_NUM,
36: ship_to_org_id NUMBER := FND_API.G_MISS_NUM,
37: deliver_to_location_id NUMBER := FND_API.G_MISS_NUM,
38: return_status VARCHAR2(1) := FND_API.G_MISS_CHAR,
39: result VARCHAR2(30) := FND_API.G_MISS_CHAR,
40: uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR,
41: uom2_code VARCHAR2(3) := FND_API.G_MISS_CHAR,
42: preferred_grade VARCHAR2(150) := FND_API.G_MISS_CHAR, -- INVCONV 4091955
43: unit_list_price NUMBER := FND_API.G_MISS_NUM,
44: item_description VARCHAR2(1000) := FND_API.G_MISS_CHAR
37: deliver_to_location_id NUMBER := FND_API.G_MISS_NUM,
38: return_status VARCHAR2(1) := FND_API.G_MISS_CHAR,
39: result VARCHAR2(30) := FND_API.G_MISS_CHAR,
40: uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR,
41: uom2_code VARCHAR2(3) := FND_API.G_MISS_CHAR,
42: preferred_grade VARCHAR2(150) := FND_API.G_MISS_CHAR, -- INVCONV 4091955
43: unit_list_price NUMBER := FND_API.G_MISS_NUM,
44: item_description VARCHAR2(1000) := FND_API.G_MISS_CHAR
45: );
38: return_status VARCHAR2(1) := FND_API.G_MISS_CHAR,
39: result VARCHAR2(30) := FND_API.G_MISS_CHAR,
40: uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR,
41: uom2_code VARCHAR2(3) := FND_API.G_MISS_CHAR,
42: preferred_grade VARCHAR2(150) := FND_API.G_MISS_CHAR, -- INVCONV 4091955
43: unit_list_price NUMBER := FND_API.G_MISS_NUM,
44: item_description VARCHAR2(1000) := FND_API.G_MISS_CHAR
45: );
46:
39: result VARCHAR2(30) := FND_API.G_MISS_CHAR,
40: uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR,
41: uom2_code VARCHAR2(3) := FND_API.G_MISS_CHAR,
42: preferred_grade VARCHAR2(150) := FND_API.G_MISS_CHAR, -- INVCONV 4091955
43: unit_list_price NUMBER := FND_API.G_MISS_NUM,
44: item_description VARCHAR2(1000) := FND_API.G_MISS_CHAR
45: );
46:
47: G_MISS_DROP_SHIP_LINE_REC Drop_Ship_Line_Rec_Type;
40: uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR,
41: uom2_code VARCHAR2(3) := FND_API.G_MISS_CHAR,
42: preferred_grade VARCHAR2(150) := FND_API.G_MISS_CHAR, -- INVCONV 4091955
43: unit_list_price NUMBER := FND_API.G_MISS_NUM,
44: item_description VARCHAR2(1000) := FND_API.G_MISS_CHAR
45: );
46:
47: G_MISS_DROP_SHIP_LINE_REC Drop_Ship_Line_Rec_Type;
48: