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 87: gets inserted into FND_FLEX_VALIDATION_TABLES.

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

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

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

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

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

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

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

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

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

Line 116: -- 1. FND_FLEX_VALIDATION_TABLES --

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

Line 136: -- 2. FND_FLEX_VALIDATION_TABLES --

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

Line 317: FROM fnd_flex_validation_tables

313: l_addl_where_clause LONG;
314: BEGIN
315: SELECT additional_where_clause
316: INTO l_addl_where_clause
317: FROM fnd_flex_validation_tables
318: WHERE flex_value_set_id = p_value_set_id;
319: RETURN l_addl_where_clause;
320: EXCEPTION
321: WHEN OTHERS THEN

Line 6496: l_id_column_name fnd_flex_validation_tables.id_column_name%TYPE;

6492: l_long_list_flag ego_value_sets_v.longlist_flag%TYPE;
6493: l_owner NUMBER;
6494: l_return_status_inf VARCHAR2(1);
6495: l_inf_where_clause VARCHAR2(1000);
6496: l_id_column_name fnd_flex_validation_tables.id_column_name%TYPE;
6497: l_id_column_type fnd_flex_validation_tables.id_column_type%TYPE;
6498: l_value_column_name fnd_flex_validation_tables.value_column_name%TYPE;
6499: l_value_column_type fnd_flex_validation_tables.value_column_type%TYPE;
6500:

Line 6497: l_id_column_type fnd_flex_validation_tables.id_column_type%TYPE;

6493: l_owner NUMBER;
6494: l_return_status_inf VARCHAR2(1);
6495: l_inf_where_clause VARCHAR2(1000);
6496: l_id_column_name fnd_flex_validation_tables.id_column_name%TYPE;
6497: l_id_column_type fnd_flex_validation_tables.id_column_type%TYPE;
6498: l_value_column_name fnd_flex_validation_tables.value_column_name%TYPE;
6499: l_value_column_type fnd_flex_validation_tables.value_column_type%TYPE;
6500:
6501: BEGIN

Line 6498: l_value_column_name fnd_flex_validation_tables.value_column_name%TYPE;

6494: l_return_status_inf VARCHAR2(1);
6495: l_inf_where_clause VARCHAR2(1000);
6496: l_id_column_name fnd_flex_validation_tables.id_column_name%TYPE;
6497: l_id_column_type fnd_flex_validation_tables.id_column_type%TYPE;
6498: l_value_column_name fnd_flex_validation_tables.value_column_name%TYPE;
6499: l_value_column_type fnd_flex_validation_tables.value_column_type%TYPE;
6500:
6501: BEGIN
6502:

Line 6499: l_value_column_type fnd_flex_validation_tables.value_column_type%TYPE;

6495: l_inf_where_clause VARCHAR2(1000);
6496: l_id_column_name fnd_flex_validation_tables.id_column_name%TYPE;
6497: l_id_column_type fnd_flex_validation_tables.id_column_type%TYPE;
6498: l_value_column_name fnd_flex_validation_tables.value_column_name%TYPE;
6499: l_value_column_type fnd_flex_validation_tables.value_column_type%TYPE;
6500:
6501: BEGIN
6502:
6503: -- For Debugging

Line 6613: -- Insert into FND_FLEX_VALIDATION_TABLES --

6609: END LOOP;
6610: END IF;
6611:
6612: ----------------------------------------------------------------------------
6613: -- Insert into FND_FLEX_VALIDATION_TABLES --
6614: ----------------------------------------------------------------------------
6615:
6616: l_return_status_inf := FND_API.G_FALSE;
6617:

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

6658:
6659: 'ORDER BY do.disp_sequence';
6660:
6661: -- SSARNOBA: As an experiment to fix 6194774, try editing the data type of the
6662: -- value set directly in the table FND_FLEX_VALIDATION_TABLES and then retry
6663: -- the search
6664:
6665: -- Bug fix 6319734 - convert the SELECT clause expressions if necessary.
6666: Build_Child_VS_Select_Exprs (

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

6701:
6702: -- Nothing had gone wrong until now, so set the global
6703: -- return status to the most recent one.
6704: x_return_status := l_return_status_inf;
6705: code_debug('Create_Child_Value_Set(): Insert into FND_FLEX_VALIDATION_TABLES failed.');
6706: RAISE FND_API.G_EXC_ERROR;
6707:
6708: END IF;
6709:

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

7241: );
7242:
7243: ---------------------- END Bug fix 6148833 -------------------------------
7244:
7245: code_debug(l_api_name ||' inserting data into fnd_flex_validation_tables ');
7246: INSERT INTO fnd_flex_validation_tables
7247: (
7248: FLEX_VALUE_SET_ID
7249: ,APPLICATION_TABLE_NAME

Line 7246: INSERT INTO fnd_flex_validation_tables

7242:
7243: ---------------------- END Bug fix 6148833 -------------------------------
7244:
7245: code_debug(l_api_name ||' inserting data into fnd_flex_validation_tables ');
7246: INSERT INTO fnd_flex_validation_tables
7247: (
7248: FLEX_VALUE_SET_ID
7249: ,APPLICATION_TABLE_NAME
7250: ,VALUE_COLUMN_NAME

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

7305: ,l_Sysdate --LAST_UPDATE_DATE
7306: ,g_current_login_id --LAST_UPDATE_LOGIN
7307: );
7308:
7309: code_debug(l_api_name ||' inserting data into fnd_flex_validation_tables COMPLETED ');
7310: -- Standard check of p_commit
7311: IF FND_API.To_Boolean(p_commit) THEN
7312: COMMIT WORK;
7313: END IF;

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

7420: );
7421:
7422: ---------------------- END Bug fix 6148833 -------------------------------
7423:
7424: code_debug(l_api_name ||' calling update fnd_flex_validation_tables ');
7425: -- no API available from fnd logged bug 3957430
7426: UPDATE FND_FLEX_VALIDATION_TABLES
7427: SET APPLICATION_TABLE_NAME = p_table_name,
7428: VALUE_COLUMN_NAME = p_value_column_name,

Line 7426: UPDATE FND_FLEX_VALIDATION_TABLES

7422: ---------------------- END Bug fix 6148833 -------------------------------
7423:
7424: code_debug(l_api_name ||' calling update fnd_flex_validation_tables ');
7425: -- no API available from fnd logged bug 3957430
7426: UPDATE FND_FLEX_VALIDATION_TABLES
7427: SET APPLICATION_TABLE_NAME = p_table_name,
7428: VALUE_COLUMN_NAME = p_value_column_name,
7429: VALUE_COLUMN_TYPE = p_value_column_type,
7430: VALUE_COLUMN_SIZE = p_value_column_size,

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

7448: LAST_UPDATE_DATE = l_Sysdate,
7449: LAST_UPDATE_LOGIN = g_current_login_id
7450: WHERE FLEX_VALUE_SET_ID = p_value_set_id;
7451:
7452: code_debug(l_api_name ||' calling update fnd_flex_validation_tables COMPLETED ');
7453: -- Standard check of p_commit
7454: IF FND_API.To_Boolean(p_commit) THEN
7455: COMMIT WORK;
7456: END IF;