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

Line 26: ROW_ID ROWID := FND_API.G_MISS_CHAR,

22: -- End of Comments
23:
24: TYPE RQL_Rec_Type IS RECORD
25: (
26: ROW_ID ROWID := FND_API.G_MISS_CHAR,
27: REQUIREMENT_LINE_ID NUMBER := FND_API.G_MISS_NUM,
28: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
29: CREATION_DATE DATE := FND_API.G_MISS_DATE,
30: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,

Line 27: REQUIREMENT_LINE_ID NUMBER := FND_API.G_MISS_NUM,

23:
24: TYPE RQL_Rec_Type IS RECORD
25: (
26: ROW_ID ROWID := FND_API.G_MISS_CHAR,
27: REQUIREMENT_LINE_ID NUMBER := FND_API.G_MISS_NUM,
28: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
29: CREATION_DATE DATE := FND_API.G_MISS_DATE,
30: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
31: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

Line 28: CREATED_BY NUMBER := FND_API.G_MISS_NUM,

24: TYPE RQL_Rec_Type IS RECORD
25: (
26: ROW_ID ROWID := FND_API.G_MISS_CHAR,
27: REQUIREMENT_LINE_ID NUMBER := FND_API.G_MISS_NUM,
28: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
29: CREATION_DATE DATE := FND_API.G_MISS_DATE,
30: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
31: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
32: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,

Line 29: CREATION_DATE DATE := FND_API.G_MISS_DATE,

25: (
26: ROW_ID ROWID := FND_API.G_MISS_CHAR,
27: REQUIREMENT_LINE_ID NUMBER := FND_API.G_MISS_NUM,
28: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
29: CREATION_DATE DATE := FND_API.G_MISS_DATE,
30: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
31: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
32: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
33: REQUIREMENT_HEADER_ID NUMBER := FND_API.G_MISS_NUM,

Line 30: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,

26: ROW_ID ROWID := FND_API.G_MISS_CHAR,
27: REQUIREMENT_LINE_ID NUMBER := FND_API.G_MISS_NUM,
28: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
29: CREATION_DATE DATE := FND_API.G_MISS_DATE,
30: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
31: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
32: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
33: REQUIREMENT_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
34: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,

Line 31: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

27: REQUIREMENT_LINE_ID NUMBER := FND_API.G_MISS_NUM,
28: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
29: CREATION_DATE DATE := FND_API.G_MISS_DATE,
30: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
31: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
32: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
33: REQUIREMENT_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
34: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
35: UOM_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 32: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,

28: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
29: CREATION_DATE DATE := FND_API.G_MISS_DATE,
30: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
31: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
32: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
33: REQUIREMENT_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
34: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
35: UOM_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
36: REQUIRED_QUANTITY NUMBER := FND_API.G_MISS_NUM,

Line 33: REQUIREMENT_HEADER_ID NUMBER := FND_API.G_MISS_NUM,

29: CREATION_DATE DATE := FND_API.G_MISS_DATE,
30: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
31: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
32: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
33: REQUIREMENT_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
34: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
35: UOM_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
36: REQUIRED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
37: SHIP_COMPLETE_FLAG VARCHAR2(3) := FND_API.G_MISS_CHAR,

Line 34: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,

30: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
31: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
32: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
33: REQUIREMENT_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
34: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
35: UOM_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
36: REQUIRED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
37: SHIP_COMPLETE_FLAG VARCHAR2(3) := FND_API.G_MISS_CHAR,
38: LIKELIHOOD NUMBER := FND_API.G_MISS_NUM,

Line 35: UOM_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,

31: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
32: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
33: REQUIREMENT_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
34: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
35: UOM_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
36: REQUIRED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
37: SHIP_COMPLETE_FLAG VARCHAR2(3) := FND_API.G_MISS_CHAR,
38: LIKELIHOOD NUMBER := FND_API.G_MISS_NUM,
39: REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,

Line 36: REQUIRED_QUANTITY NUMBER := FND_API.G_MISS_NUM,

32: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
33: REQUIREMENT_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
34: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
35: UOM_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
36: REQUIRED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
37: SHIP_COMPLETE_FLAG VARCHAR2(3) := FND_API.G_MISS_CHAR,
38: LIKELIHOOD NUMBER := FND_API.G_MISS_NUM,
39: REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
40: SOURCE_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,

Line 37: SHIP_COMPLETE_FLAG VARCHAR2(3) := FND_API.G_MISS_CHAR,

33: REQUIREMENT_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
34: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
35: UOM_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
36: REQUIRED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
37: SHIP_COMPLETE_FLAG VARCHAR2(3) := FND_API.G_MISS_CHAR,
38: LIKELIHOOD NUMBER := FND_API.G_MISS_NUM,
39: REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
40: SOURCE_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
41: SOURCE_SUBINVENTORY VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 38: LIKELIHOOD NUMBER := FND_API.G_MISS_NUM,

34: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
35: UOM_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
36: REQUIRED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
37: SHIP_COMPLETE_FLAG VARCHAR2(3) := FND_API.G_MISS_CHAR,
38: LIKELIHOOD NUMBER := FND_API.G_MISS_NUM,
39: REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
40: SOURCE_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
41: SOURCE_SUBINVENTORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
42: ORDERED_QUANTITY NUMBER := FND_API.G_MISS_NUM,

Line 39: REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,

35: UOM_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
36: REQUIRED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
37: SHIP_COMPLETE_FLAG VARCHAR2(3) := FND_API.G_MISS_CHAR,
38: LIKELIHOOD NUMBER := FND_API.G_MISS_NUM,
39: REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
40: SOURCE_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
41: SOURCE_SUBINVENTORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
42: ORDERED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
43: ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,

Line 40: SOURCE_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,

36: REQUIRED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
37: SHIP_COMPLETE_FLAG VARCHAR2(3) := FND_API.G_MISS_CHAR,
38: LIKELIHOOD NUMBER := FND_API.G_MISS_NUM,
39: REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
40: SOURCE_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
41: SOURCE_SUBINVENTORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
42: ORDERED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
43: ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
44: RESERVATION_ID NUMBER := FND_API.G_MISS_NUM,

Line 41: SOURCE_SUBINVENTORY VARCHAR2(30) := FND_API.G_MISS_CHAR,

37: SHIP_COMPLETE_FLAG VARCHAR2(3) := FND_API.G_MISS_CHAR,
38: LIKELIHOOD NUMBER := FND_API.G_MISS_NUM,
39: REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
40: SOURCE_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
41: SOURCE_SUBINVENTORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
42: ORDERED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
43: ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
44: RESERVATION_ID NUMBER := FND_API.G_MISS_NUM,
45: LOCAL_RESERVATION_ID NUMBER := FND_API.G_MISS_NUM,

Line 42: ORDERED_QUANTITY NUMBER := FND_API.G_MISS_NUM,

38: LIKELIHOOD NUMBER := FND_API.G_MISS_NUM,
39: REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
40: SOURCE_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
41: SOURCE_SUBINVENTORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
42: ORDERED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
43: ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
44: RESERVATION_ID NUMBER := FND_API.G_MISS_NUM,
45: LOCAL_RESERVATION_ID NUMBER := FND_API.G_MISS_NUM,
46: ORDER_BY_DATE DATE := FND_API.G_MISS_DATE,

Line 43: ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,

39: REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
40: SOURCE_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
41: SOURCE_SUBINVENTORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
42: ORDERED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
43: ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
44: RESERVATION_ID NUMBER := FND_API.G_MISS_NUM,
45: LOCAL_RESERVATION_ID NUMBER := FND_API.G_MISS_NUM,
46: ORDER_BY_DATE DATE := FND_API.G_MISS_DATE,
47: ARRIVAL_DATE DATE := FND_API.G_MISS_DATE,

Line 44: RESERVATION_ID NUMBER := FND_API.G_MISS_NUM,

40: SOURCE_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
41: SOURCE_SUBINVENTORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
42: ORDERED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
43: ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
44: RESERVATION_ID NUMBER := FND_API.G_MISS_NUM,
45: LOCAL_RESERVATION_ID NUMBER := FND_API.G_MISS_NUM,
46: ORDER_BY_DATE DATE := FND_API.G_MISS_DATE,
47: ARRIVAL_DATE DATE := FND_API.G_MISS_DATE,
48: ITEM_SCRATCHPAD VARCHAR2(1996) := FND_API.G_MISS_CHAR,

Line 45: LOCAL_RESERVATION_ID NUMBER := FND_API.G_MISS_NUM,

41: SOURCE_SUBINVENTORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
42: ORDERED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
43: ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
44: RESERVATION_ID NUMBER := FND_API.G_MISS_NUM,
45: LOCAL_RESERVATION_ID NUMBER := FND_API.G_MISS_NUM,
46: ORDER_BY_DATE DATE := FND_API.G_MISS_DATE,
47: ARRIVAL_DATE DATE := FND_API.G_MISS_DATE,
48: ITEM_SCRATCHPAD VARCHAR2(1996) := FND_API.G_MISS_CHAR,
49: SHIPPING_METHOD_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 46: ORDER_BY_DATE DATE := FND_API.G_MISS_DATE,

42: ORDERED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
43: ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
44: RESERVATION_ID NUMBER := FND_API.G_MISS_NUM,
45: LOCAL_RESERVATION_ID NUMBER := FND_API.G_MISS_NUM,
46: ORDER_BY_DATE DATE := FND_API.G_MISS_DATE,
47: ARRIVAL_DATE DATE := FND_API.G_MISS_DATE,
48: ITEM_SCRATCHPAD VARCHAR2(1996) := FND_API.G_MISS_CHAR,
49: SHIPPING_METHOD_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
50: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 47: ARRIVAL_DATE DATE := FND_API.G_MISS_DATE,

43: ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
44: RESERVATION_ID NUMBER := FND_API.G_MISS_NUM,
45: LOCAL_RESERVATION_ID NUMBER := FND_API.G_MISS_NUM,
46: ORDER_BY_DATE DATE := FND_API.G_MISS_DATE,
47: ARRIVAL_DATE DATE := FND_API.G_MISS_DATE,
48: ITEM_SCRATCHPAD VARCHAR2(1996) := FND_API.G_MISS_CHAR,
49: SHIPPING_METHOD_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
50: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
51: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 48: ITEM_SCRATCHPAD VARCHAR2(1996) := FND_API.G_MISS_CHAR,

44: RESERVATION_ID NUMBER := FND_API.G_MISS_NUM,
45: LOCAL_RESERVATION_ID NUMBER := FND_API.G_MISS_NUM,
46: ORDER_BY_DATE DATE := FND_API.G_MISS_DATE,
47: ARRIVAL_DATE DATE := FND_API.G_MISS_DATE,
48: ITEM_SCRATCHPAD VARCHAR2(1996) := FND_API.G_MISS_CHAR,
49: SHIPPING_METHOD_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
50: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
51: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
52: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 49: SHIPPING_METHOD_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,

45: LOCAL_RESERVATION_ID NUMBER := FND_API.G_MISS_NUM,
46: ORDER_BY_DATE DATE := FND_API.G_MISS_DATE,
47: ARRIVAL_DATE DATE := FND_API.G_MISS_DATE,
48: ITEM_SCRATCHPAD VARCHAR2(1996) := FND_API.G_MISS_CHAR,
49: SHIPPING_METHOD_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
50: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
51: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
52: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
53: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

46: ORDER_BY_DATE DATE := FND_API.G_MISS_DATE,
47: ARRIVAL_DATE DATE := FND_API.G_MISS_DATE,
48: ITEM_SCRATCHPAD VARCHAR2(1996) := FND_API.G_MISS_CHAR,
49: SHIPPING_METHOD_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
50: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
51: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
52: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
53: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
54: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

47: ARRIVAL_DATE DATE := FND_API.G_MISS_DATE,
48: ITEM_SCRATCHPAD VARCHAR2(1996) := FND_API.G_MISS_CHAR,
49: SHIPPING_METHOD_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
50: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
51: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
52: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
53: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
54: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
55: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

48: ITEM_SCRATCHPAD VARCHAR2(1996) := FND_API.G_MISS_CHAR,
49: SHIPPING_METHOD_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
50: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
51: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
52: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
53: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
54: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
55: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
56: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

49: SHIPPING_METHOD_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
50: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
51: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
52: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
53: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
54: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
55: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
56: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
57: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

50: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
51: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
52: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
53: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
54: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
55: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
56: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
57: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
58: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

51: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
52: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
53: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
54: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
55: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
56: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
57: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
58: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
59: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

52: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
53: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
54: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
55: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
56: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
57: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
58: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
59: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
60: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

53: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
54: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
55: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
56: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
57: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
58: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
59: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
60: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
61: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

54: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
55: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
56: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
57: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
58: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
59: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
60: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
61: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
62: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

55: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
56: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
57: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
58: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
59: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
60: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
61: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
62: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
63: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

56: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
57: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
58: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
59: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
60: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
61: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
62: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
63: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
64: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

57: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
58: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
59: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
60: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
61: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
62: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
63: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
64: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
65: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

58: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
59: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
60: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
61: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
62: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
63: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
64: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
65: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66: SECURITY_GROUP_ID NUMBER := FND_API.G_MISS_NUM,

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

59: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
60: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
61: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
62: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
63: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
64: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
65: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66: SECURITY_GROUP_ID NUMBER := FND_API.G_MISS_NUM,
67: SOURCED_FROM VARCHAR2(30) := FND_API.G_MISS_CHAR,

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

60: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
61: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
62: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
63: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
64: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
65: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66: SECURITY_GROUP_ID NUMBER := FND_API.G_MISS_NUM,
67: SOURCED_FROM VARCHAR2(30) := FND_API.G_MISS_CHAR,
68: SEGMENT1 VARCHAR2(240) := FND_API.G_MISS_CHAR,

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

61: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
62: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
63: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
64: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
65: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66: SECURITY_GROUP_ID NUMBER := FND_API.G_MISS_NUM,
67: SOURCED_FROM VARCHAR2(30) := FND_API.G_MISS_CHAR,
68: SEGMENT1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
69: SEGMENT2 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 66: SECURITY_GROUP_ID NUMBER := FND_API.G_MISS_NUM,

62: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
63: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
64: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
65: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66: SECURITY_GROUP_ID NUMBER := FND_API.G_MISS_NUM,
67: SOURCED_FROM VARCHAR2(30) := FND_API.G_MISS_CHAR,
68: SEGMENT1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
69: SEGMENT2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
70: SEGMENT3 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 67: SOURCED_FROM VARCHAR2(30) := FND_API.G_MISS_CHAR,

63: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
64: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
65: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66: SECURITY_GROUP_ID NUMBER := FND_API.G_MISS_NUM,
67: SOURCED_FROM VARCHAR2(30) := FND_API.G_MISS_CHAR,
68: SEGMENT1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
69: SEGMENT2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
70: SEGMENT3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
71: SEGMENT4 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 68: SEGMENT1 VARCHAR2(240) := FND_API.G_MISS_CHAR,

64: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
65: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66: SECURITY_GROUP_ID NUMBER := FND_API.G_MISS_NUM,
67: SOURCED_FROM VARCHAR2(30) := FND_API.G_MISS_CHAR,
68: SEGMENT1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
69: SEGMENT2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
70: SEGMENT3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
71: SEGMENT4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
72: SEGMENT5 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 69: SEGMENT2 VARCHAR2(240) := FND_API.G_MISS_CHAR,

65: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66: SECURITY_GROUP_ID NUMBER := FND_API.G_MISS_NUM,
67: SOURCED_FROM VARCHAR2(30) := FND_API.G_MISS_CHAR,
68: SEGMENT1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
69: SEGMENT2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
70: SEGMENT3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
71: SEGMENT4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
72: SEGMENT5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
73: SEGMENT6 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 70: SEGMENT3 VARCHAR2(240) := FND_API.G_MISS_CHAR,

66: SECURITY_GROUP_ID NUMBER := FND_API.G_MISS_NUM,
67: SOURCED_FROM VARCHAR2(30) := FND_API.G_MISS_CHAR,
68: SEGMENT1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
69: SEGMENT2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
70: SEGMENT3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
71: SEGMENT4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
72: SEGMENT5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
73: SEGMENT6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
74: SEGMENT7 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 71: SEGMENT4 VARCHAR2(240) := FND_API.G_MISS_CHAR,

67: SOURCED_FROM VARCHAR2(30) := FND_API.G_MISS_CHAR,
68: SEGMENT1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
69: SEGMENT2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
70: SEGMENT3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
71: SEGMENT4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
72: SEGMENT5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
73: SEGMENT6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
74: SEGMENT7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
75: SEGMENT8 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 72: SEGMENT5 VARCHAR2(240) := FND_API.G_MISS_CHAR,

68: SEGMENT1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
69: SEGMENT2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
70: SEGMENT3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
71: SEGMENT4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
72: SEGMENT5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
73: SEGMENT6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
74: SEGMENT7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
75: SEGMENT8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: SEGMENT9 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 73: SEGMENT6 VARCHAR2(240) := FND_API.G_MISS_CHAR,

69: SEGMENT2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
70: SEGMENT3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
71: SEGMENT4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
72: SEGMENT5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
73: SEGMENT6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
74: SEGMENT7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
75: SEGMENT8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: SEGMENT9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
77: SEGMENT10 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 74: SEGMENT7 VARCHAR2(240) := FND_API.G_MISS_CHAR,

70: SEGMENT3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
71: SEGMENT4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
72: SEGMENT5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
73: SEGMENT6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
74: SEGMENT7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
75: SEGMENT8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: SEGMENT9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
77: SEGMENT10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
78: SEGMENT11 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 75: SEGMENT8 VARCHAR2(240) := FND_API.G_MISS_CHAR,

71: SEGMENT4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
72: SEGMENT5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
73: SEGMENT6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
74: SEGMENT7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
75: SEGMENT8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: SEGMENT9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
77: SEGMENT10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
78: SEGMENT11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
79: SEGMENT12 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 76: SEGMENT9 VARCHAR2(240) := FND_API.G_MISS_CHAR,

72: SEGMENT5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
73: SEGMENT6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
74: SEGMENT7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
75: SEGMENT8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: SEGMENT9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
77: SEGMENT10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
78: SEGMENT11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
79: SEGMENT12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
80: SEGMENT13 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 77: SEGMENT10 VARCHAR2(240) := FND_API.G_MISS_CHAR,

73: SEGMENT6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
74: SEGMENT7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
75: SEGMENT8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: SEGMENT9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
77: SEGMENT10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
78: SEGMENT11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
79: SEGMENT12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
80: SEGMENT13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: SEGMENT14 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 78: SEGMENT11 VARCHAR2(240) := FND_API.G_MISS_CHAR,

74: SEGMENT7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
75: SEGMENT8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: SEGMENT9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
77: SEGMENT10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
78: SEGMENT11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
79: SEGMENT12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
80: SEGMENT13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: SEGMENT14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
82: SEGMENT15 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 79: SEGMENT12 VARCHAR2(240) := FND_API.G_MISS_CHAR,

75: SEGMENT8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
76: SEGMENT9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
77: SEGMENT10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
78: SEGMENT11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
79: SEGMENT12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
80: SEGMENT13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: SEGMENT14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
82: SEGMENT15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: SEGMENT16 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 80: SEGMENT13 VARCHAR2(240) := FND_API.G_MISS_CHAR,

76: SEGMENT9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
77: SEGMENT10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
78: SEGMENT11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
79: SEGMENT12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
80: SEGMENT13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: SEGMENT14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
82: SEGMENT15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: SEGMENT16 VARCHAR2(240) := FND_API.G_MISS_CHAR,
84: SEGMENT17 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 81: SEGMENT14 VARCHAR2(240) := FND_API.G_MISS_CHAR,

77: SEGMENT10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
78: SEGMENT11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
79: SEGMENT12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
80: SEGMENT13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: SEGMENT14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
82: SEGMENT15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: SEGMENT16 VARCHAR2(240) := FND_API.G_MISS_CHAR,
84: SEGMENT17 VARCHAR2(240) := FND_API.G_MISS_CHAR,
85: SEGMENT18 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 82: SEGMENT15 VARCHAR2(240) := FND_API.G_MISS_CHAR,

78: SEGMENT11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
79: SEGMENT12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
80: SEGMENT13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: SEGMENT14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
82: SEGMENT15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: SEGMENT16 VARCHAR2(240) := FND_API.G_MISS_CHAR,
84: SEGMENT17 VARCHAR2(240) := FND_API.G_MISS_CHAR,
85: SEGMENT18 VARCHAR2(240) := FND_API.G_MISS_CHAR,
86: SEGMENT19 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 83: SEGMENT16 VARCHAR2(240) := FND_API.G_MISS_CHAR,

79: SEGMENT12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
80: SEGMENT13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: SEGMENT14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
82: SEGMENT15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: SEGMENT16 VARCHAR2(240) := FND_API.G_MISS_CHAR,
84: SEGMENT17 VARCHAR2(240) := FND_API.G_MISS_CHAR,
85: SEGMENT18 VARCHAR2(240) := FND_API.G_MISS_CHAR,
86: SEGMENT19 VARCHAR2(240) := FND_API.G_MISS_CHAR,
87: SEGMENT20 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 84: SEGMENT17 VARCHAR2(240) := FND_API.G_MISS_CHAR,

80: SEGMENT13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: SEGMENT14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
82: SEGMENT15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: SEGMENT16 VARCHAR2(240) := FND_API.G_MISS_CHAR,
84: SEGMENT17 VARCHAR2(240) := FND_API.G_MISS_CHAR,
85: SEGMENT18 VARCHAR2(240) := FND_API.G_MISS_CHAR,
86: SEGMENT19 VARCHAR2(240) := FND_API.G_MISS_CHAR,
87: SEGMENT20 VARCHAR2(240) := FND_API.G_MISS_CHAR
88: );

Line 85: SEGMENT18 VARCHAR2(240) := FND_API.G_MISS_CHAR,

81: SEGMENT14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
82: SEGMENT15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: SEGMENT16 VARCHAR2(240) := FND_API.G_MISS_CHAR,
84: SEGMENT17 VARCHAR2(240) := FND_API.G_MISS_CHAR,
85: SEGMENT18 VARCHAR2(240) := FND_API.G_MISS_CHAR,
86: SEGMENT19 VARCHAR2(240) := FND_API.G_MISS_CHAR,
87: SEGMENT20 VARCHAR2(240) := FND_API.G_MISS_CHAR
88: );
89:

Line 86: SEGMENT19 VARCHAR2(240) := FND_API.G_MISS_CHAR,

82: SEGMENT15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: SEGMENT16 VARCHAR2(240) := FND_API.G_MISS_CHAR,
84: SEGMENT17 VARCHAR2(240) := FND_API.G_MISS_CHAR,
85: SEGMENT18 VARCHAR2(240) := FND_API.G_MISS_CHAR,
86: SEGMENT19 VARCHAR2(240) := FND_API.G_MISS_CHAR,
87: SEGMENT20 VARCHAR2(240) := FND_API.G_MISS_CHAR
88: );
89:
90: G_MISS_RQL_REC RQL_Rec_Type;

Line 87: SEGMENT20 VARCHAR2(240) := FND_API.G_MISS_CHAR

83: SEGMENT16 VARCHAR2(240) := FND_API.G_MISS_CHAR,
84: SEGMENT17 VARCHAR2(240) := FND_API.G_MISS_CHAR,
85: SEGMENT18 VARCHAR2(240) := FND_API.G_MISS_CHAR,
86: SEGMENT19 VARCHAR2(240) := FND_API.G_MISS_CHAR,
87: SEGMENT20 VARCHAR2(240) := FND_API.G_MISS_CHAR
88: );
89:
90: G_MISS_RQL_REC RQL_Rec_Type;
91: TYPE RQL_Tbl_Type IS TABLE OF RQL_Rec_Type

Line 110: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

106: -- Pre-Req :
107: -- Parameters:
108: -- IN
109: -- p_api_version_number IN NUMBER Required
110: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
111: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
112: -- P_RQL_Rec IN RQL_Rec_Type Required
113: --
114: -- OUT:

Line 111: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

107: -- Parameters:
108: -- IN
109: -- p_api_version_number IN NUMBER Required
110: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
111: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
112: -- P_RQL_Rec IN RQL_Rec_Type Required
113: --
114: -- OUT:
115: -- x_return_status OUT NOCOPY VARCHAR2

Line 126: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

122: -- End of Comments
123: --
124: PROCEDURE Create_requirement_lines(
125: P_Api_Version_Number IN NUMBER,
126: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
127: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
128: P_RQL_Tbl IN RQL_Tbl_Type := G_MISS_RQL_TBL,
129: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
130: X_REQUIREMENT_LINE_Tbl OUT NOCOPY RQL_Tbl_type,

Line 127: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

123: --
124: PROCEDURE Create_requirement_lines(
125: P_Api_Version_Number IN NUMBER,
126: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
127: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
128: P_RQL_Tbl IN RQL_Tbl_Type := G_MISS_RQL_TBL,
129: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
130: X_REQUIREMENT_LINE_Tbl OUT NOCOPY RQL_Tbl_type,
131: X_Return_Status OUT NOCOPY VARCHAR2,

Line 145: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

141: -- Pre-Req :
142: -- Parameters:
143: -- IN
144: -- p_api_version_number IN NUMBER Required
145: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
146: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
147: -- P_RQL_Rec IN RQL_Rec_Type Required
148: --
149: -- OUT:

Line 146: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

142: -- Parameters:
143: -- IN
144: -- p_api_version_number IN NUMBER Required
145: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
146: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
147: -- P_RQL_Rec IN RQL_Rec_Type Required
148: --
149: -- OUT:
150: -- x_return_status OUT NOCOPY VARCHAR2

Line 162: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

158: --
159: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
160: PROCEDURE Update_requirement_lines(
161: P_Api_Version_Number IN NUMBER,
162: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
163: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
164: P_RQL_Tbl IN RQL_Tbl_Type := G_MISS_RQL_TBL,
165: X_Return_Status OUT NOCOPY VARCHAR2,
166: X_Msg_Count OUT NOCOPY NUMBER,

Line 163: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

159: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
160: PROCEDURE Update_requirement_lines(
161: P_Api_Version_Number IN NUMBER,
162: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
163: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
164: P_RQL_Tbl IN RQL_Tbl_Type := G_MISS_RQL_TBL,
165: X_Return_Status OUT NOCOPY VARCHAR2,
166: X_Msg_Count OUT NOCOPY NUMBER,
167: X_Msg_Data OUT NOCOPY VARCHAR2

Line 179: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

175: -- Pre-Req :
176: -- Parameters:
177: -- IN
178: -- p_api_version_number IN NUMBER Required
179: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
180: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
181: -- P_RQL_Rec IN RQL_Rec_Type Required
182: --
183: -- OUT:

Line 180: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

176: -- Parameters:
177: -- IN
178: -- p_api_version_number IN NUMBER Required
179: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
180: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
181: -- P_RQL_Rec IN RQL_Rec_Type Required
182: --
183: -- OUT:
184: -- x_return_status OUT NOCOPY VARCHAR2

Line 197: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

193: -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
194: -- The Master delete procedure may not be needed depends on different business requirements.
195: PROCEDURE Delete_requirement_lines(
196: P_Api_Version_Number IN NUMBER,
197: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
198: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
199: P_RQL_Tbl IN RQL_Tbl_Type,
200: X_Return_Status OUT NOCOPY VARCHAR2,
201: X_Msg_Count OUT NOCOPY NUMBER,

Line 198: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

194: -- The Master delete procedure may not be needed depends on different business requirements.
195: PROCEDURE Delete_requirement_lines(
196: P_Api_Version_Number IN NUMBER,
197: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
198: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
199: P_RQL_Tbl IN RQL_Tbl_Type,
200: X_Return_Status OUT NOCOPY VARCHAR2,
201: X_Msg_Count OUT NOCOPY NUMBER,
202: X_Msg_Data OUT NOCOPY VARCHAR2