[Home] [Help]
208: p_TASK_GROUP_ID IN NUMBER := FND_API.G_MISS_NUM,
209: p_PICK_SLIP_NUMBER IN NUMBER := FND_API.G_MISS_NUM,
210: p_RESERVATION_ID IN NUMBER := FND_API.G_MISS_NUM,
211: p_TRANSACTION_STATUS IN NUMBER := FND_API.G_MISS_NUM,
212: P_STANDARD_OPERATION_ID IN NUMBER := FND_API.G_MISS_NUM,
213: P_TASK_PRIORITY IN NUMBER := FND_API.G_MISS_NUM,
214: P_WMS_TASK_TYPE IN NUMBER := FND_API.G_MISS_NUM,
215: P_PARENT_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
216: -- P_SOURCE_LOT_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
232: l_last_update_date DATE := p_last_update_date;
233: l_csp_mtltxn_rec CSP_MATERIAL_TRANSACTIONS_PVT.CSP_Rec_Type;
234:
235: -- for inserting data, the validation_level should be none
236: -- because we do not want to call core apps standard validations.
237: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_NONE;
238: l_transaction_temp_id NUMBER;
239:
240:
244: -- initialize message list
245: FND_MSG_PUB.initialize;
246: END IF;
247:
248: -- Standard call to check for call compatibility.
249: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
250: p_api_version_number,
251: l_api_name,
252: G_PKG_NAME)
558: l_csp_mtltxn_rec.TASK_GROUP_ID := p_TASK_GROUP_ID;
559: l_csp_mtltxn_rec.PICK_SLIP_NUMBER := p_PICK_SLIP_NUMBER;
560: l_csp_mtltxn_rec.RESERVATION_ID := p_RESERVATION_ID;
561: l_csp_mtltxn_rec.TRANSACTION_STATUS := p_TRANSACTION_STATUS;
562: l_csp_mtltxn_rec.STANDARD_OPERATION_ID := p_STANDARD_OPERATION_ID;
563: l_csp_mtltxn_rec.TASK_PRIORITY := p_TASK_PRIORITY;
564: l_csp_mtltxn_rec.WMS_TASK_TYPE := p_WMS_TASK_TYPE;
565: l_csp_mtltxn_rec.PARENT_LINE_ID := p_PARENT_LINE_ID;
566: --l_csp_mtltxn_rec.SOURCE_LOT_NUMBER := p_SOURCE_LOT_NUMBER;
697: l_csp_mtltxn_rec CSP_MATERIAL_TRANSACTIONS_PVT.CSP_Rec_Type;
698: l_csp_mtltxn_new_rec CSP_MATERIAL_TRANSACTIONS_PVT.CSP_Rec_Type;
699:
700: -- for inserting data, the validation_level should be none
701: -- because we do not want to call core apps standard validations.
702: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_NONE;
703:
704: l_csp_intransit_subinventory VARCHAR2(20);
705: l_profile_option_id NUMBER;
897: TASK_GROUP_ID ,
898: PICK_SLIP_NUMBER ,
899: RESERVATION_ID ,
900: TRANSACTION_STATUS ,
901: STANDARD_OPERATION_ID ,
902: TASK_PRIORITY ,
903: -- ADDED by phegde 02/23
904: WMS_TASK_TYPE ,
905: PARENT_LINE_ID
924: -- initialize message list
925: FND_MSG_PUB.initialize;
926: END IF;
927:
928: -- Standard call to check for call compatibility.
929: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
930: p_api_version_number,
931: l_api_name,
932: G_PKG_NAME)
1335: l_last_update_date DATE;
1336: l_csp_mtltxn_rec CSP_MATERIAL_TRANSACTIONS_PVT.CSP_Rec_Type;
1337:
1338: -- for inserting data, the validation_level should be none
1339: -- because we do not want to call core apps standard validations.
1340: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_NONE;
1341: l_transaction_temp_id NUMBER;
1342:
1343: EXCP_USER_DEFINED EXCEPTION;
1530: TASK_GROUP_ID ,
1531: PICK_SLIP_NUMBER ,
1532: RESERVATION_ID ,
1533: TRANSACTION_STATUS ,
1534: STANDARD_OPERATION_ID ,
1535: TASK_PRIORITY ,
1536: -- ADDED by phegde 02/23
1537: WMS_TASK_TYPE ,
1538: PARENT_LINE_ID
1547: -- initialize message list
1548: FND_MSG_PUB.initialize;
1549: END IF;
1550:
1551: -- Standard call to check for call compatibility.
1552: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1553: p_api_version_number,
1554: l_api_name,
1555: G_PKG_NAME)