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 13: ( attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

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

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

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

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

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

12: TYPE Trolin_ErrRec_Type IS RECORD
13: ( attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
14: , attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
15: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
16: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
17: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
18: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
19: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
20: , attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

13: ( attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
14: , attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
15: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
16: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
17: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
18: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
19: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
20: , attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
21: , attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

14: , attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
15: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
16: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
17: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
18: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
19: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
20: , attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
21: , attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
22: , attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

15: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
16: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
17: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
18: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
19: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
20: , attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
21: , attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
22: , attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
23: , attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

16: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
17: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
18: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
19: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
20: , attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
21: , attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
22: , attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
23: , attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
24: , attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

17: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
18: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
19: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
20: , attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
21: , attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
22: , attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
23: , attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
24: , attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
25: , attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

18: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
19: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
20: , attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
21: , attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
22: , attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
23: , attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
24: , attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
25: , attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
26: , attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

19: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
20: , attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
21: , attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
22: , attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
23: , attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
24: , attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
25: , attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
26: , attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
27: , attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

20: , attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
21: , attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
22: , attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
23: , attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
24: , attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
25: , attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
26: , attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
27: , attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
28: , attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR

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

21: , attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
22: , attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
23: , attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
24: , attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
25: , attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
26: , attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
27: , attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
28: , attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
29: , created_by NUMBER := FND_API.G_MISS_NUM

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

22: , attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
23: , attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
24: , attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
25: , attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
26: , attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
27: , attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
28: , attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
29: , created_by NUMBER := FND_API.G_MISS_NUM
30: , creation_date DATE := FND_API.G_MISS_DATE

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

23: , attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
24: , attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
25: , attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
26: , attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
27: , attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
28: , attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
29: , created_by NUMBER := FND_API.G_MISS_NUM
30: , creation_date DATE := FND_API.G_MISS_DATE
31: , date_required DATE := FND_API.G_MISS_DATE

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

24: , attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
25: , attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
26: , attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
27: , attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
28: , attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
29: , created_by NUMBER := FND_API.G_MISS_NUM
30: , creation_date DATE := FND_API.G_MISS_DATE
31: , date_required DATE := FND_API.G_MISS_DATE
32: , from_locator_id NUMBER := FND_API.G_MISS_NUM

Line 29: , created_by NUMBER := FND_API.G_MISS_NUM

25: , attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
26: , attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
27: , attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
28: , attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
29: , created_by NUMBER := FND_API.G_MISS_NUM
30: , creation_date DATE := FND_API.G_MISS_DATE
31: , date_required DATE := FND_API.G_MISS_DATE
32: , from_locator_id NUMBER := FND_API.G_MISS_NUM
33: , from_subinventory_code VARCHAR2(10) := FND_API.G_MISS_CHAR

Line 30: , creation_date DATE := FND_API.G_MISS_DATE

26: , attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
27: , attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
28: , attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
29: , created_by NUMBER := FND_API.G_MISS_NUM
30: , creation_date DATE := FND_API.G_MISS_DATE
31: , date_required DATE := FND_API.G_MISS_DATE
32: , from_locator_id NUMBER := FND_API.G_MISS_NUM
33: , from_subinventory_code VARCHAR2(10) := FND_API.G_MISS_CHAR
34: , from_subinventory_id NUMBER := FND_API.G_MISS_NUM

Line 31: , date_required DATE := FND_API.G_MISS_DATE

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

Line 32: , from_locator_id NUMBER := FND_API.G_MISS_NUM

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

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

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

Line 34: , from_subinventory_id NUMBER := FND_API.G_MISS_NUM

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

Line 35: , header_id NUMBER := FND_API.G_MISS_NUM

31: , date_required DATE := FND_API.G_MISS_DATE
32: , from_locator_id NUMBER := FND_API.G_MISS_NUM
33: , from_subinventory_code VARCHAR2(10) := FND_API.G_MISS_CHAR
34: , from_subinventory_id NUMBER := FND_API.G_MISS_NUM
35: , header_id NUMBER := FND_API.G_MISS_NUM
36: , inventory_item_id NUMBER := FND_API.G_MISS_NUM
37: , last_updated_by NUMBER := FND_API.G_MISS_NUM
38: , last_update_date DATE := FND_API.G_MISS_DATE
39: , last_update_login NUMBER := FND_API.G_MISS_NUM

Line 36: , inventory_item_id NUMBER := FND_API.G_MISS_NUM

32: , from_locator_id NUMBER := FND_API.G_MISS_NUM
33: , from_subinventory_code VARCHAR2(10) := FND_API.G_MISS_CHAR
34: , from_subinventory_id NUMBER := FND_API.G_MISS_NUM
35: , header_id NUMBER := FND_API.G_MISS_NUM
36: , inventory_item_id NUMBER := FND_API.G_MISS_NUM
37: , last_updated_by NUMBER := FND_API.G_MISS_NUM
38: , last_update_date DATE := FND_API.G_MISS_DATE
39: , last_update_login NUMBER := FND_API.G_MISS_NUM
40: , line_id NUMBER := FND_API.G_MISS_NUM

Line 37: , last_updated_by NUMBER := FND_API.G_MISS_NUM

33: , from_subinventory_code VARCHAR2(10) := FND_API.G_MISS_CHAR
34: , from_subinventory_id NUMBER := FND_API.G_MISS_NUM
35: , header_id NUMBER := FND_API.G_MISS_NUM
36: , inventory_item_id NUMBER := FND_API.G_MISS_NUM
37: , last_updated_by NUMBER := FND_API.G_MISS_NUM
38: , last_update_date DATE := FND_API.G_MISS_DATE
39: , last_update_login NUMBER := FND_API.G_MISS_NUM
40: , line_id NUMBER := FND_API.G_MISS_NUM
41: , line_number NUMBER := FND_API.G_MISS_NUM

Line 38: , last_update_date DATE := FND_API.G_MISS_DATE

34: , from_subinventory_id NUMBER := FND_API.G_MISS_NUM
35: , header_id NUMBER := FND_API.G_MISS_NUM
36: , inventory_item_id NUMBER := FND_API.G_MISS_NUM
37: , last_updated_by NUMBER := FND_API.G_MISS_NUM
38: , last_update_date DATE := FND_API.G_MISS_DATE
39: , last_update_login NUMBER := FND_API.G_MISS_NUM
40: , line_id NUMBER := FND_API.G_MISS_NUM
41: , line_number NUMBER := FND_API.G_MISS_NUM
42: , line_status NUMBER := FND_API.G_MISS_NUM

Line 39: , last_update_login NUMBER := FND_API.G_MISS_NUM

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

Line 40: , line_id NUMBER := FND_API.G_MISS_NUM

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

Line 41: , line_number NUMBER := FND_API.G_MISS_NUM

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

Line 42: , line_status NUMBER := FND_API.G_MISS_NUM

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

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

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

Line 45: , organization_id NUMBER := FND_API.G_MISS_NUM

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

Line 46: , program_application_id NUMBER := FND_API.G_MISS_NUM

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

Line 47: , program_id NUMBER := FND_API.G_MISS_NUM

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

Line 48: , program_update_date DATE := FND_API.G_MISS_DATE

44: , lot_number VARCHAR2(80) := FND_API.G_MISS_CHAR
45: , organization_id NUMBER := FND_API.G_MISS_NUM
46: , program_application_id NUMBER := FND_API.G_MISS_NUM
47: , program_id NUMBER := FND_API.G_MISS_NUM
48: , program_update_date DATE := FND_API.G_MISS_DATE
49: , project_id NUMBER := FND_API.G_MISS_NUM
50: , quantity NUMBER := FND_API.G_MISS_NUM
51: , quantity_delivered NUMBER := FND_API.G_MISS_NUM
52: , quantity_detailed NUMBER := FND_API.G_MISS_NUM

Line 49: , project_id NUMBER := FND_API.G_MISS_NUM

45: , organization_id NUMBER := FND_API.G_MISS_NUM
46: , program_application_id NUMBER := FND_API.G_MISS_NUM
47: , program_id NUMBER := FND_API.G_MISS_NUM
48: , program_update_date DATE := FND_API.G_MISS_DATE
49: , project_id NUMBER := FND_API.G_MISS_NUM
50: , quantity NUMBER := FND_API.G_MISS_NUM
51: , quantity_delivered NUMBER := FND_API.G_MISS_NUM
52: , quantity_detailed NUMBER := FND_API.G_MISS_NUM
53: , reason_id NUMBER := FND_API.G_MISS_NUM

Line 50: , quantity NUMBER := FND_API.G_MISS_NUM

46: , program_application_id NUMBER := FND_API.G_MISS_NUM
47: , program_id NUMBER := FND_API.G_MISS_NUM
48: , program_update_date DATE := FND_API.G_MISS_DATE
49: , project_id NUMBER := FND_API.G_MISS_NUM
50: , quantity NUMBER := FND_API.G_MISS_NUM
51: , quantity_delivered NUMBER := FND_API.G_MISS_NUM
52: , quantity_detailed NUMBER := FND_API.G_MISS_NUM
53: , reason_id NUMBER := FND_API.G_MISS_NUM
54: , reference VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 51: , quantity_delivered NUMBER := FND_API.G_MISS_NUM

47: , program_id NUMBER := FND_API.G_MISS_NUM
48: , program_update_date DATE := FND_API.G_MISS_DATE
49: , project_id NUMBER := FND_API.G_MISS_NUM
50: , quantity NUMBER := FND_API.G_MISS_NUM
51: , quantity_delivered NUMBER := FND_API.G_MISS_NUM
52: , quantity_detailed NUMBER := FND_API.G_MISS_NUM
53: , reason_id NUMBER := FND_API.G_MISS_NUM
54: , reference VARCHAR2(240) := FND_API.G_MISS_CHAR
55: , reference_id NUMBER := FND_API.G_MISS_NUM

Line 52: , quantity_detailed NUMBER := FND_API.G_MISS_NUM

48: , program_update_date DATE := FND_API.G_MISS_DATE
49: , project_id NUMBER := FND_API.G_MISS_NUM
50: , quantity NUMBER := FND_API.G_MISS_NUM
51: , quantity_delivered NUMBER := FND_API.G_MISS_NUM
52: , quantity_detailed NUMBER := FND_API.G_MISS_NUM
53: , reason_id NUMBER := FND_API.G_MISS_NUM
54: , reference VARCHAR2(240) := FND_API.G_MISS_CHAR
55: , reference_id NUMBER := FND_API.G_MISS_NUM
56: , reference_type_code NUMBER := FND_API.G_MISS_NUM

Line 53: , reason_id NUMBER := FND_API.G_MISS_NUM

49: , project_id NUMBER := FND_API.G_MISS_NUM
50: , quantity NUMBER := FND_API.G_MISS_NUM
51: , quantity_delivered NUMBER := FND_API.G_MISS_NUM
52: , quantity_detailed NUMBER := FND_API.G_MISS_NUM
53: , reason_id NUMBER := FND_API.G_MISS_NUM
54: , reference VARCHAR2(240) := FND_API.G_MISS_CHAR
55: , reference_id NUMBER := FND_API.G_MISS_NUM
56: , reference_type_code NUMBER := FND_API.G_MISS_NUM
57: , request_id NUMBER := FND_API.G_MISS_NUM

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

50: , quantity NUMBER := FND_API.G_MISS_NUM
51: , quantity_delivered NUMBER := FND_API.G_MISS_NUM
52: , quantity_detailed NUMBER := FND_API.G_MISS_NUM
53: , reason_id NUMBER := FND_API.G_MISS_NUM
54: , reference VARCHAR2(240) := FND_API.G_MISS_CHAR
55: , reference_id NUMBER := FND_API.G_MISS_NUM
56: , reference_type_code NUMBER := FND_API.G_MISS_NUM
57: , request_id NUMBER := FND_API.G_MISS_NUM
58: , revision VARCHAR2(3) := FND_API.G_MISS_CHAR

Line 55: , reference_id NUMBER := FND_API.G_MISS_NUM

51: , quantity_delivered NUMBER := FND_API.G_MISS_NUM
52: , quantity_detailed NUMBER := FND_API.G_MISS_NUM
53: , reason_id NUMBER := FND_API.G_MISS_NUM
54: , reference VARCHAR2(240) := FND_API.G_MISS_CHAR
55: , reference_id NUMBER := FND_API.G_MISS_NUM
56: , reference_type_code NUMBER := FND_API.G_MISS_NUM
57: , request_id NUMBER := FND_API.G_MISS_NUM
58: , revision VARCHAR2(3) := FND_API.G_MISS_CHAR
59: , serial_number_end VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 56: , reference_type_code NUMBER := FND_API.G_MISS_NUM

52: , quantity_detailed NUMBER := FND_API.G_MISS_NUM
53: , reason_id NUMBER := FND_API.G_MISS_NUM
54: , reference VARCHAR2(240) := FND_API.G_MISS_CHAR
55: , reference_id NUMBER := FND_API.G_MISS_NUM
56: , reference_type_code NUMBER := FND_API.G_MISS_NUM
57: , request_id NUMBER := FND_API.G_MISS_NUM
58: , revision VARCHAR2(3) := FND_API.G_MISS_CHAR
59: , serial_number_end VARCHAR2(30) := FND_API.G_MISS_CHAR
60: , serial_number_start VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 57: , request_id NUMBER := FND_API.G_MISS_NUM

53: , reason_id NUMBER := FND_API.G_MISS_NUM
54: , reference VARCHAR2(240) := FND_API.G_MISS_CHAR
55: , reference_id NUMBER := FND_API.G_MISS_NUM
56: , reference_type_code NUMBER := FND_API.G_MISS_NUM
57: , request_id NUMBER := FND_API.G_MISS_NUM
58: , revision VARCHAR2(3) := FND_API.G_MISS_CHAR
59: , serial_number_end VARCHAR2(30) := FND_API.G_MISS_CHAR
60: , serial_number_start VARCHAR2(30) := FND_API.G_MISS_CHAR
61: , status_date DATE := FND_API.G_MISS_DATE

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

54: , reference VARCHAR2(240) := FND_API.G_MISS_CHAR
55: , reference_id NUMBER := FND_API.G_MISS_NUM
56: , reference_type_code NUMBER := FND_API.G_MISS_NUM
57: , request_id NUMBER := FND_API.G_MISS_NUM
58: , revision VARCHAR2(3) := FND_API.G_MISS_CHAR
59: , serial_number_end VARCHAR2(30) := FND_API.G_MISS_CHAR
60: , serial_number_start VARCHAR2(30) := FND_API.G_MISS_CHAR
61: , status_date DATE := FND_API.G_MISS_DATE
62: , task_id NUMBER := FND_API.G_MISS_NUM

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

55: , reference_id NUMBER := FND_API.G_MISS_NUM
56: , reference_type_code NUMBER := FND_API.G_MISS_NUM
57: , request_id NUMBER := FND_API.G_MISS_NUM
58: , revision VARCHAR2(3) := FND_API.G_MISS_CHAR
59: , serial_number_end VARCHAR2(30) := FND_API.G_MISS_CHAR
60: , serial_number_start VARCHAR2(30) := FND_API.G_MISS_CHAR
61: , status_date DATE := FND_API.G_MISS_DATE
62: , task_id NUMBER := FND_API.G_MISS_NUM
63: , to_account_id NUMBER := FND_API.G_MISS_NUM

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

56: , reference_type_code NUMBER := FND_API.G_MISS_NUM
57: , request_id NUMBER := FND_API.G_MISS_NUM
58: , revision VARCHAR2(3) := FND_API.G_MISS_CHAR
59: , serial_number_end VARCHAR2(30) := FND_API.G_MISS_CHAR
60: , serial_number_start VARCHAR2(30) := FND_API.G_MISS_CHAR
61: , status_date DATE := FND_API.G_MISS_DATE
62: , task_id NUMBER := FND_API.G_MISS_NUM
63: , to_account_id NUMBER := FND_API.G_MISS_NUM
64: , to_locator_id NUMBER := FND_API.G_MISS_NUM

Line 61: , status_date DATE := FND_API.G_MISS_DATE

57: , request_id NUMBER := FND_API.G_MISS_NUM
58: , revision VARCHAR2(3) := FND_API.G_MISS_CHAR
59: , serial_number_end VARCHAR2(30) := FND_API.G_MISS_CHAR
60: , serial_number_start VARCHAR2(30) := FND_API.G_MISS_CHAR
61: , status_date DATE := FND_API.G_MISS_DATE
62: , task_id NUMBER := FND_API.G_MISS_NUM
63: , to_account_id NUMBER := FND_API.G_MISS_NUM
64: , to_locator_id NUMBER := FND_API.G_MISS_NUM
65: , to_subinventory_code VARCHAR2(10) := FND_API.G_MISS_CHAR

Line 62: , task_id NUMBER := FND_API.G_MISS_NUM

58: , revision VARCHAR2(3) := FND_API.G_MISS_CHAR
59: , serial_number_end VARCHAR2(30) := FND_API.G_MISS_CHAR
60: , serial_number_start VARCHAR2(30) := FND_API.G_MISS_CHAR
61: , status_date DATE := FND_API.G_MISS_DATE
62: , task_id NUMBER := FND_API.G_MISS_NUM
63: , to_account_id NUMBER := FND_API.G_MISS_NUM
64: , to_locator_id NUMBER := FND_API.G_MISS_NUM
65: , to_subinventory_code VARCHAR2(10) := FND_API.G_MISS_CHAR
66: , to_subinventory_id NUMBER := FND_API.G_MISS_NUM

Line 63: , to_account_id NUMBER := FND_API.G_MISS_NUM

59: , serial_number_end VARCHAR2(30) := FND_API.G_MISS_CHAR
60: , serial_number_start VARCHAR2(30) := FND_API.G_MISS_CHAR
61: , status_date DATE := FND_API.G_MISS_DATE
62: , task_id NUMBER := FND_API.G_MISS_NUM
63: , to_account_id NUMBER := FND_API.G_MISS_NUM
64: , to_locator_id NUMBER := FND_API.G_MISS_NUM
65: , to_subinventory_code VARCHAR2(10) := FND_API.G_MISS_CHAR
66: , to_subinventory_id NUMBER := FND_API.G_MISS_NUM
67: , transaction_header_id NUMBER := FND_API.G_MISS_NUM

Line 64: , to_locator_id NUMBER := FND_API.G_MISS_NUM

60: , serial_number_start VARCHAR2(30) := FND_API.G_MISS_CHAR
61: , status_date DATE := FND_API.G_MISS_DATE
62: , task_id NUMBER := FND_API.G_MISS_NUM
63: , to_account_id NUMBER := FND_API.G_MISS_NUM
64: , to_locator_id NUMBER := FND_API.G_MISS_NUM
65: , to_subinventory_code VARCHAR2(10) := FND_API.G_MISS_CHAR
66: , to_subinventory_id NUMBER := FND_API.G_MISS_NUM
67: , transaction_header_id NUMBER := FND_API.G_MISS_NUM
68: , transaction_type_id NUMBER := FND_API.G_MISS_NUM

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

61: , status_date DATE := FND_API.G_MISS_DATE
62: , task_id NUMBER := FND_API.G_MISS_NUM
63: , to_account_id NUMBER := FND_API.G_MISS_NUM
64: , to_locator_id NUMBER := FND_API.G_MISS_NUM
65: , to_subinventory_code VARCHAR2(10) := FND_API.G_MISS_CHAR
66: , to_subinventory_id NUMBER := FND_API.G_MISS_NUM
67: , transaction_header_id NUMBER := FND_API.G_MISS_NUM
68: , transaction_type_id NUMBER := FND_API.G_MISS_NUM
69: , txn_source_id NUMBER := FND_API.G_MISS_NUM

Line 66: , to_subinventory_id NUMBER := FND_API.G_MISS_NUM

62: , task_id NUMBER := FND_API.G_MISS_NUM
63: , to_account_id NUMBER := FND_API.G_MISS_NUM
64: , to_locator_id NUMBER := FND_API.G_MISS_NUM
65: , to_subinventory_code VARCHAR2(10) := FND_API.G_MISS_CHAR
66: , to_subinventory_id NUMBER := FND_API.G_MISS_NUM
67: , transaction_header_id NUMBER := FND_API.G_MISS_NUM
68: , transaction_type_id NUMBER := FND_API.G_MISS_NUM
69: , txn_source_id NUMBER := FND_API.G_MISS_NUM
70: , txn_source_line_id NUMBER := FND_API.G_MISS_NUM

Line 67: , transaction_header_id NUMBER := FND_API.G_MISS_NUM

63: , to_account_id NUMBER := FND_API.G_MISS_NUM
64: , to_locator_id NUMBER := FND_API.G_MISS_NUM
65: , to_subinventory_code VARCHAR2(10) := FND_API.G_MISS_CHAR
66: , to_subinventory_id NUMBER := FND_API.G_MISS_NUM
67: , transaction_header_id NUMBER := FND_API.G_MISS_NUM
68: , transaction_type_id NUMBER := FND_API.G_MISS_NUM
69: , txn_source_id NUMBER := FND_API.G_MISS_NUM
70: , txn_source_line_id NUMBER := FND_API.G_MISS_NUM
71: , txn_source_line_detail_id NUMBER := FND_API.G_MISS_NUM

Line 68: , transaction_type_id NUMBER := FND_API.G_MISS_NUM

64: , to_locator_id NUMBER := FND_API.G_MISS_NUM
65: , to_subinventory_code VARCHAR2(10) := FND_API.G_MISS_CHAR
66: , to_subinventory_id NUMBER := FND_API.G_MISS_NUM
67: , transaction_header_id NUMBER := FND_API.G_MISS_NUM
68: , transaction_type_id NUMBER := FND_API.G_MISS_NUM
69: , txn_source_id NUMBER := FND_API.G_MISS_NUM
70: , txn_source_line_id NUMBER := FND_API.G_MISS_NUM
71: , txn_source_line_detail_id NUMBER := FND_API.G_MISS_NUM
72: , transaction_source_type_id NUMBER := FND_API.G_MISS_NUM

Line 69: , txn_source_id NUMBER := FND_API.G_MISS_NUM

65: , to_subinventory_code VARCHAR2(10) := FND_API.G_MISS_CHAR
66: , to_subinventory_id NUMBER := FND_API.G_MISS_NUM
67: , transaction_header_id NUMBER := FND_API.G_MISS_NUM
68: , transaction_type_id NUMBER := FND_API.G_MISS_NUM
69: , txn_source_id NUMBER := FND_API.G_MISS_NUM
70: , txn_source_line_id NUMBER := FND_API.G_MISS_NUM
71: , txn_source_line_detail_id NUMBER := FND_API.G_MISS_NUM
72: , transaction_source_type_id NUMBER := FND_API.G_MISS_NUM
73: , primary_quantity NUMBER := FND_API.G_MISS_NUM

Line 70: , txn_source_line_id NUMBER := FND_API.G_MISS_NUM

66: , to_subinventory_id NUMBER := FND_API.G_MISS_NUM
67: , transaction_header_id NUMBER := FND_API.G_MISS_NUM
68: , transaction_type_id NUMBER := FND_API.G_MISS_NUM
69: , txn_source_id NUMBER := FND_API.G_MISS_NUM
70: , txn_source_line_id NUMBER := FND_API.G_MISS_NUM
71: , txn_source_line_detail_id NUMBER := FND_API.G_MISS_NUM
72: , transaction_source_type_id NUMBER := FND_API.G_MISS_NUM
73: , primary_quantity NUMBER := FND_API.G_MISS_NUM
74: , to_organization_id NUMBER := FND_API.G_MISS_NUM

Line 71: , txn_source_line_detail_id NUMBER := FND_API.G_MISS_NUM

67: , transaction_header_id NUMBER := FND_API.G_MISS_NUM
68: , transaction_type_id NUMBER := FND_API.G_MISS_NUM
69: , txn_source_id NUMBER := FND_API.G_MISS_NUM
70: , txn_source_line_id NUMBER := FND_API.G_MISS_NUM
71: , txn_source_line_detail_id NUMBER := FND_API.G_MISS_NUM
72: , transaction_source_type_id NUMBER := FND_API.G_MISS_NUM
73: , primary_quantity NUMBER := FND_API.G_MISS_NUM
74: , to_organization_id NUMBER := FND_API.G_MISS_NUM
75: , pick_strategy_id NUMBER := FND_API.G_MISS_NUM

Line 72: , transaction_source_type_id NUMBER := FND_API.G_MISS_NUM

68: , transaction_type_id NUMBER := FND_API.G_MISS_NUM
69: , txn_source_id NUMBER := FND_API.G_MISS_NUM
70: , txn_source_line_id NUMBER := FND_API.G_MISS_NUM
71: , txn_source_line_detail_id NUMBER := FND_API.G_MISS_NUM
72: , transaction_source_type_id NUMBER := FND_API.G_MISS_NUM
73: , primary_quantity NUMBER := FND_API.G_MISS_NUM
74: , to_organization_id NUMBER := FND_API.G_MISS_NUM
75: , pick_strategy_id NUMBER := FND_API.G_MISS_NUM
76: , put_away_strategy_id NUMBER := FND_API.G_MISS_NUM

Line 73: , primary_quantity NUMBER := FND_API.G_MISS_NUM

69: , txn_source_id NUMBER := FND_API.G_MISS_NUM
70: , txn_source_line_id NUMBER := FND_API.G_MISS_NUM
71: , txn_source_line_detail_id NUMBER := FND_API.G_MISS_NUM
72: , transaction_source_type_id NUMBER := FND_API.G_MISS_NUM
73: , primary_quantity NUMBER := FND_API.G_MISS_NUM
74: , to_organization_id NUMBER := FND_API.G_MISS_NUM
75: , pick_strategy_id NUMBER := FND_API.G_MISS_NUM
76: , put_away_strategy_id NUMBER := FND_API.G_MISS_NUM
77: , uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR

Line 74: , to_organization_id NUMBER := FND_API.G_MISS_NUM

70: , txn_source_line_id NUMBER := FND_API.G_MISS_NUM
71: , txn_source_line_detail_id NUMBER := FND_API.G_MISS_NUM
72: , transaction_source_type_id NUMBER := FND_API.G_MISS_NUM
73: , primary_quantity NUMBER := FND_API.G_MISS_NUM
74: , to_organization_id NUMBER := FND_API.G_MISS_NUM
75: , pick_strategy_id NUMBER := FND_API.G_MISS_NUM
76: , put_away_strategy_id NUMBER := FND_API.G_MISS_NUM
77: , uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
78: , unit_number VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 75: , pick_strategy_id NUMBER := FND_API.G_MISS_NUM

71: , txn_source_line_detail_id NUMBER := FND_API.G_MISS_NUM
72: , transaction_source_type_id NUMBER := FND_API.G_MISS_NUM
73: , primary_quantity NUMBER := FND_API.G_MISS_NUM
74: , to_organization_id NUMBER := FND_API.G_MISS_NUM
75: , pick_strategy_id NUMBER := FND_API.G_MISS_NUM
76: , put_away_strategy_id NUMBER := FND_API.G_MISS_NUM
77: , uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
78: , unit_number VARCHAR2(30) := FND_API.G_MISS_CHAR
79: , ship_to_location_id NUMBER := FND_API.G_MISS_NUM

Line 76: , put_away_strategy_id NUMBER := FND_API.G_MISS_NUM

72: , transaction_source_type_id NUMBER := FND_API.G_MISS_NUM
73: , primary_quantity NUMBER := FND_API.G_MISS_NUM
74: , to_organization_id NUMBER := FND_API.G_MISS_NUM
75: , pick_strategy_id NUMBER := FND_API.G_MISS_NUM
76: , put_away_strategy_id NUMBER := FND_API.G_MISS_NUM
77: , uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
78: , unit_number VARCHAR2(30) := FND_API.G_MISS_CHAR
79: , ship_to_location_id NUMBER := FND_API.G_MISS_NUM
80: , from_cost_group_id NUMBER := FND_API.G_MISS_NUM

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

73: , primary_quantity NUMBER := FND_API.G_MISS_NUM
74: , to_organization_id NUMBER := FND_API.G_MISS_NUM
75: , pick_strategy_id NUMBER := FND_API.G_MISS_NUM
76: , put_away_strategy_id NUMBER := FND_API.G_MISS_NUM
77: , uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
78: , unit_number VARCHAR2(30) := FND_API.G_MISS_CHAR
79: , ship_to_location_id NUMBER := FND_API.G_MISS_NUM
80: , from_cost_group_id NUMBER := FND_API.G_MISS_NUM
81: , to_cost_group_id NUMBER := FND_API.G_MISS_NUM

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

74: , to_organization_id NUMBER := FND_API.G_MISS_NUM
75: , pick_strategy_id NUMBER := FND_API.G_MISS_NUM
76: , put_away_strategy_id NUMBER := FND_API.G_MISS_NUM
77: , uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
78: , unit_number VARCHAR2(30) := FND_API.G_MISS_CHAR
79: , ship_to_location_id NUMBER := FND_API.G_MISS_NUM
80: , from_cost_group_id NUMBER := FND_API.G_MISS_NUM
81: , to_cost_group_id NUMBER := FND_API.G_MISS_NUM
82: , lpn_id NUMBER := FND_API.G_MISS_NUM

Line 79: , ship_to_location_id NUMBER := FND_API.G_MISS_NUM

75: , pick_strategy_id NUMBER := FND_API.G_MISS_NUM
76: , put_away_strategy_id NUMBER := FND_API.G_MISS_NUM
77: , uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
78: , unit_number VARCHAR2(30) := FND_API.G_MISS_CHAR
79: , ship_to_location_id NUMBER := FND_API.G_MISS_NUM
80: , from_cost_group_id NUMBER := FND_API.G_MISS_NUM
81: , to_cost_group_id NUMBER := FND_API.G_MISS_NUM
82: , lpn_id NUMBER := FND_API.G_MISS_NUM
83: , to_lpn_id NUMBER := FND_API.G_MISS_NUM

Line 80: , from_cost_group_id NUMBER := FND_API.G_MISS_NUM

76: , put_away_strategy_id NUMBER := FND_API.G_MISS_NUM
77: , uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
78: , unit_number VARCHAR2(30) := FND_API.G_MISS_CHAR
79: , ship_to_location_id NUMBER := FND_API.G_MISS_NUM
80: , from_cost_group_id NUMBER := FND_API.G_MISS_NUM
81: , to_cost_group_id NUMBER := FND_API.G_MISS_NUM
82: , lpn_id NUMBER := FND_API.G_MISS_NUM
83: , to_lpn_id NUMBER := FND_API.G_MISS_NUM
84: , pick_methodology_id NUMBER := FND_API.G_MISS_NUM

Line 81: , to_cost_group_id NUMBER := FND_API.G_MISS_NUM

77: , uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
78: , unit_number VARCHAR2(30) := FND_API.G_MISS_CHAR
79: , ship_to_location_id NUMBER := FND_API.G_MISS_NUM
80: , from_cost_group_id NUMBER := FND_API.G_MISS_NUM
81: , to_cost_group_id NUMBER := FND_API.G_MISS_NUM
82: , lpn_id NUMBER := FND_API.G_MISS_NUM
83: , to_lpn_id NUMBER := FND_API.G_MISS_NUM
84: , pick_methodology_id NUMBER := FND_API.G_MISS_NUM
85: , container_item_id NUMBER := FND_API.G_MISS_NUM

Line 82: , lpn_id NUMBER := FND_API.G_MISS_NUM

78: , unit_number VARCHAR2(30) := FND_API.G_MISS_CHAR
79: , ship_to_location_id NUMBER := FND_API.G_MISS_NUM
80: , from_cost_group_id NUMBER := FND_API.G_MISS_NUM
81: , to_cost_group_id NUMBER := FND_API.G_MISS_NUM
82: , lpn_id NUMBER := FND_API.G_MISS_NUM
83: , to_lpn_id NUMBER := FND_API.G_MISS_NUM
84: , pick_methodology_id NUMBER := FND_API.G_MISS_NUM
85: , container_item_id NUMBER := FND_API.G_MISS_NUM
86: , carton_grouping_id NUMBER := FND_API.G_MISS_NUM

Line 83: , to_lpn_id NUMBER := FND_API.G_MISS_NUM

79: , ship_to_location_id NUMBER := FND_API.G_MISS_NUM
80: , from_cost_group_id NUMBER := FND_API.G_MISS_NUM
81: , to_cost_group_id NUMBER := FND_API.G_MISS_NUM
82: , lpn_id NUMBER := FND_API.G_MISS_NUM
83: , to_lpn_id NUMBER := FND_API.G_MISS_NUM
84: , pick_methodology_id NUMBER := FND_API.G_MISS_NUM
85: , container_item_id NUMBER := FND_API.G_MISS_NUM
86: , carton_grouping_id NUMBER := FND_API.G_MISS_NUM
87: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 84: , pick_methodology_id NUMBER := FND_API.G_MISS_NUM

80: , from_cost_group_id NUMBER := FND_API.G_MISS_NUM
81: , to_cost_group_id NUMBER := FND_API.G_MISS_NUM
82: , lpn_id NUMBER := FND_API.G_MISS_NUM
83: , to_lpn_id NUMBER := FND_API.G_MISS_NUM
84: , pick_methodology_id NUMBER := FND_API.G_MISS_NUM
85: , container_item_id NUMBER := FND_API.G_MISS_NUM
86: , carton_grouping_id NUMBER := FND_API.G_MISS_NUM
87: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
88: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 85: , container_item_id NUMBER := FND_API.G_MISS_NUM

81: , to_cost_group_id NUMBER := FND_API.G_MISS_NUM
82: , lpn_id NUMBER := FND_API.G_MISS_NUM
83: , to_lpn_id NUMBER := FND_API.G_MISS_NUM
84: , pick_methodology_id NUMBER := FND_API.G_MISS_NUM
85: , container_item_id NUMBER := FND_API.G_MISS_NUM
86: , carton_grouping_id NUMBER := FND_API.G_MISS_NUM
87: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
88: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
89: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 86: , carton_grouping_id NUMBER := FND_API.G_MISS_NUM

82: , lpn_id NUMBER := FND_API.G_MISS_NUM
83: , to_lpn_id NUMBER := FND_API.G_MISS_NUM
84: , pick_methodology_id NUMBER := FND_API.G_MISS_NUM
85: , container_item_id NUMBER := FND_API.G_MISS_NUM
86: , carton_grouping_id NUMBER := FND_API.G_MISS_NUM
87: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
88: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
89: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
90: , inspection_status NUMBER :=NULL

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

83: , to_lpn_id NUMBER := FND_API.G_MISS_NUM
84: , pick_methodology_id NUMBER := FND_API.G_MISS_NUM
85: , container_item_id NUMBER := FND_API.G_MISS_NUM
86: , carton_grouping_id NUMBER := FND_API.G_MISS_NUM
87: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
88: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
89: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
90: , inspection_status NUMBER :=NULL
91: , wms_process_flag NUMBER :=NULL

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

84: , pick_methodology_id NUMBER := FND_API.G_MISS_NUM
85: , container_item_id NUMBER := FND_API.G_MISS_NUM
86: , carton_grouping_id NUMBER := FND_API.G_MISS_NUM
87: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
88: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
89: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
90: , inspection_status NUMBER :=NULL
91: , wms_process_flag NUMBER :=NULL
92: , pick_slip_number NUMBER :=NULL

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

85: , container_item_id NUMBER := FND_API.G_MISS_NUM
86: , carton_grouping_id NUMBER := FND_API.G_MISS_NUM
87: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
88: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
89: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
90: , inspection_status NUMBER :=NULL
91: , wms_process_flag NUMBER :=NULL
92: , pick_slip_number NUMBER :=NULL
93: , pick_slip_date DATE :=NULL

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

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

Line 112: , p_auto_detail_flag IN VARCHAR2 DEFAULT FND_API.G_TRUE

108: --
109: PROCEDURE release_pick_batch
110: ( p_mo_header_rec IN INV_Move_Order_PUB.Trohdr_Rec_Type
111: , p_mo_line_rec_tbl IN INV_Move_Order_PUB.Trolin_Tbl_Type
112: , p_auto_detail_flag IN VARCHAR2 DEFAULT FND_API.G_TRUE
113: , p_auto_pick_confirm_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE
114: , p_allow_partial_pick IN VARCHAR2 DEFAULT FND_API.G_TRUE
115: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
116: , p_init_msg_lst IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 113: , p_auto_pick_confirm_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE

109: PROCEDURE release_pick_batch
110: ( p_mo_header_rec IN INV_Move_Order_PUB.Trohdr_Rec_Type
111: , p_mo_line_rec_tbl IN INV_Move_Order_PUB.Trolin_Tbl_Type
112: , p_auto_detail_flag IN VARCHAR2 DEFAULT FND_API.G_TRUE
113: , p_auto_pick_confirm_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE
114: , p_allow_partial_pick IN VARCHAR2 DEFAULT FND_API.G_TRUE
115: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
116: , p_init_msg_lst IN VARCHAR2 DEFAULT FND_API.G_FALSE
117: , x_return_status OUT NOCOPY VARCHAR2

Line 114: , p_allow_partial_pick IN VARCHAR2 DEFAULT FND_API.G_TRUE

110: ( p_mo_header_rec IN INV_Move_Order_PUB.Trohdr_Rec_Type
111: , p_mo_line_rec_tbl IN INV_Move_Order_PUB.Trolin_Tbl_Type
112: , p_auto_detail_flag IN VARCHAR2 DEFAULT FND_API.G_TRUE
113: , p_auto_pick_confirm_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE
114: , p_allow_partial_pick IN VARCHAR2 DEFAULT FND_API.G_TRUE
115: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
116: , p_init_msg_lst IN VARCHAR2 DEFAULT FND_API.G_FALSE
117: , x_return_status OUT NOCOPY VARCHAR2
118: , x_msg_count OUT NOCOPY NUMBER

Line 115: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

111: , p_mo_line_rec_tbl IN INV_Move_Order_PUB.Trolin_Tbl_Type
112: , p_auto_detail_flag IN VARCHAR2 DEFAULT FND_API.G_TRUE
113: , p_auto_pick_confirm_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE
114: , p_allow_partial_pick IN VARCHAR2 DEFAULT FND_API.G_TRUE
115: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
116: , p_init_msg_lst IN VARCHAR2 DEFAULT FND_API.G_FALSE
117: , x_return_status OUT NOCOPY VARCHAR2
118: , x_msg_count OUT NOCOPY NUMBER
119: , x_msg_data OUT NOCOPY VARCHAR2

Line 116: , p_init_msg_lst IN VARCHAR2 DEFAULT FND_API.G_FALSE

112: , p_auto_detail_flag IN VARCHAR2 DEFAULT FND_API.G_TRUE
113: , p_auto_pick_confirm_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE
114: , p_allow_partial_pick IN VARCHAR2 DEFAULT FND_API.G_TRUE
115: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
116: , p_init_msg_lst IN VARCHAR2 DEFAULT FND_API.G_FALSE
117: , x_return_status OUT NOCOPY VARCHAR2
118: , x_msg_count OUT NOCOPY NUMBER
119: , x_msg_data OUT NOCOPY VARCHAR2
120: );

Line 128: , p_auto_detail_flag IN VARCHAR2 DEFAULT fnd_api.g_true

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

Line 130: , p_allow_partial_pick IN VARCHAR2 DEFAULT fnd_api.g_true

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

Line 131: , p_print_pick_slip IN VARCHAR2 DEFAULT fnd_api.g_false

127: , p_mo_line_rec_tbl IN inv_move_order_pub.trolin_tbl_type
128: , p_auto_detail_flag IN VARCHAR2 DEFAULT fnd_api.g_true
129: , p_auto_pick_confirm_flag IN VARCHAR2 DEFAULT NULL
130: , p_allow_partial_pick IN VARCHAR2 DEFAULT fnd_api.g_true
131: , p_print_pick_slip IN VARCHAR2 DEFAULT fnd_api.g_false
132: , p_plan_tasks IN BOOLEAN DEFAULT FALSE
133: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
134: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
135: , x_return_status OUT NOCOPY VARCHAR2

Line 133: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false

129: , p_auto_pick_confirm_flag IN VARCHAR2 DEFAULT NULL
130: , p_allow_partial_pick IN VARCHAR2 DEFAULT fnd_api.g_true
131: , p_print_pick_slip IN VARCHAR2 DEFAULT fnd_api.g_false
132: , p_plan_tasks IN BOOLEAN DEFAULT FALSE
133: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
134: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
135: , x_return_status OUT NOCOPY VARCHAR2
136: , x_msg_count OUT NOCOPY NUMBER
137: , x_msg_data OUT NOCOPY VARCHAR2

Line 134: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

130: , p_allow_partial_pick IN VARCHAR2 DEFAULT fnd_api.g_true
131: , p_print_pick_slip IN VARCHAR2 DEFAULT fnd_api.g_false
132: , p_plan_tasks IN BOOLEAN DEFAULT FALSE
133: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
134: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
135: , x_return_status OUT NOCOPY VARCHAR2
136: , x_msg_count OUT NOCOPY NUMBER
137: , x_msg_data OUT NOCOPY VARCHAR2
138: , x_conc_req_id OUT NOCOPY NUMBER

Line 146: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false

142: PROCEDURE pick_release(
143: x_return_status OUT NOCOPY VARCHAR2
144: , x_msg_count OUT NOCOPY NUMBER
145: , x_msg_data OUT NOCOPY VARCHAR2
146: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
147: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
148: , p_mo_line_tbl IN inv_move_order_pub.trolin_tbl_type
149: , p_allow_partial_pick IN VARCHAR2 DEFAULT fnd_api.g_true
150: , p_grouping_rule_id IN NUMBER DEFAULT NULL

Line 147: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

143: x_return_status OUT NOCOPY VARCHAR2
144: , x_msg_count OUT NOCOPY NUMBER
145: , x_msg_data OUT NOCOPY VARCHAR2
146: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
147: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
148: , p_mo_line_tbl IN inv_move_order_pub.trolin_tbl_type
149: , p_allow_partial_pick IN VARCHAR2 DEFAULT fnd_api.g_true
150: , p_grouping_rule_id IN NUMBER DEFAULT NULL
151: , p_plan_tasks IN BOOLEAN DEFAULT FALSE

Line 149: , p_allow_partial_pick IN VARCHAR2 DEFAULT fnd_api.g_true

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