APPS.INV_ITEM_REVISION_PUB dependencies on DUAL

Line 877: INTO l_revision_id FROM DUAL;

873:
874: IF p_Item_Revision_rec.revision_id IS NOT NULL THEN
875: BEGIN
876: SELECT mtl_item_revisions_b_s.CURRVAL
877: INTO l_revision_id FROM DUAL;
878: IF p_Item_Revision_rec.revision_id > l_revision_id THEN
879: Add_Message ('INV', 'INV_INVALID_REVISION_ID');
880: RAISE FND_API.g_EXC_ERROR;
881: END IF;

Line 893: FROM DUAL;

889: IF p_Item_Revision_rec.revision_id IS NULL THEN
890:
891: SELECT mtl_item_revisions_b_s.NEXTVAL
892: INTO p_Item_Revision_rec.revision_id
893: FROM DUAL;
894:
895: END IF;
896:
897: --INV_ITEM_MSG.Debug(Mctx, 'INSERT INTO mtl_item_revisions table');

Line 992: SELECT userenv('LANG') INTO G_language_code FROM dual;

988: -- then get the language code
989: --
990:
991: IF G_language_code IS NULL THEN
992: SELECT userenv('LANG') INTO G_language_code FROM dual;
993: END IF;
994:
995: -- Insert into TL table
996:

Line 1715: SELECT userenv('LANG') INTO G_language_code FROM dual;

1711: -- then get the language code
1712: --
1713:
1714: IF G_language_code IS NULL THEN
1715: SELECT userenv('LANG') INTO G_language_code FROM dual;
1716: END IF;
1717:
1718: -- Update the description in the TL table
1719: --

Line 2414: -- Create the record structure from the individual parameters for CREATE and UPDATE

2410: AND p_revision_id IS NOT NULL THEN
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;