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

Line 63: REQUIREMENT_LINE_ID NUMBER := FND_API.G_MISS_NUM,

59: -- End of Comments
60:
61: TYPE Requirement_Line_Rec_Type IS RECORD
62: (
63: REQUIREMENT_LINE_ID NUMBER := FND_API.G_MISS_NUM,
64: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
65: CREATION_DATE DATE := FND_API.G_MISS_DATE,
66: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
67: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

Line 64: CREATED_BY NUMBER := FND_API.G_MISS_NUM,

60:
61: TYPE Requirement_Line_Rec_Type IS RECORD
62: (
63: REQUIREMENT_LINE_ID NUMBER := FND_API.G_MISS_NUM,
64: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
65: CREATION_DATE DATE := FND_API.G_MISS_DATE,
66: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
67: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
68: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,

Line 65: CREATION_DATE DATE := FND_API.G_MISS_DATE,

61: TYPE Requirement_Line_Rec_Type IS RECORD
62: (
63: REQUIREMENT_LINE_ID NUMBER := FND_API.G_MISS_NUM,
64: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
65: CREATION_DATE DATE := FND_API.G_MISS_DATE,
66: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
67: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
68: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
69: REQUIREMENT_HEADER_ID NUMBER := FND_API.G_MISS_NUM,

Line 66: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,

62: (
63: REQUIREMENT_LINE_ID NUMBER := FND_API.G_MISS_NUM,
64: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
65: CREATION_DATE DATE := FND_API.G_MISS_DATE,
66: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
67: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
68: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
69: REQUIREMENT_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
70: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,

Line 67: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

63: REQUIREMENT_LINE_ID NUMBER := FND_API.G_MISS_NUM,
64: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
65: CREATION_DATE DATE := FND_API.G_MISS_DATE,
66: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
67: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
68: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
69: REQUIREMENT_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
70: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
71: UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,

Line 68: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,

64: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
65: CREATION_DATE DATE := FND_API.G_MISS_DATE,
66: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
67: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
68: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
69: REQUIREMENT_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
70: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
71: UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
72: REQUIRED_QUANTITY NUMBER := FND_API.G_MISS_NUM,

Line 69: REQUIREMENT_HEADER_ID NUMBER := FND_API.G_MISS_NUM,

65: CREATION_DATE DATE := FND_API.G_MISS_DATE,
66: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
67: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
68: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
69: REQUIREMENT_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
70: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
71: UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
72: REQUIRED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
73: SHIP_COMPLETE_FLAG VARCHAR2(3) := FND_API.G_MISS_CHAR,

Line 70: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,

66: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
67: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
68: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
69: REQUIREMENT_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
70: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
71: UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
72: REQUIRED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
73: SHIP_COMPLETE_FLAG VARCHAR2(3) := FND_API.G_MISS_CHAR,
74: LIKELIHOOD NUMBER := FND_API.G_MISS_NUM,

Line 71: UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,

67: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
68: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
69: REQUIREMENT_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
70: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
71: UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
72: REQUIRED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
73: SHIP_COMPLETE_FLAG VARCHAR2(3) := FND_API.G_MISS_CHAR,
74: LIKELIHOOD NUMBER := FND_API.G_MISS_NUM,
75: REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,

Line 72: REQUIRED_QUANTITY NUMBER := FND_API.G_MISS_NUM,

68: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
69: REQUIREMENT_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
70: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
71: UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
72: REQUIRED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
73: SHIP_COMPLETE_FLAG VARCHAR2(3) := FND_API.G_MISS_CHAR,
74: LIKELIHOOD NUMBER := FND_API.G_MISS_NUM,
75: REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
76: SOURCE_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,

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

69: REQUIREMENT_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
70: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
71: UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
72: REQUIRED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
73: SHIP_COMPLETE_FLAG VARCHAR2(3) := FND_API.G_MISS_CHAR,
74: LIKELIHOOD NUMBER := FND_API.G_MISS_NUM,
75: REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
76: SOURCE_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
77: SOURCE_SUBINVENTORY VARCHAR2(10) := FND_API.G_MISS_CHAR,

Line 74: LIKELIHOOD NUMBER := FND_API.G_MISS_NUM,

70: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
71: UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
72: REQUIRED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
73: SHIP_COMPLETE_FLAG VARCHAR2(3) := FND_API.G_MISS_CHAR,
74: LIKELIHOOD NUMBER := FND_API.G_MISS_NUM,
75: REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
76: SOURCE_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
77: SOURCE_SUBINVENTORY VARCHAR2(10) := FND_API.G_MISS_CHAR,
78: ORDERED_QUANTITY NUMBER := FND_API.G_MISS_NUM,

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

71: UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
72: REQUIRED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
73: SHIP_COMPLETE_FLAG VARCHAR2(3) := FND_API.G_MISS_CHAR,
74: LIKELIHOOD NUMBER := FND_API.G_MISS_NUM,
75: REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
76: SOURCE_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
77: SOURCE_SUBINVENTORY VARCHAR2(10) := FND_API.G_MISS_CHAR,
78: ORDERED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
79: ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,

Line 76: SOURCE_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,

72: REQUIRED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
73: SHIP_COMPLETE_FLAG VARCHAR2(3) := FND_API.G_MISS_CHAR,
74: LIKELIHOOD NUMBER := FND_API.G_MISS_NUM,
75: REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
76: SOURCE_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
77: SOURCE_SUBINVENTORY VARCHAR2(10) := FND_API.G_MISS_CHAR,
78: ORDERED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
79: ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
80: RESERVATION_ID NUMBER := FND_API.G_MISS_NUM,

Line 77: SOURCE_SUBINVENTORY VARCHAR2(10) := FND_API.G_MISS_CHAR,

73: SHIP_COMPLETE_FLAG VARCHAR2(3) := FND_API.G_MISS_CHAR,
74: LIKELIHOOD NUMBER := FND_API.G_MISS_NUM,
75: REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
76: SOURCE_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
77: SOURCE_SUBINVENTORY VARCHAR2(10) := FND_API.G_MISS_CHAR,
78: ORDERED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
79: ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
80: RESERVATION_ID NUMBER := FND_API.G_MISS_NUM,
81: ORDER_BY_DATE DATE := FND_API.G_MISS_DATE,

Line 78: ORDERED_QUANTITY NUMBER := FND_API.G_MISS_NUM,

74: LIKELIHOOD NUMBER := FND_API.G_MISS_NUM,
75: REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
76: SOURCE_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
77: SOURCE_SUBINVENTORY VARCHAR2(10) := FND_API.G_MISS_CHAR,
78: ORDERED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
79: ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
80: RESERVATION_ID NUMBER := FND_API.G_MISS_NUM,
81: ORDER_BY_DATE DATE := FND_API.G_MISS_DATE,
82: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 79: ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,

75: REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
76: SOURCE_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
77: SOURCE_SUBINVENTORY VARCHAR2(10) := FND_API.G_MISS_CHAR,
78: ORDERED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
79: ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
80: RESERVATION_ID NUMBER := FND_API.G_MISS_NUM,
81: ORDER_BY_DATE DATE := FND_API.G_MISS_DATE,
82: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 80: RESERVATION_ID NUMBER := FND_API.G_MISS_NUM,

76: SOURCE_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
77: SOURCE_SUBINVENTORY VARCHAR2(10) := FND_API.G_MISS_CHAR,
78: ORDERED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
79: ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
80: RESERVATION_ID NUMBER := FND_API.G_MISS_NUM,
81: ORDER_BY_DATE DATE := FND_API.G_MISS_DATE,
82: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 81: ORDER_BY_DATE DATE := FND_API.G_MISS_DATE,

77: SOURCE_SUBINVENTORY VARCHAR2(10) := FND_API.G_MISS_CHAR,
78: ORDERED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
79: ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
80: RESERVATION_ID NUMBER := FND_API.G_MISS_NUM,
81: ORDER_BY_DATE DATE := FND_API.G_MISS_DATE,
82: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

78: ORDERED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
79: ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
80: RESERVATION_ID NUMBER := FND_API.G_MISS_NUM,
81: ORDER_BY_DATE DATE := FND_API.G_MISS_DATE,
82: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

79: ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
80: RESERVATION_ID NUMBER := FND_API.G_MISS_NUM,
81: ORDER_BY_DATE DATE := FND_API.G_MISS_DATE,
82: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

80: RESERVATION_ID NUMBER := FND_API.G_MISS_NUM,
81: ORDER_BY_DATE DATE := FND_API.G_MISS_DATE,
82: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

81: ORDER_BY_DATE DATE := FND_API.G_MISS_DATE,
82: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

82: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

83: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

84: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

85: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

86: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

87: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

88: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

89: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

90: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
98: ARRIVAL_DATE DATE := FND_API.G_MISS_DATE,

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

91: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
98: ARRIVAL_DATE DATE := FND_API.G_MISS_DATE,
99: ITEM_SCRATCHPAD VARCHAR2(240) := FND_API.G_MISS_CHAR,

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

92: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
98: ARRIVAL_DATE DATE := FND_API.G_MISS_DATE,
99: ITEM_SCRATCHPAD VARCHAR2(240) := FND_API.G_MISS_CHAR,
100: SHIPPING_METHOD_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,

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

93: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
98: ARRIVAL_DATE DATE := FND_API.G_MISS_DATE,
99: ITEM_SCRATCHPAD VARCHAR2(240) := FND_API.G_MISS_CHAR,
100: SHIPPING_METHOD_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
101: LOCAL_RESERVATION_ID NUMBER := FND_API.G_MISS_NUM,

Line 98: ARRIVAL_DATE DATE := FND_API.G_MISS_DATE,

94: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
98: ARRIVAL_DATE DATE := FND_API.G_MISS_DATE,
99: ITEM_SCRATCHPAD VARCHAR2(240) := FND_API.G_MISS_CHAR,
100: SHIPPING_METHOD_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
101: LOCAL_RESERVATION_ID NUMBER := FND_API.G_MISS_NUM,
102: SOURCED_FROM VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 99: ITEM_SCRATCHPAD VARCHAR2(240) := FND_API.G_MISS_CHAR,

95: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
98: ARRIVAL_DATE DATE := FND_API.G_MISS_DATE,
99: ITEM_SCRATCHPAD VARCHAR2(240) := FND_API.G_MISS_CHAR,
100: SHIPPING_METHOD_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
101: LOCAL_RESERVATION_ID NUMBER := FND_API.G_MISS_NUM,
102: SOURCED_FROM VARCHAR2(30) := FND_API.G_MISS_CHAR
103: );

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

96: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
98: ARRIVAL_DATE DATE := FND_API.G_MISS_DATE,
99: ITEM_SCRATCHPAD VARCHAR2(240) := FND_API.G_MISS_CHAR,
100: SHIPPING_METHOD_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
101: LOCAL_RESERVATION_ID NUMBER := FND_API.G_MISS_NUM,
102: SOURCED_FROM VARCHAR2(30) := FND_API.G_MISS_CHAR
103: );
104:

Line 101: LOCAL_RESERVATION_ID NUMBER := FND_API.G_MISS_NUM,

97: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
98: ARRIVAL_DATE DATE := FND_API.G_MISS_DATE,
99: ITEM_SCRATCHPAD VARCHAR2(240) := FND_API.G_MISS_CHAR,
100: SHIPPING_METHOD_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
101: LOCAL_RESERVATION_ID NUMBER := FND_API.G_MISS_NUM,
102: SOURCED_FROM VARCHAR2(30) := FND_API.G_MISS_CHAR
103: );
104:
105: G_MISS_Requirement_Line_REC Requirement_Line_Rec_Type;

Line 102: SOURCED_FROM VARCHAR2(30) := FND_API.G_MISS_CHAR

98: ARRIVAL_DATE DATE := FND_API.G_MISS_DATE,
99: ITEM_SCRATCHPAD VARCHAR2(240) := FND_API.G_MISS_CHAR,
100: SHIPPING_METHOD_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
101: LOCAL_RESERVATION_ID NUMBER := FND_API.G_MISS_NUM,
102: SOURCED_FROM VARCHAR2(30) := FND_API.G_MISS_CHAR
103: );
104:
105: G_MISS_Requirement_Line_REC Requirement_Line_Rec_Type;
106: TYPE Requirement_Line_Tbl_Type IS TABLE OF Requirement_Line_Rec_Type

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

115: -- Pre-Req :
116: -- Parameters:
117: -- IN
118: -- p_api_version_number IN NUMBER Required
119: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
120: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
121: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
122: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
123: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE

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

116: -- Parameters:
117: -- IN
118: -- p_api_version_number IN NUMBER Required
119: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
120: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
121: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
122: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
123: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
124: -- p_admin_group_id IN NUMBER Required

Line 121: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

117: -- IN
118: -- p_api_version_number IN NUMBER Required
119: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
120: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
121: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
122: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
123: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
124: -- p_admin_group_id IN NUMBER Required
125: -- P_Requirement_Lines_Rec IN Requirement_Lines_Rec_Type Required

Line 122: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE

118: -- p_api_version_number IN NUMBER Required
119: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
120: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
121: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
122: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
123: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
124: -- p_admin_group_id IN NUMBER Required
125: -- P_Requirement_Lines_Rec IN Requirement_Lines_Rec_Type Required
126: -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required

Line 123: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE

119: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
120: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
121: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
122: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
123: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
124: -- p_admin_group_id IN NUMBER Required
125: -- P_Requirement_Lines_Rec IN Requirement_Lines_Rec_Type Required
126: -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required
127: --

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

136: -- End of Comments
137: --
138: PROCEDURE Create_requirement_lines(
139: P_Api_Version_Number IN NUMBER,
140: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
141: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
142: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
143: P_Requirement_Line_Tbl IN Requirement_Line_Tbl_Type := G_MISS_Requirement_Line_Tbl,
144: x_Requirement_Line_tbl OUT NOCOPY Requirement_Line_Tbl_Type,

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

137: --
138: PROCEDURE Create_requirement_lines(
139: P_Api_Version_Number IN NUMBER,
140: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
141: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
142: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
143: P_Requirement_Line_Tbl IN Requirement_Line_Tbl_Type := G_MISS_Requirement_Line_Tbl,
144: x_Requirement_Line_tbl OUT NOCOPY Requirement_Line_Tbl_Type,
145: X_Return_Status OUT NOCOPY VARCHAR2,

Line 142: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

138: PROCEDURE Create_requirement_lines(
139: P_Api_Version_Number IN NUMBER,
140: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
141: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
142: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
143: P_Requirement_Line_Tbl IN Requirement_Line_Tbl_Type := G_MISS_Requirement_Line_Tbl,
144: x_Requirement_Line_tbl OUT NOCOPY Requirement_Line_Tbl_Type,
145: X_Return_Status OUT NOCOPY VARCHAR2,
146: X_Msg_Count OUT NOCOPY NUMBER,

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

155: -- Pre-Req :
156: -- Parameters:
157: -- IN
158: -- p_api_version_number IN NUMBER Required
159: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
160: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
161: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
162: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
163: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE

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

156: -- Parameters:
157: -- IN
158: -- p_api_version_number IN NUMBER Required
159: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
160: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
161: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
162: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
163: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
164: -- p_admin_group_id IN NUMBER Required

Line 161: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

157: -- IN
158: -- p_api_version_number IN NUMBER Required
159: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
160: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
161: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
162: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
163: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
164: -- p_admin_group_id IN NUMBER Required
165: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL

Line 162: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE

158: -- p_api_version_number IN NUMBER Required
159: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
160: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
161: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
162: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
163: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
164: -- p_admin_group_id IN NUMBER Required
165: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
166: -- P_Requirement_Lines_Rec IN Requirement_Lines_Rec_Type Required

Line 163: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE

159: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
160: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
161: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
162: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
163: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
164: -- p_admin_group_id IN NUMBER Required
165: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
166: -- P_Requirement_Lines_Rec IN Requirement_Lines_Rec_Type Required
167: -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required

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

178: --
179: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
180: PROCEDURE Update_requirement_lines(
181: P_Api_Version_Number IN NUMBER,
182: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
183: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
184: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
185: P_Requirement_Line_Tbl IN Requirement_Line_Tbl_Type,
186: X_Return_Status OUT NOCOPY VARCHAR2,

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

179: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
180: PROCEDURE Update_requirement_lines(
181: P_Api_Version_Number IN NUMBER,
182: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
183: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
184: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
185: P_Requirement_Line_Tbl IN Requirement_Line_Tbl_Type,
186: X_Return_Status OUT NOCOPY VARCHAR2,
187: X_Msg_Count OUT NOCOPY NUMBER,

Line 184: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

180: PROCEDURE Update_requirement_lines(
181: P_Api_Version_Number IN NUMBER,
182: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
183: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
184: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
185: P_Requirement_Line_Tbl IN Requirement_Line_Tbl_Type,
186: X_Return_Status OUT NOCOPY VARCHAR2,
187: X_Msg_Count OUT NOCOPY NUMBER,
188: X_Msg_Data OUT NOCOPY VARCHAR2

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

196: -- Pre-Req :
197: -- Parameters:
198: -- IN
199: -- p_api_version_number IN NUMBER Required
200: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
201: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
202: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
203: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
204: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE

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

197: -- Parameters:
198: -- IN
199: -- p_api_version_number IN NUMBER Required
200: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
201: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
202: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
203: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
204: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
205: -- p_admin_group_id IN NUMBER Required

Line 202: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

198: -- IN
199: -- p_api_version_number IN NUMBER Required
200: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
201: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
202: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
203: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
204: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
205: -- p_admin_group_id IN NUMBER Required
206: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL

Line 203: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE

199: -- p_api_version_number IN NUMBER Required
200: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
201: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
202: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
203: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
204: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
205: -- p_admin_group_id IN NUMBER Required
206: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
207: -- P_Requirement_Lines_Rec IN Requirement_Lines_Rec_Type Required

Line 204: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE

200: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
201: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
202: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
203: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
204: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
205: -- p_admin_group_id IN NUMBER Required
206: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
207: -- P_Requirement_Lines_Rec IN Requirement_Lines_Rec_Type Required
208: -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required

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

220: -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
221: -- The Master delete procedure may not be needed depends on different business requirements.
222: PROCEDURE Delete_requirement_lines(
223: P_Api_Version_Number IN NUMBER,
224: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
225: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
226: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
227: P_Requirement_Line_Tbl IN Requirement_Line_Tbl_Type,
228: X_Return_Status OUT NOCOPY VARCHAR2,

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

221: -- The Master delete procedure may not be needed depends on different business requirements.
222: PROCEDURE Delete_requirement_lines(
223: P_Api_Version_Number IN NUMBER,
224: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
225: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
226: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
227: P_Requirement_Line_Tbl IN Requirement_Line_Tbl_Type,
228: X_Return_Status OUT NOCOPY VARCHAR2,
229: X_Msg_Count OUT NOCOPY NUMBER,

Line 226: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

222: PROCEDURE Delete_requirement_lines(
223: P_Api_Version_Number IN NUMBER,
224: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
225: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
226: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
227: P_Requirement_Line_Tbl IN Requirement_Line_Tbl_Type,
228: X_Return_Status OUT NOCOPY VARCHAR2,
229: X_Msg_Count OUT NOCOPY NUMBER,
230: X_Msg_Data OUT NOCOPY VARCHAR2