[Home] [Help]
649: IF p_transaction_type = 'CREATE' THEN
650: -- create an translatable independent value set
651: SELECT fnd_flex_values_s.NEXTVAL
652: INTO l_flex_value_id
653: FROM dual;
654: FND_FLEX_VALUES_PKG.INSERT_ROW
655: (x_rowid => l_rowid
656: ,x_flex_value_id => l_flex_value_id
657: ,x_attribute_sort_order => NULL
1415: WHERE OBJECT_ID = (SELECT OBJECT_ID
1416: FROM EGO_OBJECT_EXT_TABLES_B
1417: WHERE EXT_TABLE_NAME = p_table_name));
1418:
1419: SELECT EGO_DB_COL_INDEX_S.NEXTVAL INTO l_index_name FROM DUAL;
1420: l_chg_index_name:=l_index_name; --for the index name of pending table.
1421: l_index_name := 'ag_'||p_column||'_n'||l_index_name;
1422: l_chg_index_name := 'ag_pdg_'||p_column||'_n'||l_chg_index_name;--index name for the pending table.
1423:
2408: END IF;--l_fnd_exists = 'Y' Bug 4703510:END
2409:
2410: IF (l_ego_exists <> 'Y' ) THEN
2411:
2412: SELECT EGO_ATTR_GROUPS_S.NEXTVAL INTO x_attr_group_id FROM DUAL;
2413: INSERT INTO EGO_FND_DSC_FLX_CTX_EXT
2414: (
2415: ATTR_GROUP_ID
2416: ,APPLICATION_ID
4089: -- sreharih. Mon Jun 18 11:26:32 PDT 2012
4090: --
4091:
4092: l_dynamic_sql := ' SELECT 1 ' ||
4093: ' FROM DUAL ' ||
4094: ' WHERE EXISTS (SELECT 1 FROM ' || l_ext_table_vl_name ||
4095: ' WHERE ATTR_GROUP_ID = :1' ||
4096: ' AND ROWNUM = 1 ' ||
4097: ' AND ' || l_curr_db_column || ' IS NOT NULL) ';
5176: -- Vkeerthi - Fix for bug 5884003.
5177: -- Checking if Attribute's internal name is a keyword.
5178: IF (p_internal_name IS NOT NULL) THEN
5179: BEGIN
5180: EXECUTE IMMEDIATE 'SELECT NULL AS ' || p_internal_name || ' FROM DUAL';
5181: EXCEPTION
5182: WHEN OTHERS THEN
5183: RAISE e_col_internal_name_error;
5184: END;
5628: ,p_lud -- CREATION_DATE
5629: ,NVL(p_owner, g_current_user_id) -- LAST_UPDATED_BY
5630: ,p_lud -- LAST_UPDATE_DATE
5631: ,g_current_login_id -- LAST_UPDATE_LOGIN
5632: FROM DUAL;
5633:
5634: -- Standard check of p_commit
5635: IF FND_API.To_Boolean(p_commit) THEN
5636: COMMIT WORK;
7862: -- copy the old creation info
7863: -- SSARNOBA: I'm not even sure if this is needed
7864:
7865: -- Bug 12382454 : Start
7866: -- select * instead of selecting individual columns
7867: /*
7868: SELECT
7869: value_set_value_id -- VALUE_SET_VALUE_ID
7870: , value_set_id -- VALUE_SET_ID
7893: -- Add a row to the collection of new value sets
7894: -- with new creation info.
7895:
7896: -- Bug 12382454 : Start
7897: -- Instead of using the select query, will assign the values to individual fields of the record.
7898: l_vs_value_disp_orders(i).VALUE_SET_VALUE_ID := child_vs_value_ids(i);
7899: l_vs_value_disp_orders(i).VALUE_SET_ID := p_value_set_id;
7900: l_vs_value_disp_orders(i).DISP_SEQUENCE := i;
7901: l_vs_value_disp_orders(i).CREATED_BY := p_owner;
7914: , p_owner -- LAST_UPDATED_BY
7915: , SYSDATE -- LAST_UPDATE_DATE
7916: , g_current_login_id -- LAST_UPDATE_LOGIN
7917: INTO l_vs_value_disp_orders(i)
7918: FROM dual;
7919: */
7920: -- Bug 12382454 : End
7921: END IF;
7922: END LOOP;
9399:
9400:
9401: --if association id is not provided, get association id from sequence
9402: --IF( p_association_id IS NULL ) THEN
9403: --SELECT EGO_ASSOCS_S.NEXTVAL INTO x_association_id FROM DUAL;
9404: --ELSE
9405: IF(p_association_id IS NOT NULL AND p_association_id > 0) THEN
9406: x_association_id := p_association_id;
9407: END IF;
10264: END IF;
10265:
10266: --if page id is not provided, get page id from sequence
10267: IF( p_page_id IS NULL ) THEN
10268: SELECT EGO_PAGES_S.NEXTVAL INTO x_page_id FROM DUAL;
10269: ELSE
10270: x_page_id := p_page_id;
10271: END IF;
10272:
11140: IF FND_API.To_Boolean(p_init_msg_list) THEN
11141: FND_MSG_PUB.Initialize;
11142: END IF;
11143:
11144: SELECT EGO_FUNCTIONS_S.NEXTVAL INTO x_function_id FROM DUAL;
11145:
11146: INSERT INTO EGO_FUNCTIONS_B
11147: (
11148: FUNCTION_ID
11491: IF FND_API.To_Boolean(p_init_msg_list) THEN
11492: FND_MSG_PUB.Initialize;
11493: END IF;
11494:
11495: SELECT EGO_ACTIONS_S.NEXTVAL INTO x_action_id FROM DUAL;
11496:
11497: -- Ensure created action's name or sequence number do not
11498: -- match those of an action already associated with the
11499: -- classification/attribute pair.
12821: IF FND_API.To_Boolean(p_init_msg_list) THEN
12822: FND_MSG_PUB.Initialize;
12823: END IF;
12824:
12825: SELECT EGO_FUNC_PARAMS_S.NEXTVAL INTO x_function_param_id FROM DUAL;
12826:
12827: INSERT INTO EGO_FUNC_PARAMS_B
12828: (
12829: FUNC_PARAM_ID
13600: END Delete_Func_Mapping;
13601:
13602: ----------------------------------------------------------------------
13603:
13604: -- call this API to delete an individual parameter mapping
13605: PROCEDURE Delete_Func_Param_Mapping (
13606: p_api_version IN NUMBER
13607: ,p_function_id IN NUMBER
13608: ,p_mapped_obj_type IN VARCHAR2
13725: IF FND_API.To_Boolean(p_init_msg_list) THEN
13726: FND_MSG_PUB.Initialize;
13727: END IF;
13728:
13729: SELECT EGO_ACTION_GROUPS_S.NEXTVAL INTO x_action_group_id FROM DUAL;
13730:
13731: INSERT INTO EGO_ACTION_GROUPS_B
13732: (
13733: ACTION_GROUP_ID
14885: CLOSE c_check_obj_name;
14886:
14887: --Test with this dummy Query for the validity of the view name
14888: --It should not be a reserve word
14889: l_dynamic_sql := 'CREATE OR REPLACE VIEW '|| l_agv_name ||' AS SELECT * FROM DUAL';
14890:
14891: --bugfix 11907422 for 12.2 AD_DDL changes
14892: --EXECUTE IMMEDIATE l_dynamic_sql;
14893: