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_USER_ATTRS_DATA_PVT dependencies on FND_DSQL

Line 994: FND_DSQL.Add_Text('SELECT EXTENSION_ID, ' ||l_db_column_list||

990:
991: Debug_Msg(l_api_name||' pk cols '||l_pk_col_string);
992:
993: Init();
994: FND_DSQL.Add_Text('SELECT EXTENSION_ID, ' ||l_db_column_list||
995: ' FROM ' ||NVL(p_attr_group_metadata_obj.EXT_TABLE_VL_NAME
996: ,p_attr_group_metadata_obj.EXT_TABLE_B_NAME)||
997: ' WHERE ');
998:

Line 1013: FND_DSQL.Add_Text(' AND EXTENSION_ID = ');

1009: -----------------------------------------------------------------------
1010: -- If extension ID info is available, select on it. --
1011: -----------------------------------------------------------------------
1012: IF (p_extension_id IS NOT NULL) THEN
1013: FND_DSQL.Add_Text(' AND EXTENSION_ID = ');
1014: Add_Bind(p_value => p_extension_id);
1015: END IF;
1016:
1017: ----------------------------------------------------------------------------

Line 1035: FND_DSQL.Add_Text(' AND DATA_LEVEL_ID = ');

1031: l_data_level_id := Get_Data_Level_Id( p_attr_group_metadata_obj.APPLICATION_ID
1032: ,p_attr_group_metadata_obj.ATTR_GROUP_TYPE
1033: ,p_data_level);
1034:
1035: FND_DSQL.Add_Text(' AND DATA_LEVEL_ID = ');
1036: Add_Bind (p_bind_identifier => 'DATA_LEVEL_ID'
1037: ,p_value => l_data_level_id);
1038:
1039: END IF;

Line 1051: FND_DSQL.Add_Text(' AND (ATTR_GROUP_ID = ');

1047: ------------------------------------------------
1048: -- Build a predicate for each Attribute Group --
1049: -- and concatenate it into a master predicate --
1050: ------------------------------------------------
1051: FND_DSQL.Add_Text(' AND (ATTR_GROUP_ID = ');
1052: Add_Bind(p_value => p_attr_group_metadata_obj.ATTR_GROUP_ID);
1053:
1054: ---------------------------------------------------------------
1055: -- Make a string to use in the query; it will be of the form --

Line 1071: FND_DSQL.Add_Text(')');

1067: ,'EQUALS'
1068: ,TRUE
1069: ,' AND '
1070: );
1071: FND_DSQL.Add_Text(')');
1072:
1073: END IF;
1074:
1075: Debug_SQL(l_dynamic_sql);

Line 1081: FND_DSQL.Set_Cursor(l_cursor_id);

1077: ----------------------------------
1078: -- Open a cursor for processing --
1079: ----------------------------------
1080: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
1081: FND_DSQL.Set_Cursor(l_cursor_id);
1082:
1083: -------------------------------------
1084: -- Parse our dynamic SQL statement --
1085: -------------------------------------

Line 1086: DBMS_SQL.PARSE(l_cursor_id, FND_DSQL.Get_Text(), DBMS_SQL.NATIVE);

1082:
1083: -------------------------------------
1084: -- Parse our dynamic SQL statement --
1085: -------------------------------------
1086: DBMS_SQL.PARSE(l_cursor_id, FND_DSQL.Get_Text(), DBMS_SQL.NATIVE);
1087:
1088: ------------------------
1089: -- Bind our variables --
1090: ------------------------

Line 1091: FND_DSQL.Do_Binds();

1087:
1088: ------------------------
1089: -- Bind our variables --
1090: ------------------------
1091: FND_DSQL.Do_Binds();
1092:
1093: --------------------------------------------------------------------------
1094: -- Register the data types of the columns we are selecting in our query --
1095: -- (in the VARCHAR2 case, that includes stating the maximum size that a --

Line 1966: -- statement being constructed using the FND_DSQL package. We assume that we are

1962: --
1963: -- Private
1964: --
1965: -- This procedure adds text and/or bind variables, as appropriate, to a dynamic SQL
1966: -- statement being constructed using the FND_DSQL package. We assume that we are
1967: -- in the midst of building a statement, so we do not call Init().
1968: -- The procedure appends a final p_separator value onto the FND_DSQL list
1969: --
1970: -- The procedure's allowable p_mode values are:

Line 1968: -- The procedure appends a final p_separator value onto the FND_DSQL list

1964: --
1965: -- This procedure adds text and/or bind variables, as appropriate, to a dynamic SQL
1966: -- statement being constructed using the FND_DSQL package. We assume that we are
1967: -- in the midst of building a statement, so we do not call Init().
1968: -- The procedure appends a final p_separator value onto the FND_DSQL list
1969: --
1970: -- The procedure's allowable p_mode values are:
1971: -- 'VALUES': adds bind variables for Attr values, separated appropriately, to FND_DSQL
1972: -- 'VALUES_DEF': special case of VALUES that uses DEFAULT_VALUE for any NULL Attributes

Line 1971: -- 'VALUES': adds bind variables for Attr values, separated appropriately, to FND_DSQL

1967: -- in the midst of building a statement, so we do not call Init().
1968: -- The procedure appends a final p_separator value onto the FND_DSQL list
1969: --
1970: -- The procedure's allowable p_mode values are:
1971: -- 'VALUES': adds bind variables for Attr values, separated appropriately, to FND_DSQL
1972: -- 'VALUES_DEF': special case of VALUES that uses DEFAULT_VALUE for any NULL Attributes
1973: -- 'COLUMNS': adds a comma-delimited list of ext table column names and no bind variables
1974: -- 'COLUMNS_DEF': special case of COLUMNS to match with VALUES_DEF
1975: -- 'EQUALS': adds a list of elements of the form 'ColumnN = :N', where N is a number;

Line 2172: FND_DSQL.Add_Text(l_column_name);

2168: IF (UPPER(p_mode) = 'EQUALS' OR
2169: UPPER(p_mode) = 'COLUMNS' OR
2170: UPPER(p_mode) = 'COLUMNS_DEF') THEN
2171:
2172: FND_DSQL.Add_Text(l_column_name);
2173:
2174: IF (UPPER(p_mode) = 'EQUALS') THEN
2175:
2176: IF (l_candidate_value IS NULL AND p_separator = ' AND ') THEN

Line 2178: FND_DSQL.Add_Text(' IS ');

2174: IF (UPPER(p_mode) = 'EQUALS') THEN
2175:
2176: IF (l_candidate_value IS NULL AND p_separator = ' AND ') THEN
2177:
2178: FND_DSQL.Add_Text(' IS ');
2179:
2180: ELSE
2181:
2182: FND_DSQL.Add_Text(' = ');

Line 2182: FND_DSQL.Add_Text(' = ');

2178: FND_DSQL.Add_Text(' IS ');
2179:
2180: ELSE
2181:
2182: FND_DSQL.Add_Text(' = ');
2183:
2184: END IF;
2185:
2186: ELSE

Line 2188: FND_DSQL.Add_Text(p_separator);

2184: END IF;
2185:
2186: ELSE
2187:
2188: FND_DSQL.Add_Text(p_separator);
2189:
2190: END IF;
2191: END IF;
2192:

Line 2202: FND_DSQL.Add_Text(' NULL ');

2198: UPPER(p_mode) = 'VALUES_DEF') THEN
2199:
2200: IF (l_candidate_value IS NULL) THEN
2201:
2202: FND_DSQL.Add_Text(' NULL ');
2203:
2204: ELSIF (l_data_type IS NULL OR
2205: l_data_type = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR
2206: l_data_type = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN

Line 2226: FND_DSQL.Add_Text(p_separator);

2222: ,p_value => TO_DATE(l_candidate_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT));
2223:
2224: END IF;
2225:
2226: FND_DSQL.Add_Text(p_separator);
2227:
2228: END IF;
2229:
2230: -------------------------------------------

Line 2239: FND_DSQL.Add_Text(l_uom_column);

2235: IF (UPPER(p_mode) = 'EQUALS' OR
2236: UPPER(p_mode) = 'COLUMNS' OR
2237: UPPER(p_mode) = 'COLUMNS_DEF') THEN
2238:
2239: FND_DSQL.Add_Text(l_uom_column);
2240:
2241: IF (UPPER(p_mode) = 'EQUALS') THEN
2242:
2243: IF (l_uom_value IS NULL AND p_separator = ' AND ') THEN

Line 2245: FND_DSQL.Add_Text(' IS ');

2241: IF (UPPER(p_mode) = 'EQUALS') THEN
2242:
2243: IF (l_uom_value IS NULL AND p_separator = ' AND ') THEN
2244:
2245: FND_DSQL.Add_Text(' IS ');
2246:
2247: ELSE
2248:
2249: FND_DSQL.Add_Text(' = ');

Line 2249: FND_DSQL.Add_Text(' = ');

2245: FND_DSQL.Add_Text(' IS ');
2246:
2247: ELSE
2248:
2249: FND_DSQL.Add_Text(' = ');
2250:
2251: END IF;
2252:
2253: ELSE

Line 2255: FND_DSQL.Add_Text(p_separator);

2251: END IF;
2252:
2253: ELSE
2254:
2255: FND_DSQL.Add_Text(p_separator);
2256:
2257: END IF;
2258: END IF;
2259:

Line 2266: FND_DSQL.Add_Text(' NULL ');

2262: UPPER(p_mode) = 'VALUES_DEF') THEN
2263:
2264: IF (l_uom_value IS NULL) THEN
2265:
2266: FND_DSQL.Add_Text(' NULL ');
2267:
2268: ELSE
2269:
2270: FND_DSQL.Add_Text(l_uom_value);

Line 2270: FND_DSQL.Add_Text(l_uom_value);

2266: FND_DSQL.Add_Text(' NULL ');
2267:
2268: ELSE
2269:
2270: FND_DSQL.Add_Text(l_uom_value);
2271:
2272: END IF;
2273:
2274: FND_DSQL.Add_Text(p_separator);

Line 2274: FND_DSQL.Add_Text(p_separator);

2270: FND_DSQL.Add_Text(l_uom_value);
2271:
2272: END IF;
2273:
2274: FND_DSQL.Add_Text(p_separator);
2275:
2276: END IF;
2277: END IF;
2278: END IF;

Line 2367: -- built using the FND_DSQL package. This procedure neither initializes nor

2363:
2364: ----------------------------------------------------------------------
2365:
2366: -- This procedure builds a WHERE clause, which it adds to a SQL statement being
2367: -- built using the FND_DSQL package. This procedure neither initializes nor
2368: -- executes that statement; it just adds text and bind variables through calls
2369: -- to FND_DSQL procedures.
2370:
2371: PROCEDURE Build_Where_Clause (

Line 2369: -- to FND_DSQL procedures.

2365:
2366: -- This procedure builds a WHERE clause, which it adds to a SQL statement being
2367: -- built using the FND_DSQL package. This procedure neither initializes nor
2368: -- executes that statement; it just adds text and bind variables through calls
2369: -- to FND_DSQL procedures.
2370:
2371: PROCEDURE Build_Where_Clause (
2372: p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
2373: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ

Line 2408: FND_DSQL.Add_Text(' ATTR_GROUP_ID = ');

2404:
2405: END IF;
2406:
2407: IF (p_attr_group_metadata_obj.ATTR_GROUP_ID_FLAG ='Y') THEN
2408: FND_DSQL.Add_Text(' ATTR_GROUP_ID = ');
2409: Add_Bind(p_value => p_attr_group_metadata_obj.ATTR_GROUP_ID);
2410: ELSE
2411: FND_DSQL.Add_Text(' 1 = 1 ');
2412: END IF;

Line 2411: FND_DSQL.Add_Text(' 1 = 1 ');

2407: IF (p_attr_group_metadata_obj.ATTR_GROUP_ID_FLAG ='Y') THEN
2408: FND_DSQL.Add_Text(' ATTR_GROUP_ID = ');
2409: Add_Bind(p_value => p_attr_group_metadata_obj.ATTR_GROUP_ID);
2410: ELSE
2411: FND_DSQL.Add_Text(' 1 = 1 ');
2412: END IF;
2413:
2414: --------------------------------------------------------------
2415: -- Added in R12C, for implementations uptaking the enhanced --

Line 2431: FND_DSQL.Add_Text(' AND DATA_LEVEL_ID = ');

2427: l_data_level_id := Get_Data_Level_Id( p_attr_group_metadata_obj.APPLICATION_ID
2428: ,p_attr_group_metadata_obj.ATTR_GROUP_TYPE
2429: ,p_data_level);
2430:
2431: FND_DSQL.Add_Text(' AND DATA_LEVEL_ID = ');
2432: Add_Bind(p_value => l_data_level_id);
2433: END IF;
2434:
2435: Debug_Msg(l_api_name ||' calling EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols for pk ');

Line 2526: -- initialize FND_DSQL to constuct/bind/execute the query and return the result.

2522:
2523: ----------------------------------------------------------------------
2524:
2525: -- This function has two basic modes: if p_return_bound_sql is FALSE, then we
2526: -- initialize FND_DSQL to constuct/bind/execute the query and return the result.
2527: -- If TRUE, we build and return the query itself. In this case, we don't pass
2528: -- p_final_bind_value or p_attr_name_value_pairs, and when replacing Attr Group
2529: -- tokens we construct a nested query to get the value required by the token.
2530: FUNCTION Tokenized_Val_Set_Query (

Line 2833: FND_DSQL.Add_Text(SUBSTR(l_tail_of_query, 1, (l_token_start_index - 1)));

2829: l_head_of_query := l_head_of_query ||
2830: SUBSTR(l_tail_of_query, 1, (l_token_start_index - 1)) ||
2831: l_token_replacement;
2832: ELSE
2833: FND_DSQL.Add_Text(SUBSTR(l_tail_of_query, 1, (l_token_start_index - 1)));
2834: Add_Bind(p_value => l_token_replacement);
2835: END IF;
2836:
2837: ELSE

Line 2847: FND_DSQL.Add_Text(SUBSTR(l_tail_of_query, 1, (l_token_end_index - 1)));

2843: IF (p_return_bound_sql) THEN
2844: l_head_of_query := l_head_of_query ||
2845: SUBSTR(l_tail_of_query, 1, (l_token_end_index - 1));
2846: ELSE
2847: FND_DSQL.Add_Text(SUBSTR(l_tail_of_query, 1, (l_token_end_index - 1)));
2848: END IF;
2849:
2850: END IF;
2851:

Line 2879: FND_DSQL.Add_Text(l_tail_of_query);

2875: Debug_Msg('In Tokenized_Val_Set_Query, done', 2);
2876: RETURN l_dynamic_sql;
2877:
2878: ELSE
2879: FND_DSQL.Add_Text(l_tail_of_query);
2880: Add_Bind(p_value => p_final_bind_value);
2881:
2882: l_dynamic_sql := FND_DSQL.Get_Text(FALSE);
2883:

Line 2882: l_dynamic_sql := FND_DSQL.Get_Text(FALSE);

2878: ELSE
2879: FND_DSQL.Add_Text(l_tail_of_query);
2880: Add_Bind(p_value => p_final_bind_value);
2881:
2882: l_dynamic_sql := FND_DSQL.Get_Text(FALSE);
2883:
2884: Debug_Msg('In Tokenized_Val_Set_Query, l_dynamic_sql to be executed is as follows:', 3);
2885: Debug_SQL(FND_DSQL.Get_Text(TRUE));
2886:

Line 2885: Debug_SQL(FND_DSQL.Get_Text(TRUE));

2881:
2882: l_dynamic_sql := FND_DSQL.Get_Text(FALSE);
2883:
2884: Debug_Msg('In Tokenized_Val_Set_Query, l_dynamic_sql to be executed is as follows:', 3);
2885: Debug_SQL(FND_DSQL.Get_Text(TRUE));
2886:
2887: l_cursor_id := DBMS_SQL.Open_Cursor;
2888:
2889: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.Native);

Line 2890: FND_DSQL.Set_Cursor(l_cursor_id);

2886:
2887: l_cursor_id := DBMS_SQL.Open_Cursor;
2888:
2889: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.Native);
2890: FND_DSQL.Set_Cursor(l_cursor_id);
2891: FND_DSQL.Do_Binds();
2892: DBMS_SQL.Define_Column(l_cursor_id, 1, l_retrieved_value, 4000); --bug 12979914
2893:
2894: l_number_of_rows := DBMS_SQL.Execute_And_Fetch(l_cursor_id);

Line 2891: FND_DSQL.Do_Binds();

2887: l_cursor_id := DBMS_SQL.Open_Cursor;
2888:
2889: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.Native);
2890: FND_DSQL.Set_Cursor(l_cursor_id);
2891: FND_DSQL.Do_Binds();
2892: DBMS_SQL.Define_Column(l_cursor_id, 1, l_retrieved_value, 4000); --bug 12979914
2893:
2894: l_number_of_rows := DBMS_SQL.Execute_And_Fetch(l_cursor_id);
2895:

Line 2903: fnd_dsql.init(); --bug 13478195

2899:
2900: END IF;
2901:
2902: DBMS_SQL.Close_Cursor(l_cursor_id);
2903: fnd_dsql.init(); --bug 13478195
2904:
2905: Debug_Msg('In Tokenized_Val_Set_Query, l_retrieved_value is as follows: '||
2906: l_retrieved_value);
2907: Debug_Msg('In Tokenized_Val_Set_Query, done', 2);

Line 3282: -- We clear FND_DSQL and start our new query --

3278: END IF;
3279: END IF;
3280:
3281: -----------------------------------------------
3282: -- We clear FND_DSQL and start our new query --
3283: -----------------------------------------------
3284: Init();
3285: FND_DSQL.Add_Text('SELECT EXTENSION_ID FROM ' || l_vl_name ||
3286: ' WHERE 1=1 AND ' || l_change_where_clause||l_extra_where_clause||' AND ');

Line 3285: FND_DSQL.Add_Text('SELECT EXTENSION_ID FROM ' || l_vl_name ||

3281: -----------------------------------------------
3282: -- We clear FND_DSQL and start our new query --
3283: -----------------------------------------------
3284: Init();
3285: FND_DSQL.Add_Text('SELECT EXTENSION_ID FROM ' || l_vl_name ||
3286: ' WHERE 1=1 AND ' || l_change_where_clause||l_extra_where_clause||' AND ');
3287:
3288: Debug_Msg(l_api_name ||' calling Build_Where_Clause', 3);
3289: Build_Where_Clause(p_attr_group_metadata_obj

Line 3297: l_dynamic_sql := FND_DSQL.Get_Text(FALSE);

3293: ,l_data_level_name_value_pairs -- NULL if we're in Change mode
3294: ,p_attr_name_value_pairs);
3295: Debug_Msg(l_api_name ||' returning Build_Where_Clause', 3);
3296:
3297: l_dynamic_sql := FND_DSQL.Get_Text(FALSE);
3298:
3299: Debug_Msg(l_api_name ||' l_dynamic_sql is as follows: '||l_dynamic_sql, 3);
3300: Debug_SQL(FND_DSQL.Get_Text(TRUE));
3301: ----------------------------------------

Line 3300: Debug_SQL(FND_DSQL.Get_Text(TRUE));

3296:
3297: l_dynamic_sql := FND_DSQL.Get_Text(FALSE);
3298:
3299: Debug_Msg(l_api_name ||' l_dynamic_sql is as follows: '||l_dynamic_sql, 3);
3300: Debug_SQL(FND_DSQL.Get_Text(TRUE));
3301: ----------------------------------------
3302: -- Now we open a cursor for our query --
3303: ----------------------------------------
3304: l_cursor_id := DBMS_SQL.Open_Cursor;

Line 3311: FND_DSQL.Set_Cursor(l_cursor_id);

3307: -- Next we parse the query, bind our variables, --
3308: -- and tell DBMS_SQL what we want it to return --
3309: --------------------------------------------------
3310: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.Native);
3311: FND_DSQL.Set_Cursor(l_cursor_id);
3312: FND_DSQL.Do_Binds();
3313: DBMS_SQL.Define_Column(l_cursor_id, 1, l_extension_id);
3314: ---------------------------------------------------------------------
3315: -- We execute the query and see how many rows we get; if we get no --

Line 3312: FND_DSQL.Do_Binds();

3308: -- and tell DBMS_SQL what we want it to return --
3309: --------------------------------------------------
3310: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.Native);
3311: FND_DSQL.Set_Cursor(l_cursor_id);
3312: FND_DSQL.Do_Binds();
3313: DBMS_SQL.Define_Column(l_cursor_id, 1, l_extension_id);
3314: ---------------------------------------------------------------------
3315: -- We execute the query and see how many rows we get; if we get no --
3316: -- rows, we return NULL, and if we get too many rows, we return -1 --

Line 4683: FND_DSQL.Add_Text(' SELECT DATA_LEVEL FROM EGO_OBJ_AG_ASSOCS_B'||

4679:
4680: IF(l_data_level_matched AND l_column_matched) THEN
4681: --If the passed in data level is fine we check the association of the data level with the classification
4682: Init();
4683: FND_DSQL.Add_Text(' SELECT DATA_LEVEL FROM EGO_OBJ_AG_ASSOCS_B'||
4684: ' WHERE OBJECT_ID = ');
4685: Add_Bind(p_value => p_object_id);
4686: FND_DSQL.Add_Text(' AND ATTR_GROUP_ID = ');
4687: Add_Bind(p_value => p_attr_group_id);

Line 4686: FND_DSQL.Add_Text(' AND ATTR_GROUP_ID = ');

4682: Init();
4683: FND_DSQL.Add_Text(' SELECT DATA_LEVEL FROM EGO_OBJ_AG_ASSOCS_B'||
4684: ' WHERE OBJECT_ID = ');
4685: Add_Bind(p_value => p_object_id);
4686: FND_DSQL.Add_Text(' AND ATTR_GROUP_ID = ');
4687: Add_Bind(p_value => p_attr_group_id);
4688: FND_DSQL.Add_Text(' AND ROWNUM = 1');
4689: FND_DSQL.Add_Text(' AND CLASSIFICATION_CODE IN (');
4690: l_cc_value_list := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(

Line 4688: FND_DSQL.Add_Text(' AND ROWNUM = 1');

4684: ' WHERE OBJECT_ID = ');
4685: Add_Bind(p_value => p_object_id);
4686: FND_DSQL.Add_Text(' AND ATTR_GROUP_ID = ');
4687: Add_Bind(p_value => p_attr_group_id);
4688: FND_DSQL.Add_Text(' AND ROWNUM = 1');
4689: FND_DSQL.Add_Text(' AND CLASSIFICATION_CODE IN (');
4690: l_cc_value_list := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
4691: p_ext_table_metadata_obj.class_code_metadata
4692: ,p_class_code_name_value_pairs

Line 4689: FND_DSQL.Add_Text(' AND CLASSIFICATION_CODE IN (');

4685: Add_Bind(p_value => p_object_id);
4686: FND_DSQL.Add_Text(' AND ATTR_GROUP_ID = ');
4687: Add_Bind(p_value => p_attr_group_id);
4688: FND_DSQL.Add_Text(' AND ROWNUM = 1');
4689: FND_DSQL.Add_Text(' AND CLASSIFICATION_CODE IN (');
4690: l_cc_value_list := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
4691: p_ext_table_metadata_obj.class_code_metadata
4692: ,p_class_code_name_value_pairs
4693: ,'VALUES_ALL_CC'

Line 4696: FND_DSQL.Add_Text(')');

4692: ,p_class_code_name_value_pairs
4693: ,'VALUES_ALL_CC'
4694: ,TRUE
4695: );
4696: FND_DSQL.Add_Text(')');
4697: l_cursor_id := DBMS_SQL.Open_Cursor;
4698: DBMS_SQL.Parse(l_cursor_id, FND_DSQL.Get_Text(), DBMS_SQL.Native);
4699: FND_DSQL.Set_Cursor(l_cursor_id);
4700: FND_DSQL.Do_Binds();

Line 4698: DBMS_SQL.Parse(l_cursor_id, FND_DSQL.Get_Text(), DBMS_SQL.Native);

4694: ,TRUE
4695: );
4696: FND_DSQL.Add_Text(')');
4697: l_cursor_id := DBMS_SQL.Open_Cursor;
4698: DBMS_SQL.Parse(l_cursor_id, FND_DSQL.Get_Text(), DBMS_SQL.Native);
4699: FND_DSQL.Set_Cursor(l_cursor_id);
4700: FND_DSQL.Do_Binds();
4701: DBMS_SQL.Define_Column(l_cursor_id, 1, l_data_level, 30);
4702: l_dummy := DBMS_SQL.Execute(l_cursor_id);

Line 4699: FND_DSQL.Set_Cursor(l_cursor_id);

4695: );
4696: FND_DSQL.Add_Text(')');
4697: l_cursor_id := DBMS_SQL.Open_Cursor;
4698: DBMS_SQL.Parse(l_cursor_id, FND_DSQL.Get_Text(), DBMS_SQL.Native);
4699: FND_DSQL.Set_Cursor(l_cursor_id);
4700: FND_DSQL.Do_Binds();
4701: DBMS_SQL.Define_Column(l_cursor_id, 1, l_data_level, 30);
4702: l_dummy := DBMS_SQL.Execute(l_cursor_id);
4703: l_dummy := DBMS_SQL.Fetch_Rows(l_cursor_id);

Line 4700: FND_DSQL.Do_Binds();

4696: FND_DSQL.Add_Text(')');
4697: l_cursor_id := DBMS_SQL.Open_Cursor;
4698: DBMS_SQL.Parse(l_cursor_id, FND_DSQL.Get_Text(), DBMS_SQL.Native);
4699: FND_DSQL.Set_Cursor(l_cursor_id);
4700: FND_DSQL.Do_Binds();
4701: DBMS_SQL.Define_Column(l_cursor_id, 1, l_data_level, 30);
4702: l_dummy := DBMS_SQL.Execute(l_cursor_id);
4703: l_dummy := DBMS_SQL.Fetch_Rows(l_cursor_id);
4704:

Line 4745: FND_DSQL.Add_Text(' SELECT DECODE(ATTRIBUTE2, 1, ATTRIBUTE3,'||

4741: l_data_level := SUBSTR(l_data_level_list, l_start_index, (l_end_index - l_start_index));
4742: ELSE
4743:
4744: Init();
4745: FND_DSQL.Add_Text(' SELECT DECODE(ATTRIBUTE2, 1, ATTRIBUTE3,'||
4746: ' 2, ATTRIBUTE5,'||
4747: ' 3, ATTRIBUTE7,'||
4748: ' ''NONE'')'||
4749: ' FROM FND_LOOKUP_VALUES'||

Line 4756: FND_DSQL.Add_Text(' AND ATTR_GROUP_ID = ');

4752: ' AND LOOKUP_CODE = (SELECT DATA_LEVEL'||
4753: ' FROM EGO_OBJ_AG_ASSOCS_B'||
4754: ' WHERE OBJECT_ID = ');
4755: Add_Bind(p_value => p_object_id);
4756: FND_DSQL.Add_Text(' AND ATTR_GROUP_ID = ');
4757: Add_Bind(p_value => p_attr_group_id);
4758: FND_DSQL.Add_Text(' AND ROWNUM = 1');
4759:
4760: IF (LENGTH(l_cc_value_list) > 0) THEN

Line 4758: FND_DSQL.Add_Text(' AND ROWNUM = 1');

4754: ' WHERE OBJECT_ID = ');
4755: Add_Bind(p_value => p_object_id);
4756: FND_DSQL.Add_Text(' AND ATTR_GROUP_ID = ');
4757: Add_Bind(p_value => p_attr_group_id);
4758: FND_DSQL.Add_Text(' AND ROWNUM = 1');
4759:
4760: IF (LENGTH(l_cc_value_list) > 0) THEN
4761: FND_DSQL.Add_Text(' AND CLASSIFICATION_CODE IN (');
4762: l_cc_value_list := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(

Line 4761: FND_DSQL.Add_Text(' AND CLASSIFICATION_CODE IN (');

4757: Add_Bind(p_value => p_attr_group_id);
4758: FND_DSQL.Add_Text(' AND ROWNUM = 1');
4759:
4760: IF (LENGTH(l_cc_value_list) > 0) THEN
4761: FND_DSQL.Add_Text(' AND CLASSIFICATION_CODE IN (');
4762: l_cc_value_list := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
4763: p_ext_table_metadata_obj.class_code_metadata
4764: ,p_class_code_name_value_pairs
4765: ,'VALUES_ALL_CC'

Line 4768: FND_DSQL.Add_Text(')');

4764: ,p_class_code_name_value_pairs
4765: ,'VALUES_ALL_CC'
4766: ,TRUE
4767: );
4768: FND_DSQL.Add_Text(')');
4769: END IF;
4770:
4771: FND_DSQL.Add_Text(') ');
4772:

Line 4771: FND_DSQL.Add_Text(') ');

4767: );
4768: FND_DSQL.Add_Text(')');
4769: END IF;
4770:
4771: FND_DSQL.Add_Text(') ');
4772:
4773: Debug_Msg('Bind params for the preceding SQL: '||p_object_id||' and '||p_attr_group_id, 3);
4774:
4775: l_cursor_id := DBMS_SQL.Open_Cursor;

Line 4776: DBMS_SQL.Parse(l_cursor_id, FND_DSQL.Get_Text(), DBMS_SQL.Native);

4772:
4773: Debug_Msg('Bind params for the preceding SQL: '||p_object_id||' and '||p_attr_group_id, 3);
4774:
4775: l_cursor_id := DBMS_SQL.Open_Cursor;
4776: DBMS_SQL.Parse(l_cursor_id, FND_DSQL.Get_Text(), DBMS_SQL.Native);
4777: FND_DSQL.Set_Cursor(l_cursor_id);
4778: FND_DSQL.Do_Binds();
4779: DBMS_SQL.Define_Column(l_cursor_id, 1, l_data_level, 30);
4780: l_dummy := DBMS_SQL.Execute(l_cursor_id);

Line 4777: FND_DSQL.Set_Cursor(l_cursor_id);

4773: Debug_Msg('Bind params for the preceding SQL: '||p_object_id||' and '||p_attr_group_id, 3);
4774:
4775: l_cursor_id := DBMS_SQL.Open_Cursor;
4776: DBMS_SQL.Parse(l_cursor_id, FND_DSQL.Get_Text(), DBMS_SQL.Native);
4777: FND_DSQL.Set_Cursor(l_cursor_id);
4778: FND_DSQL.Do_Binds();
4779: DBMS_SQL.Define_Column(l_cursor_id, 1, l_data_level, 30);
4780: l_dummy := DBMS_SQL.Execute(l_cursor_id);
4781: l_dummy := DBMS_SQL.Fetch_Rows(l_cursor_id);

Line 4778: FND_DSQL.Do_Binds();

4774:
4775: l_cursor_id := DBMS_SQL.Open_Cursor;
4776: DBMS_SQL.Parse(l_cursor_id, FND_DSQL.Get_Text(), DBMS_SQL.Native);
4777: FND_DSQL.Set_Cursor(l_cursor_id);
4778: FND_DSQL.Do_Binds();
4779: DBMS_SQL.Define_Column(l_cursor_id, 1, l_data_level, 30);
4780: l_dummy := DBMS_SQL.Execute(l_cursor_id);
4781: l_dummy := DBMS_SQL.Fetch_Rows(l_cursor_id);
4782:

Line 7522: -- and initialize FND_DSQL for our DMLs --

7518: END IF;
7519:
7520: -----------------------------------------------
7521: -- Now we open a cursor for the statement(s) --
7522: -- and initialize FND_DSQL for our DMLs --
7523: -----------------------------------------------
7524: l_cursor_id := DBMS_SQL.Open_Cursor;
7525: Init();
7526:

Line 7552: -- FND_DSQL and start our first DML statement --

7548: IF (p_language_to_process IS NULL OR
7549: p_language_to_process = USERENV('LANG')) THEN
7550:
7551: ------------------------------------------------------
7552: -- FND_DSQL and start our first DML statement --
7553: -- NOTE: we insert into both tables regardless of --
7554: -- whether there are any Attr values for each table --
7555: -- so that the VL doesn't have to outer join --
7556: ------------------------------------------------------

Line 7560: FND_DSQL.Add_Text('INSERT INTO '||l_b_table_name||

7556: ------------------------------------------------------
7557:
7558: -- CM expects extension Id to be the first bind
7559: -- in the generated DML
7560: FND_DSQL.Add_Text('INSERT INTO '||l_b_table_name||
7561: ' ('||
7562: 'EXTENSION_ID, ');
7563:
7564: -----------------------------------------------------

Line 7568: FND_DSQL.Add_Text('ATTR_GROUP_ID, ');

7564: -----------------------------------------------------
7565: -- Add attr_group_id only if table has this column --
7566: -----------------------------------------------------
7567: IF (p_attr_group_metadata_obj.ATTR_GROUP_ID_FLAG ='Y') THEN
7568: FND_DSQL.Add_Text('ATTR_GROUP_ID, ');
7569: END IF;
7570:
7571: -----------------------------------------------------
7572: -- Add data_level_id only if it has been provided --

Line 7582: FND_DSQL.Add_Text('DATA_LEVEL_ID, ');

7578: ,p_column_name => 'DATA_LEVEL_ID'
7579: )
7580: )
7581: ) THEN
7582: FND_DSQL.Add_Text('DATA_LEVEL_ID, ');
7583: END IF;
7584:
7585: --------------------------------------------------------------------------
7586: -- We trust that the names and values (fetched separately) will match --

Line 7635: FND_DSQL.Add_Text(', ' || l_change_col_names || l_extra_col_names);

7631: END IF;
7632:
7633: Debug_Msg(' l_dl_col_names-'||l_dl_col_names);
7634:
7635: FND_DSQL.Add_Text(', ' || l_change_col_names || l_extra_col_names);
7636:
7637: -----------------------------------------------
7638: -- Add the Attr column info to the statement --
7639: -----------------------------------------------

Line 7660: FND_DSQL.Add_Text('UNIQUE_VALUE, ');

7656: l_column_exists:= HAS_COLUMN_IN_TABLE_VIEW(l_b_table_name,'UNIQUE_VALUE');
7657:
7658: -- Add UNIQUE_VALUE only if table has this column for multi row UDAs only
7659: IF (FND_API.TO_BOOLEAN(l_column_exists)) THEN
7660: FND_DSQL.Add_Text('UNIQUE_VALUE, ');
7661: END IF;
7662: END IF;
7663: -- Bug 10097738 : End
7664:

Line 7668: FND_DSQL.Add_Text('CREATED_BY, '||

7664:
7665: -------------------------------------
7666: -- Add the rest of the column info --
7667: -------------------------------------
7668: FND_DSQL.Add_Text('CREATED_BY, '||
7669: 'CREATION_DATE, '||
7670: 'LAST_UPDATED_BY, '||
7671: 'LAST_UPDATE_DATE, '||
7672: 'LAST_UPDATE_LOGIN'||

Line 7685: FND_DSQL.Add_Text(', ');

7681: -----------------------------------------------------
7682: -- Add attr_group_id only if table has this column --
7683: -----------------------------------------------------
7684: IF (p_attr_group_metadata_obj.ATTR_GROUP_ID_FLAG ='Y') THEN
7685: FND_DSQL.Add_Text(', ');
7686: Add_Bind(p_bind_identifier => 'ATTR_GROUP_ID'
7687: ,p_value => p_attr_group_metadata_obj.ATTR_GROUP_ID);
7688: END IF;
7689:

Line 7705: FND_DSQL.Add_Text(', ');

7701: ) THEN
7702: l_data_level_id := Get_Data_Level_Id( p_attr_group_metadata_obj.APPLICATION_ID
7703: ,p_attr_group_metadata_obj.ATTR_GROUP_TYPE
7704: ,p_data_level);
7705: FND_DSQL.Add_Text(', ');
7706: Add_Bind(p_bind_identifier => 'DATA_LEVEL_ID'
7707: ,p_value => l_data_level_id);
7708: Debug_Msg(' in insert_row -- l_data_level_id-'||l_data_level_id);
7709: END IF;

Line 7712: FND_DSQL.Add_Text(', ');

7708: Debug_Msg(' in insert_row -- l_data_level_id-'||l_data_level_id);
7709: END IF;
7710:
7711:
7712: FND_DSQL.Add_Text(', ');
7713: Debug_Msg(l_api_name || ' calling EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols for PK 2 ');
7714: l_pk_col_values := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
7715: p_ext_table_metadata_obj.pk_column_metadata
7716: ,p_pk_column_name_value_pairs

Line 7745: FND_DSQL.Add_Text(', '||l_change_col_values|| l_extra_col_values);

7741: ,', '
7742: );
7743: END IF;
7744:
7745: FND_DSQL.Add_Text(', '||l_change_col_values|| l_extra_col_values);
7746:
7747: Add_Attr_Info_To_Statement(p_attr_group_metadata_obj.attr_metadata_table
7748: ,p_attr_name_value_pairs
7749: ,', '

Line 7760: FND_DSQL.Add_Bind(l_new_extension_id); -- inserting the ext id value in UNIQUE_VALUE column for MR UDAs

7756: ----------------------------------------------------------------------
7757:
7758: -- Bug 10097738 : Start
7759: IF (p_attr_group_metadata_obj.MULTI_ROW_CODE = 'Y' AND FND_API.TO_BOOLEAN(l_column_exists)) THEN
7760: FND_DSQL.Add_Bind(l_new_extension_id); -- inserting the ext id value in UNIQUE_VALUE column for MR UDAs
7761: FND_DSQL.Add_Text(', ');
7762: END IF;
7763: -- Bug 10097738 : End
7764:

Line 7761: FND_DSQL.Add_Text(', ');

7757:
7758: -- Bug 10097738 : Start
7759: IF (p_attr_group_metadata_obj.MULTI_ROW_CODE = 'Y' AND FND_API.TO_BOOLEAN(l_column_exists)) THEN
7760: FND_DSQL.Add_Bind(l_new_extension_id); -- inserting the ext id value in UNIQUE_VALUE column for MR UDAs
7761: FND_DSQL.Add_Text(', ');
7762: END IF;
7763: -- Bug 10097738 : End
7764:
7765: Add_Bind(p_bind_identifier => 'CREATED_BY'

Line 7767: FND_DSQL.Add_Text(', ');

7763: -- Bug 10097738 : End
7764:
7765: Add_Bind(p_bind_identifier => 'CREATED_BY'
7766: ,p_value => l_current_user_id);
7767: FND_DSQL.Add_Text(', ');
7768: --Added by geguo for 9373845
7769: SELECT NVL(G_WHO_CREATION_DATE, SYSDATE),
7770: NVL(G_WHO_LAST_UPDATE_DATE, SYSDATE)
7771: INTO G_WHO_CREATION_DATE, G_WHO_LAST_UPDATE_DATE

Line 7776: FND_DSQL.Add_Text(', ');

7772: FROM DUAL;
7773:
7774: Add_Bind(p_bind_identifier => 'CREATION_DATE'
7775: ,p_value => G_WHO_CREATION_DATE);
7776: FND_DSQL.Add_Text(', ');
7777: Add_Bind(p_bind_identifier => 'LAST_UPDATED_BY'
7778: ,p_value => l_current_user_id);
7779: FND_DSQL.Add_Text(', ');
7780:

Line 7779: FND_DSQL.Add_Text(', ');

7775: ,p_value => G_WHO_CREATION_DATE);
7776: FND_DSQL.Add_Text(', ');
7777: Add_Bind(p_bind_identifier => 'LAST_UPDATED_BY'
7778: ,p_value => l_current_user_id);
7779: FND_DSQL.Add_Text(', ');
7780:
7781: --Added by geguo for 9373845
7782: Add_Bind(p_bind_identifier => 'LAST_UPDATE_DATE'
7783: ,p_value => G_WHO_LAST_UPDATE_DATE);

Line 7784: FND_DSQL.Add_Text(', ');

7780:
7781: --Added by geguo for 9373845
7782: Add_Bind(p_bind_identifier => 'LAST_UPDATE_DATE'
7783: ,p_value => G_WHO_LAST_UPDATE_DATE);
7784: FND_DSQL.Add_Text(', ');
7785: Add_Bind(p_bind_identifier => 'LAST_UPDATE_LOGIN'
7786: ,p_value => l_current_login_id);
7787: FND_DSQL.Add_Text(')');
7788:

Line 7787: FND_DSQL.Add_Text(')');

7783: ,p_value => G_WHO_LAST_UPDATE_DATE);
7784: FND_DSQL.Add_Text(', ');
7785: Add_Bind(p_bind_identifier => 'LAST_UPDATE_LOGIN'
7786: ,p_value => l_current_login_id);
7787: FND_DSQL.Add_Text(')');
7788:
7789: l_dynamic_sql := FND_DSQL.Get_Text(FALSE);
7790:
7791: Debug_Msg('In Insert_Row, l_dynamic_sql for base table is as follows:', 3);

Line 7789: l_dynamic_sql := FND_DSQL.Get_Text(FALSE);

7785: Add_Bind(p_bind_identifier => 'LAST_UPDATE_LOGIN'
7786: ,p_value => l_current_login_id);
7787: FND_DSQL.Add_Text(')');
7788:
7789: l_dynamic_sql := FND_DSQL.Get_Text(FALSE);
7790:
7791: Debug_Msg('In Insert_Row, l_dynamic_sql for base table is as follows:', 3);
7792: Debug_Msg(l_dynamic_sql,3);
7793: Debug_SQL(FND_DSQL.Get_Text(TRUE));

Line 7793: Debug_SQL(FND_DSQL.Get_Text(TRUE));

7789: l_dynamic_sql := FND_DSQL.Get_Text(FALSE);
7790:
7791: Debug_Msg('In Insert_Row, l_dynamic_sql for base table is as follows:', 3);
7792: Debug_Msg(l_dynamic_sql,3);
7793: Debug_SQL(FND_DSQL.Get_Text(TRUE));
7794: Set_Binds_And_Dml(l_dynamic_sql,'B');
7795:
7796: ---------------------------------------------------------------------
7797: -- Next we parse the statement, bind our variables, and execute it --

Line 7802: FND_DSQL.Set_Cursor(l_cursor_id);

7798: ---------------------------------------------------------------------
7799:
7800: IF (p_execute_dml = FND_API.G_TRUE) THEN
7801: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.Native);
7802: FND_DSQL.Set_Cursor(l_cursor_id);
7803: FND_DSQL.Do_Binds();
7804: END IF;
7805:
7806: --

Line 7803: FND_DSQL.Do_Binds();

7799:
7800: IF (p_execute_dml = FND_API.G_TRUE) THEN
7801: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.Native);
7802: FND_DSQL.Set_Cursor(l_cursor_id);
7803: FND_DSQL.Do_Binds();
7804: END IF;
7805:
7806: --
7807: -- Bug 12603968. Resetting the global variables.

Line 7854: FND_DSQL.Add_Text('INSERT INTO '||l_tl_table_name||

7850:
7851: Init();
7852: -- CM expects extension Id to be the first bind
7853: -- in the generated DML
7854: FND_DSQL.Add_Text('INSERT INTO '||l_tl_table_name||
7855: ' ('||
7856: 'EXTENSION_ID, ');
7857:
7858: -----------------------------------------------------

Line 7862: FND_DSQL.Add_Text('ATTR_GROUP_ID, ');

7858: -----------------------------------------------------
7859: -- Add attr_group_id only if table has this column --
7860: -----------------------------------------------------
7861: IF (p_attr_group_metadata_obj.ATTR_GROUP_ID_FLAG ='Y') THEN
7862: FND_DSQL.Add_Text('ATTR_GROUP_ID, ');
7863: END IF;
7864:
7865: -----------------------------------------------------
7866: -- Add data_level_id only if it has been provided --

Line 7876: FND_DSQL.Add_Text('DATA_LEVEL_ID, ');

7872: ,p_column_name => 'DATA_LEVEL_ID'
7873: )
7874: )
7875: ) THEN
7876: FND_DSQL.Add_Text('DATA_LEVEL_ID, ');
7877: END IF;
7878:
7879: l_pk_col_names := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
7880: p_ext_table_metadata_obj.pk_column_metadata

Line 7904: FND_DSQL.Add_Text(', ' || l_change_col_names||l_extra_col_names);

7900: ,', '
7901: );
7902: END IF;
7903:
7904: FND_DSQL.Add_Text(', ' || l_change_col_names||l_extra_col_names);
7905:
7906: Add_Attr_Info_To_Statement(p_attr_group_metadata_obj.attr_metadata_table
7907: ,p_attr_name_value_pairs
7908: ,', '

Line 7917: FND_DSQL.Add_Text('CREATED_BY, '||

7913: -- (No need to add a comma here, because Add_Attr_Info_To_Statement --
7914: -- adds a trailing separator to the list if it adds anything to it) --
7915: ----------------------------------------------------------------------
7916:
7917: FND_DSQL.Add_Text('CREATED_BY, '||
7918: 'CREATION_DATE, '||
7919: 'LAST_UPDATED_BY, '||
7920: 'LAST_UPDATE_DATE, '||
7921: 'LAST_UPDATE_LOGIN, '||

Line 7933: FND_DSQL.Add_Text(', ');

7929: -----------------------------------------------------
7930: -- Add attr_group_id only if table has this column --
7931: -----------------------------------------------------
7932: IF (p_attr_group_metadata_obj.ATTR_GROUP_ID_FLAG ='Y') THEN
7933: FND_DSQL.Add_Text(', ');
7934: Add_Bind(p_bind_identifier => 'ATTR_GROUP_ID'
7935: ,p_value => p_attr_group_metadata_obj.ATTR_GROUP_ID);
7936: END IF;
7937:

Line 7952: FND_DSQL.Add_Text(', ');

7948: ) THEN
7949: l_data_level_id := Get_Data_Level_Id( p_attr_group_metadata_obj.APPLICATION_ID
7950: ,p_attr_group_metadata_obj.ATTR_GROUP_TYPE
7951: ,p_data_level);
7952: FND_DSQL.Add_Text(', ');
7953: Add_Bind(p_bind_identifier => 'DATA_LEVEL_ID'
7954: ,p_value => l_data_level_id);
7955: END IF;
7956:

Line 7957: FND_DSQL.Add_Text(', ');

7953: Add_Bind(p_bind_identifier => 'DATA_LEVEL_ID'
7954: ,p_value => l_data_level_id);
7955: END IF;
7956:
7957: FND_DSQL.Add_Text(', ');
7958: l_pk_col_values := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
7959: p_ext_table_metadata_obj.pk_column_metadata
7960: ,p_pk_column_name_value_pairs
7961: ,'VALUES'

Line 7983: FND_DSQL.Add_Text(', '||l_change_col_values||l_extra_col_values);

7979: ,', '
7980: );
7981: END IF;
7982:
7983: FND_DSQL.Add_Text(', '||l_change_col_values||l_extra_col_values);
7984:
7985: Add_Attr_Info_To_Statement(p_attr_group_metadata_obj.attr_metadata_table
7986: ,p_attr_name_value_pairs
7987: ,', '

Line 7998: FND_DSQL.Add_Text(', ');

7994: ----------------------------------------------------------------------
7995:
7996: Add_Bind(p_bind_identifier => 'CREATED_BY'
7997: ,p_value => l_current_user_id);
7998: FND_DSQL.Add_Text(', ');
7999: Add_Bind(p_bind_identifier => 'CREATION_DATE'
8000: ,p_value => SYSDATE);
8001: FND_DSQL.Add_Text(', ');
8002: Add_Bind(p_bind_identifier => 'LAST_UPDATED_BY'

Line 8001: FND_DSQL.Add_Text(', ');

7997: ,p_value => l_current_user_id);
7998: FND_DSQL.Add_Text(', ');
7999: Add_Bind(p_bind_identifier => 'CREATION_DATE'
8000: ,p_value => SYSDATE);
8001: FND_DSQL.Add_Text(', ');
8002: Add_Bind(p_bind_identifier => 'LAST_UPDATED_BY'
8003: ,p_value => l_current_user_id);
8004: FND_DSQL.Add_Text(', ');
8005: Add_Bind(p_bind_identifier => 'LAST_UPDATE_DATE'

Line 8004: FND_DSQL.Add_Text(', ');

8000: ,p_value => SYSDATE);
8001: FND_DSQL.Add_Text(', ');
8002: Add_Bind(p_bind_identifier => 'LAST_UPDATED_BY'
8003: ,p_value => l_current_user_id);
8004: FND_DSQL.Add_Text(', ');
8005: Add_Bind(p_bind_identifier => 'LAST_UPDATE_DATE'
8006: ,p_value => SYSDATE);
8007: FND_DSQL.Add_Text(', ');
8008: Add_Bind(p_bind_identifier => 'LAST_UPDATE_LOGIN'

Line 8007: FND_DSQL.Add_Text(', ');

8003: ,p_value => l_current_user_id);
8004: FND_DSQL.Add_Text(', ');
8005: Add_Bind(p_bind_identifier => 'LAST_UPDATE_DATE'
8006: ,p_value => SYSDATE);
8007: FND_DSQL.Add_Text(', ');
8008: Add_Bind(p_bind_identifier => 'LAST_UPDATE_LOGIN'
8009: ,p_value => l_current_login_id);
8010: FND_DSQL.Add_Text(', ');
8011: Add_Bind(p_bind_identifier => 'SOURCE_LANG'

Line 8010: FND_DSQL.Add_Text(', ');

8006: ,p_value => SYSDATE);
8007: FND_DSQL.Add_Text(', ');
8008: Add_Bind(p_bind_identifier => 'LAST_UPDATE_LOGIN'
8009: ,p_value => l_current_login_id);
8010: FND_DSQL.Add_Text(', ');
8011: Add_Bind(p_bind_identifier => 'SOURCE_LANG'
8012: ,p_value => USERENV('LANG'));
8013: FND_DSQL.Add_Text(', L.LANGUAGE_CODE '||
8014: 'FROM '||

Line 8013: FND_DSQL.Add_Text(', L.LANGUAGE_CODE '||

8009: ,p_value => l_current_login_id);
8010: FND_DSQL.Add_Text(', ');
8011: Add_Bind(p_bind_identifier => 'SOURCE_LANG'
8012: ,p_value => USERENV('LANG'));
8013: FND_DSQL.Add_Text(', L.LANGUAGE_CODE '||
8014: 'FROM '||
8015: 'FND_LANGUAGES L '||
8016: 'WHERE L.INSTALLED_FLAG IN (''I'', ''B'')');
8017:

Line 8023: FND_DSQL.Add_Text(' AND L.LANGUAGE_CODE = ');

8019: -- We pass p_language_to_process from Implement_Change_Line so --
8020: -- that each pending TL row only inserts one production row --
8021: -----------------------------------------------------------------
8022: IF (p_language_to_process IS NOT NULL) THEN
8023: FND_DSQL.Add_Text(' AND L.LANGUAGE_CODE = ');
8024: Add_Bind(p_bind_identifier => 'LANGUAGE'
8025: ,p_value => p_language_to_process);
8026: END IF;
8027:

Line 8028: l_dynamic_sql := FND_DSQL.Get_Text(FALSE);

8024: Add_Bind(p_bind_identifier => 'LANGUAGE'
8025: ,p_value => p_language_to_process);
8026: END IF;
8027:
8028: l_dynamic_sql := FND_DSQL.Get_Text(FALSE);
8029:
8030: Set_Binds_And_Dml(l_dynamic_sql,'TL');
8031:
8032: Debug_Msg('In Insert_Row, l_dynamic_sql for TL table is as follows:', 3);

Line 8033: Debug_SQL(FND_DSQL.Get_Text(TRUE));

8029:
8030: Set_Binds_And_Dml(l_dynamic_sql,'TL');
8031:
8032: Debug_Msg('In Insert_Row, l_dynamic_sql for TL table is as follows:', 3);
8033: Debug_SQL(FND_DSQL.Get_Text(TRUE));
8034:
8035: ---------------------------------------------------
8036: -- We re-use our cursor from the first statement --
8037: ---------------------------------------------------

Line 8040: FND_DSQL.Set_Cursor(l_cursor_id);

8036: -- We re-use our cursor from the first statement --
8037: ---------------------------------------------------
8038: IF (p_execute_dml = FND_API.G_TRUE) THEN
8039: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.Native);
8040: FND_DSQL.Set_Cursor(l_cursor_id);
8041: FND_DSQL.Do_Binds();
8042: END IF;
8043:
8044: ---Start 4105841

Line 8041: FND_DSQL.Do_Binds();

8037: ---------------------------------------------------
8038: IF (p_execute_dml = FND_API.G_TRUE) THEN
8039: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.Native);
8040: FND_DSQL.Set_Cursor(l_cursor_id);
8041: FND_DSQL.Do_Binds();
8042: END IF;
8043:
8044: ---Start 4105841
8045: --raise the event if it has not been raised

Line 8408: FND_DSQL.Add_Text('UPDATE '||l_b_table_name||

8404: (p_language_to_process IS NULL OR
8405: p_language_to_process = USERENV('LANG'))) THEN
8406:
8407: Init();
8408: FND_DSQL.Add_Text('UPDATE '||l_b_table_name||
8409: ' SET '||l_extra_col_value_string||l_change_col_value_string);
8410:
8411: Add_Attr_Info_To_Statement(p_attr_group_metadata_obj.attr_metadata_table
8412: ,p_attr_name_value_pairs

Line 8422: FND_DSQL.Add_Text('LAST_UPDATED_BY = ');

8418: -- (No need to add a comma here, because Add_Attr_Info_To_Statement --
8419: -- adds a trailing separator to the list if it adds anything to it) --
8420: ----------------------------------------------------------------------
8421:
8422: FND_DSQL.Add_Text('LAST_UPDATED_BY = ');
8423: Add_Bind(p_bind_identifier => 'LAST_UPDATED_BY'
8424: ,p_value => l_current_user_id);
8425: FND_DSQL.Add_Text(', ');
8426: FND_DSQL.Add_Text('LAST_UPDATE_DATE = ');

Line 8425: FND_DSQL.Add_Text(', ');

8421:
8422: FND_DSQL.Add_Text('LAST_UPDATED_BY = ');
8423: Add_Bind(p_bind_identifier => 'LAST_UPDATED_BY'
8424: ,p_value => l_current_user_id);
8425: FND_DSQL.Add_Text(', ');
8426: FND_DSQL.Add_Text('LAST_UPDATE_DATE = ');
8427: --Added by geguo for 9373845
8428: SELECT NVL(G_WHO_LAST_UPDATE_DATE, SYSDATE) INTO G_WHO_LAST_UPDATE_DATE FROM DUAL;
8429: Add_Bind(p_bind_identifier => 'LAST_UPDATE_DATE'

Line 8426: FND_DSQL.Add_Text('LAST_UPDATE_DATE = ');

8422: FND_DSQL.Add_Text('LAST_UPDATED_BY = ');
8423: Add_Bind(p_bind_identifier => 'LAST_UPDATED_BY'
8424: ,p_value => l_current_user_id);
8425: FND_DSQL.Add_Text(', ');
8426: FND_DSQL.Add_Text('LAST_UPDATE_DATE = ');
8427: --Added by geguo for 9373845
8428: SELECT NVL(G_WHO_LAST_UPDATE_DATE, SYSDATE) INTO G_WHO_LAST_UPDATE_DATE FROM DUAL;
8429: Add_Bind(p_bind_identifier => 'LAST_UPDATE_DATE'
8430: ,p_value => G_WHO_LAST_UPDATE_DATE);

Line 8431: FND_DSQL.Add_Text(', ');

8427: --Added by geguo for 9373845
8428: SELECT NVL(G_WHO_LAST_UPDATE_DATE, SYSDATE) INTO G_WHO_LAST_UPDATE_DATE FROM DUAL;
8429: Add_Bind(p_bind_identifier => 'LAST_UPDATE_DATE'
8430: ,p_value => G_WHO_LAST_UPDATE_DATE);
8431: FND_DSQL.Add_Text(', ');
8432: FND_DSQL.Add_Text('LAST_UPDATE_LOGIN = ');
8433: Add_Bind(p_bind_identifier => 'LAST_UPDATE_LOGIN'
8434: ,p_value => l_current_login_id);
8435:

Line 8432: FND_DSQL.Add_Text('LAST_UPDATE_LOGIN = ');

8428: SELECT NVL(G_WHO_LAST_UPDATE_DATE, SYSDATE) INTO G_WHO_LAST_UPDATE_DATE FROM DUAL;
8429: Add_Bind(p_bind_identifier => 'LAST_UPDATE_DATE'
8430: ,p_value => G_WHO_LAST_UPDATE_DATE);
8431: FND_DSQL.Add_Text(', ');
8432: FND_DSQL.Add_Text('LAST_UPDATE_LOGIN = ');
8433: Add_Bind(p_bind_identifier => 'LAST_UPDATE_LOGIN'
8434: ,p_value => l_current_login_id);
8435:
8436: FND_DSQL.Add_Text(' WHERE EXTENSION_ID = ');

Line 8436: FND_DSQL.Add_Text(' WHERE EXTENSION_ID = ');

8432: FND_DSQL.Add_Text('LAST_UPDATE_LOGIN = ');
8433: Add_Bind(p_bind_identifier => 'LAST_UPDATE_LOGIN'
8434: ,p_value => l_current_login_id);
8435:
8436: FND_DSQL.Add_Text(' WHERE EXTENSION_ID = ');
8437: Add_Bind(p_bind_identifier => 'EXTENSION_ID'
8438: ,p_value => p_extension_id);
8439:
8440: ----------------------------------------------------------------------------

Line 8458: FND_DSQL.Add_Text(' AND DATA_LEVEL_ID = ');

8454: l_data_level_id := Get_Data_Level_Id( p_attr_group_metadata_obj.APPLICATION_ID
8455: ,p_attr_group_metadata_obj.ATTR_GROUP_TYPE
8456: ,p_data_level);
8457:
8458: FND_DSQL.Add_Text(' AND DATA_LEVEL_ID = ');
8459: Add_Bind(p_bind_identifier => 'DATA_LEVEL_ID'
8460: ,p_value => l_data_level_id);
8461:
8462: END IF;

Line 8475: FND_DSQL.Add_Text(' AND '||l_col_name||' = ');

8471:
8472: l_col_name := p_data_level_name_value_pairs(l_col_values_index).NAME;
8473: l_col_value := p_data_level_name_value_pairs(l_col_values_index).VALUE;
8474: IF (l_col_value is not NULL) THEN
8475: FND_DSQL.Add_Text(' AND '||l_col_name||' = ');
8476: Add_Bind(p_bind_identifier => l_col_name
8477: ,p_value => l_col_value);
8478: END IF;
8479: l_col_values_index := p_data_level_name_value_pairs.NEXT(l_col_values_index);

Line 8484: FND_DSQL.Add_Text(l_change_col_where_string);

8480: END LOOP;
8481: END IF;--p_data_level_name_value_pairs IS NOT NULL
8482: --End Bug 5211171
8483:
8484: FND_DSQL.Add_Text(l_change_col_where_string);
8485: FND_DSQL.Add_Text(l_extra_col_where_string);
8486:
8487:
8488:

Line 8485: FND_DSQL.Add_Text(l_extra_col_where_string);

8481: END IF;--p_data_level_name_value_pairs IS NOT NULL
8482: --End Bug 5211171
8483:
8484: FND_DSQL.Add_Text(l_change_col_where_string);
8485: FND_DSQL.Add_Text(l_extra_col_where_string);
8486:
8487:
8488:
8489: l_dynamic_sql := FND_DSQL.Get_Text(FALSE);

Line 8489: l_dynamic_sql := FND_DSQL.Get_Text(FALSE);

8485: FND_DSQL.Add_Text(l_extra_col_where_string);
8486:
8487:
8488:
8489: l_dynamic_sql := FND_DSQL.Get_Text(FALSE);
8490:
8491: Debug_Msg('In Update_Row, l_dynamic_sql for base table is as follows:', 3);
8492: Debug_Msg('In Update_Row, l_dynamic_sql:'||l_dynamic_sql, 3);
8493: Debug_SQL(FND_DSQL.Get_Text(TRUE));

Line 8493: Debug_SQL(FND_DSQL.Get_Text(TRUE));

8489: l_dynamic_sql := FND_DSQL.Get_Text(FALSE);
8490:
8491: Debug_Msg('In Update_Row, l_dynamic_sql for base table is as follows:', 3);
8492: Debug_Msg('In Update_Row, l_dynamic_sql:'||l_dynamic_sql, 3);
8493: Debug_SQL(FND_DSQL.Get_Text(TRUE));
8494: Set_Binds_And_Dml(l_dynamic_sql ,'B');
8495:
8496: IF (p_execute_dml = FND_API.G_TRUE) THEN
8497: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.Native);

Line 8498: FND_DSQL.Set_Cursor(l_cursor_id);

8494: Set_Binds_And_Dml(l_dynamic_sql ,'B');
8495:
8496: IF (p_execute_dml = FND_API.G_TRUE) THEN
8497: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.Native);
8498: FND_DSQL.Set_Cursor(l_cursor_id);
8499: FND_DSQL.Do_Binds();
8500: END IF;
8501:
8502: --

Line 8499: FND_DSQL.Do_Binds();

8495:
8496: IF (p_execute_dml = FND_API.G_TRUE) THEN
8497: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.Native);
8498: FND_DSQL.Set_Cursor(l_cursor_id);
8499: FND_DSQL.Do_Binds();
8500: END IF;
8501:
8502: --
8503: -- Bug 12603968. Resetting the global variables.

Line 8546: FND_DSQL.Add_Text('UPDATE '||l_tl_table_name||

8542: IF (p_attr_group_metadata_obj.TRANS_ATTRS_COUNT > 0 AND
8543: p_attr_group_metadata_obj.EXT_TABLE_TL_NAME IS NOT NULL) THEN
8544:
8545: Init();
8546: FND_DSQL.Add_Text('UPDATE '||l_tl_table_name||
8547: ' SET '||l_change_col_value_string);
8548:
8549: Add_Attr_Info_To_Statement(p_attr_group_metadata_obj.attr_metadata_table
8550: ,p_attr_name_value_pairs

Line 8560: FND_DSQL.Add_Text('LAST_UPDATED_BY = ');

8556: -- (No need to add a comma here, because Add_Attr_Info_To_Statement --
8557: -- adds a trailing separator to the list if it adds anything to it) --
8558: ----------------------------------------------------------------------
8559:
8560: FND_DSQL.Add_Text('LAST_UPDATED_BY = ');
8561: Add_Bind(p_bind_identifier => 'LAST_UPDATED_BY'
8562: ,p_value => l_current_user_id);
8563: FND_DSQL.Add_Text(', ');
8564: FND_DSQL.Add_Text('LAST_UPDATE_DATE = ');

Line 8563: FND_DSQL.Add_Text(', ');

8559:
8560: FND_DSQL.Add_Text('LAST_UPDATED_BY = ');
8561: Add_Bind(p_bind_identifier => 'LAST_UPDATED_BY'
8562: ,p_value => l_current_user_id);
8563: FND_DSQL.Add_Text(', ');
8564: FND_DSQL.Add_Text('LAST_UPDATE_DATE = ');
8565: Add_Bind(p_bind_identifier => 'LAST_UPDATE_DATE'
8566: ,p_value => SYSDATE);
8567: FND_DSQL.Add_Text(', ');

Line 8564: FND_DSQL.Add_Text('LAST_UPDATE_DATE = ');

8560: FND_DSQL.Add_Text('LAST_UPDATED_BY = ');
8561: Add_Bind(p_bind_identifier => 'LAST_UPDATED_BY'
8562: ,p_value => l_current_user_id);
8563: FND_DSQL.Add_Text(', ');
8564: FND_DSQL.Add_Text('LAST_UPDATE_DATE = ');
8565: Add_Bind(p_bind_identifier => 'LAST_UPDATE_DATE'
8566: ,p_value => SYSDATE);
8567: FND_DSQL.Add_Text(', ');
8568: FND_DSQL.Add_Text('LAST_UPDATE_LOGIN = ');

Line 8567: FND_DSQL.Add_Text(', ');

8563: FND_DSQL.Add_Text(', ');
8564: FND_DSQL.Add_Text('LAST_UPDATE_DATE = ');
8565: Add_Bind(p_bind_identifier => 'LAST_UPDATE_DATE'
8566: ,p_value => SYSDATE);
8567: FND_DSQL.Add_Text(', ');
8568: FND_DSQL.Add_Text('LAST_UPDATE_LOGIN = ');
8569: Add_Bind(p_bind_identifier => 'LAST_UPDATE_LOGIN'
8570: ,p_value => l_current_login_id);
8571: --Bug 10065435

Line 8568: FND_DSQL.Add_Text('LAST_UPDATE_LOGIN = ');

8564: FND_DSQL.Add_Text('LAST_UPDATE_DATE = ');
8565: Add_Bind(p_bind_identifier => 'LAST_UPDATE_DATE'
8566: ,p_value => SYSDATE);
8567: FND_DSQL.Add_Text(', ');
8568: FND_DSQL.Add_Text('LAST_UPDATE_LOGIN = ');
8569: Add_Bind(p_bind_identifier => 'LAST_UPDATE_LOGIN'
8570: ,p_value => l_current_login_id);
8571: --Bug 10065435
8572: FND_DSQL.Add_Text(', ');

Line 8572: FND_DSQL.Add_Text(', ');

8568: FND_DSQL.Add_Text('LAST_UPDATE_LOGIN = ');
8569: Add_Bind(p_bind_identifier => 'LAST_UPDATE_LOGIN'
8570: ,p_value => l_current_login_id);
8571: --Bug 10065435
8572: FND_DSQL.Add_Text(', ');
8573: IF (p_language_to_process IS NOT NULL and p_language_to_process <> USERENV('LANG')) THEN
8574: FND_DSQL.Add_Text('SOURCE_LANG = DECODE(SOURCE_LANG, LANGUAGE,''' || p_language_to_process || ''', SOURCE_LANG)');
8575: else
8576: FND_DSQL.Add_Text('SOURCE_LANG = ');

Line 8574: FND_DSQL.Add_Text('SOURCE_LANG = DECODE(SOURCE_LANG, LANGUAGE,''' || p_language_to_process || ''', SOURCE_LANG)');

8570: ,p_value => l_current_login_id);
8571: --Bug 10065435
8572: FND_DSQL.Add_Text(', ');
8573: IF (p_language_to_process IS NOT NULL and p_language_to_process <> USERENV('LANG')) THEN
8574: FND_DSQL.Add_Text('SOURCE_LANG = DECODE(SOURCE_LANG, LANGUAGE,''' || p_language_to_process || ''', SOURCE_LANG)');
8575: else
8576: FND_DSQL.Add_Text('SOURCE_LANG = ');
8577: Add_Bind(p_bind_identifier => 'SOURCE_LANG'
8578: ,p_value => USERENV('LANG'));

Line 8576: FND_DSQL.Add_Text('SOURCE_LANG = ');

8572: FND_DSQL.Add_Text(', ');
8573: IF (p_language_to_process IS NOT NULL and p_language_to_process <> USERENV('LANG')) THEN
8574: FND_DSQL.Add_Text('SOURCE_LANG = DECODE(SOURCE_LANG, LANGUAGE,''' || p_language_to_process || ''', SOURCE_LANG)');
8575: else
8576: FND_DSQL.Add_Text('SOURCE_LANG = ');
8577: Add_Bind(p_bind_identifier => 'SOURCE_LANG'
8578: ,p_value => USERENV('LANG'));
8579: end if; -- end Bug 10065435
8580:

Line 8581: FND_DSQL.Add_Text(' WHERE EXTENSION_ID = ');

8577: Add_Bind(p_bind_identifier => 'SOURCE_LANG'
8578: ,p_value => USERENV('LANG'));
8579: end if; -- end Bug 10065435
8580:
8581: FND_DSQL.Add_Text(' WHERE EXTENSION_ID = ');
8582: Add_Bind(p_bind_identifier => 'EXTENSION_ID'
8583: ,p_value => p_extension_id);
8584:
8585: ----------------------------------------------------------------------------

Line 8603: FND_DSQL.Add_Text(' AND DATA_LEVEL_ID = ');

8599: l_data_level_id := Get_Data_Level_Id( p_attr_group_metadata_obj.APPLICATION_ID
8600: ,p_attr_group_metadata_obj.ATTR_GROUP_TYPE
8601: ,p_data_level);
8602:
8603: FND_DSQL.Add_Text(' AND DATA_LEVEL_ID = ');
8604: Add_Bind(p_bind_identifier => 'DATA_LEVEL_ID'
8605: ,p_value => l_data_level_id);
8606:
8607: END IF;

Line 8621: FND_DSQL.Add_Text(' AND '||l_col_name||' = ');

8617: LOOP
8618: l_col_name := p_data_level_name_value_pairs(l_col_values_index).NAME;
8619: l_col_value := p_data_level_name_value_pairs(l_col_values_index).VALUE;
8620: IF (l_col_value is not NULL) THEN
8621: FND_DSQL.Add_Text(' AND '||l_col_name||' = ');
8622: Add_Bind(p_bind_identifier => l_col_name
8623: ,p_value => l_col_value);
8624: END IF;
8625: l_col_values_index := p_class_code_name_value_pairs.NEXT(l_col_values_index);

Line 8630: FND_DSQL.Add_Text(l_change_col_where_string);

8626: END LOOP;
8627: END IF;--p_data_level_name_value_pairs IS NOT NULL
8628: --End Bug 5211171
8629:
8630: FND_DSQL.Add_Text(l_change_col_where_string);
8631: FND_DSQL.Add_Text(l_extra_col_where_string); -- bug 8349515
8632:
8633: -----------------------------------------------------------------
8634: -- We pass p_language_to_process from Implement_Change_Line so --

Line 8631: FND_DSQL.Add_Text(l_extra_col_where_string); -- bug 8349515

8627: END IF;--p_data_level_name_value_pairs IS NOT NULL
8628: --End Bug 5211171
8629:
8630: FND_DSQL.Add_Text(l_change_col_where_string);
8631: FND_DSQL.Add_Text(l_extra_col_where_string); -- bug 8349515
8632:
8633: -----------------------------------------------------------------
8634: -- We pass p_language_to_process from Implement_Change_Line so --
8635: -- that each pending TL row only updates one production row --

Line 8638: FND_DSQL.Add_Text(' AND ((SOURCE_LANG = ');

8634: -- We pass p_language_to_process from Implement_Change_Line so --
8635: -- that each pending TL row only updates one production row --
8636: -----------------------------------------------------------------
8637: IF (p_language_to_process IS NOT NULL) THEN
8638: FND_DSQL.Add_Text(' AND ((SOURCE_LANG = ');
8639: Add_Bind(p_bind_identifier => 'SOURCE_LANG'
8640: ,p_value => USERENV('LANG'));
8641: FND_DSQL.Add_Text(' AND LANGUAGE = ');
8642: Add_Bind(p_bind_identifier => 'LANGUAGE'

Line 8641: FND_DSQL.Add_Text(' AND LANGUAGE = ');

8637: IF (p_language_to_process IS NOT NULL) THEN
8638: FND_DSQL.Add_Text(' AND ((SOURCE_LANG = ');
8639: Add_Bind(p_bind_identifier => 'SOURCE_LANG'
8640: ,p_value => USERENV('LANG'));
8641: FND_DSQL.Add_Text(' AND LANGUAGE = ');
8642: Add_Bind(p_bind_identifier => 'LANGUAGE'
8643: ,p_value => p_language_to_process);
8644: FND_DSQL.Add_Text(') OR (SOURCE_LANG <> ');
8645: Add_Bind(p_bind_identifier => 'SOURCE_LANG'

Line 8644: FND_DSQL.Add_Text(') OR (SOURCE_LANG <> ');

8640: ,p_value => USERENV('LANG'));
8641: FND_DSQL.Add_Text(' AND LANGUAGE = ');
8642: Add_Bind(p_bind_identifier => 'LANGUAGE'
8643: ,p_value => p_language_to_process);
8644: FND_DSQL.Add_Text(') OR (SOURCE_LANG <> ');
8645: Add_Bind(p_bind_identifier => 'SOURCE_LANG'
8646: ,p_value => USERENV('LANG'));
8647: FND_DSQL.Add_Text(' AND LANGUAGE = ');
8648: Add_Bind(p_bind_identifier => 'LANGUAGE'

Line 8647: FND_DSQL.Add_Text(' AND LANGUAGE = ');

8643: ,p_value => p_language_to_process);
8644: FND_DSQL.Add_Text(') OR (SOURCE_LANG <> ');
8645: Add_Bind(p_bind_identifier => 'SOURCE_LANG'
8646: ,p_value => USERENV('LANG'));
8647: FND_DSQL.Add_Text(' AND LANGUAGE = ');
8648: Add_Bind(p_bind_identifier => 'LANGUAGE'
8649: ,p_value => USERENV('LANG'));
8650: --added for bug 10065435
8651: FND_DSQL.Add_Text(') OR (SOURCE_LANG = ');

Line 8651: FND_DSQL.Add_Text(') OR (SOURCE_LANG = ');

8647: FND_DSQL.Add_Text(' AND LANGUAGE = ');
8648: Add_Bind(p_bind_identifier => 'LANGUAGE'
8649: ,p_value => USERENV('LANG'));
8650: --added for bug 10065435
8651: FND_DSQL.Add_Text(') OR (SOURCE_LANG = ');
8652: Add_Bind(p_bind_identifier => 'SOURCE_LANG'
8653: ,p_value => p_language_to_process);
8654: FND_DSQL.Add_Text(' AND LANGUAGE = ');
8655: Add_Bind(p_bind_identifier => 'LANGUAGE'

Line 8654: FND_DSQL.Add_Text(' AND LANGUAGE = ');

8650: --added for bug 10065435
8651: FND_DSQL.Add_Text(') OR (SOURCE_LANG = ');
8652: Add_Bind(p_bind_identifier => 'SOURCE_LANG'
8653: ,p_value => p_language_to_process);
8654: FND_DSQL.Add_Text(' AND LANGUAGE = ');
8655: Add_Bind(p_bind_identifier => 'LANGUAGE'
8656: ,p_value => p_language_to_process);
8657: --end for bug 10065435
8658: FND_DSQL.Add_Text('))');

Line 8658: FND_DSQL.Add_Text('))');

8654: FND_DSQL.Add_Text(' AND LANGUAGE = ');
8655: Add_Bind(p_bind_identifier => 'LANGUAGE'
8656: ,p_value => p_language_to_process);
8657: --end for bug 10065435
8658: FND_DSQL.Add_Text('))');
8659: ELSE
8660: ----------------------------------------------------------
8661: -- In all other flows, we want to update all rows whose --
8662: -- language or source language is the current language --

Line 8664: FND_DSQL.Add_Text(' AND (LANGUAGE = ');

8660: ----------------------------------------------------------
8661: -- In all other flows, we want to update all rows whose --
8662: -- language or source language is the current language --
8663: ----------------------------------------------------------
8664: FND_DSQL.Add_Text(' AND (LANGUAGE = ');
8665: Add_Bind(p_bind_identifier => 'LANGUAGE'
8666: ,p_value => USERENV('LANG'));
8667: FND_DSQL.Add_Text(' OR SOURCE_LANG = ');
8668: Add_Bind(p_bind_identifier => 'SOURCE_LANG'

Line 8667: FND_DSQL.Add_Text(' OR SOURCE_LANG = ');

8663: ----------------------------------------------------------
8664: FND_DSQL.Add_Text(' AND (LANGUAGE = ');
8665: Add_Bind(p_bind_identifier => 'LANGUAGE'
8666: ,p_value => USERENV('LANG'));
8667: FND_DSQL.Add_Text(' OR SOURCE_LANG = ');
8668: Add_Bind(p_bind_identifier => 'SOURCE_LANG'
8669: ,p_value => USERENV('LANG'));
8670: FND_DSQL.Add_Text(')');
8671: END IF;

Line 8670: FND_DSQL.Add_Text(')');

8666: ,p_value => USERENV('LANG'));
8667: FND_DSQL.Add_Text(' OR SOURCE_LANG = ');
8668: Add_Bind(p_bind_identifier => 'SOURCE_LANG'
8669: ,p_value => USERENV('LANG'));
8670: FND_DSQL.Add_Text(')');
8671: END IF;
8672:
8673:
8674: l_dynamic_sql := FND_DSQL.Get_Text(FALSE);

Line 8674: l_dynamic_sql := FND_DSQL.Get_Text(FALSE);

8670: FND_DSQL.Add_Text(')');
8671: END IF;
8672:
8673:
8674: l_dynamic_sql := FND_DSQL.Get_Text(FALSE);
8675: Set_Binds_And_Dml(l_dynamic_sql ,'TL');
8676:
8677: Debug_Msg('In Update_Row, l_dynamic_sql for TL table is as follows:', 3);
8678: Debug_SQL(FND_DSQL.Get_Text(TRUE));

Line 8678: Debug_SQL(FND_DSQL.Get_Text(TRUE));

8674: l_dynamic_sql := FND_DSQL.Get_Text(FALSE);
8675: Set_Binds_And_Dml(l_dynamic_sql ,'TL');
8676:
8677: Debug_Msg('In Update_Row, l_dynamic_sql for TL table is as follows:', 3);
8678: Debug_SQL(FND_DSQL.Get_Text(TRUE));
8679:
8680: IF (p_execute_dml = FND_API.G_TRUE) THEN
8681: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.Native);
8682: FND_DSQL.Set_Cursor(l_cursor_id);

Line 8682: FND_DSQL.Set_Cursor(l_cursor_id);

8678: Debug_SQL(FND_DSQL.Get_Text(TRUE));
8679:
8680: IF (p_execute_dml = FND_API.G_TRUE) THEN
8681: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.Native);
8682: FND_DSQL.Set_Cursor(l_cursor_id);
8683: FND_DSQL.Do_Binds();
8684: END IF;
8685:
8686: --Start 4105841

Line 8683: FND_DSQL.Do_Binds();

8679:
8680: IF (p_execute_dml = FND_API.G_TRUE) THEN
8681: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.Native);
8682: FND_DSQL.Set_Cursor(l_cursor_id);
8683: FND_DSQL.Do_Binds();
8684: END IF;
8685:
8686: --Start 4105841
8687: --Raise pre Event if not already raised

Line 9052: FND_DSQL.Add_Text(' AND LANGUAGE = ');

9048: -- We pass p_language_to_process from Implement_Change_Line so --
9049: -- that each pending TL row only deletes one production row --
9050: -----------------------------------------------------------------
9051: IF (p_language_to_process IS NOT NULL) THEN
9052: FND_DSQL.Add_Text(' AND LANGUAGE = ');
9053: Add_Bind(p_value => p_language_to_process);
9054: END IF;
9055: END IF;
9056:

Line 10754: -- predicate using fnd_dsql methods.

10750:
10751: --
10752: -- Bug 1276239. Performance issue in Get_User_Attrs_Data.
10753: -- Added below supporting methods to build the dynamic SQL
10754: -- predicate using fnd_dsql methods.
10755: -- sreharih. Thu Aug 25 12:44:00 PDT 2011
10756: --
10757:
10758:

Line 10765: fnd_dsql.add_text(' AND ');

10761: --
10762: PROCEDURE add_and IS
10763:
10764: BEGIN
10765: fnd_dsql.add_text(' AND ');
10766: END add_and;
10767:
10768:
10769: --

Line 10817: fnd_dsql.add_text(l_predicate);

10813: Debug_msg('add_nameval_predicate: ' || ' adding predicate for ' || p_col_metadata(i).col_name || ' value ' || p_nameval_pairs(j).value);
10814:
10815: IF p_nameval_pairs(j).value IS NULL THEN
10816: l_predicate := p_col_metadata(i).col_name || ' IS NULL ';
10817: fnd_dsql.add_text(l_predicate);
10818: ELSE
10819: l_predicate := p_col_metadata(i).col_name || ' = ';
10820: fnd_dsql.add_text(l_predicate);
10821: fnd_dsql.add_bind(p_nameval_pairs(j).value);

Line 10820: fnd_dsql.add_text(l_predicate);

10816: l_predicate := p_col_metadata(i).col_name || ' IS NULL ';
10817: fnd_dsql.add_text(l_predicate);
10818: ELSE
10819: l_predicate := p_col_metadata(i).col_name || ' = ';
10820: fnd_dsql.add_text(l_predicate);
10821: fnd_dsql.add_bind(p_nameval_pairs(j).value);
10822: END IF;
10823: x_predicate_added := TRUE;
10824: l_add_and := TRUE;

Line 10821: fnd_dsql.add_bind(p_nameval_pairs(j).value);

10817: fnd_dsql.add_text(l_predicate);
10818: ELSE
10819: l_predicate := p_col_metadata(i).col_name || ' = ';
10820: fnd_dsql.add_text(l_predicate);
10821: fnd_dsql.add_bind(p_nameval_pairs(j).value);
10822: END IF;
10823: x_predicate_added := TRUE;
10824: l_add_and := TRUE;
10825: END IF;

Line 10924: fnd_dsql.add_text(' DATA_LEVEL_ID = ');

10920: IF p_add_and THEN
10921: add_and;
10922: END IF;
10923: Debug_msg('add_datalevel_predicate: ' || 'Added data_level_id condition DATA_LEVEL_ID = ' || p_data_level_id);
10924: fnd_dsql.add_text(' DATA_LEVEL_ID = ');
10925: fnd_dsql.add_bind(p_data_level_id);
10926: l_ret := TRUE;
10927: END IF;
10928:

Line 10925: fnd_dsql.add_bind(p_data_level_id);

10921: add_and;
10922: END IF;
10923: Debug_msg('add_datalevel_predicate: ' || 'Added data_level_id condition DATA_LEVEL_ID = ' || p_data_level_id);
10924: fnd_dsql.add_text(' DATA_LEVEL_ID = ');
10925: fnd_dsql.add_bind(p_data_level_id);
10926: l_ret := TRUE;
10927: END IF;
10928:
10929: Debug_msg('add_datalevel_predicate: ' || 'Adding ext table prediacate');

Line 10966: fnd_dsql.add_text(' ATTR_GROUP_ID = ');

10962: BEGIN
10963: IF p_add_and THEN
10964: add_and;
10965: END IF;
10966: fnd_dsql.add_text(' ATTR_GROUP_ID = ');
10967: fnd_dsql.add_bind(p_attr_group_id);
10968: x_predicate_added := TRUE;
10969: END add_ag_predicate;
10970:

Line 10967: fnd_dsql.add_bind(p_attr_group_id);

10963: IF p_add_and THEN
10964: add_and;
10965: END IF;
10966: fnd_dsql.add_text(' ATTR_GROUP_ID = ');
10967: fnd_dsql.add_bind(p_attr_group_id);
10968: x_predicate_added := TRUE;
10969: END add_ag_predicate;
10970:
10971: --

Line 11139: fnd_dsql.init();

11135: l_dummy NUMBER;
11136: BEGIN
11137: Debug_msg('get_uom_value: ' || 'Entering method');
11138:
11139: fnd_dsql.init();
11140: fnd_dsql.add_text (' SELECT ' || p_uom_db_column_name ||
11141: ' FROM ' || p_table_name ||
11142: ' WHERE EXTENSION_ID = ');
11143: fnd_dsql.add_bind(p_extension_id);

Line 11140: fnd_dsql.add_text (' SELECT ' || p_uom_db_column_name ||

11136: BEGIN
11137: Debug_msg('get_uom_value: ' || 'Entering method');
11138:
11139: fnd_dsql.init();
11140: fnd_dsql.add_text (' SELECT ' || p_uom_db_column_name ||
11141: ' FROM ' || p_table_name ||
11142: ' WHERE EXTENSION_ID = ');
11143: fnd_dsql.add_bind(p_extension_id);
11144: l_cursor_id := DBMS_SQL.OPEN_CURSOR;

Line 11143: fnd_dsql.add_bind(p_extension_id);

11139: fnd_dsql.init();
11140: fnd_dsql.add_text (' SELECT ' || p_uom_db_column_name ||
11141: ' FROM ' || p_table_name ||
11142: ' WHERE EXTENSION_ID = ');
11143: fnd_dsql.add_bind(p_extension_id);
11144: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
11145: l_dynamic_sql := fnd_dsql.get_text;
11146:
11147: Debug_msg('get_uom_value: ' || ' Query ' || l_dynamic_sql);

Line 11145: l_dynamic_sql := fnd_dsql.get_text;

11141: ' FROM ' || p_table_name ||
11142: ' WHERE EXTENSION_ID = ');
11143: fnd_dsql.add_bind(p_extension_id);
11144: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
11145: l_dynamic_sql := fnd_dsql.get_text;
11146:
11147: Debug_msg('get_uom_value: ' || ' Query ' || l_dynamic_sql);
11148:
11149: DBMS_SQL.PARSE(l_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);

Line 11150: fnd_dsql.set_cursor(l_cursor_id);

11146:
11147: Debug_msg('get_uom_value: ' || ' Query ' || l_dynamic_sql);
11148:
11149: DBMS_SQL.PARSE(l_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
11150: fnd_dsql.set_cursor(l_cursor_id);
11151: fnd_dsql.do_binds;
11152:
11153: dbms_sql.define_column(l_cursor_id, 1, l_uom_value, 3);
11154: l_dummy := DBMS_SQL.Execute(l_cursor_id);

Line 11151: fnd_dsql.do_binds;

11147: Debug_msg('get_uom_value: ' || ' Query ' || l_dynamic_sql);
11148:
11149: DBMS_SQL.PARSE(l_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
11150: fnd_dsql.set_cursor(l_cursor_id);
11151: fnd_dsql.do_binds;
11152:
11153: dbms_sql.define_column(l_cursor_id, 1, l_uom_value, 3);
11154: l_dummy := DBMS_SQL.Execute(l_cursor_id);
11155:

Line 11186: -- b. Replaced literal logic with binds. Using FND_DSQL and newly

11182: -- i. Usage of DECODE in SELECT. It was required based on old
11183: -- logic when we had only one SQL for all requested AGs.
11184: -- The current logic builds one SQL per AG.
11185: -- ii. We were buidling data level primary key prediactes twice.
11186: -- b. Replaced literal logic with binds. Using FND_DSQL and newly
11187: -- created encapsulated methods.
11188: -- c. Replaced literal logic for UOM value query with binds. Also
11189: -- we are using only EXTENSION_ID predicate for it as other
11190: -- conditions are not necessary.

Line 11853: -- Bug 1276239. Logic to use fnd_dsql.

11849: -----------------------------------------------------------------------
11850: l_db_column_list := RTRIM(l_db_column_list, ',');
11851:
11852: --
11853: -- Bug 1276239. Logic to use fnd_dsql.
11854: -- Encapsulated logic to build pkcol, data level and ag
11855: -- predicates in simple method and calling it from
11856: -- here.
11857: -- sreharih. Thu Aug 25 12:44:00 PDT 2011

Line 11860: fnd_dsql.init();

11856: -- here.
11857: -- sreharih. Thu Aug 25 12:44:00 PDT 2011
11858: --
11859:
11860: fnd_dsql.init();
11861: fnd_dsql.add_text(' SELECT EXTENSION_ID, ATTR_GROUP_ID, '||l_db_column_list||
11862: ' FROM ' ||NVL(l_curr_ag_vl_name,l_curr_ag_table_name)||' EMSI'||
11863: ' WHERE ' );
11864: l_add_and := FALSE;

Line 11861: fnd_dsql.add_text(' SELECT EXTENSION_ID, ATTR_GROUP_ID, '||l_db_column_list||

11857: -- sreharih. Thu Aug 25 12:44:00 PDT 2011
11858: --
11859:
11860: fnd_dsql.init();
11861: fnd_dsql.add_text(' SELECT EXTENSION_ID, ATTR_GROUP_ID, '||l_db_column_list||
11862: ' FROM ' ||NVL(l_curr_ag_vl_name,l_curr_ag_table_name)||' EMSI'||
11863: ' WHERE ' );
11864: l_add_and := FALSE;
11865:

Line 11894: l_dynamic_sql := fnd_dsql.get_text;

11890: p_add_and => l_add_and,
11891: x_predicate_added => l_predicate_added);
11892:
11893:
11894: l_dynamic_sql := fnd_dsql.get_text;
11895:
11896:
11897: Debug_Msg(l_dynamic_sql);
11898:

Line 11907: fnd_dsql.set_cursor(l_cursor_id);

11903: -------------------------------------
11904: -- Parse our dynamic SQL statement --
11905: -------------------------------------
11906: DBMS_SQL.PARSE(l_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
11907: fnd_dsql.set_cursor(l_cursor_id);
11908: fnd_dsql.do_binds;
11909: --------------------------------------------------------------------------
11910: -- Register the data types of the columns we are selecting in our query --
11911: -- (in the VARCHAR2 case, that includes stating the maximum size that a --

Line 11908: fnd_dsql.do_binds;

11904: -- Parse our dynamic SQL statement --
11905: -------------------------------------
11906: DBMS_SQL.PARSE(l_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
11907: fnd_dsql.set_cursor(l_cursor_id);
11908: fnd_dsql.do_binds;
11909: --------------------------------------------------------------------------
11910: -- Register the data types of the columns we are selecting in our query --
11911: -- (in the VARCHAR2 case, that includes stating the maximum size that a --
11912: -- value in the column might be; to be safe we will use 1000 bytes). --

Line 12084: -- will use fnd_dsql to build and execute

12080:
12081: --
12082: -- Bug 1276239. Encapsulated logic to find
12083: -- uom value in get_uom_value method which
12084: -- will use fnd_dsql to build and execute
12085: -- query.
12086: -- sreharih. Thu Aug 25 12:44:00 PDT 2011
12087: --
12088:

Line 13761: FND_DSQL.Add_Text(

13757: -- and overriding) --
13758: -----------------------------------------------------------------
13759: l_cursor_id := DBMS_SQL.Open_Cursor;
13760: Init();
13761: FND_DSQL.Add_Text(
13762: 'SELECT ETA_OUTER.ATTRIBUTE_GROUP_ID,' ||
13763: ' ETA_OUTER.ATTRIBUTE_ID,' ||
13764: ' ETA_OUTER.ROW_NUMBER,' ||
13765: ' ETA_OUTER.ATTRIBUTE_STRING_VALUE,' ||

Line 13773: FND_DSQL.Add_Text(

13769: ' ETA_OUTER.ATTRIBUTE_TRANSLATED_VALUE' ||
13770: ' FROM EGO_TEMPL_ATTRIBUTES ETA_OUTER'
13771: );
13772: IF p_data_level IS NOT NULL THEN
13773: FND_DSQL.Add_Text(
13774: ' , EGO_DATA_LEVEL_B DL ' ||
13775: ' WHERE DL.data_level_name = '
13776: );
13777: Add_Bind(p_value => p_data_level);

Line 13778: FND_DSQL.Add_Text(

13774: ' , EGO_DATA_LEVEL_B DL ' ||
13775: ' WHERE DL.data_level_name = '
13776: );
13777: Add_Bind(p_value => p_data_level);
13778: FND_DSQL.Add_Text(
13779: ' AND DL.data_level_id = ETA_OUTER.data_level_id '
13780: );
13781: ELSE
13782: FND_DSQL.Add_Text(' WHERE 1 = 1');

Line 13782: FND_DSQL.Add_Text(' WHERE 1 = 1');

13778: FND_DSQL.Add_Text(
13779: ' AND DL.data_level_id = ETA_OUTER.data_level_id '
13780: );
13781: ELSE
13782: FND_DSQL.Add_Text(' WHERE 1 = 1');
13783: END IF;
13784: FND_DSQL.Add_Text(' AND ETA_OUTER.TEMPLATE_ID = ');
13785: Add_Bind(p_value => p_template_id);
13786: FND_DSQL.Add_Text(' AND ETA_OUTER.CLASSIFICATION_CODE IN (');

Line 13784: FND_DSQL.Add_Text(' AND ETA_OUTER.TEMPLATE_ID = ');

13780: );
13781: ELSE
13782: FND_DSQL.Add_Text(' WHERE 1 = 1');
13783: END IF;
13784: FND_DSQL.Add_Text(' AND ETA_OUTER.TEMPLATE_ID = ');
13785: Add_Bind(p_value => p_template_id);
13786: FND_DSQL.Add_Text(' AND ETA_OUTER.CLASSIFICATION_CODE IN (');
13787:
13788: -- we assume here that the calling procedure has passed in some class codes

Line 13786: FND_DSQL.Add_Text(' AND ETA_OUTER.CLASSIFICATION_CODE IN (');

13782: FND_DSQL.Add_Text(' WHERE 1 = 1');
13783: END IF;
13784: FND_DSQL.Add_Text(' AND ETA_OUTER.TEMPLATE_ID = ');
13785: Add_Bind(p_value => p_template_id);
13786: FND_DSQL.Add_Text(' AND ETA_OUTER.CLASSIFICATION_CODE IN (');
13787:
13788: -- we assume here that the calling procedure has passed in some class codes
13789: l_class_code_hierarchy := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
13790: l_ext_table_metadata_obj.class_code_metadata

Line 13797: FND_DSQL.Add_Text(')' ||

13793: ,TRUE
13794: );
13795: Debug_Msg(l_api_name||' l_class_code_hierarchy '|| l_class_code_hierarchy, 1);
13796:
13797: FND_DSQL.Add_Text(')' ||
13798: ' AND ETA_OUTER.ENABLED_FLAG = ''Y''' ||
13799: l_attr_group_ids_to_exclude||
13800: ' AND (ETA_OUTER.TEMPLATE_ID' ||
13801: ' ,ETA_OUTER.ATTRIBUTE_GROUP_ID' ||

Line 13832: FND_DSQL.Add_Text(', ' || l_decode_index);

13828: Add_Bind(p_value => SUBSTR(l_next_cc,
13829: l_cc_begin_pos,
13830: INSTR(l_next_cc, '''', -1) - l_cc_begin_pos));
13831: END IF;
13832: FND_DSQL.Add_Text(', ' || l_decode_index);
13833:
13834: EXIT WHEN (l_is_last_cc);
13835:
13836: FND_DSQL.Add_Text(', ');

Line 13836: FND_DSQL.Add_Text(', ');

13832: FND_DSQL.Add_Text(', ' || l_decode_index);
13833:
13834: EXIT WHEN (l_is_last_cc);
13835:
13836: FND_DSQL.Add_Text(', ');
13837: l_decode_index := l_decode_index + 1;
13838: l_last_loop_index := l_this_loop_index + 1;
13839:
13840: END LOOP;

Line 13842: FND_DSQL.Add_Text('))' ||

13838: l_last_loop_index := l_this_loop_index + 1;
13839:
13840: END LOOP;
13841:
13842: FND_DSQL.Add_Text('))' ||
13843: ' IN (SELECT ETA.TEMPLATE_ID' ||
13844: ' ,ETA.ATTRIBUTE_GROUP_ID' ||
13845: ' ,ETA.ATTRIBUTE_ID' ||
13846: ' ,ETA.ROW_NUMBER' ||

Line 13875: FND_DSQL.Add_Text(', ' || l_decode_index);

13871: Add_Bind(p_value => SUBSTR(l_next_cc,
13872: l_cc_begin_pos,
13873: INSTR(l_next_cc, '''', -1) - l_cc_begin_pos));
13874: END IF;
13875: FND_DSQL.Add_Text(', ' || l_decode_index);
13876:
13877: EXIT WHEN (l_is_last_cc);
13878:
13879: FND_DSQL.Add_Text(', ');

Line 13879: FND_DSQL.Add_Text(', ');

13875: FND_DSQL.Add_Text(', ' || l_decode_index);
13876:
13877: EXIT WHEN (l_is_last_cc);
13878:
13879: FND_DSQL.Add_Text(', ');
13880: l_decode_index := l_decode_index + 1;
13881: l_last_loop_index := l_this_loop_index + 1;
13882:
13883: END LOOP;

Line 13885: FND_DSQL.Add_Text(')) STEPS_ABOVE_CURR' ||

13881: l_last_loop_index := l_this_loop_index + 1;
13882:
13883: END LOOP;
13884:
13885: FND_DSQL.Add_Text(')) STEPS_ABOVE_CURR' ||
13886: ' FROM EGO_TEMPL_ATTRIBUTES ETA' ||
13887: ' WHERE ETA.TEMPLATE_ID = ');
13888: Add_Bind(p_value => p_template_id);
13889: FND_DSQL.Add_Text(

Line 13889: FND_DSQL.Add_Text(

13885: FND_DSQL.Add_Text(')) STEPS_ABOVE_CURR' ||
13886: ' FROM EGO_TEMPL_ATTRIBUTES ETA' ||
13887: ' WHERE ETA.TEMPLATE_ID = ');
13888: Add_Bind(p_value => p_template_id);
13889: FND_DSQL.Add_Text(
13890: ' AND ETA.CLASSIFICATION_CODE IN (');
13891:
13892: l_class_code_hierarchy := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
13893: l_ext_table_metadata_obj.class_code_metadata

Line 13899: FND_DSQL.Add_Text(')' ||

13895: ,'VALUES_ALL_CC'
13896: ,TRUE
13897: );
13898:
13899: FND_DSQL.Add_Text(')' ||
13900: ' GROUP BY ETA.TEMPLATE_ID, ETA.ATTRIBUTE_GROUP_ID, ETA.ATTRIBUTE_ID, ETA.ROW_NUMBER)' ||
13901: ' ORDER BY ETA_OUTER.ATTRIBUTE_GROUP_ID, ETA_OUTER.ROW_NUMBER');
13902:
13903: -----------------------------------------------------------------------------------

Line 13906: Debug_Msg(l_api_name||' complete query '|| FND_DSQL.Get_Text(), 1);

13902:
13903: -----------------------------------------------------------------------------------
13904: -- Parse and execute the query, and associate the output columns with our record --
13905: -----------------------------------------------------------------------------------
13906: Debug_Msg(l_api_name||' complete query '|| FND_DSQL.Get_Text(), 1);
13907: Debug_Msg(l_api_name||' using binds template_id: '||p_template_id||' , '||
13908: ' class code: '||l_class_code_hierarchy
13909: , 1);
13910:

Line 13911: DBMS_SQL.Parse(l_cursor_id, FND_DSQL.Get_Text(), DBMS_SQL.Native);

13907: Debug_Msg(l_api_name||' using binds template_id: '||p_template_id||' , '||
13908: ' class code: '||l_class_code_hierarchy
13909: , 1);
13910:
13911: DBMS_SQL.Parse(l_cursor_id, FND_DSQL.Get_Text(), DBMS_SQL.Native);
13912: FND_DSQL.Set_Cursor(l_cursor_id);
13913: FND_DSQL.Do_Binds();
13914: DBMS_SQL.Define_Column(l_cursor_id, 1, l_templ_attr_rec.ATTRIBUTE_GROUP_ID);
13915: DBMS_SQL.Define_Column(l_cursor_id, 2, l_templ_attr_rec.ATTRIBUTE_ID);

Line 13912: FND_DSQL.Set_Cursor(l_cursor_id);

13908: ' class code: '||l_class_code_hierarchy
13909: , 1);
13910:
13911: DBMS_SQL.Parse(l_cursor_id, FND_DSQL.Get_Text(), DBMS_SQL.Native);
13912: FND_DSQL.Set_Cursor(l_cursor_id);
13913: FND_DSQL.Do_Binds();
13914: DBMS_SQL.Define_Column(l_cursor_id, 1, l_templ_attr_rec.ATTRIBUTE_GROUP_ID);
13915: DBMS_SQL.Define_Column(l_cursor_id, 2, l_templ_attr_rec.ATTRIBUTE_ID);
13916: DBMS_SQL.Define_Column(l_cursor_id, 3, l_templ_attr_rec.ROW_NUMBER);

Line 13913: FND_DSQL.Do_Binds();

13909: , 1);
13910:
13911: DBMS_SQL.Parse(l_cursor_id, FND_DSQL.Get_Text(), DBMS_SQL.Native);
13912: FND_DSQL.Set_Cursor(l_cursor_id);
13913: FND_DSQL.Do_Binds();
13914: DBMS_SQL.Define_Column(l_cursor_id, 1, l_templ_attr_rec.ATTRIBUTE_GROUP_ID);
13915: DBMS_SQL.Define_Column(l_cursor_id, 2, l_templ_attr_rec.ATTRIBUTE_ID);
13916: DBMS_SQL.Define_Column(l_cursor_id, 3, l_templ_attr_rec.ROW_NUMBER);
13917: DBMS_SQL.Define_Column(l_cursor_id, 4, l_templ_attr_rec.ATTRIBUTE_STRING_VALUE, 150);

Line 18192: FND_DSQL.Add_Bind(p_value);

18188: G_BIND_INDEX := G_BIND_INDEX + 1;
18189: G_BIND_IDENTIFIER_TBL(G_BIND_INDEX) := p_bind_identifier;
18190: G_BIND_DATATYPE_TBL(G_BIND_INDEX) := 'C';
18191: G_BIND_TEXT_TBL(G_BIND_INDEX) := p_value;
18192: FND_DSQL.Add_Bind(p_value);
18193: END Add_Bind; --VARCHAR2
18194:
18195: ----------------------------------------------------------------------
18196:

Line 18205: FND_DSQL.Add_Bind(p_value);

18201: G_BIND_INDEX := G_BIND_INDEX + 1;
18202: G_BIND_IDENTIFIER_TBL(G_BIND_INDEX) := p_bind_identifier;
18203: G_BIND_DATATYPE_TBL(G_BIND_INDEX) := 'D';
18204: G_BIND_DATE_TBL(G_BIND_INDEX) := p_value;
18205: FND_DSQL.Add_Bind(p_value);
18206: END Add_Bind; --DATE
18207:
18208: ----------------------------------------------------------------------
18209:

Line 18218: FND_DSQL.Add_Bind(p_value);

18214: G_BIND_INDEX := G_BIND_INDEX + 1;
18215: G_BIND_IDENTIFIER_TBL(G_BIND_INDEX) := p_bind_identifier;
18216: G_BIND_DATATYPE_TBL(G_BIND_INDEX) := 'N';
18217: G_BIND_NUMBER_TBL(G_BIND_INDEX) := p_value;
18218: FND_DSQL.Add_Bind(p_value);
18219: END Add_Bind; --NUMBER
18220:
18221: ----------------------------------------------------------------------
18222:

Line 18254: FND_DSQL.Init();

18250: PROCEDURE Init
18251: IS
18252: BEGIN
18253: G_BIND_INDEX := 0;
18254: FND_DSQL.Init();
18255:
18256: FOR i IN 1 .. 100 LOOP
18257:
18258: G_BIND_IDENTIFIER_TBL(i) := NULL;