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_MATERIAL_STATUS_PUB dependencies on FND_API

Line 19: ORGANIZATION_ID NUMBER := fnd_api.g_miss_num

15: ------------------------------------------------------------------------
16:
17: TYPE mtl_status_update_rec_type is RECORD
18: (
19: ORGANIZATION_ID NUMBER := fnd_api.g_miss_num
20: ,INVENTORY_ITEM_ID NUMBER := fnd_api.g_miss_num
21: ,LOT_NUMBER VARCHAR2(80) := fnd_api.g_miss_char -- INVCONV,nsrivast
22: ,SERIAL_NUMBER VARCHAR2(30) := fnd_api.g_miss_char
23: ,TO_SERIAL_NUMBER VARCHAR2(30) := fnd_api.g_miss_char

Line 20: ,INVENTORY_ITEM_ID NUMBER := fnd_api.g_miss_num

16:
17: TYPE mtl_status_update_rec_type is RECORD
18: (
19: ORGANIZATION_ID NUMBER := fnd_api.g_miss_num
20: ,INVENTORY_ITEM_ID NUMBER := fnd_api.g_miss_num
21: ,LOT_NUMBER VARCHAR2(80) := fnd_api.g_miss_char -- INVCONV,nsrivast
22: ,SERIAL_NUMBER VARCHAR2(30) := fnd_api.g_miss_char
23: ,TO_SERIAL_NUMBER VARCHAR2(30) := fnd_api.g_miss_char
24: ,UPDATE_METHOD NUMBER := fnd_api.g_miss_num

Line 21: ,LOT_NUMBER VARCHAR2(80) := fnd_api.g_miss_char -- INVCONV,nsrivast

17: TYPE mtl_status_update_rec_type is RECORD
18: (
19: ORGANIZATION_ID NUMBER := fnd_api.g_miss_num
20: ,INVENTORY_ITEM_ID NUMBER := fnd_api.g_miss_num
21: ,LOT_NUMBER VARCHAR2(80) := fnd_api.g_miss_char -- INVCONV,nsrivast
22: ,SERIAL_NUMBER VARCHAR2(30) := fnd_api.g_miss_char
23: ,TO_SERIAL_NUMBER VARCHAR2(30) := fnd_api.g_miss_char
24: ,UPDATE_METHOD NUMBER := fnd_api.g_miss_num
25: ,STATUS_ID NUMBER := fnd_api.g_miss_num

Line 22: ,SERIAL_NUMBER VARCHAR2(30) := fnd_api.g_miss_char

18: (
19: ORGANIZATION_ID NUMBER := fnd_api.g_miss_num
20: ,INVENTORY_ITEM_ID NUMBER := fnd_api.g_miss_num
21: ,LOT_NUMBER VARCHAR2(80) := fnd_api.g_miss_char -- INVCONV,nsrivast
22: ,SERIAL_NUMBER VARCHAR2(30) := fnd_api.g_miss_char
23: ,TO_SERIAL_NUMBER VARCHAR2(30) := fnd_api.g_miss_char
24: ,UPDATE_METHOD NUMBER := fnd_api.g_miss_num
25: ,STATUS_ID NUMBER := fnd_api.g_miss_num
26: ,ZONE_CODE VARCHAR2(10) := fnd_api.g_miss_char

Line 23: ,TO_SERIAL_NUMBER VARCHAR2(30) := fnd_api.g_miss_char

19: ORGANIZATION_ID NUMBER := fnd_api.g_miss_num
20: ,INVENTORY_ITEM_ID NUMBER := fnd_api.g_miss_num
21: ,LOT_NUMBER VARCHAR2(80) := fnd_api.g_miss_char -- INVCONV,nsrivast
22: ,SERIAL_NUMBER VARCHAR2(30) := fnd_api.g_miss_char
23: ,TO_SERIAL_NUMBER VARCHAR2(30) := fnd_api.g_miss_char
24: ,UPDATE_METHOD NUMBER := fnd_api.g_miss_num
25: ,STATUS_ID NUMBER := fnd_api.g_miss_num
26: ,ZONE_CODE VARCHAR2(10) := fnd_api.g_miss_char
27: ,LOCATOR_ID NUMBER := fnd_api.g_miss_num

Line 24: ,UPDATE_METHOD NUMBER := fnd_api.g_miss_num

20: ,INVENTORY_ITEM_ID NUMBER := fnd_api.g_miss_num
21: ,LOT_NUMBER VARCHAR2(80) := fnd_api.g_miss_char -- INVCONV,nsrivast
22: ,SERIAL_NUMBER VARCHAR2(30) := fnd_api.g_miss_char
23: ,TO_SERIAL_NUMBER VARCHAR2(30) := fnd_api.g_miss_char
24: ,UPDATE_METHOD NUMBER := fnd_api.g_miss_num
25: ,STATUS_ID NUMBER := fnd_api.g_miss_num
26: ,ZONE_CODE VARCHAR2(10) := fnd_api.g_miss_char
27: ,LOCATOR_ID NUMBER := fnd_api.g_miss_num
28: ,LPN_ID NUMBER := fnd_api.g_miss_num -- -- Added for # 6633612

Line 25: ,STATUS_ID NUMBER := fnd_api.g_miss_num

21: ,LOT_NUMBER VARCHAR2(80) := fnd_api.g_miss_char -- INVCONV,nsrivast
22: ,SERIAL_NUMBER VARCHAR2(30) := fnd_api.g_miss_char
23: ,TO_SERIAL_NUMBER VARCHAR2(30) := fnd_api.g_miss_char
24: ,UPDATE_METHOD NUMBER := fnd_api.g_miss_num
25: ,STATUS_ID NUMBER := fnd_api.g_miss_num
26: ,ZONE_CODE VARCHAR2(10) := fnd_api.g_miss_char
27: ,LOCATOR_ID NUMBER := fnd_api.g_miss_num
28: ,LPN_ID NUMBER := fnd_api.g_miss_num -- -- Added for # 6633612
29: ,CREATION_DATE DATE := fnd_api.g_miss_date

Line 26: ,ZONE_CODE VARCHAR2(10) := fnd_api.g_miss_char

22: ,SERIAL_NUMBER VARCHAR2(30) := fnd_api.g_miss_char
23: ,TO_SERIAL_NUMBER VARCHAR2(30) := fnd_api.g_miss_char
24: ,UPDATE_METHOD NUMBER := fnd_api.g_miss_num
25: ,STATUS_ID NUMBER := fnd_api.g_miss_num
26: ,ZONE_CODE VARCHAR2(10) := fnd_api.g_miss_char
27: ,LOCATOR_ID NUMBER := fnd_api.g_miss_num
28: ,LPN_ID NUMBER := fnd_api.g_miss_num -- -- Added for # 6633612
29: ,CREATION_DATE DATE := fnd_api.g_miss_date
30: ,CREATED_BY NUMBER := fnd_api.g_miss_num

Line 27: ,LOCATOR_ID NUMBER := fnd_api.g_miss_num

23: ,TO_SERIAL_NUMBER VARCHAR2(30) := fnd_api.g_miss_char
24: ,UPDATE_METHOD NUMBER := fnd_api.g_miss_num
25: ,STATUS_ID NUMBER := fnd_api.g_miss_num
26: ,ZONE_CODE VARCHAR2(10) := fnd_api.g_miss_char
27: ,LOCATOR_ID NUMBER := fnd_api.g_miss_num
28: ,LPN_ID NUMBER := fnd_api.g_miss_num -- -- Added for # 6633612
29: ,CREATION_DATE DATE := fnd_api.g_miss_date
30: ,CREATED_BY NUMBER := fnd_api.g_miss_num
31: ,LAST_UPDATED_BY NUMBER := fnd_api.g_miss_num

Line 28: ,LPN_ID NUMBER := fnd_api.g_miss_num -- -- Added for # 6633612

24: ,UPDATE_METHOD NUMBER := fnd_api.g_miss_num
25: ,STATUS_ID NUMBER := fnd_api.g_miss_num
26: ,ZONE_CODE VARCHAR2(10) := fnd_api.g_miss_char
27: ,LOCATOR_ID NUMBER := fnd_api.g_miss_num
28: ,LPN_ID NUMBER := fnd_api.g_miss_num -- -- Added for # 6633612
29: ,CREATION_DATE DATE := fnd_api.g_miss_date
30: ,CREATED_BY NUMBER := fnd_api.g_miss_num
31: ,LAST_UPDATED_BY NUMBER := fnd_api.g_miss_num
32: ,LAST_UPDATE_DATE DATE := fnd_api.g_miss_date

Line 29: ,CREATION_DATE DATE := fnd_api.g_miss_date

25: ,STATUS_ID NUMBER := fnd_api.g_miss_num
26: ,ZONE_CODE VARCHAR2(10) := fnd_api.g_miss_char
27: ,LOCATOR_ID NUMBER := fnd_api.g_miss_num
28: ,LPN_ID NUMBER := fnd_api.g_miss_num -- -- Added for # 6633612
29: ,CREATION_DATE DATE := fnd_api.g_miss_date
30: ,CREATED_BY NUMBER := fnd_api.g_miss_num
31: ,LAST_UPDATED_BY NUMBER := fnd_api.g_miss_num
32: ,LAST_UPDATE_DATE DATE := fnd_api.g_miss_date
33: ,LAST_UPDATE_LOGIN NUMBER := fnd_api.g_miss_num

Line 30: ,CREATED_BY NUMBER := fnd_api.g_miss_num

26: ,ZONE_CODE VARCHAR2(10) := fnd_api.g_miss_char
27: ,LOCATOR_ID NUMBER := fnd_api.g_miss_num
28: ,LPN_ID NUMBER := fnd_api.g_miss_num -- -- Added for # 6633612
29: ,CREATION_DATE DATE := fnd_api.g_miss_date
30: ,CREATED_BY NUMBER := fnd_api.g_miss_num
31: ,LAST_UPDATED_BY NUMBER := fnd_api.g_miss_num
32: ,LAST_UPDATE_DATE DATE := fnd_api.g_miss_date
33: ,LAST_UPDATE_LOGIN NUMBER := fnd_api.g_miss_num
34: ,PROGRAM_APPLICATION_ID NUMBER := fnd_api.g_miss_num

Line 31: ,LAST_UPDATED_BY NUMBER := fnd_api.g_miss_num

27: ,LOCATOR_ID NUMBER := fnd_api.g_miss_num
28: ,LPN_ID NUMBER := fnd_api.g_miss_num -- -- Added for # 6633612
29: ,CREATION_DATE DATE := fnd_api.g_miss_date
30: ,CREATED_BY NUMBER := fnd_api.g_miss_num
31: ,LAST_UPDATED_BY NUMBER := fnd_api.g_miss_num
32: ,LAST_UPDATE_DATE DATE := fnd_api.g_miss_date
33: ,LAST_UPDATE_LOGIN NUMBER := fnd_api.g_miss_num
34: ,PROGRAM_APPLICATION_ID NUMBER := fnd_api.g_miss_num
35: ,PROGRAM_ID NUMBER := fnd_api.g_miss_num

Line 32: ,LAST_UPDATE_DATE DATE := fnd_api.g_miss_date

28: ,LPN_ID NUMBER := fnd_api.g_miss_num -- -- Added for # 6633612
29: ,CREATION_DATE DATE := fnd_api.g_miss_date
30: ,CREATED_BY NUMBER := fnd_api.g_miss_num
31: ,LAST_UPDATED_BY NUMBER := fnd_api.g_miss_num
32: ,LAST_UPDATE_DATE DATE := fnd_api.g_miss_date
33: ,LAST_UPDATE_LOGIN NUMBER := fnd_api.g_miss_num
34: ,PROGRAM_APPLICATION_ID NUMBER := fnd_api.g_miss_num
35: ,PROGRAM_ID NUMBER := fnd_api.g_miss_num
36: ,ATTRIBUTE_CATEGORY VARCHAR2(30) := fnd_api.g_miss_char

Line 33: ,LAST_UPDATE_LOGIN NUMBER := fnd_api.g_miss_num

29: ,CREATION_DATE DATE := fnd_api.g_miss_date
30: ,CREATED_BY NUMBER := fnd_api.g_miss_num
31: ,LAST_UPDATED_BY NUMBER := fnd_api.g_miss_num
32: ,LAST_UPDATE_DATE DATE := fnd_api.g_miss_date
33: ,LAST_UPDATE_LOGIN NUMBER := fnd_api.g_miss_num
34: ,PROGRAM_APPLICATION_ID NUMBER := fnd_api.g_miss_num
35: ,PROGRAM_ID NUMBER := fnd_api.g_miss_num
36: ,ATTRIBUTE_CATEGORY VARCHAR2(30) := fnd_api.g_miss_char
37: ,ATTRIBUTE1 VARCHAR2(150) := fnd_api.g_miss_char

Line 34: ,PROGRAM_APPLICATION_ID NUMBER := fnd_api.g_miss_num

30: ,CREATED_BY NUMBER := fnd_api.g_miss_num
31: ,LAST_UPDATED_BY NUMBER := fnd_api.g_miss_num
32: ,LAST_UPDATE_DATE DATE := fnd_api.g_miss_date
33: ,LAST_UPDATE_LOGIN NUMBER := fnd_api.g_miss_num
34: ,PROGRAM_APPLICATION_ID NUMBER := fnd_api.g_miss_num
35: ,PROGRAM_ID NUMBER := fnd_api.g_miss_num
36: ,ATTRIBUTE_CATEGORY VARCHAR2(30) := fnd_api.g_miss_char
37: ,ATTRIBUTE1 VARCHAR2(150) := fnd_api.g_miss_char
38: ,ATTRIBUTE2 VARCHAR2(150) := fnd_api.g_miss_char

Line 35: ,PROGRAM_ID NUMBER := fnd_api.g_miss_num

31: ,LAST_UPDATED_BY NUMBER := fnd_api.g_miss_num
32: ,LAST_UPDATE_DATE DATE := fnd_api.g_miss_date
33: ,LAST_UPDATE_LOGIN NUMBER := fnd_api.g_miss_num
34: ,PROGRAM_APPLICATION_ID NUMBER := fnd_api.g_miss_num
35: ,PROGRAM_ID NUMBER := fnd_api.g_miss_num
36: ,ATTRIBUTE_CATEGORY VARCHAR2(30) := fnd_api.g_miss_char
37: ,ATTRIBUTE1 VARCHAR2(150) := fnd_api.g_miss_char
38: ,ATTRIBUTE2 VARCHAR2(150) := fnd_api.g_miss_char
39: ,ATTRIBUTE3 VARCHAR2(150) := fnd_api.g_miss_char

Line 36: ,ATTRIBUTE_CATEGORY VARCHAR2(30) := fnd_api.g_miss_char

32: ,LAST_UPDATE_DATE DATE := fnd_api.g_miss_date
33: ,LAST_UPDATE_LOGIN NUMBER := fnd_api.g_miss_num
34: ,PROGRAM_APPLICATION_ID NUMBER := fnd_api.g_miss_num
35: ,PROGRAM_ID NUMBER := fnd_api.g_miss_num
36: ,ATTRIBUTE_CATEGORY VARCHAR2(30) := fnd_api.g_miss_char
37: ,ATTRIBUTE1 VARCHAR2(150) := fnd_api.g_miss_char
38: ,ATTRIBUTE2 VARCHAR2(150) := fnd_api.g_miss_char
39: ,ATTRIBUTE3 VARCHAR2(150) := fnd_api.g_miss_char
40: ,ATTRIBUTE4 VARCHAR2(150) := fnd_api.g_miss_char

Line 37: ,ATTRIBUTE1 VARCHAR2(150) := fnd_api.g_miss_char

33: ,LAST_UPDATE_LOGIN NUMBER := fnd_api.g_miss_num
34: ,PROGRAM_APPLICATION_ID NUMBER := fnd_api.g_miss_num
35: ,PROGRAM_ID NUMBER := fnd_api.g_miss_num
36: ,ATTRIBUTE_CATEGORY VARCHAR2(30) := fnd_api.g_miss_char
37: ,ATTRIBUTE1 VARCHAR2(150) := fnd_api.g_miss_char
38: ,ATTRIBUTE2 VARCHAR2(150) := fnd_api.g_miss_char
39: ,ATTRIBUTE3 VARCHAR2(150) := fnd_api.g_miss_char
40: ,ATTRIBUTE4 VARCHAR2(150) := fnd_api.g_miss_char
41: ,ATTRIBUTE5 VARCHAR2(150) := fnd_api.g_miss_char

Line 38: ,ATTRIBUTE2 VARCHAR2(150) := fnd_api.g_miss_char

34: ,PROGRAM_APPLICATION_ID NUMBER := fnd_api.g_miss_num
35: ,PROGRAM_ID NUMBER := fnd_api.g_miss_num
36: ,ATTRIBUTE_CATEGORY VARCHAR2(30) := fnd_api.g_miss_char
37: ,ATTRIBUTE1 VARCHAR2(150) := fnd_api.g_miss_char
38: ,ATTRIBUTE2 VARCHAR2(150) := fnd_api.g_miss_char
39: ,ATTRIBUTE3 VARCHAR2(150) := fnd_api.g_miss_char
40: ,ATTRIBUTE4 VARCHAR2(150) := fnd_api.g_miss_char
41: ,ATTRIBUTE5 VARCHAR2(150) := fnd_api.g_miss_char
42: ,ATTRIBUTE6 VARCHAR2(150) := fnd_api.g_miss_char

Line 39: ,ATTRIBUTE3 VARCHAR2(150) := fnd_api.g_miss_char

35: ,PROGRAM_ID NUMBER := fnd_api.g_miss_num
36: ,ATTRIBUTE_CATEGORY VARCHAR2(30) := fnd_api.g_miss_char
37: ,ATTRIBUTE1 VARCHAR2(150) := fnd_api.g_miss_char
38: ,ATTRIBUTE2 VARCHAR2(150) := fnd_api.g_miss_char
39: ,ATTRIBUTE3 VARCHAR2(150) := fnd_api.g_miss_char
40: ,ATTRIBUTE4 VARCHAR2(150) := fnd_api.g_miss_char
41: ,ATTRIBUTE5 VARCHAR2(150) := fnd_api.g_miss_char
42: ,ATTRIBUTE6 VARCHAR2(150) := fnd_api.g_miss_char
43: ,ATTRIBUTE7 VARCHAR2(150) := fnd_api.g_miss_char

Line 40: ,ATTRIBUTE4 VARCHAR2(150) := fnd_api.g_miss_char

36: ,ATTRIBUTE_CATEGORY VARCHAR2(30) := fnd_api.g_miss_char
37: ,ATTRIBUTE1 VARCHAR2(150) := fnd_api.g_miss_char
38: ,ATTRIBUTE2 VARCHAR2(150) := fnd_api.g_miss_char
39: ,ATTRIBUTE3 VARCHAR2(150) := fnd_api.g_miss_char
40: ,ATTRIBUTE4 VARCHAR2(150) := fnd_api.g_miss_char
41: ,ATTRIBUTE5 VARCHAR2(150) := fnd_api.g_miss_char
42: ,ATTRIBUTE6 VARCHAR2(150) := fnd_api.g_miss_char
43: ,ATTRIBUTE7 VARCHAR2(150) := fnd_api.g_miss_char
44: ,ATTRIBUTE8 VARCHAR2(150) := fnd_api.g_miss_char

Line 41: ,ATTRIBUTE5 VARCHAR2(150) := fnd_api.g_miss_char

37: ,ATTRIBUTE1 VARCHAR2(150) := fnd_api.g_miss_char
38: ,ATTRIBUTE2 VARCHAR2(150) := fnd_api.g_miss_char
39: ,ATTRIBUTE3 VARCHAR2(150) := fnd_api.g_miss_char
40: ,ATTRIBUTE4 VARCHAR2(150) := fnd_api.g_miss_char
41: ,ATTRIBUTE5 VARCHAR2(150) := fnd_api.g_miss_char
42: ,ATTRIBUTE6 VARCHAR2(150) := fnd_api.g_miss_char
43: ,ATTRIBUTE7 VARCHAR2(150) := fnd_api.g_miss_char
44: ,ATTRIBUTE8 VARCHAR2(150) := fnd_api.g_miss_char
45: ,ATTRIBUTE9 VARCHAR2(150) := fnd_api.g_miss_char

Line 42: ,ATTRIBUTE6 VARCHAR2(150) := fnd_api.g_miss_char

38: ,ATTRIBUTE2 VARCHAR2(150) := fnd_api.g_miss_char
39: ,ATTRIBUTE3 VARCHAR2(150) := fnd_api.g_miss_char
40: ,ATTRIBUTE4 VARCHAR2(150) := fnd_api.g_miss_char
41: ,ATTRIBUTE5 VARCHAR2(150) := fnd_api.g_miss_char
42: ,ATTRIBUTE6 VARCHAR2(150) := fnd_api.g_miss_char
43: ,ATTRIBUTE7 VARCHAR2(150) := fnd_api.g_miss_char
44: ,ATTRIBUTE8 VARCHAR2(150) := fnd_api.g_miss_char
45: ,ATTRIBUTE9 VARCHAR2(150) := fnd_api.g_miss_char
46: ,ATTRIBUTE10 VARCHAR2(150) := fnd_api.g_miss_char

Line 43: ,ATTRIBUTE7 VARCHAR2(150) := fnd_api.g_miss_char

39: ,ATTRIBUTE3 VARCHAR2(150) := fnd_api.g_miss_char
40: ,ATTRIBUTE4 VARCHAR2(150) := fnd_api.g_miss_char
41: ,ATTRIBUTE5 VARCHAR2(150) := fnd_api.g_miss_char
42: ,ATTRIBUTE6 VARCHAR2(150) := fnd_api.g_miss_char
43: ,ATTRIBUTE7 VARCHAR2(150) := fnd_api.g_miss_char
44: ,ATTRIBUTE8 VARCHAR2(150) := fnd_api.g_miss_char
45: ,ATTRIBUTE9 VARCHAR2(150) := fnd_api.g_miss_char
46: ,ATTRIBUTE10 VARCHAR2(150) := fnd_api.g_miss_char
47: ,ATTRIBUTE11 VARCHAR2(150) := fnd_api.g_miss_char

Line 44: ,ATTRIBUTE8 VARCHAR2(150) := fnd_api.g_miss_char

40: ,ATTRIBUTE4 VARCHAR2(150) := fnd_api.g_miss_char
41: ,ATTRIBUTE5 VARCHAR2(150) := fnd_api.g_miss_char
42: ,ATTRIBUTE6 VARCHAR2(150) := fnd_api.g_miss_char
43: ,ATTRIBUTE7 VARCHAR2(150) := fnd_api.g_miss_char
44: ,ATTRIBUTE8 VARCHAR2(150) := fnd_api.g_miss_char
45: ,ATTRIBUTE9 VARCHAR2(150) := fnd_api.g_miss_char
46: ,ATTRIBUTE10 VARCHAR2(150) := fnd_api.g_miss_char
47: ,ATTRIBUTE11 VARCHAR2(150) := fnd_api.g_miss_char
48: ,ATTRIBUTE12 VARCHAR2(150) := fnd_api.g_miss_char

Line 45: ,ATTRIBUTE9 VARCHAR2(150) := fnd_api.g_miss_char

41: ,ATTRIBUTE5 VARCHAR2(150) := fnd_api.g_miss_char
42: ,ATTRIBUTE6 VARCHAR2(150) := fnd_api.g_miss_char
43: ,ATTRIBUTE7 VARCHAR2(150) := fnd_api.g_miss_char
44: ,ATTRIBUTE8 VARCHAR2(150) := fnd_api.g_miss_char
45: ,ATTRIBUTE9 VARCHAR2(150) := fnd_api.g_miss_char
46: ,ATTRIBUTE10 VARCHAR2(150) := fnd_api.g_miss_char
47: ,ATTRIBUTE11 VARCHAR2(150) := fnd_api.g_miss_char
48: ,ATTRIBUTE12 VARCHAR2(150) := fnd_api.g_miss_char
49: ,ATTRIBUTE13 VARCHAR2(150) := fnd_api.g_miss_char

Line 46: ,ATTRIBUTE10 VARCHAR2(150) := fnd_api.g_miss_char

42: ,ATTRIBUTE6 VARCHAR2(150) := fnd_api.g_miss_char
43: ,ATTRIBUTE7 VARCHAR2(150) := fnd_api.g_miss_char
44: ,ATTRIBUTE8 VARCHAR2(150) := fnd_api.g_miss_char
45: ,ATTRIBUTE9 VARCHAR2(150) := fnd_api.g_miss_char
46: ,ATTRIBUTE10 VARCHAR2(150) := fnd_api.g_miss_char
47: ,ATTRIBUTE11 VARCHAR2(150) := fnd_api.g_miss_char
48: ,ATTRIBUTE12 VARCHAR2(150) := fnd_api.g_miss_char
49: ,ATTRIBUTE13 VARCHAR2(150) := fnd_api.g_miss_char
50: ,ATTRIBUTE14 VARCHAR2(150) := fnd_api.g_miss_char

Line 47: ,ATTRIBUTE11 VARCHAR2(150) := fnd_api.g_miss_char

43: ,ATTRIBUTE7 VARCHAR2(150) := fnd_api.g_miss_char
44: ,ATTRIBUTE8 VARCHAR2(150) := fnd_api.g_miss_char
45: ,ATTRIBUTE9 VARCHAR2(150) := fnd_api.g_miss_char
46: ,ATTRIBUTE10 VARCHAR2(150) := fnd_api.g_miss_char
47: ,ATTRIBUTE11 VARCHAR2(150) := fnd_api.g_miss_char
48: ,ATTRIBUTE12 VARCHAR2(150) := fnd_api.g_miss_char
49: ,ATTRIBUTE13 VARCHAR2(150) := fnd_api.g_miss_char
50: ,ATTRIBUTE14 VARCHAR2(150) := fnd_api.g_miss_char
51: ,ATTRIBUTE15 VARCHAR2(150) := fnd_api.g_miss_char

Line 48: ,ATTRIBUTE12 VARCHAR2(150) := fnd_api.g_miss_char

44: ,ATTRIBUTE8 VARCHAR2(150) := fnd_api.g_miss_char
45: ,ATTRIBUTE9 VARCHAR2(150) := fnd_api.g_miss_char
46: ,ATTRIBUTE10 VARCHAR2(150) := fnd_api.g_miss_char
47: ,ATTRIBUTE11 VARCHAR2(150) := fnd_api.g_miss_char
48: ,ATTRIBUTE12 VARCHAR2(150) := fnd_api.g_miss_char
49: ,ATTRIBUTE13 VARCHAR2(150) := fnd_api.g_miss_char
50: ,ATTRIBUTE14 VARCHAR2(150) := fnd_api.g_miss_char
51: ,ATTRIBUTE15 VARCHAR2(150) := fnd_api.g_miss_char
52: ,UPDATE_REASON_ID NUMBER := fnd_api.g_miss_num

Line 49: ,ATTRIBUTE13 VARCHAR2(150) := fnd_api.g_miss_char

45: ,ATTRIBUTE9 VARCHAR2(150) := fnd_api.g_miss_char
46: ,ATTRIBUTE10 VARCHAR2(150) := fnd_api.g_miss_char
47: ,ATTRIBUTE11 VARCHAR2(150) := fnd_api.g_miss_char
48: ,ATTRIBUTE12 VARCHAR2(150) := fnd_api.g_miss_char
49: ,ATTRIBUTE13 VARCHAR2(150) := fnd_api.g_miss_char
50: ,ATTRIBUTE14 VARCHAR2(150) := fnd_api.g_miss_char
51: ,ATTRIBUTE15 VARCHAR2(150) := fnd_api.g_miss_char
52: ,UPDATE_REASON_ID NUMBER := fnd_api.g_miss_num
53: ,INITIAL_STATUS_FLAG VARCHAR2(1) := fnd_api.g_miss_char

Line 50: ,ATTRIBUTE14 VARCHAR2(150) := fnd_api.g_miss_char

46: ,ATTRIBUTE10 VARCHAR2(150) := fnd_api.g_miss_char
47: ,ATTRIBUTE11 VARCHAR2(150) := fnd_api.g_miss_char
48: ,ATTRIBUTE12 VARCHAR2(150) := fnd_api.g_miss_char
49: ,ATTRIBUTE13 VARCHAR2(150) := fnd_api.g_miss_char
50: ,ATTRIBUTE14 VARCHAR2(150) := fnd_api.g_miss_char
51: ,ATTRIBUTE15 VARCHAR2(150) := fnd_api.g_miss_char
52: ,UPDATE_REASON_ID NUMBER := fnd_api.g_miss_num
53: ,INITIAL_STATUS_FLAG VARCHAR2(1) := fnd_api.g_miss_char
54: ,FROM_MOBILE_APPS_FLAG VARCHAR2(1) := fnd_api.g_miss_char

Line 51: ,ATTRIBUTE15 VARCHAR2(150) := fnd_api.g_miss_char

47: ,ATTRIBUTE11 VARCHAR2(150) := fnd_api.g_miss_char
48: ,ATTRIBUTE12 VARCHAR2(150) := fnd_api.g_miss_char
49: ,ATTRIBUTE13 VARCHAR2(150) := fnd_api.g_miss_char
50: ,ATTRIBUTE14 VARCHAR2(150) := fnd_api.g_miss_char
51: ,ATTRIBUTE15 VARCHAR2(150) := fnd_api.g_miss_char
52: ,UPDATE_REASON_ID NUMBER := fnd_api.g_miss_num
53: ,INITIAL_STATUS_FLAG VARCHAR2(1) := fnd_api.g_miss_char
54: ,FROM_MOBILE_APPS_FLAG VARCHAR2(1) := fnd_api.g_miss_char
55: -- NSRIVAST, INVCONV , Start

Line 52: ,UPDATE_REASON_ID NUMBER := fnd_api.g_miss_num

48: ,ATTRIBUTE12 VARCHAR2(150) := fnd_api.g_miss_char
49: ,ATTRIBUTE13 VARCHAR2(150) := fnd_api.g_miss_char
50: ,ATTRIBUTE14 VARCHAR2(150) := fnd_api.g_miss_char
51: ,ATTRIBUTE15 VARCHAR2(150) := fnd_api.g_miss_char
52: ,UPDATE_REASON_ID NUMBER := fnd_api.g_miss_num
53: ,INITIAL_STATUS_FLAG VARCHAR2(1) := fnd_api.g_miss_char
54: ,FROM_MOBILE_APPS_FLAG VARCHAR2(1) := fnd_api.g_miss_char
55: -- NSRIVAST, INVCONV , Start
56: ,GRADE_CODE VARCHAR2(150) := fnd_api.g_miss_char

Line 53: ,INITIAL_STATUS_FLAG VARCHAR2(1) := fnd_api.g_miss_char

49: ,ATTRIBUTE13 VARCHAR2(150) := fnd_api.g_miss_char
50: ,ATTRIBUTE14 VARCHAR2(150) := fnd_api.g_miss_char
51: ,ATTRIBUTE15 VARCHAR2(150) := fnd_api.g_miss_char
52: ,UPDATE_REASON_ID NUMBER := fnd_api.g_miss_num
53: ,INITIAL_STATUS_FLAG VARCHAR2(1) := fnd_api.g_miss_char
54: ,FROM_MOBILE_APPS_FLAG VARCHAR2(1) := fnd_api.g_miss_char
55: -- NSRIVAST, INVCONV , Start
56: ,GRADE_CODE VARCHAR2(150) := fnd_api.g_miss_char
57: ,PRIMARY_ONHAND NUMBER := fnd_api.g_miss_num

Line 54: ,FROM_MOBILE_APPS_FLAG VARCHAR2(1) := fnd_api.g_miss_char

50: ,ATTRIBUTE14 VARCHAR2(150) := fnd_api.g_miss_char
51: ,ATTRIBUTE15 VARCHAR2(150) := fnd_api.g_miss_char
52: ,UPDATE_REASON_ID NUMBER := fnd_api.g_miss_num
53: ,INITIAL_STATUS_FLAG VARCHAR2(1) := fnd_api.g_miss_char
54: ,FROM_MOBILE_APPS_FLAG VARCHAR2(1) := fnd_api.g_miss_char
55: -- NSRIVAST, INVCONV , Start
56: ,GRADE_CODE VARCHAR2(150) := fnd_api.g_miss_char
57: ,PRIMARY_ONHAND NUMBER := fnd_api.g_miss_num
58: ,SECONDARY_ONHAND NUMBER := fnd_api.g_miss_num

Line 56: ,GRADE_CODE VARCHAR2(150) := fnd_api.g_miss_char

52: ,UPDATE_REASON_ID NUMBER := fnd_api.g_miss_num
53: ,INITIAL_STATUS_FLAG VARCHAR2(1) := fnd_api.g_miss_char
54: ,FROM_MOBILE_APPS_FLAG VARCHAR2(1) := fnd_api.g_miss_char
55: -- NSRIVAST, INVCONV , Start
56: ,GRADE_CODE VARCHAR2(150) := fnd_api.g_miss_char
57: ,PRIMARY_ONHAND NUMBER := fnd_api.g_miss_num
58: ,SECONDARY_ONHAND NUMBER := fnd_api.g_miss_num
59: -- NSRIVAST, INVCONV , End
60: );

Line 57: ,PRIMARY_ONHAND NUMBER := fnd_api.g_miss_num

53: ,INITIAL_STATUS_FLAG VARCHAR2(1) := fnd_api.g_miss_char
54: ,FROM_MOBILE_APPS_FLAG VARCHAR2(1) := fnd_api.g_miss_char
55: -- NSRIVAST, INVCONV , Start
56: ,GRADE_CODE VARCHAR2(150) := fnd_api.g_miss_char
57: ,PRIMARY_ONHAND NUMBER := fnd_api.g_miss_num
58: ,SECONDARY_ONHAND NUMBER := fnd_api.g_miss_num
59: -- NSRIVAST, INVCONV , End
60: );
61:

Line 58: ,SECONDARY_ONHAND NUMBER := fnd_api.g_miss_num

54: ,FROM_MOBILE_APPS_FLAG VARCHAR2(1) := fnd_api.g_miss_char
55: -- NSRIVAST, INVCONV , Start
56: ,GRADE_CODE VARCHAR2(150) := fnd_api.g_miss_char
57: ,PRIMARY_ONHAND NUMBER := fnd_api.g_miss_num
58: ,SECONDARY_ONHAND NUMBER := fnd_api.g_miss_num
59: -- NSRIVAST, INVCONV , End
60: );
61:
62: -- Bug# 1695432, added INITIAL_STATUS_FLAG and FROM_MOBILE_APPS_FLAG col

Line 76: -- Should be fnd_api.g_false or fnd_api.g_true

72: -- p_api_version_number API version number (current version is 1.0)
73: --
74: -- p_init_msg_lst Whether initialize the error message list or
75: -- not.
76: -- Should be fnd_api.g_false or fnd_api.g_true
77: -- p_commit whether or not to commit the changes to Database
78: --
79: -- p_object_type this parameter is for performance purpose
80: -- must be specified for the proper function

Line 89: -- x_return_status = fnd_api.g_ret_sts_success, if succeeded

85:
86: -- p_status_rec Contains info to be used to update entity status
87: --
88: -- Output Parameters
89: -- x_return_status = fnd_api.g_ret_sts_success, if succeeded
90: -- = fnd_api.g_ret_sts_exc_error, if an expected
91: -- error occurred
92: -- = fnd_api.g_ret_sts_unexp_error, if
93: -- an unexpected error occurred

Line 90: -- = fnd_api.g_ret_sts_exc_error, if an expected

86: -- p_status_rec Contains info to be used to update entity status
87: --
88: -- Output Parameters
89: -- x_return_status = fnd_api.g_ret_sts_success, if succeeded
90: -- = fnd_api.g_ret_sts_exc_error, if an expected
91: -- error occurred
92: -- = fnd_api.g_ret_sts_unexp_error, if
93: -- an unexpected error occurred
94: --

Line 92: -- = fnd_api.g_ret_sts_unexp_error, if

88: -- Output Parameters
89: -- x_return_status = fnd_api.g_ret_sts_success, if succeeded
90: -- = fnd_api.g_ret_sts_exc_error, if an expected
91: -- error occurred
92: -- = fnd_api.g_ret_sts_unexp_error, if
93: -- an unexpected error occurred
94: --
95: -- x_msg_count Number of error message in the error message
96: -- list

Line 106: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

102: ------------------------------------------------------------------------------
103:
104: PROCEDURE update_status
105: ( p_api_version_number IN NUMBER
106: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
107: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
108: , x_return_status OUT NOCOPY VARCHAR2
109: , x_msg_count OUT NOCOPY NUMBER
110: , x_msg_data OUT NOCOPY VARCHAR2

Line 107: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false

103:
104: PROCEDURE update_status
105: ( p_api_version_number IN NUMBER
106: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
107: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
108: , x_return_status OUT NOCOPY VARCHAR2
109: , x_msg_count OUT NOCOPY NUMBER
110: , x_msg_data OUT NOCOPY VARCHAR2
111: , p_object_type IN VARCHAR2