[Home] [Help]
70: FUNCTION IS_CONFIG_INSTANCE_INITIALIZED
71: RETURN BOOLEAN
72: IS
73: BEGIN
74: RETURN FND_OAM_DSCFG_INSTANCES_PKG.IS_INITIALIZED;
75: END;
76:
77: -- Public
78: -- Convenience wrapper.
79: FUNCTION GET_CURRENT_CONFIG_INSTANCE_ID
80: RETURN NUMBER
81: IS
82: BEGIN
83: RETURN FND_OAM_DSCFG_INSTANCES_PKG.GET_CURRENT_ID;
84: END;
85:
86: -- Public
87: -- Convenience wrapper.
88: FUNCTION GET_CURRENT_POLICYSET_ID
89: RETURN NUMBER
90: IS
91: BEGIN
92: RETURN FND_OAM_DSCFG_INSTANCES_PKG.GET_CURRENT_POLICYSET_ID;
93: END;
94:
95: -- Public
96: PROCEDURE GET_CURRENT_TARGET_TABLE_LIST(x_table_owners OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE,
101: BEGIN
102: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
103:
104: -- make sure we have the state we need
105: IF NOT FND_OAM_DSCFG_INSTANCES_PKG.IS_INITIALIZED THEN
106: RAISE NO_DATA_FOUND;
107: END IF;
108:
109: -- FIXME: the object_id subselect is ugly and will be repeated in the compiler. Options include moving
113: SELECT DISTINCT p1.canonical_value, p2.canonical_value
114: BULK COLLECT INTO x_table_owners, x_table_names
115: FROM (SELECT object_id
116: FROM fnd_oam_dscfg_objects
117: WHERE config_instance_id = FND_OAM_DSCFG_INSTANCES_PKG.GET_CURRENT_ID
118: AND object_type in (G_OTYPE_DML_UPDATE_SEGMENT,
119: G_OTYPE_DML_DELETE_STMT,
120: G_OTYPE_DML_TRUNCATE_STMT,
121: G_OTYPE_PLSQL_TEXT)) o,
646: p_policyset_id IN NUMBER,
647: x_config_instance_id OUT NOCOPY NUMBER)
648: IS
649: BEGIN
650: FND_OAM_DSCFG_INSTANCES_PKG.ADD_CONFIG_INSTANCE(p_target_dbname => p_target_dbname,
651: p_config_instance_type => p_config_instance_type,
652: p_name => p_name,
653: p_description => p_description,
654: p_language => p_language,
661: -- Public
662: PROCEDURE SET_CURRENT_CONFIG_INSTANCE(p_config_instance_id IN NUMBER)
663: IS
664: BEGIN
665: FND_OAM_DSCFG_INSTANCES_PKG.SET_CURRENT_CONFIG_INSTANCE(p_config_instance_id => p_config_instance_id);
666: END;
667:
668: -- Public
669: PROCEDURE ADD_OBJECT(p_object_type IN VARCHAR2,