DBA Data[Home] [Help]

APPS.INV_ITEM_REVISION_PUB dependencies on BOM_GLOBALS

Line 2366: l_item_revision_rec.transaction_type := Bom_Globals.G_OPR_UPDATE;

2362:
2363: FETCH Item_Revision_Exists_cur INTO l_object_version_number;
2364:
2365: IF ( Item_Revision_Exists_cur%FOUND ) THEN
2366: l_item_revision_rec.transaction_type := Bom_Globals.G_OPR_UPDATE;
2367: ELSE
2368: l_item_revision_rec.transaction_type := Bom_Globals.G_OPR_CREATE;
2369: END IF;
2370:

Line 2368: l_item_revision_rec.transaction_type := Bom_Globals.G_OPR_CREATE;

2364:
2365: IF ( Item_Revision_Exists_cur%FOUND ) THEN
2366: l_item_revision_rec.transaction_type := Bom_Globals.G_OPR_UPDATE;
2367: ELSE
2368: l_item_revision_rec.transaction_type := Bom_Globals.G_OPR_CREATE;
2369: END IF;
2370:
2371: CLOSE Item_Revision_Exists_cur;
2372:

Line 2381: IF l_item_revision_rec.transaction_type NOT IN (Bom_Globals.G_OPR_CREATE,

2377: END IF;
2378:
2379: -- Validate the transaction type
2380:
2381: IF l_item_revision_rec.transaction_type NOT IN (Bom_Globals.G_OPR_CREATE,
2382: Bom_Globals.G_OPR_UPDATE,
2383: Bom_Globals.G_OPR_DELETE) THEN
2384:
2385: Add_Message ('INV', 'INV_INVALID_TRANS_TYPE');

Line 2382: Bom_Globals.G_OPR_UPDATE,

2378:
2379: -- Validate the transaction type
2380:
2381: IF l_item_revision_rec.transaction_type NOT IN (Bom_Globals.G_OPR_CREATE,
2382: Bom_Globals.G_OPR_UPDATE,
2383: Bom_Globals.G_OPR_DELETE) THEN
2384:
2385: Add_Message ('INV', 'INV_INVALID_TRANS_TYPE');
2386: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;

Line 2383: Bom_Globals.G_OPR_DELETE) THEN

2379: -- Validate the transaction type
2380:
2381: IF l_item_revision_rec.transaction_type NOT IN (Bom_Globals.G_OPR_CREATE,
2382: Bom_Globals.G_OPR_UPDATE,
2383: Bom_Globals.G_OPR_DELETE) THEN
2384:
2385: Add_Message ('INV', 'INV_INVALID_TRANS_TYPE');
2386: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;
2387:

Line 2409: IF l_item_revision_rec.transaction_type = Bom_Globals.G_OPR_CREATE

2405: Return;
2406:
2407: END IF;
2408:
2409: IF l_item_revision_rec.transaction_type = Bom_Globals.G_OPR_CREATE
2410: AND p_revision_id IS NOT NULL THEN
2411: l_item_revision_rec.revision_id := p_revision_id;
2412: END IF;
2413:

Line 2415: IF l_item_revision_rec.transaction_type IN (Bom_Globals.G_OPR_CREATE,

2411: l_item_revision_rec.revision_id := p_revision_id;
2412: END IF;
2413:
2414: -- Create the record structure from the individual parameters for CREATE and UPDATE
2415: IF l_item_revision_rec.transaction_type IN (Bom_Globals.G_OPR_CREATE,
2416: Bom_Globals.G_OPR_UPDATE)
2417: THEN
2418: l_item_revision_rec.inventory_item_id := p_inventory_item_id;
2419: l_item_revision_rec.organization_id := p_organization_id;

Line 2416: Bom_Globals.G_OPR_UPDATE)

2412: END IF;
2413:
2414: -- Create the record structure from the individual parameters for CREATE and UPDATE
2415: IF l_item_revision_rec.transaction_type IN (Bom_Globals.G_OPR_CREATE,
2416: Bom_Globals.G_OPR_UPDATE)
2417: THEN
2418: l_item_revision_rec.inventory_item_id := p_inventory_item_id;
2419: l_item_revision_rec.organization_id := p_organization_id;
2420: l_item_revision_rec.revision := p_revision;

Line 2459: IF l_item_revision_rec.transaction_type = Bom_Globals.G_OPR_CREATE

2455: END IF;
2456:
2457: -- Call the appropriate procedure to carry out the transaction
2458:
2459: IF l_item_revision_rec.transaction_type = Bom_Globals.G_OPR_CREATE
2460: THEN
2461:
2462: --dbms_output.put_line('Calling Create ...');
2463:

Line 2475: ELSIF l_item_revision_rec.transaction_type = Bom_Globals.G_OPR_UPDATE

2471: , p_Item_Revision_rec => l_item_revision_rec
2472: , p_process_control => p_process_control
2473: );
2474:
2475: ELSIF l_item_revision_rec.transaction_type = Bom_Globals.G_OPR_UPDATE
2476: THEN
2477:
2478: --dbms_output.put_line('Calling Update ...');
2479: l_item_revision_rec.revision_id := p_revision_id;