DBA Data[Home] [Help]

APPS.INV_ITEM_REVISION_PUB dependencies on BOM_GLOBALS

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

2427:
2428: FETCH Item_Revision_Exists_cur INTO l_object_version_number;
2429:
2430: IF ( Item_Revision_Exists_cur%FOUND ) THEN
2431: l_item_revision_rec.transaction_type := Bom_Globals.G_OPR_UPDATE;
2432: ELSE
2433: l_item_revision_rec.transaction_type := Bom_Globals.G_OPR_CREATE;
2434: END IF;
2435:

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

2429:
2430: IF ( Item_Revision_Exists_cur%FOUND ) THEN
2431: l_item_revision_rec.transaction_type := Bom_Globals.G_OPR_UPDATE;
2432: ELSE
2433: l_item_revision_rec.transaction_type := Bom_Globals.G_OPR_CREATE;
2434: END IF;
2435:
2436: CLOSE Item_Revision_Exists_cur;
2437:

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

2442: END IF;
2443:
2444: -- Validate the transaction type
2445:
2446: IF l_item_revision_rec.transaction_type NOT IN (Bom_Globals.G_OPR_CREATE,
2447: Bom_Globals.G_OPR_UPDATE,
2448: Bom_Globals.G_OPR_DELETE) THEN
2449:
2450: Add_Message ('INV', 'INV_INVALID_TRANS_TYPE');

Line 2447: Bom_Globals.G_OPR_UPDATE,

2443:
2444: -- Validate the transaction type
2445:
2446: IF l_item_revision_rec.transaction_type NOT IN (Bom_Globals.G_OPR_CREATE,
2447: Bom_Globals.G_OPR_UPDATE,
2448: Bom_Globals.G_OPR_DELETE) THEN
2449:
2450: Add_Message ('INV', 'INV_INVALID_TRANS_TYPE');
2451: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;

Line 2448: Bom_Globals.G_OPR_DELETE) THEN

2444: -- Validate the transaction type
2445:
2446: IF l_item_revision_rec.transaction_type NOT IN (Bom_Globals.G_OPR_CREATE,
2447: Bom_Globals.G_OPR_UPDATE,
2448: Bom_Globals.G_OPR_DELETE) THEN
2449:
2450: Add_Message ('INV', 'INV_INVALID_TRANS_TYPE');
2451: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;
2452:

Line 2474: IF l_item_revision_rec.transaction_type = Bom_Globals.G_OPR_CREATE

2470: Return;
2471:
2472: END IF;
2473:
2474: IF l_item_revision_rec.transaction_type = Bom_Globals.G_OPR_CREATE
2475: AND p_revision_id IS NOT NULL THEN
2476: l_item_revision_rec.revision_id := p_revision_id;
2477: END IF;
2478:

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

2476: l_item_revision_rec.revision_id := p_revision_id;
2477: END IF;
2478:
2479: -- Create the record structure from the individual parameters for CREATE and UPDATE
2480: IF l_item_revision_rec.transaction_type IN (Bom_Globals.G_OPR_CREATE,
2481: Bom_Globals.G_OPR_UPDATE)
2482: THEN
2483: l_item_revision_rec.inventory_item_id := p_inventory_item_id;
2484: l_item_revision_rec.organization_id := p_organization_id;

Line 2481: Bom_Globals.G_OPR_UPDATE)

2477: END IF;
2478:
2479: -- Create the record structure from the individual parameters for CREATE and UPDATE
2480: IF l_item_revision_rec.transaction_type IN (Bom_Globals.G_OPR_CREATE,
2481: Bom_Globals.G_OPR_UPDATE)
2482: THEN
2483: l_item_revision_rec.inventory_item_id := p_inventory_item_id;
2484: l_item_revision_rec.organization_id := p_organization_id;
2485: l_item_revision_rec.revision := p_revision;

Line 2524: IF l_item_revision_rec.transaction_type = Bom_Globals.G_OPR_CREATE

2520: END IF;
2521:
2522: -- Call the appropriate procedure to carry out the transaction
2523:
2524: IF l_item_revision_rec.transaction_type = Bom_Globals.G_OPR_CREATE
2525: THEN
2526:
2527: --dbms_output.put_line('Calling Create ...');
2528:

Line 2540: ELSIF l_item_revision_rec.transaction_type = Bom_Globals.G_OPR_UPDATE

2536: , p_Item_Revision_rec => l_item_revision_rec
2537: , p_process_control => p_process_control
2538: );
2539:
2540: ELSIF l_item_revision_rec.transaction_type = Bom_Globals.G_OPR_UPDATE
2541: THEN
2542:
2543: --dbms_output.put_line('Calling Update ...');
2544: l_item_revision_rec.revision_id := p_revision_id;

Line 2597: --IF (l_item_revision_rec.transaction_type = Bom_Globals.G_OPR_CREATE or l_inherit =1) Then

2593: to item structure. Added as part of PIM for Telco enhancements. */
2594:
2595: -- bug 8986750, save the msg before calling inherit_icc_components
2596: x_msg_data := l_msg_data;
2597: --IF (l_item_revision_rec.transaction_type = Bom_Globals.G_OPR_CREATE or l_inherit =1) Then
2598: -- start Bug 13865319 added and condition
2599: IF (l_item_revision_rec.transaction_type = Bom_Globals.G_OPR_CREATE or l_inherit =1) AND (x_return_status = FND_API. G_RET_STS_SUCCESS) Then
2600: -- end Bug 13865319 added and condition
2601:

Line 2599: IF (l_item_revision_rec.transaction_type = Bom_Globals.G_OPR_CREATE or l_inherit =1) AND (x_return_status = FND_API. G_RET_STS_SUCCESS) Then

2595: -- bug 8986750, save the msg before calling inherit_icc_components
2596: x_msg_data := l_msg_data;
2597: --IF (l_item_revision_rec.transaction_type = Bom_Globals.G_OPR_CREATE or l_inherit =1) Then
2598: -- start Bug 13865319 added and condition
2599: IF (l_item_revision_rec.transaction_type = Bom_Globals.G_OPR_CREATE or l_inherit =1) AND (x_return_status = FND_API. G_RET_STS_SUCCESS) Then
2600: -- end Bug 13865319 added and condition
2601:
2602: EGO_ICC_STRUCTURE_PVT.inherit_icc_components(
2603: p_inventory_item_id => p_inventory_item_id,