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.CSP_EXCESS_LISTS_PKG dependencies on FND_API

Line 13: EXCESS_LINE_ID NUMBER := FND_API.G_MISS_NUM,

9:
10: -- added by htank for Reverse Logistic project
11: TYPE EXCESS_RECORD_TYPE IS RECORD
12: (
13: EXCESS_LINE_ID NUMBER := FND_API.G_MISS_NUM,
14: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
15: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
16: EXCESS_QUANTITY NUMBER := FND_API.G_MISS_NUM,
17: CONDITION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 14: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,

10: -- added by htank for Reverse Logistic project
11: TYPE EXCESS_RECORD_TYPE IS RECORD
12: (
13: EXCESS_LINE_ID NUMBER := FND_API.G_MISS_NUM,
14: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
15: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
16: EXCESS_QUANTITY NUMBER := FND_API.G_MISS_NUM,
17: CONDITION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
18: CREATED_BY NUMBER := FND_API.G_MISS_NUM,

Line 15: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,

11: TYPE EXCESS_RECORD_TYPE IS RECORD
12: (
13: EXCESS_LINE_ID NUMBER := FND_API.G_MISS_NUM,
14: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
15: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
16: EXCESS_QUANTITY NUMBER := FND_API.G_MISS_NUM,
17: CONDITION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
18: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
19: CREATION_DATE DATE := FND_API.G_MISS_DATE,

Line 16: EXCESS_QUANTITY NUMBER := FND_API.G_MISS_NUM,

12: (
13: EXCESS_LINE_ID NUMBER := FND_API.G_MISS_NUM,
14: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
15: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
16: EXCESS_QUANTITY NUMBER := FND_API.G_MISS_NUM,
17: CONDITION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
18: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
19: CREATION_DATE DATE := FND_API.G_MISS_DATE,
20: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,

Line 17: CONDITION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,

13: EXCESS_LINE_ID NUMBER := FND_API.G_MISS_NUM,
14: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
15: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
16: EXCESS_QUANTITY NUMBER := FND_API.G_MISS_NUM,
17: CONDITION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
18: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
19: CREATION_DATE DATE := FND_API.G_MISS_DATE,
20: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
21: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

Line 18: CREATED_BY NUMBER := FND_API.G_MISS_NUM,

14: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
15: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
16: EXCESS_QUANTITY NUMBER := FND_API.G_MISS_NUM,
17: CONDITION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
18: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
19: CREATION_DATE DATE := FND_API.G_MISS_DATE,
20: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
21: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
22: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,

Line 19: CREATION_DATE DATE := FND_API.G_MISS_DATE,

15: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
16: EXCESS_QUANTITY NUMBER := FND_API.G_MISS_NUM,
17: CONDITION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
18: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
19: CREATION_DATE DATE := FND_API.G_MISS_DATE,
20: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
21: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
22: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
23: SUBINVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,

Line 20: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,

16: EXCESS_QUANTITY NUMBER := FND_API.G_MISS_NUM,
17: CONDITION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
18: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
19: CREATION_DATE DATE := FND_API.G_MISS_DATE,
20: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
21: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
22: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
23: SUBINVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
24: RETURNED_QUANTITY NUMBER := FND_API.G_MISS_NUM,

Line 21: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

17: CONDITION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
18: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
19: CREATION_DATE DATE := FND_API.G_MISS_DATE,
20: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
21: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
22: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
23: SUBINVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
24: RETURNED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
25: CURRENT_RETURN_QTY NUMBER := FND_API.G_MISS_NUM,

Line 22: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,

18: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
19: CREATION_DATE DATE := FND_API.G_MISS_DATE,
20: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
21: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
22: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
23: SUBINVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
24: RETURNED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
25: CURRENT_RETURN_QTY NUMBER := FND_API.G_MISS_NUM,
26: REQUISITION_LINE_ID NUMBER := FND_API.G_MISS_NUM,

Line 23: SUBINVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,

19: CREATION_DATE DATE := FND_API.G_MISS_DATE,
20: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
21: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
22: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
23: SUBINVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
24: RETURNED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
25: CURRENT_RETURN_QTY NUMBER := FND_API.G_MISS_NUM,
26: REQUISITION_LINE_ID NUMBER := FND_API.G_MISS_NUM,
27: EXCESS_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 24: RETURNED_QUANTITY NUMBER := FND_API.G_MISS_NUM,

20: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
21: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
22: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
23: SUBINVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
24: RETURNED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
25: CURRENT_RETURN_QTY NUMBER := FND_API.G_MISS_NUM,
26: REQUISITION_LINE_ID NUMBER := FND_API.G_MISS_NUM,
27: EXCESS_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
28: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 25: CURRENT_RETURN_QTY NUMBER := FND_API.G_MISS_NUM,

21: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
22: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
23: SUBINVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
24: RETURNED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
25: CURRENT_RETURN_QTY NUMBER := FND_API.G_MISS_NUM,
26: REQUISITION_LINE_ID NUMBER := FND_API.G_MISS_NUM,
27: EXCESS_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
28: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 26: REQUISITION_LINE_ID NUMBER := FND_API.G_MISS_NUM,

22: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
23: SUBINVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
24: RETURNED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
25: CURRENT_RETURN_QTY NUMBER := FND_API.G_MISS_NUM,
26: REQUISITION_LINE_ID NUMBER := FND_API.G_MISS_NUM,
27: EXCESS_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
28: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 27: EXCESS_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,

23: SUBINVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
24: RETURNED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
25: CURRENT_RETURN_QTY NUMBER := FND_API.G_MISS_NUM,
26: REQUISITION_LINE_ID NUMBER := FND_API.G_MISS_NUM,
27: EXCESS_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
28: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

24: RETURNED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
25: CURRENT_RETURN_QTY NUMBER := FND_API.G_MISS_NUM,
26: REQUISITION_LINE_ID NUMBER := FND_API.G_MISS_NUM,
27: EXCESS_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
28: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

25: CURRENT_RETURN_QTY NUMBER := FND_API.G_MISS_NUM,
26: REQUISITION_LINE_ID NUMBER := FND_API.G_MISS_NUM,
27: EXCESS_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
28: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

26: REQUISITION_LINE_ID NUMBER := FND_API.G_MISS_NUM,
27: EXCESS_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
28: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

27: EXCESS_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
28: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 32: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,

28: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
36: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 33: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,

29: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
36: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
37: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 34: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,

30: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
36: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
37: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
38: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 35: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,

31: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
36: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
37: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
38: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
39: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 36: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,

32: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
36: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
37: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
38: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
39: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
40: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 37: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,

33: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
36: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
37: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
38: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
39: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
40: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
41: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 38: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,

34: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
36: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
37: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
38: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
39: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
40: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
41: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
42: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 39: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,

35: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
36: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
37: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
38: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
39: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
40: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
41: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
42: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
43: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 40: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,

36: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
37: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
38: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
39: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
40: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
41: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
42: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
43: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
44: SECURITY_GROUP_ID NUMBER := FND_API.G_MISS_NUM,

Line 41: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,

37: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
38: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
39: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
40: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
41: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
42: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
43: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
44: SECURITY_GROUP_ID NUMBER := FND_API.G_MISS_NUM,
45: REASON_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 42: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,

38: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
39: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
40: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
41: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
42: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
43: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
44: SECURITY_GROUP_ID NUMBER := FND_API.G_MISS_NUM,
45: REASON_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
46: RETURN_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,

Line 43: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,

39: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
40: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
41: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
42: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
43: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
44: SECURITY_GROUP_ID NUMBER := FND_API.G_MISS_NUM,
45: REASON_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
46: RETURN_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
47: RETURN_SUBINVENTORY_NAME VARCHAR2(10) := FND_API.G_MISS_CHAR

Line 44: SECURITY_GROUP_ID NUMBER := FND_API.G_MISS_NUM,

40: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
41: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
42: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
43: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
44: SECURITY_GROUP_ID NUMBER := FND_API.G_MISS_NUM,
45: REASON_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
46: RETURN_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
47: RETURN_SUBINVENTORY_NAME VARCHAR2(10) := FND_API.G_MISS_CHAR
48: );

Line 45: REASON_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,

41: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
42: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
43: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
44: SECURITY_GROUP_ID NUMBER := FND_API.G_MISS_NUM,
45: REASON_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
46: RETURN_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
47: RETURN_SUBINVENTORY_NAME VARCHAR2(10) := FND_API.G_MISS_CHAR
48: );
49: G_MISS_EXCESS_REC EXCESS_RECORD_TYPE;

Line 46: RETURN_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,

42: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
43: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
44: SECURITY_GROUP_ID NUMBER := FND_API.G_MISS_NUM,
45: REASON_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
46: RETURN_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
47: RETURN_SUBINVENTORY_NAME VARCHAR2(10) := FND_API.G_MISS_CHAR
48: );
49: G_MISS_EXCESS_REC EXCESS_RECORD_TYPE;
50:

Line 47: RETURN_SUBINVENTORY_NAME VARCHAR2(10) := FND_API.G_MISS_CHAR

43: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
44: SECURITY_GROUP_ID NUMBER := FND_API.G_MISS_NUM,
45: REASON_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
46: RETURN_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
47: RETURN_SUBINVENTORY_NAME VARCHAR2(10) := FND_API.G_MISS_CHAR
48: );
49: G_MISS_EXCESS_REC EXCESS_RECORD_TYPE;
50:
51: TYPE EXCESS_TBL_TYPE IS TABLE OF EXCESS_RECORD_TYPE INDEX BY BINARY_INTEGER;

Line 71: p_RETURN_ORG_ID NUMBER := FND_API.G_MISS_NUM,

67: p_REQUISITION_LINE_ID NUMBER,
68: p_RETURNED_QUANTITY NUMBER,
69: p_CURRENT_RETURN_QTY NUMBER,
70: p_EXCESS_STATUS VARCHAR2,
71: p_RETURN_ORG_ID NUMBER := FND_API.G_MISS_NUM,
72: p_RETURN_SUB_INV VARCHAR2 := FND_API.G_MISS_CHAR,
73: p_ATTRIBUTE_CATEGORY VARCHAR2,
74: p_ATTRIBUTE1 VARCHAR2,
75: p_ATTRIBUTE2 VARCHAR2,

Line 72: p_RETURN_SUB_INV VARCHAR2 := FND_API.G_MISS_CHAR,

68: p_RETURNED_QUANTITY NUMBER,
69: p_CURRENT_RETURN_QTY NUMBER,
70: p_EXCESS_STATUS VARCHAR2,
71: p_RETURN_ORG_ID NUMBER := FND_API.G_MISS_NUM,
72: p_RETURN_SUB_INV VARCHAR2 := FND_API.G_MISS_CHAR,
73: p_ATTRIBUTE_CATEGORY VARCHAR2,
74: p_ATTRIBUTE1 VARCHAR2,
75: p_ATTRIBUTE2 VARCHAR2,
76: p_ATTRIBUTE3 VARCHAR2,