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 DBMS_SQL

Line 1080: l_cursor_id := DBMS_SQL.OPEN_CURSOR;

1076:
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 --

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 1099: DBMS_SQL.Define_Column(l_cursor_id, 1, l_extension_id);

1095: -- (in the VARCHAR2 case, that includes stating the maximum size that a --
1096: -- value in the column might be; to be safe we will use 1000 bytes). --
1097: -- First we register the EXTENSION_ID and ATTR_GROUP_ID... --
1098: --------------------------------------------------------------------------
1099: DBMS_SQL.Define_Column(l_cursor_id, 1, l_extension_id);
1100:
1101: -----------------------------------
1102: -- ...then the Database Columns. --
1103: -----------------------------------

Line 1110: DBMS_SQL.Define_Column(l_cursor_id, i+1, l_retrieved_value, 4000); --bug 12979914

1106:
1107: --------------------------------------------------------------------
1108: -- We cast everything to string for assignment to ATTR_DISP_VALUE --
1109: --------------------------------------------------------------------
1110: DBMS_SQL.Define_Column(l_cursor_id, i+1, l_retrieved_value, 4000); --bug 12979914
1111:
1112: END LOOP;
1113:
1114: -------------------------------

Line 1117: l_dummy := DBMS_SQL.Execute(l_cursor_id);

1113:
1114: -------------------------------
1115: -- Execute our dynamic query --
1116: -------------------------------
1117: l_dummy := DBMS_SQL.Execute(l_cursor_id);
1118:
1119: Debug_Msg(l_api_name||' executed the query', 3);
1120:
1121: -----------------------------------------------------------------------

Line 1127: WHILE (DBMS_SQL.FETCH_ROWS(l_cursor_id) > 0)

1123: -- appropriate fields of the attr diff object based on data type --
1124: -----------------------------------------------------------------------
1125:
1126: l_attr_diffs_last := px_attr_diffs.LAST;
1127: WHILE (DBMS_SQL.FETCH_ROWS(l_cursor_id) > 0)
1128: LOOP
1129:
1130: FOR i IN l_db_column_name_table.FIRST .. l_db_column_name_table.LAST
1131: LOOP

Line 1142: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 1, l_extension_id);

1138: LOOP
1139:
1140: IF (l_db_column_name_table(i) = l_augmented_data_table(j).DATABASE_COLUMN) THEN
1141:
1142: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 1, l_extension_id);
1143:
1144: ------------------------------------------------
1145: -- We use i+1 because of the offset caused by --
1146: -- requesting EXTENSION_ID --

Line 1148: DBMS_SQL.COLUMN_VALUE(l_cursor_id, i+1, l_retrieved_value);

1144: ------------------------------------------------
1145: -- We use i+1 because of the offset caused by --
1146: -- requesting EXTENSION_ID --
1147: ------------------------------------------------
1148: DBMS_SQL.COLUMN_VALUE(l_cursor_id, i+1, l_retrieved_value);
1149:
1150: Debug_Msg(l_api_name||' db col: '||l_db_column_name_table(i)||' val: '||l_retrieved_value, 1);
1151:
1152: IF (px_attr_diffs(j).OLD_ATTR_VALUE_NUM IS NULL AND

Line 1219: DBMS_SQL.Close_Cursor(l_cursor_id);

1215: -----------------------------------------
1216: -- Close the cursor when we're through --
1217: -----------------------------------------
1218: IF (l_cursor_id IS NOT NULL) THEN
1219: DBMS_SQL.Close_Cursor(l_cursor_id);
1220: l_cursor_id := NULL;
1221: END IF;
1222: -- Start ssingal -For Ucc Net Attribute Propagation
1223: ELSIF (p_dml_operation = 'DELETE' ) THEN

Line 2887: l_cursor_id := DBMS_SQL.Open_Cursor;

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);
2890: FND_DSQL.Set_Cursor(l_cursor_id);
2891: FND_DSQL.Do_Binds();

Line 2889: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.Native);

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);
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:

Line 2892: DBMS_SQL.Define_Column(l_cursor_id, 1, l_retrieved_value, 4000); --bug 12979914

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:
2896: IF (l_number_of_rows > 0) THEN

Line 2894: l_number_of_rows := DBMS_SQL.Execute_And_Fetch(l_cursor_id);

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:
2896: IF (l_number_of_rows > 0) THEN
2897:
2898: DBMS_SQL.Column_Value(l_cursor_id, 1, l_retrieved_value);

Line 2898: DBMS_SQL.Column_Value(l_cursor_id, 1, l_retrieved_value);

2894: l_number_of_rows := DBMS_SQL.Execute_And_Fetch(l_cursor_id);
2895:
2896: IF (l_number_of_rows > 0) THEN
2897:
2898: DBMS_SQL.Column_Value(l_cursor_id, 1, l_retrieved_value);
2899:
2900: END IF;
2901:
2902: DBMS_SQL.Close_Cursor(l_cursor_id);

Line 2902: DBMS_SQL.Close_Cursor(l_cursor_id);

2898: DBMS_SQL.Column_Value(l_cursor_id, 1, l_retrieved_value);
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);

Line 3304: l_cursor_id := DBMS_SQL.Open_Cursor;

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;
3305:
3306: --------------------------------------------------
3307: -- Next we parse the query, bind our variables, --
3308: -- and tell DBMS_SQL what we want it to return --

Line 3308: -- and tell DBMS_SQL what we want it to return --

3304: l_cursor_id := DBMS_SQL.Open_Cursor;
3305:
3306: --------------------------------------------------
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();

Line 3310: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.Native);

3306: --------------------------------------------------
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: ---------------------------------------------------------------------

Line 3313: DBMS_SQL.Define_Column(l_cursor_id, 1, l_extension_id);

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 --
3317: ---------------------------------------------------------------------

Line 3318: l_number_of_rows := DBMS_SQL.Execute_And_Fetch(l_cursor_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 --
3317: ---------------------------------------------------------------------
3318: l_number_of_rows := DBMS_SQL.Execute_And_Fetch(l_cursor_id);
3319: IF (l_number_of_rows = 1) THEN
3320: DBMS_SQL.Column_Value(l_cursor_id, 1, l_extension_id);
3321: ELSIF (l_number_of_rows > 1) THEN
3322: l_extension_id := -1;

Line 3320: DBMS_SQL.Column_Value(l_cursor_id, 1, l_extension_id);

3316: -- rows, we return NULL, and if we get too many rows, we return -1 --
3317: ---------------------------------------------------------------------
3318: l_number_of_rows := DBMS_SQL.Execute_And_Fetch(l_cursor_id);
3319: IF (l_number_of_rows = 1) THEN
3320: DBMS_SQL.Column_Value(l_cursor_id, 1, l_extension_id);
3321: ELSIF (l_number_of_rows > 1) THEN
3322: l_extension_id := -1;
3323: END IF;
3324:

Line 3328: DBMS_SQL.Close_Cursor(l_cursor_id);

3324:
3325: ---------------------------------------------------------
3326: -- Finally, we close the cursor and return our results --
3327: ---------------------------------------------------------
3328: DBMS_SQL.Close_Cursor(l_cursor_id);
3329: Debug_Msg('In Get_Extension_Id_For_Row, done; l_extension_id is '||l_extension_id, 2);
3330:
3331: RETURN l_extension_id;
3332: EXCEPTION

Line 4697: l_cursor_id := DBMS_SQL.Open_Cursor;

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();
4701: DBMS_SQL.Define_Column(l_cursor_id, 1, l_data_level, 30);

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 4701: DBMS_SQL.Define_Column(l_cursor_id, 1, l_data_level, 30);

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:
4705: IF (l_dummy = 0) THEN

Line 4702: l_dummy := DBMS_SQL.Execute(l_cursor_id);

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:
4705: IF (l_dummy = 0) THEN
4706: RAISE NO_DATA_FOUND;

Line 4703: l_dummy := DBMS_SQL.Fetch_Rows(l_cursor_id);

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:
4705: IF (l_dummy = 0) THEN
4706: RAISE NO_DATA_FOUND;
4707: END IF;

Line 4710: DBMS_SQL.Close_Cursor(l_cursor_id);

4706: RAISE NO_DATA_FOUND;
4707: END IF;
4708:
4709: --bug 9170700
4710: DBMS_SQL.Close_Cursor(l_cursor_id);
4711:
4712: l_is_data_level_correct := TRUE;
4713: ELSE
4714: l_is_data_level_correct := FALSE;

Line 4775: l_cursor_id := DBMS_SQL.Open_Cursor;

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;
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);

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 4779: DBMS_SQL.Define_Column(l_cursor_id, 1, l_data_level, 30);

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:
4783: IF (l_dummy = 0) THEN

Line 4780: l_dummy := DBMS_SQL.Execute(l_cursor_id);

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:
4783: IF (l_dummy = 0) THEN
4784: RAISE NO_DATA_FOUND;

Line 4781: l_dummy := DBMS_SQL.Fetch_Rows(l_cursor_id);

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:
4783: IF (l_dummy = 0) THEN
4784: RAISE NO_DATA_FOUND;
4785: END IF;

Line 4787: DBMS_SQL.Column_Value(l_cursor_id, 1, l_data_level);

4783: IF (l_dummy = 0) THEN
4784: RAISE NO_DATA_FOUND;
4785: END IF;
4786:
4787: DBMS_SQL.Column_Value(l_cursor_id, 1, l_data_level);
4788: DBMS_SQL.Close_Cursor(l_cursor_id);
4789:
4790: IF (G_ASSOCIATION_DATA_LEVEL_CACHE.EXISTS(p_attr_group_id)) THEN
4791:

Line 4788: DBMS_SQL.Close_Cursor(l_cursor_id);

4784: RAISE NO_DATA_FOUND;
4785: END IF;
4786:
4787: DBMS_SQL.Column_Value(l_cursor_id, 1, l_data_level);
4788: DBMS_SQL.Close_Cursor(l_cursor_id);
4789:
4790: IF (G_ASSOCIATION_DATA_LEVEL_CACHE.EXISTS(p_attr_group_id)) THEN
4791:
4792: G_ASSOCIATION_DATA_LEVEL_CACHE(p_attr_group_id) := l_obj_and_class||

Line 4925: DBMS_SQL.Close_Cursor(l_cursor_id);

4921: EXCEPTION
4922: WHEN NO_DATA_FOUND THEN
4923: Debug_Msg('In Is_Data_Level_Correct, got NO_DATA_FOUND exception so returning FALSE');
4924: IF (l_cursor_id IS NOT NULL) THEN
4925: DBMS_SQL.Close_Cursor(l_cursor_id);
4926: END IF;
4927: --------------------------------------------------------------------
4928: -- In this case, the Attribute Group isn't even associated to the --
4929: -- passed-in Classification Code, so we try to query up the --

Line 7524: l_cursor_id := DBMS_SQL.Open_Cursor;

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:
7527: --------------------------------------------------------------------------------
7528: -- If we're bulkloading, we want to default any values the user left blank, --

Line 7801: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.Native);

7797: -- Next we parse the statement, bind our variables, and execute it --
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:

Line 7837: l_number_of_rows := DBMS_SQL.Execute(l_cursor_id);

7833: END IF;
7834: --End 4105841
7835:
7836: IF (p_execute_dml = FND_API.G_TRUE) THEN
7837: l_number_of_rows := DBMS_SQL.Execute(l_cursor_id);
7838: END IF;
7839:
7840: END IF;
7841:

Line 8039: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.Native);

8035: ---------------------------------------------------
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:

Line 8068: l_number_of_rows := DBMS_SQL.Execute(l_cursor_id);

8064: END IF;
8065: --End 4105841
8066:
8067: IF (p_execute_dml = FND_API.G_TRUE) THEN
8068: l_number_of_rows := DBMS_SQL.Execute(l_cursor_id);
8069: END IF;
8070:
8071: END IF;
8072:

Line 8076: DBMS_SQL.Close_Cursor(l_cursor_id);

8072:
8073: ----------------------------------
8074: -- Finally, we close our cursor --
8075: ----------------------------------
8076: DBMS_SQL.Close_Cursor(l_cursor_id);
8077:
8078: IF (l_propagate_hierarchy
8079: AND p_attr_group_metadata_obj.HIERARCHY_PROPAGATE_FLAG = 'Y'
8080: AND px_attr_diffs.COUNT > 0 AND p_execute_dml = FND_API.G_TRUE) THEN --Bug fix 5220020

Line 8394: l_cursor_id := DBMS_SQL.Open_Cursor;

8390: END IF;
8391: --------------------------------------------------------------
8392: -- First we open a cursor for use in one or both statements --
8393: --------------------------------------------------------------
8394: l_cursor_id := DBMS_SQL.Open_Cursor;
8395:
8396: ------------------------------------------------------------------
8397: -- We pass p_language_to_process from Implement_Change_Line; if --
8398: -- we have it, then we only insert if the passed-in language is --

Line 8497: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.Native);

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);
8498: FND_DSQL.Set_Cursor(l_cursor_id);
8499: FND_DSQL.Do_Binds();
8500: END IF;
8501:

Line 8533: l_number_of_rows := DBMS_SQL.Execute(l_cursor_id);

8529: END IF;
8530: --End 4105841
8531:
8532: IF (p_execute_dml = FND_API.G_TRUE) THEN
8533: l_number_of_rows := DBMS_SQL.Execute(l_cursor_id);
8534: END IF;
8535:
8536: END IF;
8537:

Line 8681: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.Native);

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);
8683: FND_DSQL.Do_Binds();
8684: END IF;
8685:

Line 8709: l_number_of_rows := DBMS_SQL.Execute(l_cursor_id);

8705: END IF;
8706: --End 4105841
8707:
8708: IF (p_execute_dml = FND_API.G_TRUE) THEN
8709: l_number_of_rows := DBMS_SQL.Execute(l_cursor_id);
8710: END IF;
8711:
8712:
8713: END IF;

Line 8719: DBMS_SQL.Close_Cursor(l_cursor_id);

8715:
8716: ----------------------------------
8717: -- Finally, we close our cursor --
8718: ----------------------------------
8719: DBMS_SQL.Close_Cursor(l_cursor_id);
8720:
8721: --
8722: -- If caller passes multiple rows with same UK values, what should I do?
8723: -- Currently, I think they'll be treated as multiple instances of the same row,

Line 11144: l_cursor_id := DBMS_SQL.OPEN_CURSOR;

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);
11148:

Line 11149: DBMS_SQL.PARSE(l_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);

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);
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);

Line 11153: dbms_sql.define_column(l_cursor_id, 1, l_uom_value, 3);

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:
11156: Debug_msg('get_uom_value: ' || 'Executed the query');
11157:

Line 11154: l_dummy := DBMS_SQL.Execute(l_cursor_id);

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:
11156: Debug_msg('get_uom_value: ' || 'Executed the query');
11157:
11158: WHILE (DBMS_SQL.FETCH_ROWS(l_cursor_id) > 0)

Line 11158: WHILE (DBMS_SQL.FETCH_ROWS(l_cursor_id) > 0)

11154: l_dummy := DBMS_SQL.Execute(l_cursor_id);
11155:
11156: Debug_msg('get_uom_value: ' || 'Executed the query');
11157:
11158: WHILE (DBMS_SQL.FETCH_ROWS(l_cursor_id) > 0)
11159: LOOP
11160: dbms_sql.column_value(l_cursor_id, 1, l_uom_value);
11161: END LOOP;
11162:

Line 11160: dbms_sql.column_value(l_cursor_id, 1, l_uom_value);

11156: Debug_msg('get_uom_value: ' || 'Executed the query');
11157:
11158: WHILE (DBMS_SQL.FETCH_ROWS(l_cursor_id) > 0)
11159: LOOP
11160: dbms_sql.column_value(l_cursor_id, 1, l_uom_value);
11161: END LOOP;
11162:
11163: IF (l_cursor_id IS NOT NULL) THEN
11164: DBMS_SQL.Close_Cursor(l_cursor_id);

Line 11164: DBMS_SQL.Close_Cursor(l_cursor_id);

11160: dbms_sql.column_value(l_cursor_id, 1, l_uom_value);
11161: END LOOP;
11162:
11163: IF (l_cursor_id IS NOT NULL) THEN
11164: DBMS_SQL.Close_Cursor(l_cursor_id);
11165: END IF;
11166:
11167: Debug_msg('uom value = ' || l_uom_value);
11168: RETURN l_uom_value;

Line 11902: l_cursor_id := DBMS_SQL.OPEN_CURSOR;

11898:
11899: ----------------------------------
11900: -- Open a cursor for processing --
11901: ----------------------------------
11902: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
11903: -------------------------------------
11904: -- Parse our dynamic SQL statement --
11905: -------------------------------------
11906: DBMS_SQL.PARSE(l_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);

Line 11906: DBMS_SQL.PARSE(l_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);

11902: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
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 --

Line 11915: DBMS_SQL.Define_Column(l_cursor_id, 1, l_extension_id);

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). --
11913: -- First we register the EXTENSION_ID and ATTR_GROUP_ID... --
11914: --------------------------------------------------------------------------
11915: DBMS_SQL.Define_Column(l_cursor_id, 1, l_extension_id);
11916: DBMS_SQL.Define_Column(l_cursor_id, 2, l_curr_AG_ID);
11917:
11918: -----------------------------------
11919: -- Loop 1.4

Line 11916: DBMS_SQL.Define_Column(l_cursor_id, 2, l_curr_AG_ID);

11912: -- value in the column might be; to be safe we will use 1000 bytes). --
11913: -- First we register the EXTENSION_ID and ATTR_GROUP_ID... --
11914: --------------------------------------------------------------------------
11915: DBMS_SQL.Define_Column(l_cursor_id, 1, l_extension_id);
11916: DBMS_SQL.Define_Column(l_cursor_id, 2, l_curr_AG_ID);
11917:
11918: -----------------------------------
11919: -- Loop 1.4
11920: -- ...then the Database Columns. --

Line 11931: DBMS_SQL.Define_Column(l_cursor_id, (i*2)+1, l_varchar_example, 4000); --bug 12979914

11927: --------------------------------------------------------------------
11928: -- We cast everything to string for assignment to ATTR_DISP_VALUE --
11929: --------------------------------------------------------------------
11930: -- Syalaman - Fix for bug 5859465
11931: DBMS_SQL.Define_Column(l_cursor_id, (i*2)+1, l_varchar_example, 4000); --bug 12979914
11932:
11933: --ENHR12:changed for passing the internal value of the attribute
11934: --along with the display value.
11935: -- Syalaman - Fix for bug 5859465

Line 11936: DBMS_SQL.Define_Column(l_cursor_id, (i*2)+2, l_varchar_example, 4000); --bug 12979914

11932:
11933: --ENHR12:changed for passing the internal value of the attribute
11934: --along with the display value.
11935: -- Syalaman - Fix for bug 5859465
11936: DBMS_SQL.Define_Column(l_cursor_id, (i*2)+2, l_varchar_example, 4000); --bug 12979914
11937: END LOOP;
11938:
11939: -------------------------------
11940: -- Execute our dynamic query --

Line 11942: l_dummy := DBMS_SQL.Execute(l_cursor_id);

11938:
11939: -------------------------------
11940: -- Execute our dynamic query --
11941: -------------------------------
11942: l_dummy := DBMS_SQL.Execute(l_cursor_id);
11943: Debug_Msg(l_api_name||' executed the query', 3);
11944:
11945: --===============================================================================--
11946: -- Loop 1.5 --

Line 11962: WHILE (DBMS_SQL.FETCH_ROWS(l_cursor_id) > 0)

11958: -- table for an Attribute record belonging to the current AG ID, and --
11959: -- 3). l_high_aug_tab_ind_for_AG_ID, which holds the highest such index. --
11960: --===============================================================================--
11961: <>
11962: WHILE (DBMS_SQL.FETCH_ROWS(l_cursor_id) > 0)
11963: LOOP
11964:
11965: ----------------------------------------------------------------
11966: -- Get the EXTENSION_ID and ATTR_GROUP_ID for the current row --

Line 11968: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 1, l_extension_id);

11964:
11965: ----------------------------------------------------------------
11966: -- Get the EXTENSION_ID and ATTR_GROUP_ID for the current row --
11967: ----------------------------------------------------------------
11968: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 1, l_extension_id);
11969: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 2, l_curr_AG_ID);
11970:
11971: -----------------------------------------------------------------
11972: -- Reset the variable that tells us whether we need to build a --

Line 11969: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 2, l_curr_AG_ID);

11965: ----------------------------------------------------------------
11966: -- Get the EXTENSION_ID and ATTR_GROUP_ID for the current row --
11967: ----------------------------------------------------------------
11968: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 1, l_extension_id);
11969: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 2, l_curr_AG_ID);
11970:
11971: -----------------------------------------------------------------
11972: -- Reset the variable that tells us whether we need to build a --
11973: -- new row object for the out parameter x_attributes_row_table --

Line 12039: DBMS_SQL.COLUMN_VALUE(l_cursor_id, (i*2)+1, l_curr_augmented_attr_rec.ATTR_DISP_VALUE); -- Fix for bug 5859465

12035:
12036: --ENHR12:added for passing the internal value of the attribute
12037: --along with the display value.
12038: --setting the Display Value.
12039: DBMS_SQL.COLUMN_VALUE(l_cursor_id, (i*2)+1, l_curr_augmented_attr_rec.ATTR_DISP_VALUE); -- Fix for bug 5859465
12040:
12041: --setting the intrnal value of the Attribute depending on the DATA_TYPE_CODE
12042: --if the attribute is of type Translatable(A) or Char(C)
12043: IF ('C'=l_curr_augmented_attr_rec.DATA_TYPE_CODE OR 'A'=l_curr_augmented_attr_rec.DATA_TYPE_CODE) THEN

Line 12044: DBMS_SQL.COLUMN_VALUE(l_cursor_id, (i*2)+2, l_curr_augmented_attr_rec.ATTR_VALUE_STR); -- Fix for bug 5859465

12040:
12041: --setting the intrnal value of the Attribute depending on the DATA_TYPE_CODE
12042: --if the attribute is of type Translatable(A) or Char(C)
12043: IF ('C'=l_curr_augmented_attr_rec.DATA_TYPE_CODE OR 'A'=l_curr_augmented_attr_rec.DATA_TYPE_CODE) THEN
12044: DBMS_SQL.COLUMN_VALUE(l_cursor_id, (i*2)+2, l_curr_augmented_attr_rec.ATTR_VALUE_STR); -- Fix for bug 5859465
12045: l_curr_augmented_attr_rec.ATTR_VALUE_DATE:=null;
12046: l_curr_augmented_attr_rec.ATTR_VALUE_NUM:=null;
12047: --if the attribute is of type Date(X) or DateTime(Y)
12048: ELSIF('X'=l_curr_augmented_attr_rec.DATA_TYPE_CODE OR 'Y'=l_curr_augmented_attr_rec.DATA_TYPE_CODE) THEN

Line 12049: DBMS_SQL.COLUMN_VALUE(l_cursor_id, (i*2)+2,l_char_value); -- Fix for bug 5859465

12045: l_curr_augmented_attr_rec.ATTR_VALUE_DATE:=null;
12046: l_curr_augmented_attr_rec.ATTR_VALUE_NUM:=null;
12047: --if the attribute is of type Date(X) or DateTime(Y)
12048: ELSIF('X'=l_curr_augmented_attr_rec.DATA_TYPE_CODE OR 'Y'=l_curr_augmented_attr_rec.DATA_TYPE_CODE) THEN
12049: DBMS_SQL.COLUMN_VALUE(l_cursor_id, (i*2)+2,l_char_value); -- Fix for bug 5859465
12050: l_curr_augmented_attr_rec.ATTR_VALUE_STR:=null;
12051: l_curr_augmented_attr_rec.ATTR_VALUE_NUM:=null;
12052: l_curr_augmented_attr_rec.ATTR_VALUE_DATE:=TO_DATE(l_char_value,'yyyy/mm/dd HH24:MI:SS');
12053: --if the attribute is of type NUMBER(N)

Line 12055: DBMS_SQL.COLUMN_VALUE(l_cursor_id, (i*2)+2, l_char_value); -- Fix for bug 5859465

12051: l_curr_augmented_attr_rec.ATTR_VALUE_NUM:=null;
12052: l_curr_augmented_attr_rec.ATTR_VALUE_DATE:=TO_DATE(l_char_value,'yyyy/mm/dd HH24:MI:SS');
12053: --if the attribute is of type NUMBER(N)
12054: ELSIF('N'=l_curr_augmented_attr_rec.DATA_TYPE_CODE) THEN
12055: DBMS_SQL.COLUMN_VALUE(l_cursor_id, (i*2)+2, l_char_value); -- Fix for bug 5859465
12056: l_curr_augmented_attr_rec.ATTR_VALUE_STR:=null;
12057: l_curr_augmented_attr_rec.ATTR_VALUE_DATE:=null;
12058: l_curr_augmented_attr_rec.ATTR_VALUE_NUM:=TO_NUMBER(l_char_value);
12059: --bug 8218727

Line 12196: DBMS_SQL.Close_Cursor(l_cursor_id);

12192: -----------------------------------------
12193: -- Close the cursor when we're through --
12194: -----------------------------------------
12195: IF (l_cursor_id IS NOT NULL) THEN
12196: DBMS_SQL.Close_Cursor(l_cursor_id);
12197: l_cursor_id := NULL;
12198: END IF;
12199: ELSE
12200: Debug_Msg(l_api_name||' l_db_column_query_table.COUNT = ' || l_db_column_query_table.COUNT, 1);

Line 12232: DBMS_SQL.Close_Cursor(l_cursor_id);

12228: -----------------------------------------
12229: -- Close the cursor if it's still open --
12230: -----------------------------------------
12231: IF (l_cursor_id IS NOT NULL) THEN
12232: DBMS_SQL.Close_Cursor(l_cursor_id);
12233: l_cursor_id := NULL;
12234: END IF;
12235:
12236: ------------------------------------------------------

Line 12266: DBMS_SQL.Close_Cursor(l_cursor_id);

12262: -----------------------------------------
12263: -- Close the cursor if it's still open --
12264: -----------------------------------------
12265: IF (l_cursor_id IS NOT NULL) THEN
12266: DBMS_SQL.Close_Cursor(l_cursor_id);
12267: l_cursor_id := NULL;
12268: END IF;
12269: ------------------------------------------------------
12270: -- We log all errors we got as we close our session --

Line 13759: l_cursor_id := DBMS_SQL.Open_Cursor;

13755: -- Classification Code hierarchy (the query returns the lowest --
13756: -- level values, thus implementing Template value inheritance --
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,' ||

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 13914: DBMS_SQL.Define_Column(l_cursor_id, 1, l_templ_attr_rec.ATTRIBUTE_GROUP_ID);

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);
13918: DBMS_SQL.Define_Column(l_cursor_id, 5, l_templ_attr_rec.ATTRIBUTE_NUMBER_VALUE);

Line 13915: DBMS_SQL.Define_Column(l_cursor_id, 2, l_templ_attr_rec.ATTRIBUTE_ID);

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);
13918: DBMS_SQL.Define_Column(l_cursor_id, 5, l_templ_attr_rec.ATTRIBUTE_NUMBER_VALUE);
13919: DBMS_SQL.Define_Column(l_cursor_id, 6, l_templ_attr_rec.ATTRIBUTE_UOM_CODE, 3);

Line 13916: DBMS_SQL.Define_Column(l_cursor_id, 3, l_templ_attr_rec.ROW_NUMBER);

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);
13918: DBMS_SQL.Define_Column(l_cursor_id, 5, l_templ_attr_rec.ATTRIBUTE_NUMBER_VALUE);
13919: DBMS_SQL.Define_Column(l_cursor_id, 6, l_templ_attr_rec.ATTRIBUTE_UOM_CODE, 3);
13920: DBMS_SQL.Define_Column(l_cursor_id, 7, l_templ_attr_rec.ATTRIBUTE_DATE_VALUE);

Line 13917: DBMS_SQL.Define_Column(l_cursor_id, 4, l_templ_attr_rec.ATTRIBUTE_STRING_VALUE, 150);

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);
13918: DBMS_SQL.Define_Column(l_cursor_id, 5, l_templ_attr_rec.ATTRIBUTE_NUMBER_VALUE);
13919: DBMS_SQL.Define_Column(l_cursor_id, 6, l_templ_attr_rec.ATTRIBUTE_UOM_CODE, 3);
13920: DBMS_SQL.Define_Column(l_cursor_id, 7, l_templ_attr_rec.ATTRIBUTE_DATE_VALUE);
13921: DBMS_SQL.Define_Column(l_cursor_id, 8, l_templ_attr_rec.ATTRIBUTE_TRANSLATED_VALUE, 1000);

Line 13918: DBMS_SQL.Define_Column(l_cursor_id, 5, l_templ_attr_rec.ATTRIBUTE_NUMBER_VALUE);

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);
13918: DBMS_SQL.Define_Column(l_cursor_id, 5, l_templ_attr_rec.ATTRIBUTE_NUMBER_VALUE);
13919: DBMS_SQL.Define_Column(l_cursor_id, 6, l_templ_attr_rec.ATTRIBUTE_UOM_CODE, 3);
13920: DBMS_SQL.Define_Column(l_cursor_id, 7, l_templ_attr_rec.ATTRIBUTE_DATE_VALUE);
13921: DBMS_SQL.Define_Column(l_cursor_id, 8, l_templ_attr_rec.ATTRIBUTE_TRANSLATED_VALUE, 1000);
13922: l_rows_fetched := DBMS_SQL.Execute(l_cursor_id);

Line 13919: DBMS_SQL.Define_Column(l_cursor_id, 6, l_templ_attr_rec.ATTRIBUTE_UOM_CODE, 3);

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);
13918: DBMS_SQL.Define_Column(l_cursor_id, 5, l_templ_attr_rec.ATTRIBUTE_NUMBER_VALUE);
13919: DBMS_SQL.Define_Column(l_cursor_id, 6, l_templ_attr_rec.ATTRIBUTE_UOM_CODE, 3);
13920: DBMS_SQL.Define_Column(l_cursor_id, 7, l_templ_attr_rec.ATTRIBUTE_DATE_VALUE);
13921: DBMS_SQL.Define_Column(l_cursor_id, 8, l_templ_attr_rec.ATTRIBUTE_TRANSLATED_VALUE, 1000);
13922: l_rows_fetched := DBMS_SQL.Execute(l_cursor_id);
13923:

Line 13920: DBMS_SQL.Define_Column(l_cursor_id, 7, l_templ_attr_rec.ATTRIBUTE_DATE_VALUE);

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);
13918: DBMS_SQL.Define_Column(l_cursor_id, 5, l_templ_attr_rec.ATTRIBUTE_NUMBER_VALUE);
13919: DBMS_SQL.Define_Column(l_cursor_id, 6, l_templ_attr_rec.ATTRIBUTE_UOM_CODE, 3);
13920: DBMS_SQL.Define_Column(l_cursor_id, 7, l_templ_attr_rec.ATTRIBUTE_DATE_VALUE);
13921: DBMS_SQL.Define_Column(l_cursor_id, 8, l_templ_attr_rec.ATTRIBUTE_TRANSLATED_VALUE, 1000);
13922: l_rows_fetched := DBMS_SQL.Execute(l_cursor_id);
13923:
13924: WHILE (DBMS_SQL.Fetch_Rows(l_cursor_id) > 0)

Line 13921: DBMS_SQL.Define_Column(l_cursor_id, 8, l_templ_attr_rec.ATTRIBUTE_TRANSLATED_VALUE, 1000);

13917: DBMS_SQL.Define_Column(l_cursor_id, 4, l_templ_attr_rec.ATTRIBUTE_STRING_VALUE, 150);
13918: DBMS_SQL.Define_Column(l_cursor_id, 5, l_templ_attr_rec.ATTRIBUTE_NUMBER_VALUE);
13919: DBMS_SQL.Define_Column(l_cursor_id, 6, l_templ_attr_rec.ATTRIBUTE_UOM_CODE, 3);
13920: DBMS_SQL.Define_Column(l_cursor_id, 7, l_templ_attr_rec.ATTRIBUTE_DATE_VALUE);
13921: DBMS_SQL.Define_Column(l_cursor_id, 8, l_templ_attr_rec.ATTRIBUTE_TRANSLATED_VALUE, 1000);
13922: l_rows_fetched := DBMS_SQL.Execute(l_cursor_id);
13923:
13924: WHILE (DBMS_SQL.Fetch_Rows(l_cursor_id) > 0)
13925: LOOP

Line 13922: l_rows_fetched := DBMS_SQL.Execute(l_cursor_id);

13918: DBMS_SQL.Define_Column(l_cursor_id, 5, l_templ_attr_rec.ATTRIBUTE_NUMBER_VALUE);
13919: DBMS_SQL.Define_Column(l_cursor_id, 6, l_templ_attr_rec.ATTRIBUTE_UOM_CODE, 3);
13920: DBMS_SQL.Define_Column(l_cursor_id, 7, l_templ_attr_rec.ATTRIBUTE_DATE_VALUE);
13921: DBMS_SQL.Define_Column(l_cursor_id, 8, l_templ_attr_rec.ATTRIBUTE_TRANSLATED_VALUE, 1000);
13922: l_rows_fetched := DBMS_SQL.Execute(l_cursor_id);
13923:
13924: WHILE (DBMS_SQL.Fetch_Rows(l_cursor_id) > 0)
13925: LOOP
13926:

Line 13924: WHILE (DBMS_SQL.Fetch_Rows(l_cursor_id) > 0)

13920: DBMS_SQL.Define_Column(l_cursor_id, 7, l_templ_attr_rec.ATTRIBUTE_DATE_VALUE);
13921: DBMS_SQL.Define_Column(l_cursor_id, 8, l_templ_attr_rec.ATTRIBUTE_TRANSLATED_VALUE, 1000);
13922: l_rows_fetched := DBMS_SQL.Execute(l_cursor_id);
13923:
13924: WHILE (DBMS_SQL.Fetch_Rows(l_cursor_id) > 0)
13925: LOOP
13926:
13927: DBMS_SQL.Column_Value(l_cursor_id, 1, l_templ_attr_rec.ATTRIBUTE_GROUP_ID);
13928: DBMS_SQL.Column_Value(l_cursor_id, 2, l_templ_attr_rec.ATTRIBUTE_ID);

Line 13927: DBMS_SQL.Column_Value(l_cursor_id, 1, l_templ_attr_rec.ATTRIBUTE_GROUP_ID);

13923:
13924: WHILE (DBMS_SQL.Fetch_Rows(l_cursor_id) > 0)
13925: LOOP
13926:
13927: DBMS_SQL.Column_Value(l_cursor_id, 1, l_templ_attr_rec.ATTRIBUTE_GROUP_ID);
13928: DBMS_SQL.Column_Value(l_cursor_id, 2, l_templ_attr_rec.ATTRIBUTE_ID);
13929: DBMS_SQL.Column_Value(l_cursor_id, 3, l_templ_attr_rec.ROW_NUMBER);
13930: DBMS_SQL.Column_Value(l_cursor_id, 4, l_templ_attr_rec.ATTRIBUTE_STRING_VALUE);
13931: DBMS_SQL.Column_Value(l_cursor_id, 5, l_templ_attr_rec.ATTRIBUTE_NUMBER_VALUE);

Line 13928: DBMS_SQL.Column_Value(l_cursor_id, 2, l_templ_attr_rec.ATTRIBUTE_ID);

13924: WHILE (DBMS_SQL.Fetch_Rows(l_cursor_id) > 0)
13925: LOOP
13926:
13927: DBMS_SQL.Column_Value(l_cursor_id, 1, l_templ_attr_rec.ATTRIBUTE_GROUP_ID);
13928: DBMS_SQL.Column_Value(l_cursor_id, 2, l_templ_attr_rec.ATTRIBUTE_ID);
13929: DBMS_SQL.Column_Value(l_cursor_id, 3, l_templ_attr_rec.ROW_NUMBER);
13930: DBMS_SQL.Column_Value(l_cursor_id, 4, l_templ_attr_rec.ATTRIBUTE_STRING_VALUE);
13931: DBMS_SQL.Column_Value(l_cursor_id, 5, l_templ_attr_rec.ATTRIBUTE_NUMBER_VALUE);
13932: DBMS_SQL.Column_Value(l_cursor_id, 6, l_templ_attr_rec.ATTRIBUTE_UOM_CODE);

Line 13929: DBMS_SQL.Column_Value(l_cursor_id, 3, l_templ_attr_rec.ROW_NUMBER);

13925: LOOP
13926:
13927: DBMS_SQL.Column_Value(l_cursor_id, 1, l_templ_attr_rec.ATTRIBUTE_GROUP_ID);
13928: DBMS_SQL.Column_Value(l_cursor_id, 2, l_templ_attr_rec.ATTRIBUTE_ID);
13929: DBMS_SQL.Column_Value(l_cursor_id, 3, l_templ_attr_rec.ROW_NUMBER);
13930: DBMS_SQL.Column_Value(l_cursor_id, 4, l_templ_attr_rec.ATTRIBUTE_STRING_VALUE);
13931: DBMS_SQL.Column_Value(l_cursor_id, 5, l_templ_attr_rec.ATTRIBUTE_NUMBER_VALUE);
13932: DBMS_SQL.Column_Value(l_cursor_id, 6, l_templ_attr_rec.ATTRIBUTE_UOM_CODE);
13933: DBMS_SQL.Column_Value(l_cursor_id, 7, l_templ_attr_rec.ATTRIBUTE_DATE_VALUE);

Line 13930: DBMS_SQL.Column_Value(l_cursor_id, 4, l_templ_attr_rec.ATTRIBUTE_STRING_VALUE);

13926:
13927: DBMS_SQL.Column_Value(l_cursor_id, 1, l_templ_attr_rec.ATTRIBUTE_GROUP_ID);
13928: DBMS_SQL.Column_Value(l_cursor_id, 2, l_templ_attr_rec.ATTRIBUTE_ID);
13929: DBMS_SQL.Column_Value(l_cursor_id, 3, l_templ_attr_rec.ROW_NUMBER);
13930: DBMS_SQL.Column_Value(l_cursor_id, 4, l_templ_attr_rec.ATTRIBUTE_STRING_VALUE);
13931: DBMS_SQL.Column_Value(l_cursor_id, 5, l_templ_attr_rec.ATTRIBUTE_NUMBER_VALUE);
13932: DBMS_SQL.Column_Value(l_cursor_id, 6, l_templ_attr_rec.ATTRIBUTE_UOM_CODE);
13933: DBMS_SQL.Column_Value(l_cursor_id, 7, l_templ_attr_rec.ATTRIBUTE_DATE_VALUE);
13934: DBMS_SQL.Column_Value(l_cursor_id, 8, l_templ_attr_rec.ATTRIBUTE_TRANSLATED_VALUE);

Line 13931: DBMS_SQL.Column_Value(l_cursor_id, 5, l_templ_attr_rec.ATTRIBUTE_NUMBER_VALUE);

13927: DBMS_SQL.Column_Value(l_cursor_id, 1, l_templ_attr_rec.ATTRIBUTE_GROUP_ID);
13928: DBMS_SQL.Column_Value(l_cursor_id, 2, l_templ_attr_rec.ATTRIBUTE_ID);
13929: DBMS_SQL.Column_Value(l_cursor_id, 3, l_templ_attr_rec.ROW_NUMBER);
13930: DBMS_SQL.Column_Value(l_cursor_id, 4, l_templ_attr_rec.ATTRIBUTE_STRING_VALUE);
13931: DBMS_SQL.Column_Value(l_cursor_id, 5, l_templ_attr_rec.ATTRIBUTE_NUMBER_VALUE);
13932: DBMS_SQL.Column_Value(l_cursor_id, 6, l_templ_attr_rec.ATTRIBUTE_UOM_CODE);
13933: DBMS_SQL.Column_Value(l_cursor_id, 7, l_templ_attr_rec.ATTRIBUTE_DATE_VALUE);
13934: DBMS_SQL.Column_Value(l_cursor_id, 8, l_templ_attr_rec.ATTRIBUTE_TRANSLATED_VALUE);
13935:

Line 13932: DBMS_SQL.Column_Value(l_cursor_id, 6, l_templ_attr_rec.ATTRIBUTE_UOM_CODE);

13928: DBMS_SQL.Column_Value(l_cursor_id, 2, l_templ_attr_rec.ATTRIBUTE_ID);
13929: DBMS_SQL.Column_Value(l_cursor_id, 3, l_templ_attr_rec.ROW_NUMBER);
13930: DBMS_SQL.Column_Value(l_cursor_id, 4, l_templ_attr_rec.ATTRIBUTE_STRING_VALUE);
13931: DBMS_SQL.Column_Value(l_cursor_id, 5, l_templ_attr_rec.ATTRIBUTE_NUMBER_VALUE);
13932: DBMS_SQL.Column_Value(l_cursor_id, 6, l_templ_attr_rec.ATTRIBUTE_UOM_CODE);
13933: DBMS_SQL.Column_Value(l_cursor_id, 7, l_templ_attr_rec.ATTRIBUTE_DATE_VALUE);
13934: DBMS_SQL.Column_Value(l_cursor_id, 8, l_templ_attr_rec.ATTRIBUTE_TRANSLATED_VALUE);
13935:
13936: Debug_Msg(l_api_name ||' processing AG '||l_templ_attr_rec.ATTRIBUTE_GROUP_ID,1);

Line 13933: DBMS_SQL.Column_Value(l_cursor_id, 7, l_templ_attr_rec.ATTRIBUTE_DATE_VALUE);

13929: DBMS_SQL.Column_Value(l_cursor_id, 3, l_templ_attr_rec.ROW_NUMBER);
13930: DBMS_SQL.Column_Value(l_cursor_id, 4, l_templ_attr_rec.ATTRIBUTE_STRING_VALUE);
13931: DBMS_SQL.Column_Value(l_cursor_id, 5, l_templ_attr_rec.ATTRIBUTE_NUMBER_VALUE);
13932: DBMS_SQL.Column_Value(l_cursor_id, 6, l_templ_attr_rec.ATTRIBUTE_UOM_CODE);
13933: DBMS_SQL.Column_Value(l_cursor_id, 7, l_templ_attr_rec.ATTRIBUTE_DATE_VALUE);
13934: DBMS_SQL.Column_Value(l_cursor_id, 8, l_templ_attr_rec.ATTRIBUTE_TRANSLATED_VALUE);
13935:
13936: Debug_Msg(l_api_name ||' processing AG '||l_templ_attr_rec.ATTRIBUTE_GROUP_ID,1);
13937: -----------------------------------------------------------------------

Line 13934: DBMS_SQL.Column_Value(l_cursor_id, 8, l_templ_attr_rec.ATTRIBUTE_TRANSLATED_VALUE);

13930: DBMS_SQL.Column_Value(l_cursor_id, 4, l_templ_attr_rec.ATTRIBUTE_STRING_VALUE);
13931: DBMS_SQL.Column_Value(l_cursor_id, 5, l_templ_attr_rec.ATTRIBUTE_NUMBER_VALUE);
13932: DBMS_SQL.Column_Value(l_cursor_id, 6, l_templ_attr_rec.ATTRIBUTE_UOM_CODE);
13933: DBMS_SQL.Column_Value(l_cursor_id, 7, l_templ_attr_rec.ATTRIBUTE_DATE_VALUE);
13934: DBMS_SQL.Column_Value(l_cursor_id, 8, l_templ_attr_rec.ATTRIBUTE_TRANSLATED_VALUE);
13935:
13936: Debug_Msg(l_api_name ||' processing AG '||l_templ_attr_rec.ATTRIBUTE_GROUP_ID,1);
13937: -----------------------------------------------------------------------
13938: -- Find out whether we're at the beginning of an Attr Group or a row --

Line 14131: DBMS_SQL.Close_Cursor(l_cursor_id);

14127:
14128: END LOOP;
14129:
14130: --bug 9170700
14131: DBMS_SQL.Close_Cursor(l_cursor_id);
14132:
14133: ------------------------------------------------------------------------
14134: -- Now we process the last row (i.e., the row whose values we've been --
14135: -- collecting in the last few loops but that we've not yet processed) --

Line 14342: l_pk_array dbms_sql.Varchar2_Table;

14338: l_current_user_id NUMBER := FND_GLOBAL.User_Id;
14339: l_current_login_id NUMBER := FND_GLOBAL.Login_Id;
14340: l_dummy INTEGER;
14341: l_pk_cursor INTEGER;
14342: l_pk_array dbms_sql.Varchar2_Table;
14343: l_dt_array dbms_sql.Varchar2_Table;
14344: l_pk_array_index NUMBER := 0;
14345: l_dt_array_index NUMBER := 0;
14346:

Line 14343: l_dt_array dbms_sql.Varchar2_Table;

14339: l_current_login_id NUMBER := FND_GLOBAL.Login_Id;
14340: l_dummy INTEGER;
14341: l_pk_cursor INTEGER;
14342: l_pk_array dbms_sql.Varchar2_Table;
14343: l_dt_array dbms_sql.Varchar2_Table;
14344: l_pk_array_index NUMBER := 0;
14345: l_dt_array_index NUMBER := 0;
14346:
14347: l_has_data_level_id BOOLEAN := FALSE; -- TRUE is for R12C

Line 14918: l_pk_cursor := dbms_sql.open_cursor;

14914: l_dynamic_sql := SUBSTR(l_dynamic_sql, 1, LENGTH(l_dynamic_sql) - LENGTH(' AND'));
14915: END IF;
14916:
14917: --13871278 using binding in l_dynamic_sql
14918: l_pk_cursor := dbms_sql.open_cursor;
14919: DBMS_SQL.PARSE(l_pk_cursor, l_dynamic_sql, DBMS_SQL.native);
14920: DBMS_SQL.DEFINE_COLUMN(l_pk_cursor, 1, l_copy_from_ext_id);
14921: DBMS_SQL.DEFINE_COLUMN(l_pk_cursor, 2, l_copy_to_ext_id);
14922: FOR l_pk_index IN 1 .. l_pk_array.count

Line 14919: DBMS_SQL.PARSE(l_pk_cursor, l_dynamic_sql, DBMS_SQL.native);

14915: END IF;
14916:
14917: --13871278 using binding in l_dynamic_sql
14918: l_pk_cursor := dbms_sql.open_cursor;
14919: DBMS_SQL.PARSE(l_pk_cursor, l_dynamic_sql, DBMS_SQL.native);
14920: DBMS_SQL.DEFINE_COLUMN(l_pk_cursor, 1, l_copy_from_ext_id);
14921: DBMS_SQL.DEFINE_COLUMN(l_pk_cursor, 2, l_copy_to_ext_id);
14922: FOR l_pk_index IN 1 .. l_pk_array.count
14923: LOOP

Line 14920: DBMS_SQL.DEFINE_COLUMN(l_pk_cursor, 1, l_copy_from_ext_id);

14916:
14917: --13871278 using binding in l_dynamic_sql
14918: l_pk_cursor := dbms_sql.open_cursor;
14919: DBMS_SQL.PARSE(l_pk_cursor, l_dynamic_sql, DBMS_SQL.native);
14920: DBMS_SQL.DEFINE_COLUMN(l_pk_cursor, 1, l_copy_from_ext_id);
14921: DBMS_SQL.DEFINE_COLUMN(l_pk_cursor, 2, l_copy_to_ext_id);
14922: FOR l_pk_index IN 1 .. l_pk_array.count
14923: LOOP
14924: DBMS_SQL.BIND_VARIABLE(l_pk_cursor, ':PK'||(l_pk_index), l_pk_array(l_pk_index));

Line 14921: DBMS_SQL.DEFINE_COLUMN(l_pk_cursor, 2, l_copy_to_ext_id);

14917: --13871278 using binding in l_dynamic_sql
14918: l_pk_cursor := dbms_sql.open_cursor;
14919: DBMS_SQL.PARSE(l_pk_cursor, l_dynamic_sql, DBMS_SQL.native);
14920: DBMS_SQL.DEFINE_COLUMN(l_pk_cursor, 1, l_copy_from_ext_id);
14921: DBMS_SQL.DEFINE_COLUMN(l_pk_cursor, 2, l_copy_to_ext_id);
14922: FOR l_pk_index IN 1 .. l_pk_array.count
14923: LOOP
14924: DBMS_SQL.BIND_VARIABLE(l_pk_cursor, ':PK'||(l_pk_index), l_pk_array(l_pk_index));
14925: END LOOP;

Line 14924: DBMS_SQL.BIND_VARIABLE(l_pk_cursor, ':PK'||(l_pk_index), l_pk_array(l_pk_index));

14920: DBMS_SQL.DEFINE_COLUMN(l_pk_cursor, 1, l_copy_from_ext_id);
14921: DBMS_SQL.DEFINE_COLUMN(l_pk_cursor, 2, l_copy_to_ext_id);
14922: FOR l_pk_index IN 1 .. l_pk_array.count
14923: LOOP
14924: DBMS_SQL.BIND_VARIABLE(l_pk_cursor, ':PK'||(l_pk_index), l_pk_array(l_pk_index));
14925: END LOOP;
14926: FOR l_dtlevel_index IN 1 .. l_dt_array.count
14927: LOOP
14928: DBMS_SQL.BIND_VARIABLE(l_pk_cursor, ':DT'||(l_dtlevel_index), l_dt_array(l_dtlevel_index));

Line 14928: DBMS_SQL.BIND_VARIABLE(l_pk_cursor, ':DT'||(l_dtlevel_index), l_dt_array(l_dtlevel_index));

14924: DBMS_SQL.BIND_VARIABLE(l_pk_cursor, ':PK'||(l_pk_index), l_pk_array(l_pk_index));
14925: END LOOP;
14926: FOR l_dtlevel_index IN 1 .. l_dt_array.count
14927: LOOP
14928: DBMS_SQL.BIND_VARIABLE(l_pk_cursor, ':DT'||(l_dtlevel_index), l_dt_array(l_dtlevel_index));
14929: END LOOP;
14930: l_dummy := DBMS_SQL.EXECUTE(l_pk_cursor);
14931: --bug 8655864 end
14932: --OPEN l_dynamic_cursor FOR l_dynamic_sql;

Line 14930: l_dummy := DBMS_SQL.EXECUTE(l_pk_cursor);

14926: FOR l_dtlevel_index IN 1 .. l_dt_array.count
14927: LOOP
14928: DBMS_SQL.BIND_VARIABLE(l_pk_cursor, ':DT'||(l_dtlevel_index), l_dt_array(l_dtlevel_index));
14929: END LOOP;
14930: l_dummy := DBMS_SQL.EXECUTE(l_pk_cursor);
14931: --bug 8655864 end
14932: --OPEN l_dynamic_cursor FOR l_dynamic_sql;
14933: LOOP
14934: --FETCH l_dynamic_cursor INTO l_copy_from_ext_id, l_copy_to_ext_id;

Line 14935: IF DBMS_SQL.FETCH_ROWS(l_pk_cursor)>0 THEN

14931: --bug 8655864 end
14932: --OPEN l_dynamic_cursor FOR l_dynamic_sql;
14933: LOOP
14934: --FETCH l_dynamic_cursor INTO l_copy_from_ext_id, l_copy_to_ext_id;
14935: IF DBMS_SQL.FETCH_ROWS(l_pk_cursor)>0 THEN
14936: DBMS_SQL.COLUMN_VALUE(l_pk_cursor, 1, l_copy_from_ext_id);
14937: DBMS_SQL.COLUMN_VALUE(l_pk_cursor, 2, l_copy_to_ext_id);
14938:
14939: --EXIT WHEN l_dynamic_cursor%NOTFOUND;

Line 14936: DBMS_SQL.COLUMN_VALUE(l_pk_cursor, 1, l_copy_from_ext_id);

14932: --OPEN l_dynamic_cursor FOR l_dynamic_sql;
14933: LOOP
14934: --FETCH l_dynamic_cursor INTO l_copy_from_ext_id, l_copy_to_ext_id;
14935: IF DBMS_SQL.FETCH_ROWS(l_pk_cursor)>0 THEN
14936: DBMS_SQL.COLUMN_VALUE(l_pk_cursor, 1, l_copy_from_ext_id);
14937: DBMS_SQL.COLUMN_VALUE(l_pk_cursor, 2, l_copy_to_ext_id);
14938:
14939: --EXIT WHEN l_dynamic_cursor%NOTFOUND;
14940:

Line 14937: DBMS_SQL.COLUMN_VALUE(l_pk_cursor, 2, l_copy_to_ext_id);

14933: LOOP
14934: --FETCH l_dynamic_cursor INTO l_copy_from_ext_id, l_copy_to_ext_id;
14935: IF DBMS_SQL.FETCH_ROWS(l_pk_cursor)>0 THEN
14936: DBMS_SQL.COLUMN_VALUE(l_pk_cursor, 1, l_copy_from_ext_id);
14937: DBMS_SQL.COLUMN_VALUE(l_pk_cursor, 2, l_copy_to_ext_id);
14938:
14939: --EXIT WHEN l_dynamic_cursor%NOTFOUND;
14940:
14941: EXECUTE IMMEDIATE l_base_table_copy_dml USING l_copy_to_ext_id, l_copy_from_ext_id;

Line 14952: DBMS_SQL.CLOSE_CURSOR(l_pk_cursor);

14948: Debug_Msg(l_api_name || ' NO RECORDS in l_pk_cursor');
14949: EXIT;
14950: END IF;
14951: END LOOP;
14952: DBMS_SQL.CLOSE_CURSOR(l_pk_cursor);
14953: --CLOSE l_dynamic_cursor;
14954: END LOOP;
14955: END IF; -- l_attr_group_types
14956:

Line 14979: IF DBMS_SQL.IS_OPEN(l_pk_cursor) then

14975: ,p_addto_fnd_stack => G_ADD_ERRORS_TO_FND_STACK
14976: );
14977:
14978: WHEN OTHERS THEN
14979: IF DBMS_SQL.IS_OPEN(l_pk_cursor) then
14980: DBMS_SQL.CLOSE_CURSOR(l_pk_cursor);
14981: END IF;
14982: Debug_Msg(l_api_name || ' EXCEPTION OTHERS '||SQLERRM);
14983: IF FND_API.To_Boolean(p_commit) THEN

Line 14980: DBMS_SQL.CLOSE_CURSOR(l_pk_cursor);

14976: );
14977:
14978: WHEN OTHERS THEN
14979: IF DBMS_SQL.IS_OPEN(l_pk_cursor) then
14980: DBMS_SQL.CLOSE_CURSOR(l_pk_cursor);
14981: END IF;
14982: Debug_Msg(l_api_name || ' EXCEPTION OTHERS '||SQLERRM);
14983: IF FND_API.To_Boolean(p_commit) THEN
14984: ROLLBACK TO Copy_User_Attrs_Data_PUB;

Line 15055: l_desc_table DBMS_SQL.Desc_Tab;

15051: l_history_tl_prod_cols_list VARCHAR2(10000);
15052: l_dynamic_sql VARCHAR2(32767); --the largest a VARCHAR2 can be
15053: l_cursor_id NUMBER;
15054: l_column_count NUMBER;
15055: l_desc_table DBMS_SQL.Desc_Tab;
15056: l_retrieved_value VARCHAR2(1000);
15057: l_dummy NUMBER;
15058: l_current_column_index NUMBER;
15059: l_current_row_language VARCHAR2(30);

Line 15391: l_cursor_id := DBMS_SQL.Open_Cursor;

15387: ' AND B.ACD_TYPE = TL.ACD_TYPE'||
15388: ' AND B.CHANGE_LINE_ID = TL.CHANGE_LINE_ID'||
15389: ' AND B.CHANGE_LINE_ID = :1';
15390:
15391: l_cursor_id := DBMS_SQL.Open_Cursor;
15392: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.Native);
15393: DBMS_SQL.Bind_Variable(l_cursor_id, ':1', p_change_line_id);
15394: DBMS_SQL.Describe_Columns(l_cursor_id, l_column_count, l_desc_table);
15395:

Line 15392: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.Native);

15388: ' AND B.CHANGE_LINE_ID = TL.CHANGE_LINE_ID'||
15389: ' AND B.CHANGE_LINE_ID = :1';
15390:
15391: l_cursor_id := DBMS_SQL.Open_Cursor;
15392: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.Native);
15393: DBMS_SQL.Bind_Variable(l_cursor_id, ':1', p_change_line_id);
15394: DBMS_SQL.Describe_Columns(l_cursor_id, l_column_count, l_desc_table);
15395:
15396: FOR i IN 1 .. l_column_count

Line 15393: DBMS_SQL.Bind_Variable(l_cursor_id, ':1', p_change_line_id);

15389: ' AND B.CHANGE_LINE_ID = :1';
15390:
15391: l_cursor_id := DBMS_SQL.Open_Cursor;
15392: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.Native);
15393: DBMS_SQL.Bind_Variable(l_cursor_id, ':1', p_change_line_id);
15394: DBMS_SQL.Describe_Columns(l_cursor_id, l_column_count, l_desc_table);
15395:
15396: FOR i IN 1 .. l_column_count
15397: LOOP

Line 15394: DBMS_SQL.Describe_Columns(l_cursor_id, l_column_count, l_desc_table);

15390:
15391: l_cursor_id := DBMS_SQL.Open_Cursor;
15392: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.Native);
15393: DBMS_SQL.Bind_Variable(l_cursor_id, ':1', p_change_line_id);
15394: DBMS_SQL.Describe_Columns(l_cursor_id, l_column_count, l_desc_table);
15395:
15396: FOR i IN 1 .. l_column_count
15397: LOOP
15398: -------------------------------------------------------------

Line 15402: DBMS_SQL.Define_Column(l_cursor_id, i, l_retrieved_value, 1000);

15398: -------------------------------------------------------------
15399: -- We define all columns as VARCHAR2(1000) for convenience --
15400: -- ASSUMPTION: no PKs will ever be DATE objects --
15401: -------------------------------------------------------------
15402: DBMS_SQL.Define_Column(l_cursor_id, i, l_retrieved_value, 1000);
15403: END LOOP;
15404:
15405: ----------------------------------
15406: -- Execute our dynamic query... --

Line 15408: l_dummy := DBMS_SQL.Execute(l_cursor_id);

15404:
15405: ----------------------------------
15406: -- Execute our dynamic query... --
15407: ----------------------------------
15408: l_dummy := DBMS_SQL.Execute(l_cursor_id);
15409:
15410: ----------------------------------------------------
15411: -- ...then loop through the result set, gathering --
15412: -- the column values and then calling Process_Row --

Line 15414: WHILE (DBMS_SQL.Fetch_Rows(l_cursor_id) > 0)

15410: ----------------------------------------------------
15411: -- ...then loop through the result set, gathering --
15412: -- the column values and then calling Process_Row --
15413: ----------------------------------------------------
15414: WHILE (DBMS_SQL.Fetch_Rows(l_cursor_id) > 0)
15415: LOOP
15416:
15417: l_current_column_index := 1;
15418: l_attr_name_value_pairs.DELETE();

Line 15424: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);

15420: ------------------------------------
15421: -- Get the PK values for this row --
15422: ------------------------------------
15423: IF (l_pk_column_name_value_pairs.COUNT > 0) THEN
15424: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);
15425: l_current_column_index := l_current_column_index + 1;
15426: l_pk_column_name_value_pairs(1).VALUE := SUBSTRB(l_retrieved_value, 1, 150);
15427: END IF;
15428: IF (l_pk_column_name_value_pairs.COUNT > 1) THEN

Line 15429: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);

15425: l_current_column_index := l_current_column_index + 1;
15426: l_pk_column_name_value_pairs(1).VALUE := SUBSTRB(l_retrieved_value, 1, 150);
15427: END IF;
15428: IF (l_pk_column_name_value_pairs.COUNT > 1) THEN
15429: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);
15430: l_current_column_index := l_current_column_index + 1;
15431: l_pk_column_name_value_pairs(2).VALUE := SUBSTRB(l_retrieved_value, 1, 150);
15432: END IF;
15433: IF (l_pk_column_name_value_pairs.COUNT > 2) THEN

Line 15434: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);

15430: l_current_column_index := l_current_column_index + 1;
15431: l_pk_column_name_value_pairs(2).VALUE := SUBSTRB(l_retrieved_value, 1, 150);
15432: END IF;
15433: IF (l_pk_column_name_value_pairs.COUNT > 2) THEN
15434: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);
15435: l_current_column_index := l_current_column_index + 1;
15436: l_pk_column_name_value_pairs(3).VALUE := SUBSTRB(l_retrieved_value, 1, 150);
15437: END IF;
15438: IF (l_pk_column_name_value_pairs.COUNT > 3) THEN

Line 15439: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);

15435: l_current_column_index := l_current_column_index + 1;
15436: l_pk_column_name_value_pairs(3).VALUE := SUBSTRB(l_retrieved_value, 1, 150);
15437: END IF;
15438: IF (l_pk_column_name_value_pairs.COUNT > 3) THEN
15439: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);
15440: l_current_column_index := l_current_column_index + 1;
15441: l_pk_column_name_value_pairs(4).VALUE := SUBSTRB(l_retrieved_value, 1, 150);
15442: END IF;
15443: IF (l_pk_column_name_value_pairs.COUNT > 4) THEN

Line 15444: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);

15440: l_current_column_index := l_current_column_index + 1;
15441: l_pk_column_name_value_pairs(4).VALUE := SUBSTRB(l_retrieved_value, 1, 150);
15442: END IF;
15443: IF (l_pk_column_name_value_pairs.COUNT > 4) THEN
15444: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);
15445: l_current_column_index := l_current_column_index + 1;
15446: l_pk_column_name_value_pairs(5).VALUE := SUBSTRB(l_retrieved_value, 1, 150);
15447: END IF;
15448:

Line 15455: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);

15451: -- and try to get related Class Codes as well --
15452: ------------------------------------------------
15453: IF (l_class_code_name_value_pairs IS NOT NULL AND
15454: l_class_code_name_value_pairs.COUNT > 0) THEN
15455: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);
15456: l_current_column_index := l_current_column_index + 1;
15457: l_class_code_name_value_pairs(1).VALUE := SUBSTRB(l_retrieved_value, 1, 150);
15458:
15459: EXECUTE IMMEDIATE 'BEGIN '||p_related_class_code_function||'(:1, :2); END;'

Line 15467: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);

15463:
15464: ----------------------------
15465: -- Determine the ACD Type --
15466: ----------------------------
15467: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);
15468: l_current_column_index := l_current_column_index + 1;
15469: l_current_acd_type := l_retrieved_value;
15470:
15471: ---------------------------------------------------------

Line 15474: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);

15470:
15471: ---------------------------------------------------------
15472: -- Find the Attr Group metadata from the Attr Group ID --
15473: ---------------------------------------------------------
15474: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);
15475: l_current_column_index := l_current_column_index + 1;
15476: l_attr_group_metadata_obj :=
15477: EGO_USER_ATTRS_COMMON_PVT.Get_Attr_Group_Metadata(
15478: p_attr_group_id => TO_NUMBER(l_retrieved_value)

Line 15517: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);

15513:
15514: --------------------------
15515: -- Get the extension ID --
15516: --------------------------
15517: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);
15518: l_current_column_index := l_current_column_index + 1;
15519: l_current_pending_ext_id := TO_NUMBER(l_retrieved_value);
15520:
15521: -------------------------------------------------------------------

Line 15532: DBMS_SQL.Column_Value(l_cursor_id, i, l_retrieved_value);

15528: -----------------------------------------------
15529: -- Get the current column name and its value --
15530: -----------------------------------------------
15531: l_current_column_name := l_desc_table(i).COL_NAME;
15532: DBMS_SQL.Column_Value(l_cursor_id, i, l_retrieved_value);
15533:
15534: ------------------------------------------------------------------------
15535: -- See whether the current column belongs to a User-Defined Attribute --
15536: ------------------------------------------------------------------------

Line 15913: DBMS_SQL.Close_Cursor(l_cursor_id);

15909: RAISE FND_API.G_EXC_ERROR;
15910: END IF;
15911: END IF;
15912: END LOOP;
15913: DBMS_SQL.Close_Cursor(l_cursor_id);
15914:
15915: ---------------------------------------------------------------------------
15916: -- Finally, set the IMPLEMENTATION_DATE for all rows we just implemented --
15917: ---------------------------------------------------------------------------

Line 16088: l_cursor := DBMS_SQL.OPEN_CURSOR;

16084: x_date_val := NULL;
16085:
16086: l_db_column_alias := EGO_USER_ATTRS_COMMON_PVT.Create_DB_Col_Alias_If_Needed(p_attr_metadata_obj);
16087:
16088: l_cursor := DBMS_SQL.OPEN_CURSOR;
16089: l_bind_index := 0;
16090:
16091: --------------------------
16092: -- SELECT, FROM clauses --

Line 16233: DBMS_SQL.PARSE(l_cursor, l_dynamic_sql, DBMS_SQL.NATIVE);

16229: --======================================================================--
16230: -- 2. Parse the query and bind the input variables --
16231: --======================================================================--
16232:
16233: DBMS_SQL.PARSE(l_cursor, l_dynamic_sql, DBMS_SQL.NATIVE);
16234:
16235: Debug_Msg('Get_Ext_Data(): Bind value table has ' || l_bind_value_table.COUNT || ' elements');
16236:
16237: -- Bind the attribute group ID value, and the primary key values for the object

Line 16245: DBMS_SQL.BIND_VARIABLE(

16241: l_bind_var_value := l_bind_value_table(i);
16242: l_bind_var_value_num := to_number(l_bind_var_value);
16243: Debug_Msg(l_api_name || ' Binding '|| l_bind_var_name || ' to value ' || l_bind_var_value_num);
16244:
16245: DBMS_SQL.BIND_VARIABLE(
16246: c => l_cursor, -- SQL query
16247: name => l_bind_var_name, -- bind variable name
16248: value => l_bind_var_value -- bind value (VARCHAR2(80))
16249: );

Line 16256: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, x_num_val);

16252: ------------------------
16253: -- Define the outputs --
16254: ------------------------
16255: IF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
16256: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, x_num_val);
16257: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = 'X' OR p_attr_metadata_obj.DATA_TYPE_CODE = 'Y') THEN
16258: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_str,150);
16259: ELSE
16260: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, x_str_val, 150);

Line 16258: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_str,150);

16254: ------------------------
16255: IF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
16256: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, x_num_val);
16257: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = 'X' OR p_attr_metadata_obj.DATA_TYPE_CODE = 'Y') THEN
16258: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_str,150);
16259: ELSE
16260: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, x_str_val, 150);
16261: END IF;
16262:

Line 16260: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, x_str_val, 150);

16256: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, x_num_val);
16257: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = 'X' OR p_attr_metadata_obj.DATA_TYPE_CODE = 'Y') THEN
16258: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_str,150);
16259: ELSE
16260: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, x_str_val, 150);
16261: END IF;
16262:
16263: --======================================================================--
16264: -- 3. Execute the query and fetch the attribute internal value --

Line 16267: l_row_count := DBMS_SQL.EXECUTE_AND_FETCH(l_cursor, FALSE);

16263: --======================================================================--
16264: -- 3. Execute the query and fetch the attribute internal value --
16265: --======================================================================--
16266:
16267: l_row_count := DBMS_SQL.EXECUTE_AND_FETCH(l_cursor, FALSE);
16268: IF (l_row_count > 0) THEN
16269:
16270: IF (p_attr_metadata_obj.DATA_TYPE_CODE = 'N') THEN
16271: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, x_num_val);

Line 16271: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, x_num_val);

16267: l_row_count := DBMS_SQL.EXECUTE_AND_FETCH(l_cursor, FALSE);
16268: IF (l_row_count > 0) THEN
16269:
16270: IF (p_attr_metadata_obj.DATA_TYPE_CODE = 'N') THEN
16271: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, x_num_val);
16272: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = 'X' OR p_attr_metadata_obj.DATA_TYPE_CODE = 'Y') THEN
16273: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_str);
16274: x_date_val := TO_DATE(l_str,EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
16275: ELSE

Line 16273: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_str);

16269:
16270: IF (p_attr_metadata_obj.DATA_TYPE_CODE = 'N') THEN
16271: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, x_num_val);
16272: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = 'X' OR p_attr_metadata_obj.DATA_TYPE_CODE = 'Y') THEN
16273: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_str);
16274: x_date_val := TO_DATE(l_str,EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
16275: ELSE
16276: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, x_str_val);
16277: END IF;

Line 16276: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, x_str_val);

16272: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = 'X' OR p_attr_metadata_obj.DATA_TYPE_CODE = 'Y') THEN
16273: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_str);
16274: x_date_val := TO_DATE(l_str,EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
16275: ELSE
16276: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, x_str_val);
16277: END IF;
16278: END IF;
16279:
16280: DBMS_SQL.CLOSE_CURSOR(l_cursor);

Line 16280: DBMS_SQL.CLOSE_CURSOR(l_cursor);

16276: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, x_str_val);
16277: END IF;
16278: END IF;
16279:
16280: DBMS_SQL.CLOSE_CURSOR(l_cursor);
16281:
16282: Debug_Msg(l_api_name || ' Done.' );
16283:
16284: END Get_Ext_Data;