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 22: ORGANIZATION_ID NUMBER := fnd_api.g_miss_num

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

Line 23: ,INVENTORY_ITEM_ID NUMBER := fnd_api.g_miss_num

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

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

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

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

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

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

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

Line 27: ,UPDATE_METHOD NUMBER := fnd_api.g_miss_num

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

Line 28: ,STATUS_ID NUMBER := fnd_api.g_miss_num

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

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

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

Line 30: ,LOCATOR_ID NUMBER := fnd_api.g_miss_num

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

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

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

Line 32: ,CREATION_DATE DATE := fnd_api.g_miss_date

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

Line 33: ,CREATED_BY NUMBER := fnd_api.g_miss_num

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

Line 34: ,LAST_UPDATED_BY NUMBER := fnd_api.g_miss_num

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

Line 35: ,LAST_UPDATE_DATE DATE := fnd_api.g_miss_date

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

Line 36: ,LAST_UPDATE_LOGIN NUMBER := fnd_api.g_miss_num

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

Line 37: ,PROGRAM_APPLICATION_ID NUMBER := fnd_api.g_miss_num

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

Line 38: ,PROGRAM_ID NUMBER := fnd_api.g_miss_num

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 55: ,UPDATE_REASON_ID NUMBER := fnd_api.g_miss_num

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

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

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

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

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

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

55: ,UPDATE_REASON_ID NUMBER := fnd_api.g_miss_num
56: ,INITIAL_STATUS_FLAG VARCHAR2(1) := fnd_api.g_miss_char
57: ,FROM_MOBILE_APPS_FLAG VARCHAR2(1) := fnd_api.g_miss_char
58: -- NSRIVAST, INVCONV , Start
59: ,GRADE_CODE VARCHAR2(150) := fnd_api.g_miss_char
60: ,PRIMARY_ONHAND NUMBER := fnd_api.g_miss_num
61: ,SECONDARY_ONHAND NUMBER := fnd_api.g_miss_num
62: ,GROUP_ID NUMBER := fnd_api.g_miss_num --Bug#11826279
63: ,pending_status NUMBER := fnd_api.g_miss_num --ERES Deferred

Line 60: ,PRIMARY_ONHAND NUMBER := fnd_api.g_miss_num

56: ,INITIAL_STATUS_FLAG VARCHAR2(1) := fnd_api.g_miss_char
57: ,FROM_MOBILE_APPS_FLAG VARCHAR2(1) := fnd_api.g_miss_char
58: -- NSRIVAST, INVCONV , Start
59: ,GRADE_CODE VARCHAR2(150) := fnd_api.g_miss_char
60: ,PRIMARY_ONHAND NUMBER := fnd_api.g_miss_num
61: ,SECONDARY_ONHAND NUMBER := fnd_api.g_miss_num
62: ,GROUP_ID NUMBER := fnd_api.g_miss_num --Bug#11826279
63: ,pending_status NUMBER := fnd_api.g_miss_num --ERES Deferred
64: -- NSRIVAST, INVCONV , End

Line 61: ,SECONDARY_ONHAND NUMBER := fnd_api.g_miss_num

57: ,FROM_MOBILE_APPS_FLAG VARCHAR2(1) := fnd_api.g_miss_char
58: -- NSRIVAST, INVCONV , Start
59: ,GRADE_CODE VARCHAR2(150) := fnd_api.g_miss_char
60: ,PRIMARY_ONHAND NUMBER := fnd_api.g_miss_num
61: ,SECONDARY_ONHAND NUMBER := fnd_api.g_miss_num
62: ,GROUP_ID NUMBER := fnd_api.g_miss_num --Bug#11826279
63: ,pending_status NUMBER := fnd_api.g_miss_num --ERES Deferred
64: -- NSRIVAST, INVCONV , End
65: );

Line 62: ,GROUP_ID NUMBER := fnd_api.g_miss_num --Bug#11826279

58: -- NSRIVAST, INVCONV , Start
59: ,GRADE_CODE VARCHAR2(150) := fnd_api.g_miss_char
60: ,PRIMARY_ONHAND NUMBER := fnd_api.g_miss_num
61: ,SECONDARY_ONHAND NUMBER := fnd_api.g_miss_num
62: ,GROUP_ID NUMBER := fnd_api.g_miss_num --Bug#11826279
63: ,pending_status NUMBER := fnd_api.g_miss_num --ERES Deferred
64: -- NSRIVAST, INVCONV , End
65: );
66:

Line 63: ,pending_status NUMBER := fnd_api.g_miss_num --ERES Deferred

59: ,GRADE_CODE VARCHAR2(150) := fnd_api.g_miss_char
60: ,PRIMARY_ONHAND NUMBER := fnd_api.g_miss_num
61: ,SECONDARY_ONHAND NUMBER := fnd_api.g_miss_num
62: ,GROUP_ID NUMBER := fnd_api.g_miss_num --Bug#11826279
63: ,pending_status NUMBER := fnd_api.g_miss_num --ERES Deferred
64: -- NSRIVAST, INVCONV , End
65: );
66:
67: -- Bug# 1695432, added INITIAL_STATUS_FLAG and FROM_MOBILE_APPS_FLAG col

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

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

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

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

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

91: -- p_status_rec Contains info to be used to update entity status
92: --
93: -- Output Parameters
94: -- x_return_status = fnd_api.g_ret_sts_success, if succeeded
95: -- = fnd_api.g_ret_sts_exc_error, if an expected
96: -- error occurred
97: -- = fnd_api.g_ret_sts_unexp_error, if
98: -- an unexpected error occurred
99: --

Line 97: -- = fnd_api.g_ret_sts_unexp_error, if

93: -- Output Parameters
94: -- x_return_status = fnd_api.g_ret_sts_success, if succeeded
95: -- = fnd_api.g_ret_sts_exc_error, if an expected
96: -- error occurred
97: -- = fnd_api.g_ret_sts_unexp_error, if
98: -- an unexpected error occurred
99: --
100: -- x_msg_count Number of error message in the error message
101: -- list

Line 111: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

107: ------------------------------------------------------------------------------
108:
109: PROCEDURE update_status
110: ( p_api_version_number IN NUMBER
111: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
112: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
113: , x_return_status OUT NOCOPY VARCHAR2
114: , x_msg_count OUT NOCOPY NUMBER
115: , x_msg_data OUT NOCOPY VARCHAR2

Line 112: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false

108:
109: PROCEDURE update_status
110: ( p_api_version_number IN NUMBER
111: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
112: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
113: , x_return_status OUT NOCOPY VARCHAR2
114: , x_msg_count OUT NOCOPY NUMBER
115: , x_msg_data OUT NOCOPY VARCHAR2
116: , p_object_type IN VARCHAR2