DBA Data[Home] [Help]

APPS.OE_PURCHASE_RELEASE_PVT dependencies on FND_API

Line 16: (header_id NUMBER := FND_API.G_MISS_NUM,

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,

Line 17: order_type_name VARCHAR2(240) := FND_API.G_MISS_CHAR,

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,

Line 18: order_number NUMBER := FND_API.G_MISS_NUM,

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,

Line 19: line_number 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,

Line 20: line_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,

Line 21: item_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,

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,

Line 22: inventory_item_id 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,

Line 23: ship_from_org_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,

Line 24: open_quantity 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,

Line 25: open_quantity2 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,
29: user_name VARCHAR2(100) := FND_API.G_MISS_CHAR, -- Bug# 4189838

Line 26: project_id NUMBER := FND_API.G_MISS_NUM,

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,

Line 27: task_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,

Line 28: end_item_unit_number VARCHAR2(30) := FND_API.G_MISS_CHAR,

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,

Line 29: user_name VARCHAR2(100) := FND_API.G_MISS_CHAR, -- Bug# 4189838

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,

Line 30: employee_id 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,
34: charge_account_id NUMBER := FND_API.G_MISS_NUM,

Line 31: request_date DATE := FND_API.G_MISS_DATE,

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,

Line 32: schedule_ship_date DATE := FND_API.G_MISS_DATE,

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,

Line 33: source_type_code 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,
37: deliver_to_location_id NUMBER := FND_API.G_MISS_NUM,

Line 34: charge_account_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,

Line 35: accrual_account_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,
39: result VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 36: ship_to_org_id NUMBER := FND_API.G_MISS_NUM,

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,

Line 37: deliver_to_location_id NUMBER := FND_API.G_MISS_NUM,

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,

Line 38: return_status VARCHAR2(1) := 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

Line 39: result VARCHAR2(30) := FND_API.G_MISS_CHAR,

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,

Line 40: uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR,

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

Line 41: uom2_code VARCHAR2(3) := 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: );

Line 42: preferred_grade VARCHAR2(150) := FND_API.G_MISS_CHAR, -- INVCONV 4091955

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:

Line 43: unit_list_price NUMBER := FND_API.G_MISS_NUM,

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;

Line 44: item_description VARCHAR2(1000) := 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;
48: