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

Line 40: PICKLIST_SERIAL_LOT_ID NUMBER := FND_API.G_MISS_NUM,

36: -- End of Comments
37:
38: TYPE psl_Rec_Type IS RECORD
39: (
40: PICKLIST_SERIAL_LOT_ID NUMBER := FND_API.G_MISS_NUM,
41: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
42: CREATION_DATE DATE := FND_API.G_MISS_DATE,
43: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
44: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

Line 41: CREATED_BY NUMBER := FND_API.G_MISS_NUM,

37:
38: TYPE psl_Rec_Type IS RECORD
39: (
40: PICKLIST_SERIAL_LOT_ID NUMBER := FND_API.G_MISS_NUM,
41: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
42: CREATION_DATE DATE := FND_API.G_MISS_DATE,
43: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
44: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
45: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,

Line 42: CREATION_DATE DATE := FND_API.G_MISS_DATE,

38: TYPE psl_Rec_Type IS RECORD
39: (
40: PICKLIST_SERIAL_LOT_ID NUMBER := FND_API.G_MISS_NUM,
41: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
42: CREATION_DATE DATE := FND_API.G_MISS_DATE,
43: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
44: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
45: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
46: PICKLIST_LINE_ID NUMBER := FND_API.G_MISS_NUM,

Line 43: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,

39: (
40: PICKLIST_SERIAL_LOT_ID NUMBER := FND_API.G_MISS_NUM,
41: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
42: CREATION_DATE DATE := FND_API.G_MISS_DATE,
43: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
44: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
45: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
46: PICKLIST_LINE_ID NUMBER := FND_API.G_MISS_NUM,
47: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,

Line 44: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

40: PICKLIST_SERIAL_LOT_ID NUMBER := FND_API.G_MISS_NUM,
41: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
42: CREATION_DATE DATE := FND_API.G_MISS_DATE,
43: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
44: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
45: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
46: PICKLIST_LINE_ID NUMBER := FND_API.G_MISS_NUM,
47: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
48: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,

Line 45: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,

41: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
42: CREATION_DATE DATE := FND_API.G_MISS_DATE,
43: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
44: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
45: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
46: PICKLIST_LINE_ID NUMBER := FND_API.G_MISS_NUM,
47: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
48: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
49: QUANTITY NUMBER := FND_API.G_MISS_NUM,

Line 46: PICKLIST_LINE_ID NUMBER := FND_API.G_MISS_NUM,

42: CREATION_DATE DATE := FND_API.G_MISS_DATE,
43: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
44: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
45: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
46: PICKLIST_LINE_ID NUMBER := FND_API.G_MISS_NUM,
47: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
48: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
49: QUANTITY NUMBER := FND_API.G_MISS_NUM,
50: LOT_NUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,

Line 47: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,

43: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
44: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
45: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
46: PICKLIST_LINE_ID NUMBER := FND_API.G_MISS_NUM,
47: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
48: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
49: QUANTITY NUMBER := FND_API.G_MISS_NUM,
50: LOT_NUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
51: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 48: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,

44: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
45: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
46: PICKLIST_LINE_ID NUMBER := FND_API.G_MISS_NUM,
47: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
48: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
49: QUANTITY NUMBER := FND_API.G_MISS_NUM,
50: LOT_NUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
51: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR
52: );

Line 49: QUANTITY NUMBER := FND_API.G_MISS_NUM,

45: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
46: PICKLIST_LINE_ID NUMBER := FND_API.G_MISS_NUM,
47: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
48: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
49: QUANTITY NUMBER := FND_API.G_MISS_NUM,
50: LOT_NUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
51: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR
52: );
53:

Line 50: LOT_NUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,

46: PICKLIST_LINE_ID NUMBER := FND_API.G_MISS_NUM,
47: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
48: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
49: QUANTITY NUMBER := FND_API.G_MISS_NUM,
50: LOT_NUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
51: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR
52: );
53:
54: G_MISS_psl_REC psl_Rec_Type;

Line 51: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR

47: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
48: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
49: QUANTITY NUMBER := FND_API.G_MISS_NUM,
50: LOT_NUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
51: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR
52: );
53:
54: G_MISS_psl_REC psl_Rec_Type;
55: TYPE psl_Tbl_Type IS TABLE OF psl_Rec_Type

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

64: -- Pre-Req :
65: -- Parameters:
66: -- IN
67: -- p_api_version_number IN NUMBER Required
68: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
69: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
70: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
71: -- P_psl_Rec IN psl_Rec_Type Required
72: --

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

65: -- Parameters:
66: -- IN
67: -- p_api_version_number IN NUMBER Required
68: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
69: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
70: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
71: -- P_psl_Rec IN psl_Rec_Type Required
72: --
73: -- OUT:

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

66: -- IN
67: -- p_api_version_number IN NUMBER Required
68: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
69: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
70: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
71: -- P_psl_Rec IN psl_Rec_Type Required
72: --
73: -- OUT:
74: -- x_return_status OUT NOCOPY VARCHAR2

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

81: -- End of Comments
82: --
83: PROCEDURE Create_pick_serial_lots(
84: P_Api_Version_Number IN NUMBER,
85: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
86: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
87: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
88: P_psl_Rec IN psl_Rec_Type := G_MISS_psl_REC,
89: --Hint: Add detail tables as parameter lists if it's master-detail relationship.

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

82: --
83: PROCEDURE Create_pick_serial_lots(
84: P_Api_Version_Number IN NUMBER,
85: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
86: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
87: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
88: P_psl_Rec IN psl_Rec_Type := G_MISS_psl_REC,
89: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
90: X_PICKLIST_SERIAL_LOT_ID OUT NOCOPY NUMBER,

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

83: PROCEDURE Create_pick_serial_lots(
84: P_Api_Version_Number IN NUMBER,
85: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
86: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
87: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
88: P_psl_Rec IN psl_Rec_Type := G_MISS_psl_REC,
89: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
90: X_PICKLIST_SERIAL_LOT_ID OUT NOCOPY NUMBER,
91: X_Return_Status OUT NOCOPY VARCHAR2,

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

101: -- Pre-Req :
102: -- Parameters:
103: -- IN
104: -- p_api_version_number IN NUMBER Required
105: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
106: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
107: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
108: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
109: -- P_psl_Rec IN psl_Rec_Type Required

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

102: -- Parameters:
103: -- IN
104: -- p_api_version_number IN NUMBER Required
105: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
106: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
107: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
108: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
109: -- P_psl_Rec IN psl_Rec_Type Required
110: --

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

103: -- IN
104: -- p_api_version_number IN NUMBER Required
105: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
106: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
107: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
108: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
109: -- P_psl_Rec IN psl_Rec_Type Required
110: --
111: -- OUT:

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

120: --
121: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
122: PROCEDURE Update_pick_serial_lots(
123: P_Api_Version_Number IN NUMBER,
124: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
125: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
126: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
127: P_Identity_Salesforce_Id IN NUMBER := NULL,
128: P_psl_Rec IN psl_Rec_Type,

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

121: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
122: PROCEDURE Update_pick_serial_lots(
123: P_Api_Version_Number IN NUMBER,
124: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
125: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
126: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
127: P_Identity_Salesforce_Id IN NUMBER := NULL,
128: P_psl_Rec IN psl_Rec_Type,
129: X_Return_Status OUT NOCOPY VARCHAR2,

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

122: PROCEDURE Update_pick_serial_lots(
123: P_Api_Version_Number IN NUMBER,
124: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
125: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
126: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
127: P_Identity_Salesforce_Id IN NUMBER := NULL,
128: P_psl_Rec IN psl_Rec_Type,
129: X_Return_Status OUT NOCOPY VARCHAR2,
130: X_Msg_Count OUT NOCOPY NUMBER,

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

139: -- Pre-Req :
140: -- Parameters:
141: -- IN
142: -- p_api_version_number IN NUMBER Required
143: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
144: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
145: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
146: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
147: -- P_psl_Rec IN psl_Rec_Type Required

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

140: -- Parameters:
141: -- IN
142: -- p_api_version_number IN NUMBER Required
143: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
144: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
145: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
146: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
147: -- P_psl_Rec IN psl_Rec_Type Required
148: --

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

141: -- IN
142: -- p_api_version_number IN NUMBER Required
143: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
144: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
145: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
146: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
147: -- P_psl_Rec IN psl_Rec_Type Required
148: --
149: -- OUT:

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

159: -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
160: -- The Master delete procedure may not be needed depends on different business requirements.
161: PROCEDURE Delete_pick_serial_lots(
162: P_Api_Version_Number IN NUMBER,
163: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
164: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
165: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
166: P_identity_salesforce_id IN NUMBER := NULL,
167: P_psl_Rec IN psl_Rec_Type,

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

160: -- The Master delete procedure may not be needed depends on different business requirements.
161: PROCEDURE Delete_pick_serial_lots(
162: P_Api_Version_Number IN NUMBER,
163: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
164: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
165: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
166: P_identity_salesforce_id IN NUMBER := NULL,
167: P_psl_Rec IN psl_Rec_Type,
168: X_Return_Status OUT NOCOPY VARCHAR2,

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

161: PROCEDURE Delete_pick_serial_lots(
162: P_Api_Version_Number IN NUMBER,
163: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
164: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
165: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
166: P_identity_salesforce_id IN NUMBER := NULL,
167: P_psl_Rec IN psl_Rec_Type,
168: X_Return_Status OUT NOCOPY VARCHAR2,
169: X_Msg_Count OUT NOCOPY NUMBER,

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

181: --
182: -- End of Comments
183:
184: PROCEDURE Validate_PL_SERIAL_LOT_ID (
185: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
186: P_Validation_mode IN VARCHAR2,
187: P_PICKLIST_SERIAL_LOT_ID IN NUMBER,
188: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
189: X_Return_Status OUT NOCOPY VARCHAR2,

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

202: --
203: -- End of Comments
204:
205: PROCEDURE Validate_PICKLIST_LINE_ID (
206: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
207: P_Validation_mode IN VARCHAR2,
208: P_PICKLIST_LINE_ID IN NUMBER,
209: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
210: X_Return_Status OUT NOCOPY VARCHAR2,

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

223: --
224: -- End of Comments
225:
226: PROCEDURE Validate_ORGANIZATION_ID (
227: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
228: P_Validation_mode IN VARCHAR2,
229: P_ORGANIZATION_ID IN NUMBER,
230: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
231: X_Return_Status OUT NOCOPY VARCHAR2,

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

244: --
245: -- End of Comments
246:
247: PROCEDURE Validate_INVENTORY_ITEM_ID (
248: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
249: P_Validation_mode IN VARCHAR2,
250: P_INVENTORY_ITEM_ID IN NUMBER,
251: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
252: X_Return_Status OUT NOCOPY VARCHAR2,

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

265: --
266: -- End of Comments
267:
268: PROCEDURE Validate_QUANTITY (
269: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
270: P_Validation_mode IN VARCHAR2,
271: P_QUANTITY IN NUMBER,
272: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
273: X_Return_Status OUT NOCOPY VARCHAR2,

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

286: --
287: -- End of Comments
288:
289: PROCEDURE Validate_LOT_NUMBER (
290: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
291: P_Validation_mode IN VARCHAR2,
292: P_LOT_NUMBER IN VARCHAR2,
293: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
294: X_Return_Status OUT NOCOPY VARCHAR2,

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

307: --
308: -- End of Comments
309:
310: PROCEDURE Validate_SERIAL_NUMBER (
311: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
312: P_Validation_mode IN VARCHAR2,
313: P_SERIAL_NUMBER IN VARCHAR2,
314: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
315: X_Return_Status OUT NOCOPY VARCHAR2,

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

328: -- 2. Developer can manually added inter-field level validation.
329: -- End of Comments
330:
331: PROCEDURE Validate_psl_rec(
332: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
333: P_Validation_mode IN VARCHAR2,
334: P_psl_Rec IN psl_Rec_Type,
335: X_Return_Status OUT NOCOPY VARCHAR2,
336: X_Msg_Count OUT NOCOPY NUMBER,

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

348: -- 2. We can also validate table instead of record. There will be an option for user to choose.
349: -- End of Comments
350:
351: PROCEDURE Validate_pick_serial_lots(
352: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
353: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
354: P_Validation_mode IN VARCHAR2,
355: P_psl_Rec IN psl_Rec_Type,
356: X_Return_Status OUT NOCOPY VARCHAR2,

Line 353: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

349: -- End of Comments
350:
351: PROCEDURE Validate_pick_serial_lots(
352: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
353: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
354: P_Validation_mode IN VARCHAR2,
355: P_psl_Rec IN psl_Rec_Type,
356: X_Return_Status OUT NOCOPY VARCHAR2,
357: X_Msg_Count OUT NOCOPY NUMBER,