eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_WIP_PICKING_PVT dependencies on FND_API

Line 17: ( attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR

13:
14: -- Bug 4288399, creating a new table of records which will be passed back to
15: -- WIP containing errored record information with the error message.
16: TYPE Trolin_ErrRec_Type IS RECORD
17: ( attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
18: , attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
19: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
20: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
21: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 18: , attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR

14: -- Bug 4288399, creating a new table of records which will be passed back to
15: -- WIP containing errored record information with the error message.
16: TYPE Trolin_ErrRec_Type IS RECORD
17: ( attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
18: , attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
19: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
20: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
21: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
22: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 19: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR

15: -- WIP containing errored record information with the error message.
16: TYPE Trolin_ErrRec_Type IS RECORD
17: ( attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
18: , attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
19: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
20: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
21: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
22: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
23: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 20: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR

16: TYPE Trolin_ErrRec_Type IS RECORD
17: ( attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
18: , attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
19: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
20: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
21: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
22: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
23: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
24: , attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 21: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR

17: ( attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
18: , attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
19: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
20: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
21: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
22: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
23: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
24: , attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
25: , attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 22: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR

18: , attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
19: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
20: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
21: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
22: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
23: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
24: , attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
25: , attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
26: , attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 23: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR

19: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
20: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
21: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
22: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
23: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
24: , attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
25: , attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
26: , attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
27: , attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 24: , attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR

20: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
21: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
22: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
23: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
24: , attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
25: , attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
26: , attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
27: , attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
28: , attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 25: , attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR

21: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
22: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
23: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
24: , attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
25: , attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
26: , attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
27: , attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
28: , attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
29: , attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 26: , attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR

22: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
23: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
24: , attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
25: , attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
26: , attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
27: , attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
28: , attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
29: , attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
30: , attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 27: , attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR

23: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
24: , attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
25: , attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
26: , attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
27: , attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
28: , attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
29: , attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
30: , attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
31: , attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 28: , attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR

24: , attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
25: , attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
26: , attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
27: , attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
28: , attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
29: , attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
30: , attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
31: , attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
32: , attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 29: , attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR

25: , attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
26: , attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
27: , attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
28: , attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
29: , attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
30: , attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
31: , attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
32: , attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
33: , created_by NUMBER := FND_API.G_MISS_NUM

Line 30: , attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR

26: , attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
27: , attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
28: , attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
29: , attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
30: , attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
31: , attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
32: , attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
33: , created_by NUMBER := FND_API.G_MISS_NUM
34: , creation_date DATE := FND_API.G_MISS_DATE

Line 31: , attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR

27: , attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
28: , attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
29: , attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
30: , attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
31: , attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
32: , attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
33: , created_by NUMBER := FND_API.G_MISS_NUM
34: , creation_date DATE := FND_API.G_MISS_DATE
35: , date_required DATE := FND_API.G_MISS_DATE

Line 32: , attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR

28: , attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
29: , attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
30: , attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
31: , attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
32: , attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
33: , created_by NUMBER := FND_API.G_MISS_NUM
34: , creation_date DATE := FND_API.G_MISS_DATE
35: , date_required DATE := FND_API.G_MISS_DATE
36: , from_locator_id NUMBER := FND_API.G_MISS_NUM

Line 33: , created_by NUMBER := FND_API.G_MISS_NUM

29: , attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
30: , attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
31: , attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
32: , attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
33: , created_by NUMBER := FND_API.G_MISS_NUM
34: , creation_date DATE := FND_API.G_MISS_DATE
35: , date_required DATE := FND_API.G_MISS_DATE
36: , from_locator_id NUMBER := FND_API.G_MISS_NUM
37: , from_subinventory_code VARCHAR2(10) := FND_API.G_MISS_CHAR

Line 34: , creation_date DATE := FND_API.G_MISS_DATE

30: , attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
31: , attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
32: , attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
33: , created_by NUMBER := FND_API.G_MISS_NUM
34: , creation_date DATE := FND_API.G_MISS_DATE
35: , date_required DATE := FND_API.G_MISS_DATE
36: , from_locator_id NUMBER := FND_API.G_MISS_NUM
37: , from_subinventory_code VARCHAR2(10) := FND_API.G_MISS_CHAR
38: , from_subinventory_id NUMBER := FND_API.G_MISS_NUM

Line 35: , date_required DATE := FND_API.G_MISS_DATE

31: , attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
32: , attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
33: , created_by NUMBER := FND_API.G_MISS_NUM
34: , creation_date DATE := FND_API.G_MISS_DATE
35: , date_required DATE := FND_API.G_MISS_DATE
36: , from_locator_id NUMBER := FND_API.G_MISS_NUM
37: , from_subinventory_code VARCHAR2(10) := FND_API.G_MISS_CHAR
38: , from_subinventory_id NUMBER := FND_API.G_MISS_NUM
39: , header_id NUMBER := FND_API.G_MISS_NUM

Line 36: , from_locator_id NUMBER := FND_API.G_MISS_NUM

32: , attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
33: , created_by NUMBER := FND_API.G_MISS_NUM
34: , creation_date DATE := FND_API.G_MISS_DATE
35: , date_required DATE := FND_API.G_MISS_DATE
36: , from_locator_id NUMBER := FND_API.G_MISS_NUM
37: , from_subinventory_code VARCHAR2(10) := FND_API.G_MISS_CHAR
38: , from_subinventory_id NUMBER := FND_API.G_MISS_NUM
39: , header_id NUMBER := FND_API.G_MISS_NUM
40: , inventory_item_id NUMBER := FND_API.G_MISS_NUM

Line 37: , from_subinventory_code VARCHAR2(10) := FND_API.G_MISS_CHAR

33: , created_by NUMBER := FND_API.G_MISS_NUM
34: , creation_date DATE := FND_API.G_MISS_DATE
35: , date_required DATE := FND_API.G_MISS_DATE
36: , from_locator_id NUMBER := FND_API.G_MISS_NUM
37: , from_subinventory_code VARCHAR2(10) := FND_API.G_MISS_CHAR
38: , from_subinventory_id NUMBER := FND_API.G_MISS_NUM
39: , header_id NUMBER := FND_API.G_MISS_NUM
40: , inventory_item_id NUMBER := FND_API.G_MISS_NUM
41: , last_updated_by NUMBER := FND_API.G_MISS_NUM

Line 38: , from_subinventory_id NUMBER := FND_API.G_MISS_NUM

34: , creation_date DATE := FND_API.G_MISS_DATE
35: , date_required DATE := FND_API.G_MISS_DATE
36: , from_locator_id NUMBER := FND_API.G_MISS_NUM
37: , from_subinventory_code VARCHAR2(10) := FND_API.G_MISS_CHAR
38: , from_subinventory_id NUMBER := FND_API.G_MISS_NUM
39: , header_id NUMBER := FND_API.G_MISS_NUM
40: , inventory_item_id NUMBER := FND_API.G_MISS_NUM
41: , last_updated_by NUMBER := FND_API.G_MISS_NUM
42: , last_update_date DATE := FND_API.G_MISS_DATE

Line 39: , header_id NUMBER := FND_API.G_MISS_NUM

35: , date_required DATE := FND_API.G_MISS_DATE
36: , from_locator_id NUMBER := FND_API.G_MISS_NUM
37: , from_subinventory_code VARCHAR2(10) := FND_API.G_MISS_CHAR
38: , from_subinventory_id NUMBER := FND_API.G_MISS_NUM
39: , header_id NUMBER := FND_API.G_MISS_NUM
40: , inventory_item_id NUMBER := FND_API.G_MISS_NUM
41: , last_updated_by NUMBER := FND_API.G_MISS_NUM
42: , last_update_date DATE := FND_API.G_MISS_DATE
43: , last_update_login NUMBER := FND_API.G_MISS_NUM

Line 40: , inventory_item_id NUMBER := FND_API.G_MISS_NUM

36: , from_locator_id NUMBER := FND_API.G_MISS_NUM
37: , from_subinventory_code VARCHAR2(10) := FND_API.G_MISS_CHAR
38: , from_subinventory_id NUMBER := FND_API.G_MISS_NUM
39: , header_id NUMBER := FND_API.G_MISS_NUM
40: , inventory_item_id NUMBER := FND_API.G_MISS_NUM
41: , last_updated_by NUMBER := FND_API.G_MISS_NUM
42: , last_update_date DATE := FND_API.G_MISS_DATE
43: , last_update_login NUMBER := FND_API.G_MISS_NUM
44: , line_id NUMBER := FND_API.G_MISS_NUM

Line 41: , last_updated_by NUMBER := FND_API.G_MISS_NUM

37: , from_subinventory_code VARCHAR2(10) := FND_API.G_MISS_CHAR
38: , from_subinventory_id NUMBER := FND_API.G_MISS_NUM
39: , header_id NUMBER := FND_API.G_MISS_NUM
40: , inventory_item_id NUMBER := FND_API.G_MISS_NUM
41: , last_updated_by NUMBER := FND_API.G_MISS_NUM
42: , last_update_date DATE := FND_API.G_MISS_DATE
43: , last_update_login NUMBER := FND_API.G_MISS_NUM
44: , line_id NUMBER := FND_API.G_MISS_NUM
45: , line_number NUMBER := FND_API.G_MISS_NUM

Line 42: , last_update_date DATE := FND_API.G_MISS_DATE

38: , from_subinventory_id NUMBER := FND_API.G_MISS_NUM
39: , header_id NUMBER := FND_API.G_MISS_NUM
40: , inventory_item_id NUMBER := FND_API.G_MISS_NUM
41: , last_updated_by NUMBER := FND_API.G_MISS_NUM
42: , last_update_date DATE := FND_API.G_MISS_DATE
43: , last_update_login NUMBER := FND_API.G_MISS_NUM
44: , line_id NUMBER := FND_API.G_MISS_NUM
45: , line_number NUMBER := FND_API.G_MISS_NUM
46: , line_status NUMBER := FND_API.G_MISS_NUM

Line 43: , last_update_login NUMBER := FND_API.G_MISS_NUM

39: , header_id NUMBER := FND_API.G_MISS_NUM
40: , inventory_item_id NUMBER := FND_API.G_MISS_NUM
41: , last_updated_by NUMBER := FND_API.G_MISS_NUM
42: , last_update_date DATE := FND_API.G_MISS_DATE
43: , last_update_login NUMBER := FND_API.G_MISS_NUM
44: , line_id NUMBER := FND_API.G_MISS_NUM
45: , line_number NUMBER := FND_API.G_MISS_NUM
46: , line_status NUMBER := FND_API.G_MISS_NUM
47: -- Increased lot size to 80 Char - Mercy Thomas - B4625329

Line 44: , line_id NUMBER := FND_API.G_MISS_NUM

40: , inventory_item_id NUMBER := FND_API.G_MISS_NUM
41: , last_updated_by NUMBER := FND_API.G_MISS_NUM
42: , last_update_date DATE := FND_API.G_MISS_DATE
43: , last_update_login NUMBER := FND_API.G_MISS_NUM
44: , line_id NUMBER := FND_API.G_MISS_NUM
45: , line_number NUMBER := FND_API.G_MISS_NUM
46: , line_status NUMBER := FND_API.G_MISS_NUM
47: -- Increased lot size to 80 Char - Mercy Thomas - B4625329
48: , lot_number VARCHAR2(80) := FND_API.G_MISS_CHAR

Line 45: , line_number NUMBER := FND_API.G_MISS_NUM

41: , last_updated_by NUMBER := FND_API.G_MISS_NUM
42: , last_update_date DATE := FND_API.G_MISS_DATE
43: , last_update_login NUMBER := FND_API.G_MISS_NUM
44: , line_id NUMBER := FND_API.G_MISS_NUM
45: , line_number NUMBER := FND_API.G_MISS_NUM
46: , line_status NUMBER := FND_API.G_MISS_NUM
47: -- Increased lot size to 80 Char - Mercy Thomas - B4625329
48: , lot_number VARCHAR2(80) := FND_API.G_MISS_CHAR
49: , organization_id NUMBER := FND_API.G_MISS_NUM

Line 46: , line_status NUMBER := FND_API.G_MISS_NUM

42: , last_update_date DATE := FND_API.G_MISS_DATE
43: , last_update_login NUMBER := FND_API.G_MISS_NUM
44: , line_id NUMBER := FND_API.G_MISS_NUM
45: , line_number NUMBER := FND_API.G_MISS_NUM
46: , line_status NUMBER := FND_API.G_MISS_NUM
47: -- Increased lot size to 80 Char - Mercy Thomas - B4625329
48: , lot_number VARCHAR2(80) := FND_API.G_MISS_CHAR
49: , organization_id NUMBER := FND_API.G_MISS_NUM
50: , program_application_id NUMBER := FND_API.G_MISS_NUM

Line 48: , lot_number VARCHAR2(80) := FND_API.G_MISS_CHAR

44: , line_id NUMBER := FND_API.G_MISS_NUM
45: , line_number NUMBER := FND_API.G_MISS_NUM
46: , line_status NUMBER := FND_API.G_MISS_NUM
47: -- Increased lot size to 80 Char - Mercy Thomas - B4625329
48: , lot_number VARCHAR2(80) := FND_API.G_MISS_CHAR
49: , organization_id NUMBER := FND_API.G_MISS_NUM
50: , program_application_id NUMBER := FND_API.G_MISS_NUM
51: , program_id NUMBER := FND_API.G_MISS_NUM
52: , program_update_date DATE := FND_API.G_MISS_DATE

Line 49: , organization_id NUMBER := FND_API.G_MISS_NUM

45: , line_number NUMBER := FND_API.G_MISS_NUM
46: , line_status NUMBER := FND_API.G_MISS_NUM
47: -- Increased lot size to 80 Char - Mercy Thomas - B4625329
48: , lot_number VARCHAR2(80) := FND_API.G_MISS_CHAR
49: , organization_id NUMBER := FND_API.G_MISS_NUM
50: , program_application_id NUMBER := FND_API.G_MISS_NUM
51: , program_id NUMBER := FND_API.G_MISS_NUM
52: , program_update_date DATE := FND_API.G_MISS_DATE
53: , project_id NUMBER := FND_API.G_MISS_NUM

Line 50: , program_application_id NUMBER := FND_API.G_MISS_NUM

46: , line_status NUMBER := FND_API.G_MISS_NUM
47: -- Increased lot size to 80 Char - Mercy Thomas - B4625329
48: , lot_number VARCHAR2(80) := FND_API.G_MISS_CHAR
49: , organization_id NUMBER := FND_API.G_MISS_NUM
50: , program_application_id NUMBER := FND_API.G_MISS_NUM
51: , program_id NUMBER := FND_API.G_MISS_NUM
52: , program_update_date DATE := FND_API.G_MISS_DATE
53: , project_id NUMBER := FND_API.G_MISS_NUM
54: , quantity NUMBER := FND_API.G_MISS_NUM

Line 51: , program_id NUMBER := FND_API.G_MISS_NUM

47: -- Increased lot size to 80 Char - Mercy Thomas - B4625329
48: , lot_number VARCHAR2(80) := FND_API.G_MISS_CHAR
49: , organization_id NUMBER := FND_API.G_MISS_NUM
50: , program_application_id NUMBER := FND_API.G_MISS_NUM
51: , program_id NUMBER := FND_API.G_MISS_NUM
52: , program_update_date DATE := FND_API.G_MISS_DATE
53: , project_id NUMBER := FND_API.G_MISS_NUM
54: , quantity NUMBER := FND_API.G_MISS_NUM
55: , quantity_delivered NUMBER := FND_API.G_MISS_NUM

Line 52: , program_update_date DATE := FND_API.G_MISS_DATE

48: , lot_number VARCHAR2(80) := FND_API.G_MISS_CHAR
49: , organization_id NUMBER := FND_API.G_MISS_NUM
50: , program_application_id NUMBER := FND_API.G_MISS_NUM
51: , program_id NUMBER := FND_API.G_MISS_NUM
52: , program_update_date DATE := FND_API.G_MISS_DATE
53: , project_id NUMBER := FND_API.G_MISS_NUM
54: , quantity NUMBER := FND_API.G_MISS_NUM
55: , quantity_delivered NUMBER := FND_API.G_MISS_NUM
56: , quantity_detailed NUMBER := FND_API.G_MISS_NUM

Line 53: , project_id NUMBER := FND_API.G_MISS_NUM

49: , organization_id NUMBER := FND_API.G_MISS_NUM
50: , program_application_id NUMBER := FND_API.G_MISS_NUM
51: , program_id NUMBER := FND_API.G_MISS_NUM
52: , program_update_date DATE := FND_API.G_MISS_DATE
53: , project_id NUMBER := FND_API.G_MISS_NUM
54: , quantity NUMBER := FND_API.G_MISS_NUM
55: , quantity_delivered NUMBER := FND_API.G_MISS_NUM
56: , quantity_detailed NUMBER := FND_API.G_MISS_NUM
57: , reason_id NUMBER := FND_API.G_MISS_NUM

Line 54: , quantity NUMBER := FND_API.G_MISS_NUM

50: , program_application_id NUMBER := FND_API.G_MISS_NUM
51: , program_id NUMBER := FND_API.G_MISS_NUM
52: , program_update_date DATE := FND_API.G_MISS_DATE
53: , project_id NUMBER := FND_API.G_MISS_NUM
54: , quantity NUMBER := FND_API.G_MISS_NUM
55: , quantity_delivered NUMBER := FND_API.G_MISS_NUM
56: , quantity_detailed NUMBER := FND_API.G_MISS_NUM
57: , reason_id NUMBER := FND_API.G_MISS_NUM
58: , reference VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 55: , quantity_delivered NUMBER := FND_API.G_MISS_NUM

51: , program_id NUMBER := FND_API.G_MISS_NUM
52: , program_update_date DATE := FND_API.G_MISS_DATE
53: , project_id NUMBER := FND_API.G_MISS_NUM
54: , quantity NUMBER := FND_API.G_MISS_NUM
55: , quantity_delivered NUMBER := FND_API.G_MISS_NUM
56: , quantity_detailed NUMBER := FND_API.G_MISS_NUM
57: , reason_id NUMBER := FND_API.G_MISS_NUM
58: , reference VARCHAR2(240) := FND_API.G_MISS_CHAR
59: , reference_id NUMBER := FND_API.G_MISS_NUM

Line 56: , quantity_detailed NUMBER := FND_API.G_MISS_NUM

52: , program_update_date DATE := FND_API.G_MISS_DATE
53: , project_id NUMBER := FND_API.G_MISS_NUM
54: , quantity NUMBER := FND_API.G_MISS_NUM
55: , quantity_delivered NUMBER := FND_API.G_MISS_NUM
56: , quantity_detailed NUMBER := FND_API.G_MISS_NUM
57: , reason_id NUMBER := FND_API.G_MISS_NUM
58: , reference VARCHAR2(240) := FND_API.G_MISS_CHAR
59: , reference_id NUMBER := FND_API.G_MISS_NUM
60: , reference_type_code NUMBER := FND_API.G_MISS_NUM

Line 57: , reason_id NUMBER := FND_API.G_MISS_NUM

53: , project_id NUMBER := FND_API.G_MISS_NUM
54: , quantity NUMBER := FND_API.G_MISS_NUM
55: , quantity_delivered NUMBER := FND_API.G_MISS_NUM
56: , quantity_detailed NUMBER := FND_API.G_MISS_NUM
57: , reason_id NUMBER := FND_API.G_MISS_NUM
58: , reference VARCHAR2(240) := FND_API.G_MISS_CHAR
59: , reference_id NUMBER := FND_API.G_MISS_NUM
60: , reference_type_code NUMBER := FND_API.G_MISS_NUM
61: , request_id NUMBER := FND_API.G_MISS_NUM

Line 58: , reference VARCHAR2(240) := FND_API.G_MISS_CHAR

54: , quantity NUMBER := FND_API.G_MISS_NUM
55: , quantity_delivered NUMBER := FND_API.G_MISS_NUM
56: , quantity_detailed NUMBER := FND_API.G_MISS_NUM
57: , reason_id NUMBER := FND_API.G_MISS_NUM
58: , reference VARCHAR2(240) := FND_API.G_MISS_CHAR
59: , reference_id NUMBER := FND_API.G_MISS_NUM
60: , reference_type_code NUMBER := FND_API.G_MISS_NUM
61: , request_id NUMBER := FND_API.G_MISS_NUM
62: , revision VARCHAR2(3) := FND_API.G_MISS_CHAR

Line 59: , reference_id NUMBER := FND_API.G_MISS_NUM

55: , quantity_delivered NUMBER := FND_API.G_MISS_NUM
56: , quantity_detailed NUMBER := FND_API.G_MISS_NUM
57: , reason_id NUMBER := FND_API.G_MISS_NUM
58: , reference VARCHAR2(240) := FND_API.G_MISS_CHAR
59: , reference_id NUMBER := FND_API.G_MISS_NUM
60: , reference_type_code NUMBER := FND_API.G_MISS_NUM
61: , request_id NUMBER := FND_API.G_MISS_NUM
62: , revision VARCHAR2(3) := FND_API.G_MISS_CHAR
63: , serial_number_end VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 60: , reference_type_code NUMBER := FND_API.G_MISS_NUM

56: , quantity_detailed NUMBER := FND_API.G_MISS_NUM
57: , reason_id NUMBER := FND_API.G_MISS_NUM
58: , reference VARCHAR2(240) := FND_API.G_MISS_CHAR
59: , reference_id NUMBER := FND_API.G_MISS_NUM
60: , reference_type_code NUMBER := FND_API.G_MISS_NUM
61: , request_id NUMBER := FND_API.G_MISS_NUM
62: , revision VARCHAR2(3) := FND_API.G_MISS_CHAR
63: , serial_number_end VARCHAR2(30) := FND_API.G_MISS_CHAR
64: , serial_number_start VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 61: , request_id NUMBER := FND_API.G_MISS_NUM

57: , reason_id NUMBER := FND_API.G_MISS_NUM
58: , reference VARCHAR2(240) := FND_API.G_MISS_CHAR
59: , reference_id NUMBER := FND_API.G_MISS_NUM
60: , reference_type_code NUMBER := FND_API.G_MISS_NUM
61: , request_id NUMBER := FND_API.G_MISS_NUM
62: , revision VARCHAR2(3) := FND_API.G_MISS_CHAR
63: , serial_number_end VARCHAR2(30) := FND_API.G_MISS_CHAR
64: , serial_number_start VARCHAR2(30) := FND_API.G_MISS_CHAR
65: , status_date DATE := FND_API.G_MISS_DATE

Line 62: , revision VARCHAR2(3) := FND_API.G_MISS_CHAR

58: , reference VARCHAR2(240) := FND_API.G_MISS_CHAR
59: , reference_id NUMBER := FND_API.G_MISS_NUM
60: , reference_type_code NUMBER := FND_API.G_MISS_NUM
61: , request_id NUMBER := FND_API.G_MISS_NUM
62: , revision VARCHAR2(3) := FND_API.G_MISS_CHAR
63: , serial_number_end VARCHAR2(30) := FND_API.G_MISS_CHAR
64: , serial_number_start VARCHAR2(30) := FND_API.G_MISS_CHAR
65: , status_date DATE := FND_API.G_MISS_DATE
66: , task_id NUMBER := FND_API.G_MISS_NUM

Line 63: , serial_number_end VARCHAR2(30) := FND_API.G_MISS_CHAR

59: , reference_id NUMBER := FND_API.G_MISS_NUM
60: , reference_type_code NUMBER := FND_API.G_MISS_NUM
61: , request_id NUMBER := FND_API.G_MISS_NUM
62: , revision VARCHAR2(3) := FND_API.G_MISS_CHAR
63: , serial_number_end VARCHAR2(30) := FND_API.G_MISS_CHAR
64: , serial_number_start VARCHAR2(30) := FND_API.G_MISS_CHAR
65: , status_date DATE := FND_API.G_MISS_DATE
66: , task_id NUMBER := FND_API.G_MISS_NUM
67: , to_account_id NUMBER := FND_API.G_MISS_NUM

Line 64: , serial_number_start VARCHAR2(30) := FND_API.G_MISS_CHAR

60: , reference_type_code NUMBER := FND_API.G_MISS_NUM
61: , request_id NUMBER := FND_API.G_MISS_NUM
62: , revision VARCHAR2(3) := FND_API.G_MISS_CHAR
63: , serial_number_end VARCHAR2(30) := FND_API.G_MISS_CHAR
64: , serial_number_start VARCHAR2(30) := FND_API.G_MISS_CHAR
65: , status_date DATE := FND_API.G_MISS_DATE
66: , task_id NUMBER := FND_API.G_MISS_NUM
67: , to_account_id NUMBER := FND_API.G_MISS_NUM
68: , to_locator_id NUMBER := FND_API.G_MISS_NUM

Line 65: , status_date DATE := FND_API.G_MISS_DATE

61: , request_id NUMBER := FND_API.G_MISS_NUM
62: , revision VARCHAR2(3) := FND_API.G_MISS_CHAR
63: , serial_number_end VARCHAR2(30) := FND_API.G_MISS_CHAR
64: , serial_number_start VARCHAR2(30) := FND_API.G_MISS_CHAR
65: , status_date DATE := FND_API.G_MISS_DATE
66: , task_id NUMBER := FND_API.G_MISS_NUM
67: , to_account_id NUMBER := FND_API.G_MISS_NUM
68: , to_locator_id NUMBER := FND_API.G_MISS_NUM
69: , to_subinventory_code VARCHAR2(10) := FND_API.G_MISS_CHAR

Line 66: , task_id NUMBER := FND_API.G_MISS_NUM

62: , revision VARCHAR2(3) := FND_API.G_MISS_CHAR
63: , serial_number_end VARCHAR2(30) := FND_API.G_MISS_CHAR
64: , serial_number_start VARCHAR2(30) := FND_API.G_MISS_CHAR
65: , status_date DATE := FND_API.G_MISS_DATE
66: , task_id NUMBER := FND_API.G_MISS_NUM
67: , to_account_id NUMBER := FND_API.G_MISS_NUM
68: , to_locator_id NUMBER := FND_API.G_MISS_NUM
69: , to_subinventory_code VARCHAR2(10) := FND_API.G_MISS_CHAR
70: , to_subinventory_id NUMBER := FND_API.G_MISS_NUM

Line 67: , to_account_id NUMBER := FND_API.G_MISS_NUM

63: , serial_number_end VARCHAR2(30) := FND_API.G_MISS_CHAR
64: , serial_number_start VARCHAR2(30) := FND_API.G_MISS_CHAR
65: , status_date DATE := FND_API.G_MISS_DATE
66: , task_id NUMBER := FND_API.G_MISS_NUM
67: , to_account_id NUMBER := FND_API.G_MISS_NUM
68: , to_locator_id NUMBER := FND_API.G_MISS_NUM
69: , to_subinventory_code VARCHAR2(10) := FND_API.G_MISS_CHAR
70: , to_subinventory_id NUMBER := FND_API.G_MISS_NUM
71: , transaction_header_id NUMBER := FND_API.G_MISS_NUM

Line 68: , to_locator_id NUMBER := FND_API.G_MISS_NUM

64: , serial_number_start VARCHAR2(30) := FND_API.G_MISS_CHAR
65: , status_date DATE := FND_API.G_MISS_DATE
66: , task_id NUMBER := FND_API.G_MISS_NUM
67: , to_account_id NUMBER := FND_API.G_MISS_NUM
68: , to_locator_id NUMBER := FND_API.G_MISS_NUM
69: , to_subinventory_code VARCHAR2(10) := FND_API.G_MISS_CHAR
70: , to_subinventory_id NUMBER := FND_API.G_MISS_NUM
71: , transaction_header_id NUMBER := FND_API.G_MISS_NUM
72: , transaction_type_id NUMBER := FND_API.G_MISS_NUM

Line 69: , to_subinventory_code VARCHAR2(10) := FND_API.G_MISS_CHAR

65: , status_date DATE := FND_API.G_MISS_DATE
66: , task_id NUMBER := FND_API.G_MISS_NUM
67: , to_account_id NUMBER := FND_API.G_MISS_NUM
68: , to_locator_id NUMBER := FND_API.G_MISS_NUM
69: , to_subinventory_code VARCHAR2(10) := FND_API.G_MISS_CHAR
70: , to_subinventory_id NUMBER := FND_API.G_MISS_NUM
71: , transaction_header_id NUMBER := FND_API.G_MISS_NUM
72: , transaction_type_id NUMBER := FND_API.G_MISS_NUM
73: , txn_source_id NUMBER := FND_API.G_MISS_NUM

Line 70: , to_subinventory_id NUMBER := FND_API.G_MISS_NUM

66: , task_id NUMBER := FND_API.G_MISS_NUM
67: , to_account_id NUMBER := FND_API.G_MISS_NUM
68: , to_locator_id NUMBER := FND_API.G_MISS_NUM
69: , to_subinventory_code VARCHAR2(10) := FND_API.G_MISS_CHAR
70: , to_subinventory_id NUMBER := FND_API.G_MISS_NUM
71: , transaction_header_id NUMBER := FND_API.G_MISS_NUM
72: , transaction_type_id NUMBER := FND_API.G_MISS_NUM
73: , txn_source_id NUMBER := FND_API.G_MISS_NUM
74: , txn_source_line_id NUMBER := FND_API.G_MISS_NUM

Line 71: , transaction_header_id NUMBER := FND_API.G_MISS_NUM

67: , to_account_id NUMBER := FND_API.G_MISS_NUM
68: , to_locator_id NUMBER := FND_API.G_MISS_NUM
69: , to_subinventory_code VARCHAR2(10) := FND_API.G_MISS_CHAR
70: , to_subinventory_id NUMBER := FND_API.G_MISS_NUM
71: , transaction_header_id NUMBER := FND_API.G_MISS_NUM
72: , transaction_type_id NUMBER := FND_API.G_MISS_NUM
73: , txn_source_id NUMBER := FND_API.G_MISS_NUM
74: , txn_source_line_id NUMBER := FND_API.G_MISS_NUM
75: , txn_source_line_detail_id NUMBER := FND_API.G_MISS_NUM

Line 72: , transaction_type_id NUMBER := FND_API.G_MISS_NUM

68: , to_locator_id NUMBER := FND_API.G_MISS_NUM
69: , to_subinventory_code VARCHAR2(10) := FND_API.G_MISS_CHAR
70: , to_subinventory_id NUMBER := FND_API.G_MISS_NUM
71: , transaction_header_id NUMBER := FND_API.G_MISS_NUM
72: , transaction_type_id NUMBER := FND_API.G_MISS_NUM
73: , txn_source_id NUMBER := FND_API.G_MISS_NUM
74: , txn_source_line_id NUMBER := FND_API.G_MISS_NUM
75: , txn_source_line_detail_id NUMBER := FND_API.G_MISS_NUM
76: , transaction_source_type_id NUMBER := FND_API.G_MISS_NUM

Line 73: , txn_source_id NUMBER := FND_API.G_MISS_NUM

69: , to_subinventory_code VARCHAR2(10) := FND_API.G_MISS_CHAR
70: , to_subinventory_id NUMBER := FND_API.G_MISS_NUM
71: , transaction_header_id NUMBER := FND_API.G_MISS_NUM
72: , transaction_type_id NUMBER := FND_API.G_MISS_NUM
73: , txn_source_id NUMBER := FND_API.G_MISS_NUM
74: , txn_source_line_id NUMBER := FND_API.G_MISS_NUM
75: , txn_source_line_detail_id NUMBER := FND_API.G_MISS_NUM
76: , transaction_source_type_id NUMBER := FND_API.G_MISS_NUM
77: , primary_quantity NUMBER := FND_API.G_MISS_NUM

Line 74: , txn_source_line_id NUMBER := FND_API.G_MISS_NUM

70: , to_subinventory_id NUMBER := FND_API.G_MISS_NUM
71: , transaction_header_id NUMBER := FND_API.G_MISS_NUM
72: , transaction_type_id NUMBER := FND_API.G_MISS_NUM
73: , txn_source_id NUMBER := FND_API.G_MISS_NUM
74: , txn_source_line_id NUMBER := FND_API.G_MISS_NUM
75: , txn_source_line_detail_id NUMBER := FND_API.G_MISS_NUM
76: , transaction_source_type_id NUMBER := FND_API.G_MISS_NUM
77: , primary_quantity NUMBER := FND_API.G_MISS_NUM
78: , to_organization_id NUMBER := FND_API.G_MISS_NUM

Line 75: , txn_source_line_detail_id NUMBER := FND_API.G_MISS_NUM

71: , transaction_header_id NUMBER := FND_API.G_MISS_NUM
72: , transaction_type_id NUMBER := FND_API.G_MISS_NUM
73: , txn_source_id NUMBER := FND_API.G_MISS_NUM
74: , txn_source_line_id NUMBER := FND_API.G_MISS_NUM
75: , txn_source_line_detail_id NUMBER := FND_API.G_MISS_NUM
76: , transaction_source_type_id NUMBER := FND_API.G_MISS_NUM
77: , primary_quantity NUMBER := FND_API.G_MISS_NUM
78: , to_organization_id NUMBER := FND_API.G_MISS_NUM
79: , pick_strategy_id NUMBER := FND_API.G_MISS_NUM

Line 76: , transaction_source_type_id NUMBER := FND_API.G_MISS_NUM

72: , transaction_type_id NUMBER := FND_API.G_MISS_NUM
73: , txn_source_id NUMBER := FND_API.G_MISS_NUM
74: , txn_source_line_id NUMBER := FND_API.G_MISS_NUM
75: , txn_source_line_detail_id NUMBER := FND_API.G_MISS_NUM
76: , transaction_source_type_id NUMBER := FND_API.G_MISS_NUM
77: , primary_quantity NUMBER := FND_API.G_MISS_NUM
78: , to_organization_id NUMBER := FND_API.G_MISS_NUM
79: , pick_strategy_id NUMBER := FND_API.G_MISS_NUM
80: , put_away_strategy_id NUMBER := FND_API.G_MISS_NUM

Line 77: , primary_quantity NUMBER := FND_API.G_MISS_NUM

73: , txn_source_id NUMBER := FND_API.G_MISS_NUM
74: , txn_source_line_id NUMBER := FND_API.G_MISS_NUM
75: , txn_source_line_detail_id NUMBER := FND_API.G_MISS_NUM
76: , transaction_source_type_id NUMBER := FND_API.G_MISS_NUM
77: , primary_quantity NUMBER := FND_API.G_MISS_NUM
78: , to_organization_id NUMBER := FND_API.G_MISS_NUM
79: , pick_strategy_id NUMBER := FND_API.G_MISS_NUM
80: , put_away_strategy_id NUMBER := FND_API.G_MISS_NUM
81: , uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR

Line 78: , to_organization_id NUMBER := FND_API.G_MISS_NUM

74: , txn_source_line_id NUMBER := FND_API.G_MISS_NUM
75: , txn_source_line_detail_id NUMBER := FND_API.G_MISS_NUM
76: , transaction_source_type_id NUMBER := FND_API.G_MISS_NUM
77: , primary_quantity NUMBER := FND_API.G_MISS_NUM
78: , to_organization_id NUMBER := FND_API.G_MISS_NUM
79: , pick_strategy_id NUMBER := FND_API.G_MISS_NUM
80: , put_away_strategy_id NUMBER := FND_API.G_MISS_NUM
81: , uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
82: , unit_number VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 79: , pick_strategy_id NUMBER := FND_API.G_MISS_NUM

75: , txn_source_line_detail_id NUMBER := FND_API.G_MISS_NUM
76: , transaction_source_type_id NUMBER := FND_API.G_MISS_NUM
77: , primary_quantity NUMBER := FND_API.G_MISS_NUM
78: , to_organization_id NUMBER := FND_API.G_MISS_NUM
79: , pick_strategy_id NUMBER := FND_API.G_MISS_NUM
80: , put_away_strategy_id NUMBER := FND_API.G_MISS_NUM
81: , uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
82: , unit_number VARCHAR2(30) := FND_API.G_MISS_CHAR
83: , ship_to_location_id NUMBER := FND_API.G_MISS_NUM

Line 80: , put_away_strategy_id NUMBER := FND_API.G_MISS_NUM

76: , transaction_source_type_id NUMBER := FND_API.G_MISS_NUM
77: , primary_quantity NUMBER := FND_API.G_MISS_NUM
78: , to_organization_id NUMBER := FND_API.G_MISS_NUM
79: , pick_strategy_id NUMBER := FND_API.G_MISS_NUM
80: , put_away_strategy_id NUMBER := FND_API.G_MISS_NUM
81: , uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
82: , unit_number VARCHAR2(30) := FND_API.G_MISS_CHAR
83: , ship_to_location_id NUMBER := FND_API.G_MISS_NUM
84: , from_cost_group_id NUMBER := FND_API.G_MISS_NUM

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

77: , primary_quantity NUMBER := FND_API.G_MISS_NUM
78: , to_organization_id NUMBER := FND_API.G_MISS_NUM
79: , pick_strategy_id NUMBER := FND_API.G_MISS_NUM
80: , put_away_strategy_id NUMBER := FND_API.G_MISS_NUM
81: , uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
82: , unit_number VARCHAR2(30) := FND_API.G_MISS_CHAR
83: , ship_to_location_id NUMBER := FND_API.G_MISS_NUM
84: , from_cost_group_id NUMBER := FND_API.G_MISS_NUM
85: , to_cost_group_id NUMBER := FND_API.G_MISS_NUM

Line 82: , unit_number VARCHAR2(30) := FND_API.G_MISS_CHAR

78: , to_organization_id NUMBER := FND_API.G_MISS_NUM
79: , pick_strategy_id NUMBER := FND_API.G_MISS_NUM
80: , put_away_strategy_id NUMBER := FND_API.G_MISS_NUM
81: , uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
82: , unit_number VARCHAR2(30) := FND_API.G_MISS_CHAR
83: , ship_to_location_id NUMBER := FND_API.G_MISS_NUM
84: , from_cost_group_id NUMBER := FND_API.G_MISS_NUM
85: , to_cost_group_id NUMBER := FND_API.G_MISS_NUM
86: , lpn_id NUMBER := FND_API.G_MISS_NUM

Line 83: , ship_to_location_id NUMBER := FND_API.G_MISS_NUM

79: , pick_strategy_id NUMBER := FND_API.G_MISS_NUM
80: , put_away_strategy_id NUMBER := FND_API.G_MISS_NUM
81: , uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
82: , unit_number VARCHAR2(30) := FND_API.G_MISS_CHAR
83: , ship_to_location_id NUMBER := FND_API.G_MISS_NUM
84: , from_cost_group_id NUMBER := FND_API.G_MISS_NUM
85: , to_cost_group_id NUMBER := FND_API.G_MISS_NUM
86: , lpn_id NUMBER := FND_API.G_MISS_NUM
87: , to_lpn_id NUMBER := FND_API.G_MISS_NUM

Line 84: , from_cost_group_id NUMBER := FND_API.G_MISS_NUM

80: , put_away_strategy_id NUMBER := FND_API.G_MISS_NUM
81: , uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
82: , unit_number VARCHAR2(30) := FND_API.G_MISS_CHAR
83: , ship_to_location_id NUMBER := FND_API.G_MISS_NUM
84: , from_cost_group_id NUMBER := FND_API.G_MISS_NUM
85: , to_cost_group_id NUMBER := FND_API.G_MISS_NUM
86: , lpn_id NUMBER := FND_API.G_MISS_NUM
87: , to_lpn_id NUMBER := FND_API.G_MISS_NUM
88: , pick_methodology_id NUMBER := FND_API.G_MISS_NUM

Line 85: , to_cost_group_id NUMBER := FND_API.G_MISS_NUM

81: , uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
82: , unit_number VARCHAR2(30) := FND_API.G_MISS_CHAR
83: , ship_to_location_id NUMBER := FND_API.G_MISS_NUM
84: , from_cost_group_id NUMBER := FND_API.G_MISS_NUM
85: , to_cost_group_id NUMBER := FND_API.G_MISS_NUM
86: , lpn_id NUMBER := FND_API.G_MISS_NUM
87: , to_lpn_id NUMBER := FND_API.G_MISS_NUM
88: , pick_methodology_id NUMBER := FND_API.G_MISS_NUM
89: , container_item_id NUMBER := FND_API.G_MISS_NUM

Line 86: , lpn_id NUMBER := FND_API.G_MISS_NUM

82: , unit_number VARCHAR2(30) := FND_API.G_MISS_CHAR
83: , ship_to_location_id NUMBER := FND_API.G_MISS_NUM
84: , from_cost_group_id NUMBER := FND_API.G_MISS_NUM
85: , to_cost_group_id NUMBER := FND_API.G_MISS_NUM
86: , lpn_id NUMBER := FND_API.G_MISS_NUM
87: , to_lpn_id NUMBER := FND_API.G_MISS_NUM
88: , pick_methodology_id NUMBER := FND_API.G_MISS_NUM
89: , container_item_id NUMBER := FND_API.G_MISS_NUM
90: , carton_grouping_id NUMBER := FND_API.G_MISS_NUM

Line 87: , to_lpn_id NUMBER := FND_API.G_MISS_NUM

83: , ship_to_location_id NUMBER := FND_API.G_MISS_NUM
84: , from_cost_group_id NUMBER := FND_API.G_MISS_NUM
85: , to_cost_group_id NUMBER := FND_API.G_MISS_NUM
86: , lpn_id NUMBER := FND_API.G_MISS_NUM
87: , to_lpn_id NUMBER := FND_API.G_MISS_NUM
88: , pick_methodology_id NUMBER := FND_API.G_MISS_NUM
89: , container_item_id NUMBER := FND_API.G_MISS_NUM
90: , carton_grouping_id NUMBER := FND_API.G_MISS_NUM
91: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 88: , pick_methodology_id NUMBER := FND_API.G_MISS_NUM

84: , from_cost_group_id NUMBER := FND_API.G_MISS_NUM
85: , to_cost_group_id NUMBER := FND_API.G_MISS_NUM
86: , lpn_id NUMBER := FND_API.G_MISS_NUM
87: , to_lpn_id NUMBER := FND_API.G_MISS_NUM
88: , pick_methodology_id NUMBER := FND_API.G_MISS_NUM
89: , container_item_id NUMBER := FND_API.G_MISS_NUM
90: , carton_grouping_id NUMBER := FND_API.G_MISS_NUM
91: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
92: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 89: , container_item_id NUMBER := FND_API.G_MISS_NUM

85: , to_cost_group_id NUMBER := FND_API.G_MISS_NUM
86: , lpn_id NUMBER := FND_API.G_MISS_NUM
87: , to_lpn_id NUMBER := FND_API.G_MISS_NUM
88: , pick_methodology_id NUMBER := FND_API.G_MISS_NUM
89: , container_item_id NUMBER := FND_API.G_MISS_NUM
90: , carton_grouping_id NUMBER := FND_API.G_MISS_NUM
91: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
92: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
93: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 90: , carton_grouping_id NUMBER := FND_API.G_MISS_NUM

86: , lpn_id NUMBER := FND_API.G_MISS_NUM
87: , to_lpn_id NUMBER := FND_API.G_MISS_NUM
88: , pick_methodology_id NUMBER := FND_API.G_MISS_NUM
89: , container_item_id NUMBER := FND_API.G_MISS_NUM
90: , carton_grouping_id NUMBER := FND_API.G_MISS_NUM
91: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
92: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
93: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
94: , inspection_status NUMBER :=NULL

Line 91: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR

87: , to_lpn_id NUMBER := FND_API.G_MISS_NUM
88: , pick_methodology_id NUMBER := FND_API.G_MISS_NUM
89: , container_item_id NUMBER := FND_API.G_MISS_NUM
90: , carton_grouping_id NUMBER := FND_API.G_MISS_NUM
91: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
92: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
93: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
94: , inspection_status NUMBER :=NULL
95: , wms_process_flag NUMBER :=NULL

Line 92: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

88: , pick_methodology_id NUMBER := FND_API.G_MISS_NUM
89: , container_item_id NUMBER := FND_API.G_MISS_NUM
90: , carton_grouping_id NUMBER := FND_API.G_MISS_NUM
91: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
92: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
93: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
94: , inspection_status NUMBER :=NULL
95: , wms_process_flag NUMBER :=NULL
96: , pick_slip_number NUMBER :=NULL

Line 93: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR

89: , container_item_id NUMBER := FND_API.G_MISS_NUM
90: , carton_grouping_id NUMBER := FND_API.G_MISS_NUM
91: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
92: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
93: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
94: , inspection_status NUMBER :=NULL
95: , wms_process_flag NUMBER :=NULL
96: , pick_slip_number NUMBER :=NULL
97: , pick_slip_date DATE :=NULL

Line 102: , error_message VARCHAR2(2000) := FND_API.G_MISS_CHAR);

98: , ship_set_id NUMBER :=NULL
99: , ship_model_id NUMBER :=NULL
100: , model_quantity NUMBER :=NULL
101: , required_quantity NUMBER :=NULL
102: , error_message VARCHAR2(2000) := FND_API.G_MISS_CHAR);
103:
104: TYPE Trolin_ErrTbl_Type IS TABLE OF Trolin_ErrRec_Type
105: INDEX BY BINARY_INTEGER;
106:

Line 116: , p_auto_detail_flag IN VARCHAR2 DEFAULT FND_API.G_TRUE

112: --
113: PROCEDURE release_pick_batch
114: ( p_mo_header_rec IN INV_Move_Order_PUB.Trohdr_Rec_Type
115: , p_mo_line_rec_tbl IN INV_Move_Order_PUB.Trolin_Tbl_Type
116: , p_auto_detail_flag IN VARCHAR2 DEFAULT FND_API.G_TRUE
117: , p_auto_pick_confirm_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE
118: , p_allow_partial_pick IN VARCHAR2 DEFAULT FND_API.G_TRUE
119: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
120: , p_init_msg_lst IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 117: , p_auto_pick_confirm_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE

113: PROCEDURE release_pick_batch
114: ( p_mo_header_rec IN INV_Move_Order_PUB.Trohdr_Rec_Type
115: , p_mo_line_rec_tbl IN INV_Move_Order_PUB.Trolin_Tbl_Type
116: , p_auto_detail_flag IN VARCHAR2 DEFAULT FND_API.G_TRUE
117: , p_auto_pick_confirm_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE
118: , p_allow_partial_pick IN VARCHAR2 DEFAULT FND_API.G_TRUE
119: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
120: , p_init_msg_lst IN VARCHAR2 DEFAULT FND_API.G_FALSE
121: , x_return_status OUT NOCOPY VARCHAR2

Line 118: , p_allow_partial_pick IN VARCHAR2 DEFAULT FND_API.G_TRUE

114: ( p_mo_header_rec IN INV_Move_Order_PUB.Trohdr_Rec_Type
115: , p_mo_line_rec_tbl IN INV_Move_Order_PUB.Trolin_Tbl_Type
116: , p_auto_detail_flag IN VARCHAR2 DEFAULT FND_API.G_TRUE
117: , p_auto_pick_confirm_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE
118: , p_allow_partial_pick IN VARCHAR2 DEFAULT FND_API.G_TRUE
119: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
120: , p_init_msg_lst IN VARCHAR2 DEFAULT FND_API.G_FALSE
121: , x_return_status OUT NOCOPY VARCHAR2
122: , x_msg_count OUT NOCOPY NUMBER

Line 119: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

115: , p_mo_line_rec_tbl IN INV_Move_Order_PUB.Trolin_Tbl_Type
116: , p_auto_detail_flag IN VARCHAR2 DEFAULT FND_API.G_TRUE
117: , p_auto_pick_confirm_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE
118: , p_allow_partial_pick IN VARCHAR2 DEFAULT FND_API.G_TRUE
119: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
120: , p_init_msg_lst IN VARCHAR2 DEFAULT FND_API.G_FALSE
121: , x_return_status OUT NOCOPY VARCHAR2
122: , x_msg_count OUT NOCOPY NUMBER
123: , x_msg_data OUT NOCOPY VARCHAR2

Line 120: , p_init_msg_lst IN VARCHAR2 DEFAULT FND_API.G_FALSE

116: , p_auto_detail_flag IN VARCHAR2 DEFAULT FND_API.G_TRUE
117: , p_auto_pick_confirm_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE
118: , p_allow_partial_pick IN VARCHAR2 DEFAULT FND_API.G_TRUE
119: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
120: , p_init_msg_lst IN VARCHAR2 DEFAULT FND_API.G_FALSE
121: , x_return_status OUT NOCOPY VARCHAR2
122: , x_msg_count OUT NOCOPY NUMBER
123: , x_msg_data OUT NOCOPY VARCHAR2
124: );

Line 132: , p_auto_detail_flag IN VARCHAR2 DEFAULT fnd_api.g_true

128: --
129: PROCEDURE release_pick_batch
130: ( p_mo_header_rec IN OUT NOCOPY inv_move_order_pub.trohdr_rec_type
131: , p_mo_line_rec_tbl IN inv_move_order_pub.trolin_tbl_type
132: , p_auto_detail_flag IN VARCHAR2 DEFAULT fnd_api.g_true
133: , p_auto_pick_confirm_flag IN VARCHAR2 DEFAULT NULL
134: , p_allow_partial_pick IN VARCHAR2 DEFAULT fnd_api.g_true
135: , p_print_pick_slip IN VARCHAR2 DEFAULT fnd_api.g_false
136: , p_plan_tasks IN BOOLEAN DEFAULT FALSE

Line 134: , p_allow_partial_pick IN VARCHAR2 DEFAULT fnd_api.g_true

130: ( p_mo_header_rec IN OUT NOCOPY inv_move_order_pub.trohdr_rec_type
131: , p_mo_line_rec_tbl IN inv_move_order_pub.trolin_tbl_type
132: , p_auto_detail_flag IN VARCHAR2 DEFAULT fnd_api.g_true
133: , p_auto_pick_confirm_flag IN VARCHAR2 DEFAULT NULL
134: , p_allow_partial_pick IN VARCHAR2 DEFAULT fnd_api.g_true
135: , p_print_pick_slip IN VARCHAR2 DEFAULT fnd_api.g_false
136: , p_plan_tasks IN BOOLEAN DEFAULT FALSE
137: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
138: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

Line 135: , p_print_pick_slip IN VARCHAR2 DEFAULT fnd_api.g_false

131: , p_mo_line_rec_tbl IN inv_move_order_pub.trolin_tbl_type
132: , p_auto_detail_flag IN VARCHAR2 DEFAULT fnd_api.g_true
133: , p_auto_pick_confirm_flag IN VARCHAR2 DEFAULT NULL
134: , p_allow_partial_pick IN VARCHAR2 DEFAULT fnd_api.g_true
135: , p_print_pick_slip IN VARCHAR2 DEFAULT fnd_api.g_false
136: , p_plan_tasks IN BOOLEAN DEFAULT FALSE
137: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
138: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
139: , x_return_status OUT NOCOPY VARCHAR2

Line 137: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false

133: , p_auto_pick_confirm_flag IN VARCHAR2 DEFAULT NULL
134: , p_allow_partial_pick IN VARCHAR2 DEFAULT fnd_api.g_true
135: , p_print_pick_slip IN VARCHAR2 DEFAULT fnd_api.g_false
136: , p_plan_tasks IN BOOLEAN DEFAULT FALSE
137: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
138: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
139: , x_return_status OUT NOCOPY VARCHAR2
140: , x_msg_count OUT NOCOPY NUMBER
141: , x_msg_data OUT NOCOPY VARCHAR2

Line 138: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

134: , p_allow_partial_pick IN VARCHAR2 DEFAULT fnd_api.g_true
135: , p_print_pick_slip IN VARCHAR2 DEFAULT fnd_api.g_false
136: , p_plan_tasks IN BOOLEAN DEFAULT FALSE
137: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
138: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
139: , x_return_status OUT NOCOPY VARCHAR2
140: , x_msg_count OUT NOCOPY NUMBER
141: , x_msg_data OUT NOCOPY VARCHAR2
142: , x_conc_req_id OUT NOCOPY NUMBER

Line 150: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false

146: PROCEDURE pick_release(
147: x_return_status OUT NOCOPY VARCHAR2
148: , x_msg_count OUT NOCOPY NUMBER
149: , x_msg_data OUT NOCOPY VARCHAR2
150: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
151: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
152: , p_mo_line_tbl IN inv_move_order_pub.trolin_tbl_type
153: , p_allow_partial_pick IN VARCHAR2 DEFAULT fnd_api.g_true
154: , p_grouping_rule_id IN NUMBER DEFAULT NULL

Line 151: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

147: x_return_status OUT NOCOPY VARCHAR2
148: , x_msg_count OUT NOCOPY NUMBER
149: , x_msg_data OUT NOCOPY VARCHAR2
150: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
151: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
152: , p_mo_line_tbl IN inv_move_order_pub.trolin_tbl_type
153: , p_allow_partial_pick IN VARCHAR2 DEFAULT fnd_api.g_true
154: , p_grouping_rule_id IN NUMBER DEFAULT NULL
155: , p_plan_tasks IN BOOLEAN DEFAULT FALSE

Line 153: , p_allow_partial_pick IN VARCHAR2 DEFAULT fnd_api.g_true

149: , x_msg_data OUT NOCOPY VARCHAR2
150: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
151: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
152: , p_mo_line_tbl IN inv_move_order_pub.trolin_tbl_type
153: , p_allow_partial_pick IN VARCHAR2 DEFAULT fnd_api.g_true
154: , p_grouping_rule_id IN NUMBER DEFAULT NULL
155: , p_plan_tasks IN BOOLEAN DEFAULT FALSE
156: , p_call_wip_api IN BOOLEAN DEFAULT FALSE
157: );