DBA Data[Home] [Help]

APPS.WMA_COMPLETION dependencies on WMA_COMMON

Line 472: item wma_common.Item;

468: parameters IN CmpParams,
469: txnMode IN NUMBER,
470: errMessage IN OUT NOCOPY VARCHAR2)
471: return boolean IS
472: item wma_common.Item;
473: job wma_common.Job;
474: lastOpSeq NUMBER;
475: periodID NUMBER;
476: availableQty NUMBER;

Line 473: job wma_common.Job;

469: txnMode IN NUMBER,
470: errMessage IN OUT NOCOPY VARCHAR2)
471: return boolean IS
472: item wma_common.Item;
473: job wma_common.Job;
474: lastOpSeq NUMBER;
475: periodID NUMBER;
476: availableQty NUMBER;
477: openPastPeriod BOOLEAN := false;

Line 637: cmpRecord.source_code := wma_common.SERIALIZATION_SOURCE_CODE;

633: cmpRecord.completion_transaction_id := parameters.cmpTransactionID;
634: cmpRecord.created_by := parameters.environment.userID;
635: cmpRecord.creation_date := sysdate;
636: if ( parameters.isFromSerializedPage = 1 ) then
637: cmpRecord.source_code := wma_common.SERIALIZATION_SOURCE_CODE;
638: else
639: cmpRecord.source_code := wma_common.SOURCE_CODE;
640: end if;
641: cmpRecord.source_header_id := -1;

Line 639: cmpRecord.source_code := wma_common.SOURCE_CODE;

635: cmpRecord.creation_date := sysdate;
636: if ( parameters.isFromSerializedPage = 1 ) then
637: cmpRecord.source_code := wma_common.SERIALIZATION_SOURCE_CODE;
638: else
639: cmpRecord.source_code := wma_common.SOURCE_CODE;
640: end if;
641: cmpRecord.source_header_id := -1;
642: cmpRecord.source_line_id := -1;
643: -- cmpRecord.lock_flag := 'N';

Line 771: item wma_common.Item;

767: Function derive(LpnCmpRecord IN OUT NOCOPY LpnCmpTxnRec,
768: parameters IN LpnCmpParams,
769: errMessage IN OUT NOCOPY VARCHAR2)
770: return boolean IS
771: item wma_common.Item;
772: job wma_common.Job;
773: lastOpSeq NUMBER;
774: periodID NUMBER;
775: availableQty NUMBER;

Line 772: job wma_common.Job;

768: parameters IN LpnCmpParams,
769: errMessage IN OUT NOCOPY VARCHAR2)
770: return boolean IS
771: item wma_common.Item;
772: job wma_common.Job;
773: lastOpSeq NUMBER;
774: periodID NUMBER;
775: availableQty NUMBER;
776: openPastPeriod BOOLEAN := false;

Line 944: job IN wma_common.Job,

940: * Returns:
941: * boolean flag indicating if validation is successful
942: */
943: FUNCTION checkQuantity (parameters IN CmpParams,
944: job IN wma_common.Job,
945: errMessage IN OUT NOCOPY VARCHAR2) return boolean
946: IS
947: availableQty NUMBER;
948: status BOOLEAN;

Line 1187: FUNCTION getLastOpSeq (job IN wma_common.Job) return number

1183: * job job to get the last operation sequence for.
1184: * Returns:
1185: * number the last operation sequence. -1 if it doesn't exist.
1186: */
1187: FUNCTION getLastOpSeq (job IN wma_common.Job) return number
1188: IS
1189: lastOpSeq NUMBER;
1190: BEGIN
1191: lastOpSeq := getLastOpSeq (job.wipEntityID, job.organizationID);

Line 1242: FUNCTION getAvailableQty (job IN wma_common.Job) return number

1238: * job job to find the available quantity for.
1239: * Returns:
1240: * number the available quantity in the job.
1241: */
1242: FUNCTION getAvailableQty (job IN wma_common.Job) return number
1243: IS
1244: lastOpSeq NUMBER;
1245: availableQty NUMBER;
1246:

Line 1455: WMA_COMMON.SOURCE_CODE,

1451: qa_collection_id, kanban_card_id, lpn_id,
1452: end_item_unit_number, completion_transaction_id)
1453: values (lpnCmpRecord.row.header_id,
1454: lpnCmpRecord.row.header_id,
1455: WMA_COMMON.SOURCE_CODE,
1456: lpnCmpRecord.row.transaction_mode,
1457: lpnCmpRecord.row.created_by,
1458: lpnCmpRecord.row.creation_date,
1459: lpnCmpRecord.row.lock_flag,