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.

APPS.EGO_EXT_FWK_PUB dependencies on FND_FLEX_VALIDATION_TABLES

Line 88: gets inserted into FND_FLEX_VALIDATION_TABLES.

84: /*-----------------------------------------------------------------------------
85:
86: DESCRIPTION
87: Builds the SELECT clause expressions for a child value set definition that
88: gets inserted into FND_FLEX_VALIDATION_TABLES.
89:
90: BUG FIX
91: 6319734
92:

Line 108: , x_id_column_type OUT NOCOPY fnd_flex_validation_tables.id_column_type%TYPE

104:
105: -----------------------------------------------------------------------------*/
106: PROCEDURE Build_Child_VS_Select_Exprs (
107: p_parent_vs_row IN ego_value_sets_v%ROWTYPE
108: , x_id_column_type OUT NOCOPY fnd_flex_validation_tables.id_column_type%TYPE
109: , x_value_column_type OUT NOCOPY fnd_flex_validation_tables.value_column_type%TYPE
110: , x_id_column_name OUT NOCOPY fnd_flex_validation_tables.id_column_name%TYPE
111: , x_value_column_name OUT NOCOPY fnd_flex_validation_tables.value_column_name%TYPE
112: )

Line 109: , x_value_column_type OUT NOCOPY fnd_flex_validation_tables.value_column_type%TYPE

105: -----------------------------------------------------------------------------*/
106: PROCEDURE Build_Child_VS_Select_Exprs (
107: p_parent_vs_row IN ego_value_sets_v%ROWTYPE
108: , x_id_column_type OUT NOCOPY fnd_flex_validation_tables.id_column_type%TYPE
109: , x_value_column_type OUT NOCOPY fnd_flex_validation_tables.value_column_type%TYPE
110: , x_id_column_name OUT NOCOPY fnd_flex_validation_tables.id_column_name%TYPE
111: , x_value_column_name OUT NOCOPY fnd_flex_validation_tables.value_column_name%TYPE
112: )
113: IS

Line 110: , x_id_column_name OUT NOCOPY fnd_flex_validation_tables.id_column_name%TYPE

106: PROCEDURE Build_Child_VS_Select_Exprs (
107: p_parent_vs_row IN ego_value_sets_v%ROWTYPE
108: , x_id_column_type OUT NOCOPY fnd_flex_validation_tables.id_column_type%TYPE
109: , x_value_column_type OUT NOCOPY fnd_flex_validation_tables.value_column_type%TYPE
110: , x_id_column_name OUT NOCOPY fnd_flex_validation_tables.id_column_name%TYPE
111: , x_value_column_name OUT NOCOPY fnd_flex_validation_tables.value_column_name%TYPE
112: )
113: IS
114: BEGIN

Line 111: , x_value_column_name OUT NOCOPY fnd_flex_validation_tables.value_column_name%TYPE

107: p_parent_vs_row IN ego_value_sets_v%ROWTYPE
108: , x_id_column_type OUT NOCOPY fnd_flex_validation_tables.id_column_type%TYPE
109: , x_value_column_type OUT NOCOPY fnd_flex_validation_tables.value_column_type%TYPE
110: , x_id_column_name OUT NOCOPY fnd_flex_validation_tables.id_column_name%TYPE
111: , x_value_column_name OUT NOCOPY fnd_flex_validation_tables.value_column_name%TYPE
112: )
113: IS
114: BEGIN
115:

Line 117: -- 1. FND_FLEX_VALIDATION_TABLES --

113: IS
114: BEGIN
115:
116: ----------------------------------------------------------------------------
117: -- 1. FND_FLEX_VALIDATION_TABLES --
118: -- - ID_COLUMN_NAME --
119: -- - ID_COLUMN_TYPE --
120: ----------------------------------------------------------------------------
121:

Line 137: -- 2. FND_FLEX_VALIDATION_TABLES --

133: , x_column_name => x_id_column_name
134: );
135:
136: ----------------------------------------------------------------------------
137: -- 2. FND_FLEX_VALIDATION_TABLES --
138: -- - VALUE_COLUMN_NAME --
139: -- - VALUE_COLUMN_TYPE --
140: ----------------------------------------------------------------------------
141:

Line 353: FROM fnd_flex_validation_tables

349: l_addl_where_clause LONG;
350: BEGIN
351: SELECT additional_where_clause
352: INTO l_addl_where_clause
353: FROM fnd_flex_validation_tables
354: WHERE flex_value_set_id = p_value_set_id;
355: RETURN l_addl_where_clause;
356: EXCEPTION
357: WHEN OTHERS THEN

Line 7236: l_id_column_name fnd_flex_validation_tables.id_column_name%TYPE;

7232: l_long_list_flag ego_value_sets_v.longlist_flag%TYPE;
7233: l_owner NUMBER;
7234: l_return_status_inf VARCHAR2(1);
7235: l_inf_where_clause VARCHAR2(1000);
7236: l_id_column_name fnd_flex_validation_tables.id_column_name%TYPE;
7237: l_id_column_type fnd_flex_validation_tables.id_column_type%TYPE;
7238: l_value_column_name fnd_flex_validation_tables.value_column_name%TYPE;
7239: l_value_column_type fnd_flex_validation_tables.value_column_type%TYPE;
7240:

Line 7237: l_id_column_type fnd_flex_validation_tables.id_column_type%TYPE;

7233: l_owner NUMBER;
7234: l_return_status_inf VARCHAR2(1);
7235: l_inf_where_clause VARCHAR2(1000);
7236: l_id_column_name fnd_flex_validation_tables.id_column_name%TYPE;
7237: l_id_column_type fnd_flex_validation_tables.id_column_type%TYPE;
7238: l_value_column_name fnd_flex_validation_tables.value_column_name%TYPE;
7239: l_value_column_type fnd_flex_validation_tables.value_column_type%TYPE;
7240:
7241: BEGIN

Line 7238: l_value_column_name fnd_flex_validation_tables.value_column_name%TYPE;

7234: l_return_status_inf VARCHAR2(1);
7235: l_inf_where_clause VARCHAR2(1000);
7236: l_id_column_name fnd_flex_validation_tables.id_column_name%TYPE;
7237: l_id_column_type fnd_flex_validation_tables.id_column_type%TYPE;
7238: l_value_column_name fnd_flex_validation_tables.value_column_name%TYPE;
7239: l_value_column_type fnd_flex_validation_tables.value_column_type%TYPE;
7240:
7241: BEGIN
7242:

Line 7239: l_value_column_type fnd_flex_validation_tables.value_column_type%TYPE;

7235: l_inf_where_clause VARCHAR2(1000);
7236: l_id_column_name fnd_flex_validation_tables.id_column_name%TYPE;
7237: l_id_column_type fnd_flex_validation_tables.id_column_type%TYPE;
7238: l_value_column_name fnd_flex_validation_tables.value_column_name%TYPE;
7239: l_value_column_type fnd_flex_validation_tables.value_column_type%TYPE;
7240:
7241: BEGIN
7242:
7243: -- For Debugging

Line 7353: -- Insert into FND_FLEX_VALIDATION_TABLES --

7349: END LOOP;
7350: END IF;
7351:
7352: ----------------------------------------------------------------------------
7353: -- Insert into FND_FLEX_VALIDATION_TABLES --
7354: ----------------------------------------------------------------------------
7355:
7356: l_return_status_inf := FND_API.G_FALSE;
7357:

Line 7402: -- value set directly in the table FND_FLEX_VALIDATION_TABLES and then retry

7398:
7399: 'ORDER BY do.disp_sequence';
7400:
7401: -- SSARNOBA: As an experiment to fix 6194774, try editing the data type of the
7402: -- value set directly in the table FND_FLEX_VALIDATION_TABLES and then retry
7403: -- the search
7404:
7405: -- Bug fix 6319734 - convert the SELECT clause expressions if necessary.
7406: Build_Child_VS_Select_Exprs (

Line 7445: code_debug('Create_Child_Value_Set(): Insert into FND_FLEX_VALIDATION_TABLES failed.');

7441:
7442: -- Nothing had gone wrong until now, so set the global
7443: -- return status to the most recent one.
7444: x_return_status := l_return_status_inf;
7445: code_debug('Create_Child_Value_Set(): Insert into FND_FLEX_VALIDATION_TABLES failed.');
7446: RAISE FND_API.G_EXC_ERROR;
7447:
7448: END IF;
7449:

Line 8036: code_debug(l_api_name ||' inserting data into fnd_flex_validation_tables ');

8032: );
8033:
8034: ---------------------- END Bug fix 6148833 -------------------------------
8035:
8036: code_debug(l_api_name ||' inserting data into fnd_flex_validation_tables ');
8037: INSERT INTO fnd_flex_validation_tables
8038: (
8039: FLEX_VALUE_SET_ID
8040: ,APPLICATION_TABLE_NAME

Line 8037: INSERT INTO fnd_flex_validation_tables

8033:
8034: ---------------------- END Bug fix 6148833 -------------------------------
8035:
8036: code_debug(l_api_name ||' inserting data into fnd_flex_validation_tables ');
8037: INSERT INTO fnd_flex_validation_tables
8038: (
8039: FLEX_VALUE_SET_ID
8040: ,APPLICATION_TABLE_NAME
8041: ,VALUE_COLUMN_NAME

Line 8100: code_debug(l_api_name ||' inserting data into fnd_flex_validation_tables COMPLETED ');

8096: ,l_Sysdate --LAST_UPDATE_DATE
8097: ,g_current_login_id --LAST_UPDATE_LOGIN
8098: );
8099:
8100: code_debug(l_api_name ||' inserting data into fnd_flex_validation_tables COMPLETED ');
8101: -- Standard check of p_commit
8102: IF FND_API.To_Boolean(p_commit) THEN
8103: COMMIT WORK;
8104: END IF;

Line 8215: code_debug(l_api_name ||' calling update fnd_flex_validation_tables ');

8211: );
8212:
8213: ---------------------- END Bug fix 6148833 -------------------------------
8214:
8215: code_debug(l_api_name ||' calling update fnd_flex_validation_tables ');
8216: -- no API available from fnd logged bug 3957430
8217: UPDATE FND_FLEX_VALIDATION_TABLES
8218: SET APPLICATION_TABLE_NAME = p_table_name,
8219: VALUE_COLUMN_NAME = p_value_column_name,

Line 8217: UPDATE FND_FLEX_VALIDATION_TABLES

8213: ---------------------- END Bug fix 6148833 -------------------------------
8214:
8215: code_debug(l_api_name ||' calling update fnd_flex_validation_tables ');
8216: -- no API available from fnd logged bug 3957430
8217: UPDATE FND_FLEX_VALIDATION_TABLES
8218: SET APPLICATION_TABLE_NAME = p_table_name,
8219: VALUE_COLUMN_NAME = p_value_column_name,
8220: VALUE_COLUMN_TYPE = p_value_column_type,
8221: VALUE_COLUMN_SIZE = p_value_column_size,

Line 8243: code_debug(l_api_name ||' calling update fnd_flex_validation_tables COMPLETED ');

8239: LAST_UPDATE_DATE = l_Sysdate,
8240: LAST_UPDATE_LOGIN = g_current_login_id
8241: WHERE FLEX_VALUE_SET_ID = p_value_set_id;
8242:
8243: code_debug(l_api_name ||' calling update fnd_flex_validation_tables COMPLETED ');
8244: -- Standard check of p_commit
8245: IF FND_API.To_Boolean(p_commit) THEN
8246: COMMIT WORK;
8247: END IF;