DBA Data[Home] [Help]

APPS.WMA_COMPLETION dependencies on WMA_COMMON

Line 467: item wma_common.Item;

463: parameters IN CmpParams,
464: txnMode IN NUMBER,
465: errMessage IN OUT NOCOPY VARCHAR2)
466: return boolean IS
467: item wma_common.Item;
468: job wma_common.Job;
469: lastOpSeq NUMBER;
470: periodID NUMBER;
471: availableQty NUMBER;

Line 468: job wma_common.Job;

464: txnMode IN NUMBER,
465: errMessage IN OUT NOCOPY VARCHAR2)
466: return boolean IS
467: item wma_common.Item;
468: job wma_common.Job;
469: lastOpSeq NUMBER;
470: periodID NUMBER;
471: availableQty NUMBER;
472: openPastPeriod BOOLEAN := false;

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

628: cmpRecord.completion_transaction_id := parameters.cmpTransactionID;
629: cmpRecord.created_by := parameters.environment.userID;
630: cmpRecord.creation_date := sysdate;
631: if ( parameters.isFromSerializedPage = 1 ) then
632: cmpRecord.source_code := wma_common.SERIALIZATION_SOURCE_CODE;
633: else
634: cmpRecord.source_code := wma_common.SOURCE_CODE;
635: end if;
636: cmpRecord.source_header_id := -1;

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

630: cmpRecord.creation_date := sysdate;
631: if ( parameters.isFromSerializedPage = 1 ) then
632: cmpRecord.source_code := wma_common.SERIALIZATION_SOURCE_CODE;
633: else
634: cmpRecord.source_code := wma_common.SOURCE_CODE;
635: end if;
636: cmpRecord.source_header_id := -1;
637: cmpRecord.source_line_id := -1;
638: -- cmpRecord.lock_flag := 'N';

Line 766: item wma_common.Item;

762: Function derive(LpnCmpRecord IN OUT NOCOPY LpnCmpTxnRec,
763: parameters IN LpnCmpParams,
764: errMessage IN OUT NOCOPY VARCHAR2)
765: return boolean IS
766: item wma_common.Item;
767: job wma_common.Job;
768: lastOpSeq NUMBER;
769: periodID NUMBER;
770: availableQty NUMBER;

Line 767: job wma_common.Job;

763: parameters IN LpnCmpParams,
764: errMessage IN OUT NOCOPY VARCHAR2)
765: return boolean IS
766: item wma_common.Item;
767: job wma_common.Job;
768: lastOpSeq NUMBER;
769: periodID NUMBER;
770: availableQty NUMBER;
771: openPastPeriod BOOLEAN := false;

Line 935: job IN wma_common.Job,

931: * Returns:
932: * boolean flag indicating if validation is successful
933: */
934: FUNCTION checkQuantity (parameters IN CmpParams,
935: job IN wma_common.Job,
936: errMessage IN OUT NOCOPY VARCHAR2) return boolean
937: IS
938: availableQty NUMBER;
939: status BOOLEAN;

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

1174: * job job to get the last operation sequence for.
1175: * Returns:
1176: * number the last operation sequence. -1 if it doesn't exist.
1177: */
1178: FUNCTION getLastOpSeq (job IN wma_common.Job) return number
1179: IS
1180: lastOpSeq NUMBER;
1181: BEGIN
1182: lastOpSeq := getLastOpSeq (job.wipEntityID, job.organizationID);

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

1229: * job job to find the available quantity for.
1230: * Returns:
1231: * number the available quantity in the job.
1232: */
1233: FUNCTION getAvailableQty (job IN wma_common.Job) return number
1234: IS
1235: lastOpSeq NUMBER;
1236: availableQty NUMBER;
1237:

Line 1446: WMA_COMMON.SOURCE_CODE,

1442: qa_collection_id, kanban_card_id, lpn_id,
1443: end_item_unit_number, completion_transaction_id)
1444: values (lpnCmpRecord.row.header_id,
1445: lpnCmpRecord.row.header_id,
1446: WMA_COMMON.SOURCE_CODE,
1447: lpnCmpRecord.row.transaction_mode,
1448: lpnCmpRecord.row.created_by,
1449: lpnCmpRecord.row.creation_date,
1450: lpnCmpRecord.row.lock_flag,