eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.EGO_EXT_FWK_PUB dependencies on DUAL

Line 615: FROM dual;

611: IF p_transaction_type = 'CREATE' THEN
612: -- create an translatable independent value set
613: SELECT fnd_flex_values_s.NEXTVAL
614: INTO l_flex_value_id
615: FROM dual;
616: FND_FLEX_VALUES_PKG.INSERT_ROW
617: (x_rowid => l_rowid
618: ,x_flex_value_id => l_flex_value_id
619: ,x_attribute_sort_order => NULL

Line 1372: SELECT EGO_DB_COL_INDEX_S.NEXTVAL INTO l_index_name FROM DUAL;

1368: WHERE OBJECT_ID = (SELECT OBJECT_ID
1369: FROM EGO_OBJECT_EXT_TABLES_B
1370: WHERE EXT_TABLE_NAME = p_table_name));
1371:
1372: SELECT EGO_DB_COL_INDEX_S.NEXTVAL INTO l_index_name FROM DUAL;
1373: l_chg_index_name:=l_index_name; --for the index name of pending table.
1374: l_index_name := 'ag_'||p_column||'_n'||l_index_name;
1375: l_chg_index_name := 'ag_pdg_'||p_column||'_n'||l_chg_index_name;--index name for the pending table.
1376:

Line 2327: SELECT EGO_ATTR_GROUPS_S.NEXTVAL INTO x_attr_group_id FROM DUAL;

2323: global_flag => 'N');
2324: END IF;--l_fnd_exists = 'Y' Bug 4703510:END
2325:
2326: IF (l_ego_exists <> 'Y' ) THEN
2327: SELECT EGO_ATTR_GROUPS_S.NEXTVAL INTO x_attr_group_id FROM DUAL;
2328: INSERT INTO EGO_FND_DSC_FLX_CTX_EXT
2329: (
2330: ATTR_GROUP_ID
2331: ,APPLICATION_ID

Line 4972: EXECUTE IMMEDIATE 'SELECT NULL AS ' || p_internal_name || ' FROM DUAL';

4968: -- Vkeerthi - Fix for bug 5884003.
4969: -- Checking if Attribute's internal name is a keyword.
4970: IF (p_internal_name IS NOT NULL) THEN
4971: BEGIN
4972: EXECUTE IMMEDIATE 'SELECT NULL AS ' || p_internal_name || ' FROM DUAL';
4973: EXCEPTION
4974: WHEN OTHERS THEN
4975: RAISE e_col_internal_name_error;
4976: END;

Line 5424: FROM DUAL;

5420: ,p_lud -- CREATION_DATE
5421: ,NVL(p_owner, g_current_user_id) -- LAST_UPDATED_BY
5422: ,p_lud -- LAST_UPDATE_DATE
5423: ,g_current_login_id -- LAST_UPDATE_LOGIN
5424: FROM DUAL;
5425:
5426: -- Standard check of p_commit
5427: IF FND_API.To_Boolean(p_commit) THEN
5428: COMMIT WORK;

Line 7129: FROM dual;

7125: , p_owner -- LAST_UPDATED_BY
7126: , SYSDATE -- LAST_UPDATE_DATE
7127: , g_current_login_id -- LAST_UPDATE_LOGIN
7128: INTO l_vs_value_disp_orders(i)
7129: FROM dual;
7130: END IF;
7131: END LOOP;
7132:
7133: -- Delete all the existing values from the child VS

Line 8411: EXECUTE IMMEDIATE 'SELECT EGO_STYLE_SKU_ITEM_PVT.IsStyle_Item_Exist_For_ICC(:1) FROM DUAL'

8407: WHERE OBJECT_ID = p_object_id
8408: AND OBJ_NAME = 'EGO_ITEM';
8409:
8410: IF(l_dummy_number IS NOT NULL) THEN
8411: EXECUTE IMMEDIATE 'SELECT EGO_STYLE_SKU_ITEM_PVT.IsStyle_Item_Exist_For_ICC(:1) FROM DUAL'
8412: INTO l_style_exists USING IN To_Number(p_classification_code);
8413: END IF;
8414:
8415: EXCEPTION

Line 8439: --SELECT EGO_ASSOCS_S.NEXTVAL INTO x_association_id FROM DUAL;

8435:
8436:
8437: --if association id is not provided, get association id from sequence
8438: --IF( p_association_id IS NULL ) THEN
8439: --SELECT EGO_ASSOCS_S.NEXTVAL INTO x_association_id FROM DUAL;
8440: --ELSE
8441: IF(p_association_id IS NOT NULL AND p_association_id > 0) THEN
8442: x_association_id := p_association_id;
8443: END IF;

Line 9298: SELECT EGO_PAGES_S.NEXTVAL INTO x_page_id FROM DUAL;

9294: END IF;
9295:
9296: --if page id is not provided, get page id from sequence
9297: IF( p_page_id IS NULL ) THEN
9298: SELECT EGO_PAGES_S.NEXTVAL INTO x_page_id FROM DUAL;
9299: ELSE
9300: x_page_id := p_page_id;
9301: END IF;
9302:

Line 10174: SELECT EGO_FUNCTIONS_S.NEXTVAL INTO x_function_id FROM DUAL;

10170: IF FND_API.To_Boolean(p_init_msg_list) THEN
10171: FND_MSG_PUB.Initialize;
10172: END IF;
10173:
10174: SELECT EGO_FUNCTIONS_S.NEXTVAL INTO x_function_id FROM DUAL;
10175:
10176: INSERT INTO EGO_FUNCTIONS_B
10177: (
10178: FUNCTION_ID

Line 10525: SELECT EGO_ACTIONS_S.NEXTVAL INTO x_action_id FROM DUAL;

10521: IF FND_API.To_Boolean(p_init_msg_list) THEN
10522: FND_MSG_PUB.Initialize;
10523: END IF;
10524:
10525: SELECT EGO_ACTIONS_S.NEXTVAL INTO x_action_id FROM DUAL;
10526:
10527: -- Ensure created action's name or sequence number do not
10528: -- match those of an action already associated with the
10529: -- classification/attribute pair.

Line 11853: SELECT EGO_FUNC_PARAMS_S.NEXTVAL INTO x_function_param_id FROM DUAL;

11849: IF FND_API.To_Boolean(p_init_msg_list) THEN
11850: FND_MSG_PUB.Initialize;
11851: END IF;
11852:
11853: SELECT EGO_FUNC_PARAMS_S.NEXTVAL INTO x_function_param_id FROM DUAL;
11854:
11855: INSERT INTO EGO_FUNC_PARAMS_B
11856: (
11857: FUNC_PARAM_ID

Line 12632: -- call this API to delete an individual parameter mapping

12628: END Delete_Func_Mapping;
12629:
12630: ----------------------------------------------------------------------
12631:
12632: -- call this API to delete an individual parameter mapping
12633: PROCEDURE Delete_Func_Param_Mapping (
12634: p_api_version IN NUMBER
12635: ,p_function_id IN NUMBER
12636: ,p_mapped_obj_type IN VARCHAR2

Line 12757: SELECT EGO_ACTION_GROUPS_S.NEXTVAL INTO x_action_group_id FROM DUAL;

12753: IF FND_API.To_Boolean(p_init_msg_list) THEN
12754: FND_MSG_PUB.Initialize;
12755: END IF;
12756:
12757: SELECT EGO_ACTION_GROUPS_S.NEXTVAL INTO x_action_group_id FROM DUAL;
12758:
12759: INSERT INTO EGO_ACTION_GROUPS_B
12760: (
12761: ACTION_GROUP_ID

Line 13830: l_dynamic_sql := 'CREATE OR REPLACE VIEW '|| l_agv_name ||' AS SELECT * FROM DUAL';

13826: CLOSE c_check_obj_name;
13827:
13828: --Test with this dummy Query for the validity of the view name
13829: --It should not be a reserve word
13830: l_dynamic_sql := 'CREATE OR REPLACE VIEW '|| l_agv_name ||' AS SELECT * FROM DUAL';
13831: EXECUTE IMMEDIATE l_dynamic_sql;
13832:
13833: -- Syalaman - Fix for bug 5911824
13834: -- Droping the dummy view created in above statement so that