APPS.EGO_RULE_SETS_PKG dependencies on DUAL

Line 412: select EGO_RULE_SETS_S.nextval into X_RULESET_ID from dual;

408:
409: LOG_MSG('RULESET_SUCCESS', 'Ruleset: ' || X_RULESET_NAME || ' updated successfully!');
410: elsif (X_RULESET_ID is null) then
411:
412: select EGO_RULE_SETS_S.nextval into X_RULESET_ID from dual;
413:
414: insert into EGO_RULE_SETS_B (
415: RULESET_ID,
416: RULESET_NAME,

Line 881: select EGO_RULE_SETS_S.nextval into l_ruleset_id from dual;

877: );
878:
879: exception
880: when NO_DATA_FOUND then
881: select EGO_RULE_SETS_S.nextval into l_ruleset_id from dual;
882:
883: EGO_RULE_SETS_PKG.INSERT_ROW(
884: X_ROWID => X_ROWID,
885: X_RULESET_ID => l_ruleset_id,

Line 930: SELECT decode(l_selected_business_entity, 'ITEM_LEVEL', 43101, 'ITEM_ORG', 43102, 'ITEM_SUP', 43103, 'ITEM_SUP_SITE', 43104, 'ITEM_SUP_SITE_ORG', 43105, 'ITEM_REVISION_LEVEL', 43106, -1) INTO l_datalevel_id FROM dual;

926: and not exists (select 'x' from ego_mtl_sy_items_ext_b where organization_id = p_org_id and inventory_item_id = p_inventory_item_id and item_catalog_group_id = p_icc_id and attr_group_id = assoc.attr_group_id and data_level_id = p_datalevel_id);
927: BEGIN
928: SELECT top_ruleset_id INTO l_top_ruleset_id FROM EGO_ONDEMAND_RULES_BATCHS_B WHERE batch_id = p_batch_id;
929: SELECT business_entity INTO l_selected_business_entity FROM EGO_ONDEMAND_RULES_BATCHS_B WHERE batch_id = p_batch_id;
930: SELECT decode(l_selected_business_entity, 'ITEM_LEVEL', 43101, 'ITEM_ORG', 43102, 'ITEM_SUP', 43103, 'ITEM_SUP_SITE', 43104, 'ITEM_SUP_SITE_ORG', 43105, 'ITEM_REVISION_LEVEL', 43106, -1) INTO l_datalevel_id FROM dual;
931: IF l_datalevel_id > 0 THEN
932: OPEN l_cursor_batch_items(p_batch_id);
933: loop
934: fetch l_cursor_batch_items INTO l_batch_item_rec;

Line 953: SELECT EGO_EXTFWK_S.NEXTVAL INTO l_ext_id FROM dual;

949: exit WHEN c_default_ag%NOTFOUND;
950:
951: SELECT multi_row_code INTO l_multi_row_code FROM ego_attr_groups_v WHERE attr_group_id = l_ag_id;
952: IF l_multi_row_code <> 'Y' THEN
953: SELECT EGO_EXTFWK_S.NEXTVAL INTO l_ext_id FROM dual;
954: --insert ext data
955: INSERT INTO ego_mtl_sy_items_ext_b(extension_id, organization_id, inventory_item_id, item_catalog_group_id, attr_group_id, data_level_id, created_by, creation_date, last_updated_by, last_update_date, revision_id, pk1_value, pk2_value)
956: VALUES (l_ext_id, l_batch_item_rec.organization_id, l_batch_item_rec.inventory_item_id, l_batch_item_rec.item_catalog_group_id, l_ag_id, l_datalevel_id, 1, SYSDATE, 1, SYSDATE, l_revision_id, l_supplier_id, l_supplier_site_id);
957: --inert language data