DBA Data[Home] [Help]

APPS.INV_PROCESS_TEMP dependencies on INV_VALIDATE

Line 14: l_org INV_Validate.ORG;

10: status NUMBER := 1;
11: hasErrors BOOLEAN := FALSE;
12: l_txnrecs TXNRECS;
13: l_txnrecord TXNREC;
14: l_org INV_Validate.ORG;
15: l_item INV_Validate.ITEM;
16: l_openAcctPeriod NUMBER;
17:
18: l_row_count NUMBER;

Line 15: l_item INV_Validate.ITEM;

11: hasErrors BOOLEAN := FALSE;
12: l_txnrecs TXNRECS;
13: l_txnrecord TXNREC;
14: l_org INV_Validate.ORG;
15: l_item INV_Validate.ITEM;
16: l_openAcctPeriod NUMBER;
17:
18: l_row_count NUMBER;
19: l_errorTolerance NUMBER;

Line 202: status := INV_Validate.Organization(l_org);

198: FETCH l_txnrecs INTO l_txnrecord;
199: EXIT WHEN l_TXNRECS%NOTFOUND;
200: -- get key entity objects
201: l_org.organization_id := l_txnrecord.organization_id;
202: status := INV_Validate.Organization(l_org);
203:
204: l_item.organization_id := l_txnrecord.organization_id;
205: l_item.inventory_item_id := l_txnrecord.inventory_item_id;
206: status := INV_Validate.Inventory_Item(l_item,l_org);

Line 206: status := INV_Validate.Inventory_Item(l_item,l_org);

202: status := INV_Validate.Organization(l_org);
203:
204: l_item.organization_id := l_txnrecord.organization_id;
205: l_item.inventory_item_id := l_txnrecord.inventory_item_id;
206: status := INV_Validate.Inventory_Item(l_item,l_org);
207:
208: status := validateLOT(l_txnrecord,l_org,l_item);
209: status := validateUnitNumber(l_txnrecord);
210:

Line 1291: org IN INV_Validate.ORG,

1287: END validateFreightInfo;
1288:
1289: /* validates lot details */
1290: FUNCTION validateLOT(txnrec IN TXNREC,
1291: org IN INV_Validate.ORG,
1292: item IN INV_Validate.ITEM) RETURN NUMBER
1293: IS
1294: CURSOR LOT_DETAILS(txnTempID
1295: MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_TEMP_ID%TYPE) IS

Line 1292: item IN INV_Validate.ITEM) RETURN NUMBER

1288:
1289: /* validates lot details */
1290: FUNCTION validateLOT(txnrec IN TXNREC,
1291: org IN INV_Validate.ORG,
1292: item IN INV_Validate.ITEM) RETURN NUMBER
1293: IS
1294: CURSOR LOT_DETAILS(txnTempID
1295: MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_TEMP_ID%TYPE) IS
1296: SELECT LOT_NUMBER,