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 894: FND_DSQL.Add_Text('SELECT EXTENSION_ID, ' ||l_db_column_list||

890:
891: Debug_Msg(l_api_name||' pk cols '||l_pk_col_string);
892:
893: Init();
894: FND_DSQL.Add_Text('SELECT EXTENSION_ID, ' ||l_db_column_list||
895: ' FROM ' ||NVL(p_attr_group_metadata_obj.EXT_TABLE_VL_NAME
896: ,p_attr_group_metadata_obj.EXT_TABLE_B_NAME)||
897: ' WHERE ');
898:

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

909: -----------------------------------------------------------------------
910: -- If extension ID info is available, select on it. --
911: -----------------------------------------------------------------------
912: IF (p_extension_id IS NOT NULL) THEN
913: FND_DSQL.Add_Text(' AND EXTENSION_ID = ');
914: Add_Bind(p_value => p_extension_id);
915: END IF;
916:
917: ----------------------------------------------------------------------------

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

931: l_data_level_id := Get_Data_Level_Id( p_attr_group_metadata_obj.APPLICATION_ID
932: ,p_attr_group_metadata_obj.ATTR_GROUP_TYPE
933: ,p_data_level);
934:
935: FND_DSQL.Add_Text(' AND DATA_LEVEL_ID = ');
936: Add_Bind (p_bind_identifier => 'DATA_LEVEL_ID'
937: ,p_value => l_data_level_id);
938:
939: END IF;

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

947: ------------------------------------------------
948: -- Build a predicate for each Attribute Group --
949: -- and concatenate it into a master predicate --
950: ------------------------------------------------
951: FND_DSQL.Add_Text(' AND (ATTR_GROUP_ID = ');
952: Add_Bind(p_value => p_attr_group_metadata_obj.ATTR_GROUP_ID);
953:
954: ---------------------------------------------------------------
955: -- Make a string to use in the query; it will be of the form --

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

967: ,'EQUALS'
968: ,TRUE
969: ,' AND '
970: );
971: FND_DSQL.Add_Text(')');
972:
973: END IF;
974:
975: Debug_SQL(l_dynamic_sql);

Line 981: FND_DSQL.Set_Cursor(l_cursor_id);

977: ----------------------------------
978: -- Open a cursor for processing --
979: ----------------------------------
980: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
981: FND_DSQL.Set_Cursor(l_cursor_id);
982:
983: -------------------------------------
984: -- Parse our dynamic SQL statement --
985: -------------------------------------

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

982:
983: -------------------------------------
984: -- Parse our dynamic SQL statement --
985: -------------------------------------
986: DBMS_SQL.PARSE(l_cursor_id, FND_DSQL.Get_Text(), DBMS_SQL.NATIVE);
987:
988: ------------------------
989: -- Bind our variables --
990: ------------------------

Line 991: FND_DSQL.Do_Binds();

987:
988: ------------------------
989: -- Bind our variables --
990: ------------------------
991: FND_DSQL.Do_Binds();
992:
993: --------------------------------------------------------------------------
994: -- Register the data types of the columns we are selecting in our query --
995: -- (in the VARCHAR2 case, that includes stating the maximum size that a --

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

1815: --
1816: -- Private
1817: --
1818: -- This procedure adds text and/or bind variables, as appropriate, to a dynamic SQL
1819: -- statement being constructed using the FND_DSQL package. We assume that we are
1820: -- in the midst of building a statement, so we do not call Init().
1821: -- The procedure appends a final p_separator value onto the FND_DSQL list
1822: --
1823: -- The procedure's allowable p_mode values are:

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

1817: --
1818: -- This procedure adds text and/or bind variables, as appropriate, to a dynamic SQL
1819: -- statement being constructed using the FND_DSQL package. We assume that we are
1820: -- in the midst of building a statement, so we do not call Init().
1821: -- The procedure appends a final p_separator value onto the FND_DSQL list
1822: --
1823: -- The procedure's allowable p_mode values are:
1824: -- 'VALUES': adds bind variables for Attr values, separated appropriately, to FND_DSQL
1825: -- 'VALUES_DEF': special case of VALUES that uses DEFAULT_VALUE for any NULL Attributes

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

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

Line 2025: FND_DSQL.Add_Text(l_column_name);

2021: IF (UPPER(p_mode) = 'EQUALS' OR
2022: UPPER(p_mode) = 'COLUMNS' OR
2023: UPPER(p_mode) = 'COLUMNS_DEF') THEN
2024:
2025: FND_DSQL.Add_Text(l_column_name);
2026:
2027: IF (UPPER(p_mode) = 'EQUALS') THEN
2028:
2029: IF (l_candidate_value IS NULL AND p_separator = ' AND ') THEN

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

2027: IF (UPPER(p_mode) = 'EQUALS') THEN
2028:
2029: IF (l_candidate_value IS NULL AND p_separator = ' AND ') THEN
2030:
2031: FND_DSQL.Add_Text(' IS ');
2032:
2033: ELSE
2034:
2035: FND_DSQL.Add_Text(' = ');

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

2031: FND_DSQL.Add_Text(' IS ');
2032:
2033: ELSE
2034:
2035: FND_DSQL.Add_Text(' = ');
2036:
2037: END IF;
2038:
2039: ELSE

Line 2041: FND_DSQL.Add_Text(p_separator);

2037: END IF;
2038:
2039: ELSE
2040:
2041: FND_DSQL.Add_Text(p_separator);
2042:
2043: END IF;
2044: END IF;
2045:

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

2051: UPPER(p_mode) = 'VALUES_DEF') THEN
2052:
2053: IF (l_candidate_value IS NULL) THEN
2054:
2055: FND_DSQL.Add_Text(' NULL ');
2056:
2057: ELSIF (l_data_type IS NULL OR
2058: l_data_type = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE OR
2059: l_data_type = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE) THEN

Line 2077: FND_DSQL.Add_Text(p_separator);

2073: ,p_value => TO_DATE(l_candidate_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT));
2074:
2075: END IF;
2076:
2077: FND_DSQL.Add_Text(p_separator);
2078:
2079: END IF;
2080:
2081: -------------------------------------------

Line 2090: FND_DSQL.Add_Text(l_uom_column);

2086: IF (UPPER(p_mode) = 'EQUALS' OR
2087: UPPER(p_mode) = 'COLUMNS' OR
2088: UPPER(p_mode) = 'COLUMNS_DEF') THEN
2089:
2090: FND_DSQL.Add_Text(l_uom_column);
2091:
2092: IF (UPPER(p_mode) = 'EQUALS') THEN
2093:
2094: IF (l_uom_value IS NULL AND p_separator = ' AND ') THEN

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

2092: IF (UPPER(p_mode) = 'EQUALS') THEN
2093:
2094: IF (l_uom_value IS NULL AND p_separator = ' AND ') THEN
2095:
2096: FND_DSQL.Add_Text(' IS ');
2097:
2098: ELSE
2099:
2100: FND_DSQL.Add_Text(' = ');

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

2096: FND_DSQL.Add_Text(' IS ');
2097:
2098: ELSE
2099:
2100: FND_DSQL.Add_Text(' = ');
2101:
2102: END IF;
2103:
2104: ELSE

Line 2106: FND_DSQL.Add_Text(p_separator);

2102: END IF;
2103:
2104: ELSE
2105:
2106: FND_DSQL.Add_Text(p_separator);
2107:
2108: END IF;
2109: END IF;
2110:

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

2113: UPPER(p_mode) = 'VALUES_DEF') THEN
2114:
2115: IF (l_uom_value IS NULL) THEN
2116:
2117: FND_DSQL.Add_Text(' NULL ');
2118:
2119: ELSE
2120:
2121: FND_DSQL.Add_Text(l_uom_value);

Line 2121: FND_DSQL.Add_Text(l_uom_value);

2117: FND_DSQL.Add_Text(' NULL ');
2118:
2119: ELSE
2120:
2121: FND_DSQL.Add_Text(l_uom_value);
2122:
2123: END IF;
2124:
2125: FND_DSQL.Add_Text(p_separator);

Line 2125: FND_DSQL.Add_Text(p_separator);

2121: FND_DSQL.Add_Text(l_uom_value);
2122:
2123: END IF;
2124:
2125: FND_DSQL.Add_Text(p_separator);
2126:
2127: END IF;
2128: END IF;
2129: END IF;

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

2142:
2143: ----------------------------------------------------------------------
2144:
2145: -- This procedure builds a WHERE clause, which it adds to a SQL statement being
2146: -- built using the FND_DSQL package. This procedure neither initializes nor
2147: -- executes that statement; it just adds text and bind variables through calls
2148: -- to FND_DSQL procedures.
2149:
2150: PROCEDURE Build_Where_Clause (

Line 2148: -- to FND_DSQL procedures.

2144:
2145: -- This procedure builds a WHERE clause, which it adds to a SQL statement being
2146: -- built using the FND_DSQL package. This procedure neither initializes nor
2147: -- executes that statement; it just adds text and bind variables through calls
2148: -- to FND_DSQL procedures.
2149:
2150: PROCEDURE Build_Where_Clause (
2151: p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
2152: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ

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

2183:
2184: END IF;
2185:
2186: IF (p_attr_group_metadata_obj.ATTR_GROUP_ID_FLAG ='Y') THEN
2187: FND_DSQL.Add_Text(' ATTR_GROUP_ID = ');
2188: Add_Bind(p_value => p_attr_group_metadata_obj.ATTR_GROUP_ID);
2189: ELSE
2190: FND_DSQL.Add_Text(' 1 = 1 ');
2191: END IF;

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

2186: IF (p_attr_group_metadata_obj.ATTR_GROUP_ID_FLAG ='Y') THEN
2187: FND_DSQL.Add_Text(' ATTR_GROUP_ID = ');
2188: Add_Bind(p_value => p_attr_group_metadata_obj.ATTR_GROUP_ID);
2189: ELSE
2190: FND_DSQL.Add_Text(' 1 = 1 ');
2191: END IF;
2192:
2193: --------------------------------------------------------------
2194: -- Added in R12C, for implementations uptaking the enhanced --

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

2206: l_data_level_id := Get_Data_Level_Id( p_attr_group_metadata_obj.APPLICATION_ID
2207: ,p_attr_group_metadata_obj.ATTR_GROUP_TYPE
2208: ,p_data_level);
2209:
2210: FND_DSQL.Add_Text(' AND DATA_LEVEL_ID = ');
2211: Add_Bind(p_value => l_data_level_id);
2212: END IF;
2213:
2214: Debug_Msg(l_api_name ||' calling EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols for pk ');

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

2301:
2302: ----------------------------------------------------------------------
2303:
2304: -- This function has two basic modes: if p_return_bound_sql is FALSE, then we
2305: -- initialize FND_DSQL to constuct/bind/execute the query and return the result.
2306: -- If TRUE, we build and return the query itself. In this case, we don't pass
2307: -- p_final_bind_value or p_attr_name_value_pairs, and when replacing Attr Group
2308: -- tokens we construct a nested query to get the value required by the token.
2309: FUNCTION Tokenized_Val_Set_Query (

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

2602: l_head_of_query := l_head_of_query ||
2603: SUBSTR(l_tail_of_query, 1, (l_token_start_index - 1)) ||
2604: l_token_replacement;
2605: ELSE
2606: FND_DSQL.Add_Text(SUBSTR(l_tail_of_query, 1, (l_token_start_index - 1)));
2607: Add_Bind(p_value => l_token_replacement);
2608: END IF;
2609:
2610: ELSE

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

2616: IF (p_return_bound_sql) THEN
2617: l_head_of_query := l_head_of_query ||
2618: SUBSTR(l_tail_of_query, 1, (l_token_end_index - 1));
2619: ELSE
2620: FND_DSQL.Add_Text(SUBSTR(l_tail_of_query, 1, (l_token_end_index - 1)));
2621: END IF;
2622:
2623: END IF;
2624:

Line 2652: FND_DSQL.Add_Text(l_tail_of_query);

2648: Debug_Msg('In Tokenized_Val_Set_Query, done', 2);
2649: RETURN l_dynamic_sql;
2650:
2651: ELSE
2652: FND_DSQL.Add_Text(l_tail_of_query);
2653: Add_Bind(p_value => p_final_bind_value);
2654:
2655: l_dynamic_sql := FND_DSQL.Get_Text(FALSE);
2656:

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

2651: ELSE
2652: FND_DSQL.Add_Text(l_tail_of_query);
2653: Add_Bind(p_value => p_final_bind_value);
2654:
2655: l_dynamic_sql := FND_DSQL.Get_Text(FALSE);
2656:
2657: Debug_Msg('In Tokenized_Val_Set_Query, l_dynamic_sql to be executed is as follows:', 3);
2658: Debug_SQL(FND_DSQL.Get_Text(TRUE));
2659:

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

2654:
2655: l_dynamic_sql := FND_DSQL.Get_Text(FALSE);
2656:
2657: Debug_Msg('In Tokenized_Val_Set_Query, l_dynamic_sql to be executed is as follows:', 3);
2658: Debug_SQL(FND_DSQL.Get_Text(TRUE));
2659:
2660: l_cursor_id := DBMS_SQL.Open_Cursor;
2661:
2662: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.Native);

Line 2663: FND_DSQL.Set_Cursor(l_cursor_id);

2659:
2660: l_cursor_id := DBMS_SQL.Open_Cursor;
2661:
2662: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.Native);
2663: FND_DSQL.Set_Cursor(l_cursor_id);
2664: FND_DSQL.Do_Binds();
2665: DBMS_SQL.Define_Column(l_cursor_id, 1, l_retrieved_value, 1000);
2666:
2667: l_number_of_rows := DBMS_SQL.Execute_And_Fetch(l_cursor_id);

Line 2664: FND_DSQL.Do_Binds();

2660: l_cursor_id := DBMS_SQL.Open_Cursor;
2661:
2662: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.Native);
2663: FND_DSQL.Set_Cursor(l_cursor_id);
2664: FND_DSQL.Do_Binds();
2665: DBMS_SQL.Define_Column(l_cursor_id, 1, l_retrieved_value, 1000);
2666:
2667: l_number_of_rows := DBMS_SQL.Execute_And_Fetch(l_cursor_id);
2668:

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

3036: END IF;
3037: END IF;
3038:
3039: -----------------------------------------------
3040: -- We clear FND_DSQL and start our new query --
3041: -----------------------------------------------
3042: Init();
3043: FND_DSQL.Add_Text('SELECT EXTENSION_ID FROM ' || l_vl_name ||
3044: ' WHERE 1=1 AND ' || l_change_where_clause||l_extra_where_clause||' AND ');

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

3039: -----------------------------------------------
3040: -- We clear FND_DSQL and start our new query --
3041: -----------------------------------------------
3042: Init();
3043: FND_DSQL.Add_Text('SELECT EXTENSION_ID FROM ' || l_vl_name ||
3044: ' WHERE 1=1 AND ' || l_change_where_clause||l_extra_where_clause||' AND ');
3045:
3046: Debug_Msg(l_api_name ||' calling Build_Where_Clause', 3);
3047: Build_Where_Clause(p_attr_group_metadata_obj

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

3051: ,l_data_level_name_value_pairs -- NULL if we're in Change mode
3052: ,p_attr_name_value_pairs);
3053: Debug_Msg(l_api_name ||' returning Build_Where_Clause', 3);
3054:
3055: l_dynamic_sql := FND_DSQL.Get_Text(FALSE);
3056:
3057: Debug_Msg(l_api_name ||' l_dynamic_sql is as follows: '||l_dynamic_sql, 3);
3058: Debug_SQL(FND_DSQL.Get_Text(TRUE));
3059: ----------------------------------------

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

3054:
3055: l_dynamic_sql := FND_DSQL.Get_Text(FALSE);
3056:
3057: Debug_Msg(l_api_name ||' l_dynamic_sql is as follows: '||l_dynamic_sql, 3);
3058: Debug_SQL(FND_DSQL.Get_Text(TRUE));
3059: ----------------------------------------
3060: -- Now we open a cursor for our query --
3061: ----------------------------------------
3062: l_cursor_id := DBMS_SQL.Open_Cursor;

Line 3069: FND_DSQL.Set_Cursor(l_cursor_id);

3065: -- Next we parse the query, bind our variables, --
3066: -- and tell DBMS_SQL what we want it to return --
3067: --------------------------------------------------
3068: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.Native);
3069: FND_DSQL.Set_Cursor(l_cursor_id);
3070: FND_DSQL.Do_Binds();
3071: DBMS_SQL.Define_Column(l_cursor_id, 1, l_extension_id);
3072: ---------------------------------------------------------------------
3073: -- We execute the query and see how many rows we get; if we get no --

Line 3070: FND_DSQL.Do_Binds();

3066: -- and tell DBMS_SQL what we want it to return --
3067: --------------------------------------------------
3068: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.Native);
3069: FND_DSQL.Set_Cursor(l_cursor_id);
3070: FND_DSQL.Do_Binds();
3071: DBMS_SQL.Define_Column(l_cursor_id, 1, l_extension_id);
3072: ---------------------------------------------------------------------
3073: -- We execute the query and see how many rows we get; if we get no --
3074: -- rows, we return NULL, and if we get too many rows, we return -1 --

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

4216:
4217: IF(l_data_level_matched AND l_column_matched) THEN
4218: --If the passed in data level is fine we check the association of the data level with the classification
4219: Init();
4220: FND_DSQL.Add_Text(' SELECT DATA_LEVEL FROM EGO_OBJ_AG_ASSOCS_B'||
4221: ' WHERE OBJECT_ID = ');
4222: Add_Bind(p_value => p_object_id);
4223: FND_DSQL.Add_Text(' AND ATTR_GROUP_ID = ');
4224: Add_Bind(p_value => p_attr_group_id);

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

4219: Init();
4220: FND_DSQL.Add_Text(' SELECT DATA_LEVEL FROM EGO_OBJ_AG_ASSOCS_B'||
4221: ' WHERE OBJECT_ID = ');
4222: Add_Bind(p_value => p_object_id);
4223: FND_DSQL.Add_Text(' AND ATTR_GROUP_ID = ');
4224: Add_Bind(p_value => p_attr_group_id);
4225: FND_DSQL.Add_Text(' AND ROWNUM = 1');
4226: FND_DSQL.Add_Text(' AND CLASSIFICATION_CODE IN (');
4227: l_cc_value_list := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(

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

4221: ' WHERE OBJECT_ID = ');
4222: Add_Bind(p_value => p_object_id);
4223: FND_DSQL.Add_Text(' AND ATTR_GROUP_ID = ');
4224: Add_Bind(p_value => p_attr_group_id);
4225: FND_DSQL.Add_Text(' AND ROWNUM = 1');
4226: FND_DSQL.Add_Text(' AND CLASSIFICATION_CODE IN (');
4227: l_cc_value_list := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
4228: p_ext_table_metadata_obj.class_code_metadata
4229: ,p_class_code_name_value_pairs

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

4222: Add_Bind(p_value => p_object_id);
4223: FND_DSQL.Add_Text(' AND ATTR_GROUP_ID = ');
4224: Add_Bind(p_value => p_attr_group_id);
4225: FND_DSQL.Add_Text(' AND ROWNUM = 1');
4226: FND_DSQL.Add_Text(' AND CLASSIFICATION_CODE IN (');
4227: l_cc_value_list := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
4228: p_ext_table_metadata_obj.class_code_metadata
4229: ,p_class_code_name_value_pairs
4230: ,'VALUES_ALL_CC'

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

4229: ,p_class_code_name_value_pairs
4230: ,'VALUES_ALL_CC'
4231: ,TRUE
4232: );
4233: FND_DSQL.Add_Text(')');
4234: l_cursor_id := DBMS_SQL.Open_Cursor;
4235: DBMS_SQL.Parse(l_cursor_id, FND_DSQL.Get_Text(), DBMS_SQL.Native);
4236: FND_DSQL.Set_Cursor(l_cursor_id);
4237: FND_DSQL.Do_Binds();

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

4231: ,TRUE
4232: );
4233: FND_DSQL.Add_Text(')');
4234: l_cursor_id := DBMS_SQL.Open_Cursor;
4235: DBMS_SQL.Parse(l_cursor_id, FND_DSQL.Get_Text(), DBMS_SQL.Native);
4236: FND_DSQL.Set_Cursor(l_cursor_id);
4237: FND_DSQL.Do_Binds();
4238: DBMS_SQL.Define_Column(l_cursor_id, 1, l_data_level, 30);
4239: l_dummy := DBMS_SQL.Execute(l_cursor_id);

Line 4236: FND_DSQL.Set_Cursor(l_cursor_id);

4232: );
4233: FND_DSQL.Add_Text(')');
4234: l_cursor_id := DBMS_SQL.Open_Cursor;
4235: DBMS_SQL.Parse(l_cursor_id, FND_DSQL.Get_Text(), DBMS_SQL.Native);
4236: FND_DSQL.Set_Cursor(l_cursor_id);
4237: FND_DSQL.Do_Binds();
4238: DBMS_SQL.Define_Column(l_cursor_id, 1, l_data_level, 30);
4239: l_dummy := DBMS_SQL.Execute(l_cursor_id);
4240: l_dummy := DBMS_SQL.Fetch_Rows(l_cursor_id);

Line 4237: FND_DSQL.Do_Binds();

4233: FND_DSQL.Add_Text(')');
4234: l_cursor_id := DBMS_SQL.Open_Cursor;
4235: DBMS_SQL.Parse(l_cursor_id, FND_DSQL.Get_Text(), DBMS_SQL.Native);
4236: FND_DSQL.Set_Cursor(l_cursor_id);
4237: FND_DSQL.Do_Binds();
4238: DBMS_SQL.Define_Column(l_cursor_id, 1, l_data_level, 30);
4239: l_dummy := DBMS_SQL.Execute(l_cursor_id);
4240: l_dummy := DBMS_SQL.Fetch_Rows(l_cursor_id);
4241:

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

4275: l_data_level := SUBSTR(l_data_level_list, l_start_index, (l_end_index - l_start_index));
4276: ELSE
4277:
4278: Init();
4279: FND_DSQL.Add_Text(' SELECT DECODE(ATTRIBUTE2, 1, ATTRIBUTE3,'||
4280: ' 2, ATTRIBUTE5,'||
4281: ' 3, ATTRIBUTE7,'||
4282: ' ''NONE'')'||
4283: ' FROM FND_LOOKUP_VALUES'||

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

4286: ' AND LOOKUP_CODE = (SELECT DATA_LEVEL'||
4287: ' FROM EGO_OBJ_AG_ASSOCS_B'||
4288: ' WHERE OBJECT_ID = ');
4289: Add_Bind(p_value => p_object_id);
4290: FND_DSQL.Add_Text(' AND ATTR_GROUP_ID = ');
4291: Add_Bind(p_value => p_attr_group_id);
4292: FND_DSQL.Add_Text(' AND ROWNUM = 1');
4293:
4294: IF (LENGTH(l_cc_value_list) > 0) THEN

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

4288: ' WHERE OBJECT_ID = ');
4289: Add_Bind(p_value => p_object_id);
4290: FND_DSQL.Add_Text(' AND ATTR_GROUP_ID = ');
4291: Add_Bind(p_value => p_attr_group_id);
4292: FND_DSQL.Add_Text(' AND ROWNUM = 1');
4293:
4294: IF (LENGTH(l_cc_value_list) > 0) THEN
4295: FND_DSQL.Add_Text(' AND CLASSIFICATION_CODE IN (');
4296: l_cc_value_list := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(

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

4291: Add_Bind(p_value => p_attr_group_id);
4292: FND_DSQL.Add_Text(' AND ROWNUM = 1');
4293:
4294: IF (LENGTH(l_cc_value_list) > 0) THEN
4295: FND_DSQL.Add_Text(' AND CLASSIFICATION_CODE IN (');
4296: l_cc_value_list := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
4297: p_ext_table_metadata_obj.class_code_metadata
4298: ,p_class_code_name_value_pairs
4299: ,'VALUES_ALL_CC'

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

4298: ,p_class_code_name_value_pairs
4299: ,'VALUES_ALL_CC'
4300: ,TRUE
4301: );
4302: FND_DSQL.Add_Text(')');
4303: END IF;
4304:
4305: FND_DSQL.Add_Text(') ');
4306:

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

4301: );
4302: FND_DSQL.Add_Text(')');
4303: END IF;
4304:
4305: FND_DSQL.Add_Text(') ');
4306:
4307: Debug_Msg('Bind params for the preceding SQL: '||p_object_id||' and '||p_attr_group_id, 3);
4308:
4309: l_cursor_id := DBMS_SQL.Open_Cursor;

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

4306:
4307: Debug_Msg('Bind params for the preceding SQL: '||p_object_id||' and '||p_attr_group_id, 3);
4308:
4309: l_cursor_id := DBMS_SQL.Open_Cursor;
4310: DBMS_SQL.Parse(l_cursor_id, FND_DSQL.Get_Text(), DBMS_SQL.Native);
4311: FND_DSQL.Set_Cursor(l_cursor_id);
4312: FND_DSQL.Do_Binds();
4313: DBMS_SQL.Define_Column(l_cursor_id, 1, l_data_level, 30);
4314: l_dummy := DBMS_SQL.Execute(l_cursor_id);

Line 4311: FND_DSQL.Set_Cursor(l_cursor_id);

4307: Debug_Msg('Bind params for the preceding SQL: '||p_object_id||' and '||p_attr_group_id, 3);
4308:
4309: l_cursor_id := DBMS_SQL.Open_Cursor;
4310: DBMS_SQL.Parse(l_cursor_id, FND_DSQL.Get_Text(), DBMS_SQL.Native);
4311: FND_DSQL.Set_Cursor(l_cursor_id);
4312: FND_DSQL.Do_Binds();
4313: DBMS_SQL.Define_Column(l_cursor_id, 1, l_data_level, 30);
4314: l_dummy := DBMS_SQL.Execute(l_cursor_id);
4315: l_dummy := DBMS_SQL.Fetch_Rows(l_cursor_id);

Line 4312: FND_DSQL.Do_Binds();

4308:
4309: l_cursor_id := DBMS_SQL.Open_Cursor;
4310: DBMS_SQL.Parse(l_cursor_id, FND_DSQL.Get_Text(), DBMS_SQL.Native);
4311: FND_DSQL.Set_Cursor(l_cursor_id);
4312: FND_DSQL.Do_Binds();
4313: DBMS_SQL.Define_Column(l_cursor_id, 1, l_data_level, 30);
4314: l_dummy := DBMS_SQL.Execute(l_cursor_id);
4315: l_dummy := DBMS_SQL.Fetch_Rows(l_cursor_id);
4316:

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

7002: END IF;
7003:
7004: -----------------------------------------------
7005: -- Now we open a cursor for the statement(s) --
7006: -- and initialize FND_DSQL for our DMLs --
7007: -----------------------------------------------
7008: l_cursor_id := DBMS_SQL.Open_Cursor;
7009: Init();
7010:

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

7032: IF (p_language_to_process IS NULL OR
7033: p_language_to_process = USERENV('LANG')) THEN
7034:
7035: ------------------------------------------------------
7036: -- FND_DSQL and start our first DML statement --
7037: -- NOTE: we insert into both tables regardless of --
7038: -- whether there are any Attr values for each table --
7039: -- so that the VL doesn't have to outer join --
7040: ------------------------------------------------------

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

7040: ------------------------------------------------------
7041:
7042: -- CM expects extension Id to be the first bind
7043: -- in the generated DML
7044: FND_DSQL.Add_Text('INSERT INTO '||l_b_table_name||
7045: ' ('||
7046: 'EXTENSION_ID, ');
7047:
7048: -----------------------------------------------------

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

7048: -----------------------------------------------------
7049: -- Add attr_group_id only if table has this column --
7050: -----------------------------------------------------
7051: IF (p_attr_group_metadata_obj.ATTR_GROUP_ID_FLAG ='Y') THEN
7052: FND_DSQL.Add_Text('ATTR_GROUP_ID, ');
7053: END IF;
7054:
7055: -----------------------------------------------------
7056: -- Add data_level_id only if it has been provided --

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

7062: ,p_column_name => 'DATA_LEVEL_ID'
7063: )
7064: )
7065: ) THEN
7066: FND_DSQL.Add_Text('DATA_LEVEL_ID, ');
7067: END IF;
7068:
7069: --------------------------------------------------------------------------
7070: -- We trust that the names and values (fetched separately) will match --

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

7115: END IF;
7116:
7117: Debug_Msg(' l_dl_col_names-'||l_dl_col_names);
7118:
7119: FND_DSQL.Add_Text(', ' || l_change_col_names || l_extra_col_names);
7120:
7121: -----------------------------------------------
7122: -- Add the Attr column info to the statement --
7123: -----------------------------------------------

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

7135:
7136: -------------------------------------
7137: -- Add the rest of the column info --
7138: -------------------------------------
7139: FND_DSQL.Add_Text('CREATED_BY, '||
7140: 'CREATION_DATE, '||
7141: 'LAST_UPDATED_BY, '||
7142: 'LAST_UPDATE_DATE, '||
7143: 'LAST_UPDATE_LOGIN'||

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

7152: -----------------------------------------------------
7153: -- Add attr_group_id only if table has this column --
7154: -----------------------------------------------------
7155: IF (p_attr_group_metadata_obj.ATTR_GROUP_ID_FLAG ='Y') THEN
7156: FND_DSQL.Add_Text(', ');
7157: Add_Bind(p_bind_identifier => 'ATTR_GROUP_ID'
7158: ,p_value => p_attr_group_metadata_obj.ATTR_GROUP_ID);
7159: END IF;
7160:

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

7172: ) THEN
7173: l_data_level_id := Get_Data_Level_Id( p_attr_group_metadata_obj.APPLICATION_ID
7174: ,p_attr_group_metadata_obj.ATTR_GROUP_TYPE
7175: ,p_data_level);
7176: FND_DSQL.Add_Text(', ');
7177: Add_Bind(p_bind_identifier => 'DATA_LEVEL_ID'
7178: ,p_value => l_data_level_id);
7179: Debug_Msg(' in insert_row -- l_data_level_id-'||l_data_level_id);
7180: END IF;

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

7179: Debug_Msg(' in insert_row -- l_data_level_id-'||l_data_level_id);
7180: END IF;
7181:
7182:
7183: FND_DSQL.Add_Text(', ');
7184: Debug_Msg(l_api_name || ' calling EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols for PK 2 ');
7185: l_pk_col_values := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
7186: p_ext_table_metadata_obj.pk_column_metadata
7187: ,p_pk_column_name_value_pairs

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

7212: ,', '
7213: );
7214: END IF;
7215:
7216: FND_DSQL.Add_Text(', '||l_change_col_values|| l_extra_col_values);
7217:
7218: Add_Attr_Info_To_Statement(p_attr_group_metadata_obj.attr_metadata_table
7219: ,p_attr_name_value_pairs
7220: ,', '

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

7227: ----------------------------------------------------------------------
7228:
7229: Add_Bind(p_bind_identifier => 'CREATED_BY'
7230: ,p_value => l_current_user_id);
7231: FND_DSQL.Add_Text(', ');
7232: Add_Bind(p_bind_identifier => 'CREATION_DATE'
7233: ,p_value => SYSDATE);
7234: FND_DSQL.Add_Text(', ');
7235: Add_Bind(p_bind_identifier => 'LAST_UPDATED_BY'

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

7230: ,p_value => l_current_user_id);
7231: FND_DSQL.Add_Text(', ');
7232: Add_Bind(p_bind_identifier => 'CREATION_DATE'
7233: ,p_value => SYSDATE);
7234: FND_DSQL.Add_Text(', ');
7235: Add_Bind(p_bind_identifier => 'LAST_UPDATED_BY'
7236: ,p_value => l_current_user_id);
7237: FND_DSQL.Add_Text(', ');
7238: Add_Bind(p_bind_identifier => 'LAST_UPDATE_DATE'

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

7233: ,p_value => SYSDATE);
7234: FND_DSQL.Add_Text(', ');
7235: Add_Bind(p_bind_identifier => 'LAST_UPDATED_BY'
7236: ,p_value => l_current_user_id);
7237: FND_DSQL.Add_Text(', ');
7238: Add_Bind(p_bind_identifier => 'LAST_UPDATE_DATE'
7239: ,p_value => SYSDATE);
7240: FND_DSQL.Add_Text(', ');
7241: Add_Bind(p_bind_identifier => 'LAST_UPDATE_LOGIN'

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

7236: ,p_value => l_current_user_id);
7237: FND_DSQL.Add_Text(', ');
7238: Add_Bind(p_bind_identifier => 'LAST_UPDATE_DATE'
7239: ,p_value => SYSDATE);
7240: FND_DSQL.Add_Text(', ');
7241: Add_Bind(p_bind_identifier => 'LAST_UPDATE_LOGIN'
7242: ,p_value => l_current_login_id);
7243: FND_DSQL.Add_Text(')');
7244:

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

7239: ,p_value => SYSDATE);
7240: FND_DSQL.Add_Text(', ');
7241: Add_Bind(p_bind_identifier => 'LAST_UPDATE_LOGIN'
7242: ,p_value => l_current_login_id);
7243: FND_DSQL.Add_Text(')');
7244:
7245: l_dynamic_sql := FND_DSQL.Get_Text(FALSE);
7246:
7247: Debug_Msg('In Insert_Row, l_dynamic_sql for base table is as follows:', 3);

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

7241: Add_Bind(p_bind_identifier => 'LAST_UPDATE_LOGIN'
7242: ,p_value => l_current_login_id);
7243: FND_DSQL.Add_Text(')');
7244:
7245: l_dynamic_sql := FND_DSQL.Get_Text(FALSE);
7246:
7247: Debug_Msg('In Insert_Row, l_dynamic_sql for base table is as follows:', 3);
7248: Debug_Msg(l_dynamic_sql,3);
7249: Debug_SQL(FND_DSQL.Get_Text(TRUE));

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

7245: l_dynamic_sql := FND_DSQL.Get_Text(FALSE);
7246:
7247: Debug_Msg('In Insert_Row, l_dynamic_sql for base table is as follows:', 3);
7248: Debug_Msg(l_dynamic_sql,3);
7249: Debug_SQL(FND_DSQL.Get_Text(TRUE));
7250: Set_Binds_And_Dml(l_dynamic_sql,'B');
7251:
7252: ---------------------------------------------------------------------
7253: -- Next we parse the statement, bind our variables, and execute it --

Line 7258: FND_DSQL.Set_Cursor(l_cursor_id);

7254: ---------------------------------------------------------------------
7255:
7256: IF (p_execute_dml = FND_API.G_TRUE) THEN
7257: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.Native);
7258: FND_DSQL.Set_Cursor(l_cursor_id);
7259: FND_DSQL.Do_Binds();
7260: END IF;
7261:
7262: --Start 4105841 Raise pre event

Line 7259: FND_DSQL.Do_Binds();

7255:
7256: IF (p_execute_dml = FND_API.G_TRUE) THEN
7257: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.Native);
7258: FND_DSQL.Set_Cursor(l_cursor_id);
7259: FND_DSQL.Do_Binds();
7260: END IF;
7261:
7262: --Start 4105841 Raise pre event
7263: IF (p_change_obj IS NULL) THEN

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

7297:
7298: Init();
7299: -- CM expects extension Id to be the first bind
7300: -- in the generated DML
7301: FND_DSQL.Add_Text('INSERT INTO '||l_tl_table_name||
7302: ' ('||
7303: 'EXTENSION_ID, ');
7304:
7305: -----------------------------------------------------

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

7305: -----------------------------------------------------
7306: -- Add attr_group_id only if table has this column --
7307: -----------------------------------------------------
7308: IF (p_attr_group_metadata_obj.ATTR_GROUP_ID_FLAG ='Y') THEN
7309: FND_DSQL.Add_Text('ATTR_GROUP_ID, ');
7310: END IF;
7311:
7312: -----------------------------------------------------
7313: -- Add data_level_id only if it has been provided --

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

7319: ,p_column_name => 'DATA_LEVEL_ID'
7320: )
7321: )
7322: ) THEN
7323: FND_DSQL.Add_Text('DATA_LEVEL_ID, ');
7324: END IF;
7325:
7326: l_pk_col_names := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
7327: p_ext_table_metadata_obj.pk_column_metadata

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

7347: ,', '
7348: );
7349: END IF;
7350:
7351: FND_DSQL.Add_Text(', ' || l_change_col_names||l_extra_col_names);
7352:
7353: Add_Attr_Info_To_Statement(p_attr_group_metadata_obj.attr_metadata_table
7354: ,p_attr_name_value_pairs
7355: ,', '

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

7360: -- (No need to add a comma here, because Add_Attr_Info_To_Statement --
7361: -- adds a trailing separator to the list if it adds anything to it) --
7362: ----------------------------------------------------------------------
7363:
7364: FND_DSQL.Add_Text('CREATED_BY, '||
7365: 'CREATION_DATE, '||
7366: 'LAST_UPDATED_BY, '||
7367: 'LAST_UPDATE_DATE, '||
7368: 'LAST_UPDATE_LOGIN, '||

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

7376: -----------------------------------------------------
7377: -- Add attr_group_id only if table has this column --
7378: -----------------------------------------------------
7379: IF (p_attr_group_metadata_obj.ATTR_GROUP_ID_FLAG ='Y') THEN
7380: FND_DSQL.Add_Text(', ');
7381: Add_Bind(p_bind_identifier => 'ATTR_GROUP_ID'
7382: ,p_value => p_attr_group_metadata_obj.ATTR_GROUP_ID);
7383: END IF;
7384:

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

7395: ) THEN
7396: l_data_level_id := Get_Data_Level_Id( p_attr_group_metadata_obj.APPLICATION_ID
7397: ,p_attr_group_metadata_obj.ATTR_GROUP_TYPE
7398: ,p_data_level);
7399: FND_DSQL.Add_Text(', ');
7400: Add_Bind(p_bind_identifier => 'DATA_LEVEL_ID'
7401: ,p_value => l_data_level_id);
7402: END IF;
7403:

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

7400: Add_Bind(p_bind_identifier => 'DATA_LEVEL_ID'
7401: ,p_value => l_data_level_id);
7402: END IF;
7403:
7404: FND_DSQL.Add_Text(', ');
7405: l_pk_col_values := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
7406: p_ext_table_metadata_obj.pk_column_metadata
7407: ,p_pk_column_name_value_pairs
7408: ,'VALUES'

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

7426: ,', '
7427: );
7428: END IF;
7429:
7430: FND_DSQL.Add_Text(', '||l_change_col_values||l_extra_col_values);
7431:
7432: Add_Attr_Info_To_Statement(p_attr_group_metadata_obj.attr_metadata_table
7433: ,p_attr_name_value_pairs
7434: ,', '

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

7441: ----------------------------------------------------------------------
7442:
7443: Add_Bind(p_bind_identifier => 'CREATED_BY'
7444: ,p_value => l_current_user_id);
7445: FND_DSQL.Add_Text(', ');
7446: Add_Bind(p_bind_identifier => 'CREATION_DATE'
7447: ,p_value => SYSDATE);
7448: FND_DSQL.Add_Text(', ');
7449: Add_Bind(p_bind_identifier => 'LAST_UPDATED_BY'

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

7444: ,p_value => l_current_user_id);
7445: FND_DSQL.Add_Text(', ');
7446: Add_Bind(p_bind_identifier => 'CREATION_DATE'
7447: ,p_value => SYSDATE);
7448: FND_DSQL.Add_Text(', ');
7449: Add_Bind(p_bind_identifier => 'LAST_UPDATED_BY'
7450: ,p_value => l_current_user_id);
7451: FND_DSQL.Add_Text(', ');
7452: Add_Bind(p_bind_identifier => 'LAST_UPDATE_DATE'

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

7447: ,p_value => SYSDATE);
7448: FND_DSQL.Add_Text(', ');
7449: Add_Bind(p_bind_identifier => 'LAST_UPDATED_BY'
7450: ,p_value => l_current_user_id);
7451: FND_DSQL.Add_Text(', ');
7452: Add_Bind(p_bind_identifier => 'LAST_UPDATE_DATE'
7453: ,p_value => SYSDATE);
7454: FND_DSQL.Add_Text(', ');
7455: Add_Bind(p_bind_identifier => 'LAST_UPDATE_LOGIN'

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

7450: ,p_value => l_current_user_id);
7451: FND_DSQL.Add_Text(', ');
7452: Add_Bind(p_bind_identifier => 'LAST_UPDATE_DATE'
7453: ,p_value => SYSDATE);
7454: FND_DSQL.Add_Text(', ');
7455: Add_Bind(p_bind_identifier => 'LAST_UPDATE_LOGIN'
7456: ,p_value => l_current_login_id);
7457: FND_DSQL.Add_Text(', ');
7458: Add_Bind(p_bind_identifier => 'SOURCE_LANG'

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

7453: ,p_value => SYSDATE);
7454: FND_DSQL.Add_Text(', ');
7455: Add_Bind(p_bind_identifier => 'LAST_UPDATE_LOGIN'
7456: ,p_value => l_current_login_id);
7457: FND_DSQL.Add_Text(', ');
7458: Add_Bind(p_bind_identifier => 'SOURCE_LANG'
7459: ,p_value => USERENV('LANG'));
7460: FND_DSQL.Add_Text(', L.LANGUAGE_CODE '||
7461: 'FROM '||

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

7456: ,p_value => l_current_login_id);
7457: FND_DSQL.Add_Text(', ');
7458: Add_Bind(p_bind_identifier => 'SOURCE_LANG'
7459: ,p_value => USERENV('LANG'));
7460: FND_DSQL.Add_Text(', L.LANGUAGE_CODE '||
7461: 'FROM '||
7462: 'FND_LANGUAGES L '||
7463: 'WHERE L.INSTALLED_FLAG IN (''I'', ''B'')');
7464:

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

7466: -- We pass p_language_to_process from Implement_Change_Line so --
7467: -- that each pending TL row only inserts one production row --
7468: -----------------------------------------------------------------
7469: IF (p_language_to_process IS NOT NULL) THEN
7470: FND_DSQL.Add_Text(' AND L.LANGUAGE_CODE = ');
7471: Add_Bind(p_bind_identifier => 'LANGUAGE'
7472: ,p_value => p_language_to_process);
7473: END IF;
7474:

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

7471: Add_Bind(p_bind_identifier => 'LANGUAGE'
7472: ,p_value => p_language_to_process);
7473: END IF;
7474:
7475: l_dynamic_sql := FND_DSQL.Get_Text(FALSE);
7476:
7477: Set_Binds_And_Dml(l_dynamic_sql,'TL');
7478:
7479: Debug_Msg('In Insert_Row, l_dynamic_sql for TL table is as follows:', 3);

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

7476:
7477: Set_Binds_And_Dml(l_dynamic_sql,'TL');
7478:
7479: Debug_Msg('In Insert_Row, l_dynamic_sql for TL table is as follows:', 3);
7480: Debug_SQL(FND_DSQL.Get_Text(TRUE));
7481:
7482: ---------------------------------------------------
7483: -- We re-use our cursor from the first statement --
7484: ---------------------------------------------------

Line 7487: FND_DSQL.Set_Cursor(l_cursor_id);

7483: -- We re-use our cursor from the first statement --
7484: ---------------------------------------------------
7485: IF (p_execute_dml = FND_API.G_TRUE) THEN
7486: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.Native);
7487: FND_DSQL.Set_Cursor(l_cursor_id);
7488: FND_DSQL.Do_Binds();
7489: END IF;
7490:
7491: ---Start 4105841

Line 7488: FND_DSQL.Do_Binds();

7484: ---------------------------------------------------
7485: IF (p_execute_dml = FND_API.G_TRUE) THEN
7486: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.Native);
7487: FND_DSQL.Set_Cursor(l_cursor_id);
7488: FND_DSQL.Do_Binds();
7489: END IF;
7490:
7491: ---Start 4105841
7492: --raise the event if it has not been raised

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

7851: (p_language_to_process IS NULL OR
7852: p_language_to_process = USERENV('LANG'))) THEN
7853:
7854: Init();
7855: FND_DSQL.Add_Text('UPDATE '||l_b_table_name||
7856: ' SET '||l_extra_col_value_string||l_change_col_value_string);
7857:
7858: Add_Attr_Info_To_Statement(p_attr_group_metadata_obj.attr_metadata_table
7859: ,p_attr_name_value_pairs

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

7865: -- (No need to add a comma here, because Add_Attr_Info_To_Statement --
7866: -- adds a trailing separator to the list if it adds anything to it) --
7867: ----------------------------------------------------------------------
7868:
7869: FND_DSQL.Add_Text('LAST_UPDATED_BY = ');
7870: Add_Bind(p_bind_identifier => 'LAST_UPDATED_BY'
7871: ,p_value => l_current_user_id);
7872: FND_DSQL.Add_Text(', ');
7873: FND_DSQL.Add_Text('LAST_UPDATE_DATE = ');

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

7868:
7869: FND_DSQL.Add_Text('LAST_UPDATED_BY = ');
7870: Add_Bind(p_bind_identifier => 'LAST_UPDATED_BY'
7871: ,p_value => l_current_user_id);
7872: FND_DSQL.Add_Text(', ');
7873: FND_DSQL.Add_Text('LAST_UPDATE_DATE = ');
7874: Add_Bind(p_bind_identifier => 'LAST_UPDATE_DATE'
7875: ,p_value => SYSDATE);
7876: FND_DSQL.Add_Text(', ');

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

7869: FND_DSQL.Add_Text('LAST_UPDATED_BY = ');
7870: Add_Bind(p_bind_identifier => 'LAST_UPDATED_BY'
7871: ,p_value => l_current_user_id);
7872: FND_DSQL.Add_Text(', ');
7873: FND_DSQL.Add_Text('LAST_UPDATE_DATE = ');
7874: Add_Bind(p_bind_identifier => 'LAST_UPDATE_DATE'
7875: ,p_value => SYSDATE);
7876: FND_DSQL.Add_Text(', ');
7877: FND_DSQL.Add_Text('LAST_UPDATE_LOGIN = ');

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

7872: FND_DSQL.Add_Text(', ');
7873: FND_DSQL.Add_Text('LAST_UPDATE_DATE = ');
7874: Add_Bind(p_bind_identifier => 'LAST_UPDATE_DATE'
7875: ,p_value => SYSDATE);
7876: FND_DSQL.Add_Text(', ');
7877: FND_DSQL.Add_Text('LAST_UPDATE_LOGIN = ');
7878: Add_Bind(p_bind_identifier => 'LAST_UPDATE_LOGIN'
7879: ,p_value => l_current_login_id);
7880:

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

7873: FND_DSQL.Add_Text('LAST_UPDATE_DATE = ');
7874: Add_Bind(p_bind_identifier => 'LAST_UPDATE_DATE'
7875: ,p_value => SYSDATE);
7876: FND_DSQL.Add_Text(', ');
7877: FND_DSQL.Add_Text('LAST_UPDATE_LOGIN = ');
7878: Add_Bind(p_bind_identifier => 'LAST_UPDATE_LOGIN'
7879: ,p_value => l_current_login_id);
7880:
7881: FND_DSQL.Add_Text(' WHERE EXTENSION_ID = ');

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

7877: FND_DSQL.Add_Text('LAST_UPDATE_LOGIN = ');
7878: Add_Bind(p_bind_identifier => 'LAST_UPDATE_LOGIN'
7879: ,p_value => l_current_login_id);
7880:
7881: FND_DSQL.Add_Text(' WHERE EXTENSION_ID = ');
7882: Add_Bind(p_bind_identifier => 'EXTENSION_ID'
7883: ,p_value => p_extension_id);
7884:
7885: ----------------------------------------------------------------------------

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

7899: l_data_level_id := Get_Data_Level_Id( p_attr_group_metadata_obj.APPLICATION_ID
7900: ,p_attr_group_metadata_obj.ATTR_GROUP_TYPE
7901: ,p_data_level);
7902:
7903: FND_DSQL.Add_Text(' AND DATA_LEVEL_ID = ');
7904: Add_Bind(p_bind_identifier => 'DATA_LEVEL_ID'
7905: ,p_value => l_data_level_id);
7906:
7907: END IF;

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

7916:
7917: l_col_name := p_data_level_name_value_pairs(l_col_values_index).NAME;
7918: l_col_value := p_data_level_name_value_pairs(l_col_values_index).VALUE;
7919: IF (l_col_value is not NULL) THEN
7920: FND_DSQL.Add_Text(' AND '||l_col_name||' = ');
7921: Add_Bind(p_bind_identifier => l_col_name
7922: ,p_value => l_col_value);
7923: END IF;
7924: l_col_values_index := p_data_level_name_value_pairs.NEXT(l_col_values_index);

Line 7929: FND_DSQL.Add_Text(l_change_col_where_string);

7925: END LOOP;
7926: END IF;--p_data_level_name_value_pairs IS NOT NULL
7927: --End Bug 5211171
7928:
7929: FND_DSQL.Add_Text(l_change_col_where_string);
7930: FND_DSQL.Add_Text(l_extra_col_where_string);
7931:
7932:
7933:

Line 7930: FND_DSQL.Add_Text(l_extra_col_where_string);

7926: END IF;--p_data_level_name_value_pairs IS NOT NULL
7927: --End Bug 5211171
7928:
7929: FND_DSQL.Add_Text(l_change_col_where_string);
7930: FND_DSQL.Add_Text(l_extra_col_where_string);
7931:
7932:
7933:
7934: l_dynamic_sql := FND_DSQL.Get_Text(FALSE);

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

7930: FND_DSQL.Add_Text(l_extra_col_where_string);
7931:
7932:
7933:
7934: l_dynamic_sql := FND_DSQL.Get_Text(FALSE);
7935:
7936: Debug_Msg('In Update_Row, l_dynamic_sql for base table is as follows:', 3);
7937: Debug_Msg('In Update_Row, l_dynamic_sql:'||l_dynamic_sql, 3);
7938: Debug_SQL(FND_DSQL.Get_Text(TRUE));

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

7934: l_dynamic_sql := FND_DSQL.Get_Text(FALSE);
7935:
7936: Debug_Msg('In Update_Row, l_dynamic_sql for base table is as follows:', 3);
7937: Debug_Msg('In Update_Row, l_dynamic_sql:'||l_dynamic_sql, 3);
7938: Debug_SQL(FND_DSQL.Get_Text(TRUE));
7939: Set_Binds_And_Dml(l_dynamic_sql ,'B');
7940:
7941: IF (p_execute_dml = FND_API.G_TRUE) THEN
7942: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.Native);

Line 7943: FND_DSQL.Set_Cursor(l_cursor_id);

7939: Set_Binds_And_Dml(l_dynamic_sql ,'B');
7940:
7941: IF (p_execute_dml = FND_API.G_TRUE) THEN
7942: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.Native);
7943: FND_DSQL.Set_Cursor(l_cursor_id);
7944: FND_DSQL.Do_Binds();
7945: END IF;
7946:
7947: --Start 4105841 Raise Pre Event

Line 7944: FND_DSQL.Do_Binds();

7940:
7941: IF (p_execute_dml = FND_API.G_TRUE) THEN
7942: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.Native);
7943: FND_DSQL.Set_Cursor(l_cursor_id);
7944: FND_DSQL.Do_Binds();
7945: END IF;
7946:
7947: --Start 4105841 Raise Pre Event
7948: IF (p_change_obj IS NULL) THEN

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

7978: IF (p_attr_group_metadata_obj.TRANS_ATTRS_COUNT > 0 AND
7979: p_attr_group_metadata_obj.EXT_TABLE_TL_NAME IS NOT NULL) THEN
7980:
7981: Init();
7982: FND_DSQL.Add_Text('UPDATE '||l_tl_table_name||
7983: ' SET '||l_change_col_value_string);
7984:
7985: Add_Attr_Info_To_Statement(p_attr_group_metadata_obj.attr_metadata_table
7986: ,p_attr_name_value_pairs

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

7992: -- (No need to add a comma here, because Add_Attr_Info_To_Statement --
7993: -- adds a trailing separator to the list if it adds anything to it) --
7994: ----------------------------------------------------------------------
7995:
7996: FND_DSQL.Add_Text('LAST_UPDATED_BY = ');
7997: Add_Bind(p_bind_identifier => 'LAST_UPDATED_BY'
7998: ,p_value => l_current_user_id);
7999: FND_DSQL.Add_Text(', ');
8000: FND_DSQL.Add_Text('LAST_UPDATE_DATE = ');

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

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

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

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

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

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

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

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

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

8003: FND_DSQL.Add_Text(', ');
8004: FND_DSQL.Add_Text('LAST_UPDATE_LOGIN = ');
8005: Add_Bind(p_bind_identifier => 'LAST_UPDATE_LOGIN'
8006: ,p_value => l_current_login_id);
8007: FND_DSQL.Add_Text(', ');
8008: FND_DSQL.Add_Text('SOURCE_LANG = ');
8009: Add_Bind(p_bind_identifier => 'SOURCE_LANG'
8010: ,p_value => USERENV('LANG'));
8011: FND_DSQL.Add_Text(' WHERE EXTENSION_ID = ');

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

8004: FND_DSQL.Add_Text('LAST_UPDATE_LOGIN = ');
8005: Add_Bind(p_bind_identifier => 'LAST_UPDATE_LOGIN'
8006: ,p_value => l_current_login_id);
8007: FND_DSQL.Add_Text(', ');
8008: FND_DSQL.Add_Text('SOURCE_LANG = ');
8009: Add_Bind(p_bind_identifier => 'SOURCE_LANG'
8010: ,p_value => USERENV('LANG'));
8011: FND_DSQL.Add_Text(' WHERE EXTENSION_ID = ');
8012: Add_Bind(p_bind_identifier => 'EXTENSION_ID'

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

8007: FND_DSQL.Add_Text(', ');
8008: FND_DSQL.Add_Text('SOURCE_LANG = ');
8009: Add_Bind(p_bind_identifier => 'SOURCE_LANG'
8010: ,p_value => USERENV('LANG'));
8011: FND_DSQL.Add_Text(' WHERE EXTENSION_ID = ');
8012: Add_Bind(p_bind_identifier => 'EXTENSION_ID'
8013: ,p_value => p_extension_id);
8014:
8015: ----------------------------------------------------------------------------

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

8029: l_data_level_id := Get_Data_Level_Id( p_attr_group_metadata_obj.APPLICATION_ID
8030: ,p_attr_group_metadata_obj.ATTR_GROUP_TYPE
8031: ,p_data_level);
8032:
8033: FND_DSQL.Add_Text(' AND DATA_LEVEL_ID = ');
8034: Add_Bind(p_bind_identifier => 'DATA_LEVEL_ID'
8035: ,p_value => l_data_level_id);
8036:
8037: END IF;

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

8047: LOOP
8048: l_col_name := p_data_level_name_value_pairs(l_col_values_index).NAME;
8049: l_col_value := p_data_level_name_value_pairs(l_col_values_index).VALUE;
8050: IF (l_col_value is not NULL) THEN
8051: FND_DSQL.Add_Text(' AND '||l_col_name||' = ');
8052: Add_Bind(p_bind_identifier => l_col_name
8053: ,p_value => l_col_value);
8054: END IF;
8055: l_col_values_index := p_class_code_name_value_pairs.NEXT(l_col_values_index);

Line 8060: FND_DSQL.Add_Text(l_change_col_where_string);

8056: END LOOP;
8057: END IF;--p_data_level_name_value_pairs IS NOT NULL
8058: --End Bug 5211171
8059:
8060: FND_DSQL.Add_Text(l_change_col_where_string);
8061:
8062: -----------------------------------------------------------------
8063: -- We pass p_language_to_process from Implement_Change_Line so --
8064: -- that each pending TL row only updates one production row --

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

8063: -- We pass p_language_to_process from Implement_Change_Line so --
8064: -- that each pending TL row only updates one production row --
8065: -----------------------------------------------------------------
8066: IF (p_language_to_process IS NOT NULL) THEN
8067: FND_DSQL.Add_Text(' AND ((SOURCE_LANG = ');
8068: Add_Bind(p_bind_identifier => 'SOURCE_LANG'
8069: ,p_value => USERENV('LANG'));
8070: FND_DSQL.Add_Text(' AND LANGUAGE = ');
8071: Add_Bind(p_bind_identifier => 'LANGUAGE'

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

8066: IF (p_language_to_process IS NOT NULL) THEN
8067: FND_DSQL.Add_Text(' AND ((SOURCE_LANG = ');
8068: Add_Bind(p_bind_identifier => 'SOURCE_LANG'
8069: ,p_value => USERENV('LANG'));
8070: FND_DSQL.Add_Text(' AND LANGUAGE = ');
8071: Add_Bind(p_bind_identifier => 'LANGUAGE'
8072: ,p_value => p_language_to_process);
8073: FND_DSQL.Add_Text(') OR (SOURCE_LANG <> ');
8074: Add_Bind(p_bind_identifier => 'SOURCE_LANG'

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

8069: ,p_value => USERENV('LANG'));
8070: FND_DSQL.Add_Text(' AND LANGUAGE = ');
8071: Add_Bind(p_bind_identifier => 'LANGUAGE'
8072: ,p_value => p_language_to_process);
8073: FND_DSQL.Add_Text(') OR (SOURCE_LANG <> ');
8074: Add_Bind(p_bind_identifier => 'SOURCE_LANG'
8075: ,p_value => USERENV('LANG'));
8076: FND_DSQL.Add_Text(' AND LANGUAGE = ');
8077: Add_Bind(p_bind_identifier => 'LANGUAGE'

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

8072: ,p_value => p_language_to_process);
8073: FND_DSQL.Add_Text(') OR (SOURCE_LANG <> ');
8074: Add_Bind(p_bind_identifier => 'SOURCE_LANG'
8075: ,p_value => USERENV('LANG'));
8076: FND_DSQL.Add_Text(' AND LANGUAGE = ');
8077: Add_Bind(p_bind_identifier => 'LANGUAGE'
8078: ,p_value => USERENV('LANG'));
8079: FND_DSQL.Add_Text('))');
8080: ELSE

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

8075: ,p_value => USERENV('LANG'));
8076: FND_DSQL.Add_Text(' AND LANGUAGE = ');
8077: Add_Bind(p_bind_identifier => 'LANGUAGE'
8078: ,p_value => USERENV('LANG'));
8079: FND_DSQL.Add_Text('))');
8080: ELSE
8081: ----------------------------------------------------------
8082: -- In all other flows, we want to update all rows whose --
8083: -- language or source language is the current language --

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

8081: ----------------------------------------------------------
8082: -- In all other flows, we want to update all rows whose --
8083: -- language or source language is the current language --
8084: ----------------------------------------------------------
8085: FND_DSQL.Add_Text(' AND (LANGUAGE = ');
8086: Add_Bind(p_bind_identifier => 'LANGUAGE'
8087: ,p_value => USERENV('LANG'));
8088: FND_DSQL.Add_Text(' OR SOURCE_LANG = ');
8089: Add_Bind(p_bind_identifier => 'SOURCE_LANG'

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

8084: ----------------------------------------------------------
8085: FND_DSQL.Add_Text(' AND (LANGUAGE = ');
8086: Add_Bind(p_bind_identifier => 'LANGUAGE'
8087: ,p_value => USERENV('LANG'));
8088: FND_DSQL.Add_Text(' OR SOURCE_LANG = ');
8089: Add_Bind(p_bind_identifier => 'SOURCE_LANG'
8090: ,p_value => USERENV('LANG'));
8091: FND_DSQL.Add_Text(')');
8092: END IF;

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

8087: ,p_value => USERENV('LANG'));
8088: FND_DSQL.Add_Text(' OR SOURCE_LANG = ');
8089: Add_Bind(p_bind_identifier => 'SOURCE_LANG'
8090: ,p_value => USERENV('LANG'));
8091: FND_DSQL.Add_Text(')');
8092: END IF;
8093:
8094:
8095: l_dynamic_sql := FND_DSQL.Get_Text(FALSE);

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

8091: FND_DSQL.Add_Text(')');
8092: END IF;
8093:
8094:
8095: l_dynamic_sql := FND_DSQL.Get_Text(FALSE);
8096: Set_Binds_And_Dml(l_dynamic_sql ,'TL');
8097:
8098: Debug_Msg('In Update_Row, l_dynamic_sql for TL table is as follows:', 3);
8099: Debug_SQL(FND_DSQL.Get_Text(TRUE));

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

8095: l_dynamic_sql := FND_DSQL.Get_Text(FALSE);
8096: Set_Binds_And_Dml(l_dynamic_sql ,'TL');
8097:
8098: Debug_Msg('In Update_Row, l_dynamic_sql for TL table is as follows:', 3);
8099: Debug_SQL(FND_DSQL.Get_Text(TRUE));
8100:
8101: IF (p_execute_dml = FND_API.G_TRUE) THEN
8102: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.Native);
8103: FND_DSQL.Set_Cursor(l_cursor_id);

Line 8103: FND_DSQL.Set_Cursor(l_cursor_id);

8099: Debug_SQL(FND_DSQL.Get_Text(TRUE));
8100:
8101: IF (p_execute_dml = FND_API.G_TRUE) THEN
8102: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.Native);
8103: FND_DSQL.Set_Cursor(l_cursor_id);
8104: FND_DSQL.Do_Binds();
8105: END IF;
8106:
8107: --Start 4105841

Line 8104: FND_DSQL.Do_Binds();

8100:
8101: IF (p_execute_dml = FND_API.G_TRUE) THEN
8102: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.Native);
8103: FND_DSQL.Set_Cursor(l_cursor_id);
8104: FND_DSQL.Do_Binds();
8105: END IF;
8106:
8107: --Start 4105841
8108: --Raise pre Event if not already raised

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

8469: -- We pass p_language_to_process from Implement_Change_Line so --
8470: -- that each pending TL row only deletes one production row --
8471: -----------------------------------------------------------------
8472: IF (p_language_to_process IS NOT NULL) THEN
8473: FND_DSQL.Add_Text(' AND LANGUAGE = ');
8474: Add_Bind(p_value => p_language_to_process);
8475: END IF;
8476: END IF;
8477:

Line 12735: FND_DSQL.Add_Text(

12731: -- and overriding) --
12732: -----------------------------------------------------------------
12733: l_cursor_id := DBMS_SQL.Open_Cursor;
12734: Init();
12735: FND_DSQL.Add_Text(
12736: 'SELECT ETA_OUTER.ATTRIBUTE_GROUP_ID,' ||
12737: ' ETA_OUTER.ATTRIBUTE_ID,' ||
12738: ' ETA_OUTER.ROW_NUMBER,' ||
12739: ' ETA_OUTER.ATTRIBUTE_STRING_VALUE,' ||

Line 12747: FND_DSQL.Add_Text(

12743: ' ETA_OUTER.ATTRIBUTE_TRANSLATED_VALUE' ||
12744: ' FROM EGO_TEMPL_ATTRIBUTES ETA_OUTER'
12745: );
12746: IF p_data_level IS NOT NULL THEN
12747: FND_DSQL.Add_Text(
12748: ' , EGO_DATA_LEVEL_B DL ' ||
12749: ' WHERE DL.data_level_name = '
12750: );
12751: Add_Bind(p_value => p_data_level);

Line 12752: FND_DSQL.Add_Text(

12748: ' , EGO_DATA_LEVEL_B DL ' ||
12749: ' WHERE DL.data_level_name = '
12750: );
12751: Add_Bind(p_value => p_data_level);
12752: FND_DSQL.Add_Text(
12753: ' AND DL.data_level_id = ETA_OUTER.data_level_id '
12754: );
12755: ELSE
12756: FND_DSQL.Add_Text(' WHERE 1 = 1');

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

12752: FND_DSQL.Add_Text(
12753: ' AND DL.data_level_id = ETA_OUTER.data_level_id '
12754: );
12755: ELSE
12756: FND_DSQL.Add_Text(' WHERE 1 = 1');
12757: END IF;
12758: FND_DSQL.Add_Text(' AND ETA_OUTER.TEMPLATE_ID = ');
12759: Add_Bind(p_value => p_template_id);
12760: FND_DSQL.Add_Text(' AND ETA_OUTER.CLASSIFICATION_CODE IN (');

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

12754: );
12755: ELSE
12756: FND_DSQL.Add_Text(' WHERE 1 = 1');
12757: END IF;
12758: FND_DSQL.Add_Text(' AND ETA_OUTER.TEMPLATE_ID = ');
12759: Add_Bind(p_value => p_template_id);
12760: FND_DSQL.Add_Text(' AND ETA_OUTER.CLASSIFICATION_CODE IN (');
12761:
12762: -- we assume here that the calling procedure has passed in some class codes

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

12756: FND_DSQL.Add_Text(' WHERE 1 = 1');
12757: END IF;
12758: FND_DSQL.Add_Text(' AND ETA_OUTER.TEMPLATE_ID = ');
12759: Add_Bind(p_value => p_template_id);
12760: FND_DSQL.Add_Text(' AND ETA_OUTER.CLASSIFICATION_CODE IN (');
12761:
12762: -- we assume here that the calling procedure has passed in some class codes
12763: l_class_code_hierarchy := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
12764: l_ext_table_metadata_obj.class_code_metadata

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

12767: ,TRUE
12768: );
12769: Debug_Msg(l_api_name||' l_class_code_hierarchy '|| l_class_code_hierarchy, 1);
12770:
12771: FND_DSQL.Add_Text(')' ||
12772: ' AND ETA_OUTER.ENABLED_FLAG = ''Y''' ||
12773: l_attr_group_ids_to_exclude||
12774: ' AND (ETA_OUTER.TEMPLATE_ID' ||
12775: ' ,ETA_OUTER.ATTRIBUTE_GROUP_ID' ||

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

12802: Add_Bind(p_value => SUBSTR(l_next_cc,
12803: l_cc_begin_pos,
12804: INSTR(l_next_cc, '''', -1) - l_cc_begin_pos));
12805: END IF;
12806: FND_DSQL.Add_Text(', ' || l_decode_index);
12807:
12808: EXIT WHEN (l_is_last_cc);
12809:
12810: FND_DSQL.Add_Text(', ');

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

12806: FND_DSQL.Add_Text(', ' || l_decode_index);
12807:
12808: EXIT WHEN (l_is_last_cc);
12809:
12810: FND_DSQL.Add_Text(', ');
12811: l_decode_index := l_decode_index + 1;
12812: l_last_loop_index := l_this_loop_index + 1;
12813:
12814: END LOOP;

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

12812: l_last_loop_index := l_this_loop_index + 1;
12813:
12814: END LOOP;
12815:
12816: FND_DSQL.Add_Text('))' ||
12817: ' IN (SELECT ETA.TEMPLATE_ID' ||
12818: ' ,ETA.ATTRIBUTE_GROUP_ID' ||
12819: ' ,ETA.ATTRIBUTE_ID' ||
12820: ' ,ETA.ROW_NUMBER' ||

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

12845: Add_Bind(p_value => SUBSTR(l_next_cc,
12846: l_cc_begin_pos,
12847: INSTR(l_next_cc, '''', -1) - l_cc_begin_pos));
12848: END IF;
12849: FND_DSQL.Add_Text(', ' || l_decode_index);
12850:
12851: EXIT WHEN (l_is_last_cc);
12852:
12853: FND_DSQL.Add_Text(', ');

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

12849: FND_DSQL.Add_Text(', ' || l_decode_index);
12850:
12851: EXIT WHEN (l_is_last_cc);
12852:
12853: FND_DSQL.Add_Text(', ');
12854: l_decode_index := l_decode_index + 1;
12855: l_last_loop_index := l_this_loop_index + 1;
12856:
12857: END LOOP;

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

12855: l_last_loop_index := l_this_loop_index + 1;
12856:
12857: END LOOP;
12858:
12859: FND_DSQL.Add_Text(')) STEPS_ABOVE_CURR' ||
12860: ' FROM EGO_TEMPL_ATTRIBUTES ETA' ||
12861: ' WHERE ETA.TEMPLATE_ID = ');
12862: Add_Bind(p_value => p_template_id);
12863: FND_DSQL.Add_Text(

Line 12863: FND_DSQL.Add_Text(

12859: FND_DSQL.Add_Text(')) STEPS_ABOVE_CURR' ||
12860: ' FROM EGO_TEMPL_ATTRIBUTES ETA' ||
12861: ' WHERE ETA.TEMPLATE_ID = ');
12862: Add_Bind(p_value => p_template_id);
12863: FND_DSQL.Add_Text(
12864: ' AND ETA.CLASSIFICATION_CODE IN (');
12865:
12866: l_class_code_hierarchy := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
12867: l_ext_table_metadata_obj.class_code_metadata

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

12869: ,'VALUES_ALL_CC'
12870: ,TRUE
12871: );
12872:
12873: FND_DSQL.Add_Text(')' ||
12874: ' GROUP BY ETA.TEMPLATE_ID, ETA.ATTRIBUTE_GROUP_ID, ETA.ATTRIBUTE_ID, ETA.ROW_NUMBER)' ||
12875: ' ORDER BY ETA_OUTER.ATTRIBUTE_GROUP_ID, ETA_OUTER.ROW_NUMBER');
12876:
12877: -----------------------------------------------------------------------------------

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

12876:
12877: -----------------------------------------------------------------------------------
12878: -- Parse and execute the query, and associate the output columns with our record --
12879: -----------------------------------------------------------------------------------
12880: Debug_Msg(l_api_name||' complete query '|| FND_DSQL.Get_Text(), 1);
12881: Debug_Msg(l_api_name||' using binds template_id: '||p_template_id||' , '||
12882: ' class code: '||l_class_code_hierarchy
12883: , 1);
12884:

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

12881: Debug_Msg(l_api_name||' using binds template_id: '||p_template_id||' , '||
12882: ' class code: '||l_class_code_hierarchy
12883: , 1);
12884:
12885: DBMS_SQL.Parse(l_cursor_id, FND_DSQL.Get_Text(), DBMS_SQL.Native);
12886: FND_DSQL.Set_Cursor(l_cursor_id);
12887: FND_DSQL.Do_Binds();
12888: DBMS_SQL.Define_Column(l_cursor_id, 1, l_templ_attr_rec.ATTRIBUTE_GROUP_ID);
12889: DBMS_SQL.Define_Column(l_cursor_id, 2, l_templ_attr_rec.ATTRIBUTE_ID);

Line 12886: FND_DSQL.Set_Cursor(l_cursor_id);

12882: ' class code: '||l_class_code_hierarchy
12883: , 1);
12884:
12885: DBMS_SQL.Parse(l_cursor_id, FND_DSQL.Get_Text(), DBMS_SQL.Native);
12886: FND_DSQL.Set_Cursor(l_cursor_id);
12887: FND_DSQL.Do_Binds();
12888: DBMS_SQL.Define_Column(l_cursor_id, 1, l_templ_attr_rec.ATTRIBUTE_GROUP_ID);
12889: DBMS_SQL.Define_Column(l_cursor_id, 2, l_templ_attr_rec.ATTRIBUTE_ID);
12890: DBMS_SQL.Define_Column(l_cursor_id, 3, l_templ_attr_rec.ROW_NUMBER);

Line 12887: FND_DSQL.Do_Binds();

12883: , 1);
12884:
12885: DBMS_SQL.Parse(l_cursor_id, FND_DSQL.Get_Text(), DBMS_SQL.Native);
12886: FND_DSQL.Set_Cursor(l_cursor_id);
12887: FND_DSQL.Do_Binds();
12888: DBMS_SQL.Define_Column(l_cursor_id, 1, l_templ_attr_rec.ATTRIBUTE_GROUP_ID);
12889: DBMS_SQL.Define_Column(l_cursor_id, 2, l_templ_attr_rec.ATTRIBUTE_ID);
12890: DBMS_SQL.Define_Column(l_cursor_id, 3, l_templ_attr_rec.ROW_NUMBER);
12891: DBMS_SQL.Define_Column(l_cursor_id, 4, l_templ_attr_rec.ATTRIBUTE_STRING_VALUE, 150);

Line 17031: FND_DSQL.Add_Bind(p_value);

17027: G_BIND_INDEX := G_BIND_INDEX + 1;
17028: G_BIND_IDENTIFIER_TBL(G_BIND_INDEX) := p_bind_identifier;
17029: G_BIND_DATATYPE_TBL(G_BIND_INDEX) := 'C';
17030: G_BIND_TEXT_TBL(G_BIND_INDEX) := p_value;
17031: FND_DSQL.Add_Bind(p_value);
17032: END Add_Bind; --VARCHAR2
17033:
17034: ----------------------------------------------------------------------
17035:

Line 17044: FND_DSQL.Add_Bind(p_value);

17040: G_BIND_INDEX := G_BIND_INDEX + 1;
17041: G_BIND_IDENTIFIER_TBL(G_BIND_INDEX) := p_bind_identifier;
17042: G_BIND_DATATYPE_TBL(G_BIND_INDEX) := 'D';
17043: G_BIND_DATE_TBL(G_BIND_INDEX) := p_value;
17044: FND_DSQL.Add_Bind(p_value);
17045: END Add_Bind; --DATE
17046:
17047: ----------------------------------------------------------------------
17048:

Line 17057: FND_DSQL.Add_Bind(p_value);

17053: G_BIND_INDEX := G_BIND_INDEX + 1;
17054: G_BIND_IDENTIFIER_TBL(G_BIND_INDEX) := p_bind_identifier;
17055: G_BIND_DATATYPE_TBL(G_BIND_INDEX) := 'N';
17056: G_BIND_NUMBER_TBL(G_BIND_INDEX) := p_value;
17057: FND_DSQL.Add_Bind(p_value);
17058: END Add_Bind; --NUMBER
17059:
17060: ----------------------------------------------------------------------
17061:

Line 17093: FND_DSQL.Init();

17089: PROCEDURE Init
17090: IS
17091: BEGIN
17092: G_BIND_INDEX := 0;
17093: FND_DSQL.Init();
17094:
17095: FOR i IN 1 .. 100 LOOP
17096:
17097: G_BIND_IDENTIFIER_TBL(i) := NULL;