APPS.INV_ITEM_REVISION_PUB dependencies on DUAL

Line 932: INTO l_revision_id FROM DUAL;

928:
929: IF p_Item_Revision_rec.revision_id IS NOT NULL THEN
930: BEGIN
931: SELECT mtl_item_revisions_b_s.CURRVAL
932: INTO l_revision_id FROM DUAL;
933: IF p_Item_Revision_rec.revision_id > l_revision_id THEN
934: Add_Message ('INV', 'INV_INVALID_REVISION_ID');
935: RAISE FND_API.g_EXC_ERROR;
936: END IF;

Line 948: FROM DUAL;

944: IF p_Item_Revision_rec.revision_id IS NULL THEN
945:
946: SELECT mtl_item_revisions_b_s.NEXTVAL
947: INTO p_Item_Revision_rec.revision_id
948: FROM DUAL;
949:
950: END IF;
951:
952: --INV_ITEM_MSG.Debug(Mctx, 'INSERT INTO mtl_item_revisions table');

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

1043: -- then get the language code
1044: --
1045:
1046: IF G_language_code IS NULL THEN
1047: SELECT userenv('LANG') INTO G_language_code FROM dual;
1048: END IF;
1049:
1050: -- Insert into TL table
1051:

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

1773: -- then get the language code
1774: --
1775:
1776: IF G_language_code IS NULL THEN
1777: SELECT userenv('LANG') INTO G_language_code FROM dual;
1778: END IF;
1779:
1780: -- Update the description in the TL table
1781: --

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

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