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

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

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

995: -- (in the VARCHAR2 case, that includes stating the maximum size that a --
996: -- value in the column might be; to be safe we will use 1000 bytes). --
997: -- First we register the EXTENSION_ID and ATTR_GROUP_ID... --
998: --------------------------------------------------------------------------
999: DBMS_SQL.Define_Column(l_cursor_id, 1, l_extension_id);
1000:
1001: -----------------------------------
1002: -- ...then the Database Columns. --
1003: -----------------------------------

Line 1010: DBMS_SQL.Define_Column(l_cursor_id, i+1, l_retrieved_value, 1000);

1006:
1007: --------------------------------------------------------------------
1008: -- We cast everything to string for assignment to ATTR_DISP_VALUE --
1009: --------------------------------------------------------------------
1010: DBMS_SQL.Define_Column(l_cursor_id, i+1, l_retrieved_value, 1000);
1011:
1012: END LOOP;
1013:
1014: -------------------------------

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

1013:
1014: -------------------------------
1015: -- Execute our dynamic query --
1016: -------------------------------
1017: l_dummy := DBMS_SQL.Execute(l_cursor_id);
1018:
1019: Debug_Msg(l_api_name||' executed the query', 3);
1020:
1021: -----------------------------------------------------------------------

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

1023: -- appropriate fields of the attr diff object based on data type --
1024: -----------------------------------------------------------------------
1025:
1026: l_attr_diffs_last := px_attr_diffs.LAST;
1027: WHILE (DBMS_SQL.FETCH_ROWS(l_cursor_id) > 0)
1028: LOOP
1029:
1030: FOR i IN l_db_column_name_table.FIRST .. l_db_column_name_table.LAST
1031: LOOP

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

1038: LOOP
1039:
1040: IF (l_db_column_name_table(i) = l_augmented_data_table(j).DATABASE_COLUMN) THEN
1041:
1042: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 1, l_extension_id);
1043:
1044: ------------------------------------------------
1045: -- We use i+1 because of the offset caused by --
1046: -- requesting EXTENSION_ID --

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

1044: ------------------------------------------------
1045: -- We use i+1 because of the offset caused by --
1046: -- requesting EXTENSION_ID --
1047: ------------------------------------------------
1048: DBMS_SQL.COLUMN_VALUE(l_cursor_id, i+1, l_retrieved_value);
1049:
1050: Debug_Msg(l_api_name||' db col: '||l_db_column_name_table(i)||' val: '||l_retrieved_value, 1);
1051:
1052: IF (px_attr_diffs(j).OLD_ATTR_VALUE_NUM IS NULL AND

Line 1119: DBMS_SQL.Close_Cursor(l_cursor_id);

1115: -----------------------------------------
1116: -- Close the cursor when we're through --
1117: -----------------------------------------
1118: IF (l_cursor_id IS NOT NULL) THEN
1119: DBMS_SQL.Close_Cursor(l_cursor_id);
1120: l_cursor_id := NULL;
1121: END IF;
1122: -- Start ssingal -For Ucc Net Attribute Propagation
1123: ELSIF (p_dml_operation = 'DELETE' ) THEN

Line 2660: l_cursor_id := DBMS_SQL.Open_Cursor;

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

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

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

Line 2665: DBMS_SQL.Define_Column(l_cursor_id, 1, l_retrieved_value, 1000);

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

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

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:
2669: IF (l_number_of_rows > 0) THEN
2670:
2671: DBMS_SQL.Column_Value(l_cursor_id, 1, l_retrieved_value);

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

2667: l_number_of_rows := DBMS_SQL.Execute_And_Fetch(l_cursor_id);
2668:
2669: IF (l_number_of_rows > 0) THEN
2670:
2671: DBMS_SQL.Column_Value(l_cursor_id, 1, l_retrieved_value);
2672:
2673: END IF;
2674:
2675: DBMS_SQL.Close_Cursor(l_cursor_id);

Line 2675: DBMS_SQL.Close_Cursor(l_cursor_id);

2671: DBMS_SQL.Column_Value(l_cursor_id, 1, l_retrieved_value);
2672:
2673: END IF;
2674:
2675: DBMS_SQL.Close_Cursor(l_cursor_id);
2676:
2677: Debug_Msg('In Tokenized_Val_Set_Query, l_retrieved_value is as follows: '||
2678: l_retrieved_value);
2679: Debug_Msg('In Tokenized_Val_Set_Query, done', 2);

Line 3062: l_cursor_id := DBMS_SQL.Open_Cursor;

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;
3063:
3064: --------------------------------------------------
3065: -- Next we parse the query, bind our variables, --
3066: -- and tell DBMS_SQL what we want it to return --

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

3062: l_cursor_id := DBMS_SQL.Open_Cursor;
3063:
3064: --------------------------------------------------
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();

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

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

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

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

Line 3076: l_number_of_rows := DBMS_SQL.Execute_And_Fetch(l_cursor_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 --
3075: ---------------------------------------------------------------------
3076: l_number_of_rows := DBMS_SQL.Execute_And_Fetch(l_cursor_id);
3077: IF (l_number_of_rows = 1) THEN
3078: DBMS_SQL.Column_Value(l_cursor_id, 1, l_extension_id);
3079: ELSIF (l_number_of_rows > 1) THEN
3080: l_extension_id := -1;

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

3074: -- rows, we return NULL, and if we get too many rows, we return -1 --
3075: ---------------------------------------------------------------------
3076: l_number_of_rows := DBMS_SQL.Execute_And_Fetch(l_cursor_id);
3077: IF (l_number_of_rows = 1) THEN
3078: DBMS_SQL.Column_Value(l_cursor_id, 1, l_extension_id);
3079: ELSIF (l_number_of_rows > 1) THEN
3080: l_extension_id := -1;
3081: END IF;
3082:

Line 3086: DBMS_SQL.Close_Cursor(l_cursor_id);

3082:
3083: ---------------------------------------------------------
3084: -- Finally, we close the cursor and return our results --
3085: ---------------------------------------------------------
3086: DBMS_SQL.Close_Cursor(l_cursor_id);
3087: Debug_Msg('In Get_Extension_Id_For_Row, done; l_extension_id is '||l_extension_id, 2);
3088:
3089: RETURN l_extension_id;
3090: EXCEPTION

Line 4234: l_cursor_id := DBMS_SQL.Open_Cursor;

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

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

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

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

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

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

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:
4242: IF (l_dummy = 0) THEN
4243: RAISE NO_DATA_FOUND;
4244: END IF;

Line 4309: l_cursor_id := DBMS_SQL.Open_Cursor;

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

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

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

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

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

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

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:
4317: IF (l_dummy = 0) THEN
4318: RAISE NO_DATA_FOUND;
4319: END IF;

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

4317: IF (l_dummy = 0) THEN
4318: RAISE NO_DATA_FOUND;
4319: END IF;
4320:
4321: DBMS_SQL.Column_Value(l_cursor_id, 1, l_data_level);
4322: DBMS_SQL.Close_Cursor(l_cursor_id);
4323:
4324: IF (G_ASSOCIATION_DATA_LEVEL_CACHE.EXISTS(p_attr_group_id)) THEN
4325:

Line 4322: DBMS_SQL.Close_Cursor(l_cursor_id);

4318: RAISE NO_DATA_FOUND;
4319: END IF;
4320:
4321: DBMS_SQL.Column_Value(l_cursor_id, 1, l_data_level);
4322: DBMS_SQL.Close_Cursor(l_cursor_id);
4323:
4324: IF (G_ASSOCIATION_DATA_LEVEL_CACHE.EXISTS(p_attr_group_id)) THEN
4325:
4326: G_ASSOCIATION_DATA_LEVEL_CACHE(p_attr_group_id) := l_obj_and_class||

Line 4459: DBMS_SQL.Close_Cursor(l_cursor_id);

4455: EXCEPTION
4456: WHEN NO_DATA_FOUND THEN
4457: Debug_Msg('In Is_Data_Level_Correct, got NO_DATA_FOUND exception so returning FALSE');
4458: IF (l_cursor_id IS NOT NULL) THEN
4459: DBMS_SQL.Close_Cursor(l_cursor_id);
4460: END IF;
4461: --------------------------------------------------------------------
4462: -- In this case, the Attribute Group isn't even associated to the --
4463: -- passed-in Classification Code, so we try to query up the --

Line 7008: l_cursor_id := DBMS_SQL.Open_Cursor;

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

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

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

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

7280: END IF;
7281: --End 4105841
7282:
7283: IF (p_execute_dml = FND_API.G_TRUE) THEN
7284: l_number_of_rows := DBMS_SQL.Execute(l_cursor_id);
7285: END IF;
7286:
7287: END IF;
7288:

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

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

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

7511: END IF;
7512: --End 4105841
7513:
7514: IF (p_execute_dml = FND_API.G_TRUE) THEN
7515: l_number_of_rows := DBMS_SQL.Execute(l_cursor_id);
7516: END IF;
7517:
7518: END IF;
7519:

Line 7523: DBMS_SQL.Close_Cursor(l_cursor_id);

7519:
7520: ----------------------------------
7521: -- Finally, we close our cursor --
7522: ----------------------------------
7523: DBMS_SQL.Close_Cursor(l_cursor_id);
7524:
7525: IF (l_propagate_hierarchy
7526: AND p_attr_group_metadata_obj.HIERARCHY_PROPAGATE_FLAG = 'Y'
7527: AND px_attr_diffs.COUNT > 0 AND p_execute_dml = FND_API.G_TRUE) THEN --Bug fix 5220020

Line 7841: l_cursor_id := DBMS_SQL.Open_Cursor;

7837: END IF;
7838: --------------------------------------------------------------
7839: -- First we open a cursor for use in one or both statements --
7840: --------------------------------------------------------------
7841: l_cursor_id := DBMS_SQL.Open_Cursor;
7842:
7843: ------------------------------------------------------------------
7844: -- We pass p_language_to_process from Implement_Change_Line; if --
7845: -- we have it, then we only insert if the passed-in language is --

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

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);
7943: FND_DSQL.Set_Cursor(l_cursor_id);
7944: FND_DSQL.Do_Binds();
7945: END IF;
7946:

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

7965: END IF;
7966: --End 4105841
7967:
7968: IF (p_execute_dml = FND_API.G_TRUE) THEN
7969: l_number_of_rows := DBMS_SQL.Execute(l_cursor_id);
7970: END IF;
7971:
7972: END IF;
7973:

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

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);
8104: FND_DSQL.Do_Binds();
8105: END IF;
8106:

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

8126: END IF;
8127: --End 4105841
8128:
8129: IF (p_execute_dml = FND_API.G_TRUE) THEN
8130: l_number_of_rows := DBMS_SQL.Execute(l_cursor_id);
8131: END IF;
8132:
8133:
8134: END IF;

Line 8140: DBMS_SQL.Close_Cursor(l_cursor_id);

8136:
8137: ----------------------------------
8138: -- Finally, we close our cursor --
8139: ----------------------------------
8140: DBMS_SQL.Close_Cursor(l_cursor_id);
8141:
8142: --
8143: -- If caller passes multiple rows with same UK values, what should I do?
8144: -- Currently, I think they'll be treated as multiple instances of the same row,

Line 10936: l_cursor_id := DBMS_SQL.OPEN_CURSOR;

10932:
10933: ----------------------------------
10934: -- Open a cursor for processing --
10935: ----------------------------------
10936: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
10937: -------------------------------------
10938: -- Parse our dynamic SQL statement --
10939: -------------------------------------
10940: DBMS_SQL.PARSE(l_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);

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

10936: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
10937: -------------------------------------
10938: -- Parse our dynamic SQL statement --
10939: -------------------------------------
10940: DBMS_SQL.PARSE(l_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
10941: --------------------------------------------------------------------------
10942: -- Register the data types of the columns we are selecting in our query --
10943: -- (in the VARCHAR2 case, that includes stating the maximum size that a --
10944: -- value in the column might be; to be safe we will use 1000 bytes). --

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

10943: -- (in the VARCHAR2 case, that includes stating the maximum size that a --
10944: -- value in the column might be; to be safe we will use 1000 bytes). --
10945: -- First we register the EXTENSION_ID and ATTR_GROUP_ID... --
10946: --------------------------------------------------------------------------
10947: DBMS_SQL.Define_Column(l_cursor_id, 1, l_extension_id);
10948: DBMS_SQL.Define_Column(l_cursor_id, 2, l_curr_AG_ID);
10949:
10950: -----------------------------------
10951: -- Loop 1.4

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

10944: -- value in the column might be; to be safe we will use 1000 bytes). --
10945: -- First we register the EXTENSION_ID and ATTR_GROUP_ID... --
10946: --------------------------------------------------------------------------
10947: DBMS_SQL.Define_Column(l_cursor_id, 1, l_extension_id);
10948: DBMS_SQL.Define_Column(l_cursor_id, 2, l_curr_AG_ID);
10949:
10950: -----------------------------------
10951: -- Loop 1.4
10952: -- ...then the Database Columns. --

Line 10963: DBMS_SQL.Define_Column(l_cursor_id, (i*2)+1, l_varchar_example, 1000);

10959: --------------------------------------------------------------------
10960: -- We cast everything to string for assignment to ATTR_DISP_VALUE --
10961: --------------------------------------------------------------------
10962: -- Syalaman - Fix for bug 5859465
10963: DBMS_SQL.Define_Column(l_cursor_id, (i*2)+1, l_varchar_example, 1000);
10964:
10965: --ENHR12:changed for passing the internal value of the attribute
10966: --along with the display value.
10967: -- Syalaman - Fix for bug 5859465

Line 10968: DBMS_SQL.Define_Column(l_cursor_id, (i*2)+2, l_varchar_example, 1000);

10964:
10965: --ENHR12:changed for passing the internal value of the attribute
10966: --along with the display value.
10967: -- Syalaman - Fix for bug 5859465
10968: DBMS_SQL.Define_Column(l_cursor_id, (i*2)+2, l_varchar_example, 1000);
10969: END LOOP;
10970:
10971: -------------------------------
10972: -- Execute our dynamic query --

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

10970:
10971: -------------------------------
10972: -- Execute our dynamic query --
10973: -------------------------------
10974: l_dummy := DBMS_SQL.Execute(l_cursor_id);
10975: Debug_Msg(l_api_name||' executed the query', 3);
10976:
10977: --===============================================================================--
10978: -- Loop 1.5 --

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

10990: -- table for an Attribute record belonging to the current AG ID, and --
10991: -- 3). l_high_aug_tab_ind_for_AG_ID, which holds the highest such index. --
10992: --===============================================================================--
10993: <>
10994: WHILE (DBMS_SQL.FETCH_ROWS(l_cursor_id) > 0)
10995: LOOP
10996:
10997: ----------------------------------------------------------------
10998: -- Get the EXTENSION_ID and ATTR_GROUP_ID for the current row --

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

10996:
10997: ----------------------------------------------------------------
10998: -- Get the EXTENSION_ID and ATTR_GROUP_ID for the current row --
10999: ----------------------------------------------------------------
11000: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 1, l_extension_id);
11001: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 2, l_curr_AG_ID);
11002:
11003: -----------------------------------------------------------------
11004: -- Reset the variable that tells us whether we need to build a --

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

10997: ----------------------------------------------------------------
10998: -- Get the EXTENSION_ID and ATTR_GROUP_ID for the current row --
10999: ----------------------------------------------------------------
11000: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 1, l_extension_id);
11001: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 2, l_curr_AG_ID);
11002:
11003: -----------------------------------------------------------------
11004: -- Reset the variable that tells us whether we need to build a --
11005: -- new row object for the out parameter x_attributes_row_table --

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

11067:
11068: --ENHR12:added for passing the internal value of the attribute
11069: --along with the display value.
11070: --setting the Display Value.
11071: DBMS_SQL.COLUMN_VALUE(l_cursor_id, (i*2)+1, l_curr_augmented_attr_rec.ATTR_DISP_VALUE); -- Fix for bug 5859465
11072:
11073: --setting the intrnal value of the Attribute depending on the DATA_TYPE_CODE
11074: --if the attribute is of type Translatable(A) or Char(C)
11075: IF ('C'=l_curr_augmented_attr_rec.DATA_TYPE_CODE OR 'A'=l_curr_augmented_attr_rec.DATA_TYPE_CODE) THEN

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

11072:
11073: --setting the intrnal value of the Attribute depending on the DATA_TYPE_CODE
11074: --if the attribute is of type Translatable(A) or Char(C)
11075: IF ('C'=l_curr_augmented_attr_rec.DATA_TYPE_CODE OR 'A'=l_curr_augmented_attr_rec.DATA_TYPE_CODE) THEN
11076: DBMS_SQL.COLUMN_VALUE(l_cursor_id, (i*2)+2, l_curr_augmented_attr_rec.ATTR_VALUE_STR); -- Fix for bug 5859465
11077: l_curr_augmented_attr_rec.ATTR_VALUE_DATE:=null;
11078: l_curr_augmented_attr_rec.ATTR_VALUE_NUM:=null;
11079: --if the attribute is of type Date(X) or DateTime(Y)
11080: ELSIF('X'=l_curr_augmented_attr_rec.DATA_TYPE_CODE OR 'Y'=l_curr_augmented_attr_rec.DATA_TYPE_CODE) THEN

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

11077: l_curr_augmented_attr_rec.ATTR_VALUE_DATE:=null;
11078: l_curr_augmented_attr_rec.ATTR_VALUE_NUM:=null;
11079: --if the attribute is of type Date(X) or DateTime(Y)
11080: ELSIF('X'=l_curr_augmented_attr_rec.DATA_TYPE_CODE OR 'Y'=l_curr_augmented_attr_rec.DATA_TYPE_CODE) THEN
11081: DBMS_SQL.COLUMN_VALUE(l_cursor_id, (i*2)+2,l_char_value); -- Fix for bug 5859465
11082: l_curr_augmented_attr_rec.ATTR_VALUE_STR:=null;
11083: l_curr_augmented_attr_rec.ATTR_VALUE_NUM:=null;
11084: l_curr_augmented_attr_rec.ATTR_VALUE_DATE:=TO_DATE(l_char_value,'yyyy/mm/dd HH24:MI:SS');
11085: --if the attribute is of type NUMBER(N)

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

11083: l_curr_augmented_attr_rec.ATTR_VALUE_NUM:=null;
11084: l_curr_augmented_attr_rec.ATTR_VALUE_DATE:=TO_DATE(l_char_value,'yyyy/mm/dd HH24:MI:SS');
11085: --if the attribute is of type NUMBER(N)
11086: ELSIF('N'=l_curr_augmented_attr_rec.DATA_TYPE_CODE) THEN
11087: DBMS_SQL.COLUMN_VALUE(l_cursor_id, (i*2)+2, l_char_value); -- Fix for bug 5859465
11088: l_curr_augmented_attr_rec.ATTR_VALUE_STR:=null;
11089: l_curr_augmented_attr_rec.ATTR_VALUE_DATE:=null;
11090: l_curr_augmented_attr_rec.ATTR_VALUE_NUM:=TO_NUMBER(l_char_value);
11091: END IF;

Line 11177: DBMS_SQL.Close_Cursor(l_cursor_id);

11173: -----------------------------------------
11174: -- Close the cursor when we're through --
11175: -----------------------------------------
11176: IF (l_cursor_id IS NOT NULL) THEN
11177: DBMS_SQL.Close_Cursor(l_cursor_id);
11178: l_cursor_id := NULL;
11179: END IF;
11180: ELSE
11181: Debug_Msg(l_api_name||' l_db_column_query_table.COUNT = ' || l_db_column_query_table.COUNT, 1);

Line 11213: DBMS_SQL.Close_Cursor(l_cursor_id);

11209: -----------------------------------------
11210: -- Close the cursor if it's still open --
11211: -----------------------------------------
11212: IF (l_cursor_id IS NOT NULL) THEN
11213: DBMS_SQL.Close_Cursor(l_cursor_id);
11214: l_cursor_id := NULL;
11215: END IF;
11216:
11217: ------------------------------------------------------

Line 11247: DBMS_SQL.Close_Cursor(l_cursor_id);

11243: -----------------------------------------
11244: -- Close the cursor if it's still open --
11245: -----------------------------------------
11246: IF (l_cursor_id IS NOT NULL) THEN
11247: DBMS_SQL.Close_Cursor(l_cursor_id);
11248: l_cursor_id := NULL;
11249: END IF;
11250: ------------------------------------------------------
11251: -- We log all errors we got as we close our session --

Line 12733: l_cursor_id := DBMS_SQL.Open_Cursor;

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

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

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

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

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

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

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

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

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);
12892: DBMS_SQL.Define_Column(l_cursor_id, 5, l_templ_attr_rec.ATTRIBUTE_NUMBER_VALUE);
12893: DBMS_SQL.Define_Column(l_cursor_id, 6, l_templ_attr_rec.ATTRIBUTE_UOM_CODE, 3);
12894: DBMS_SQL.Define_Column(l_cursor_id, 7, l_templ_attr_rec.ATTRIBUTE_DATE_VALUE);
12895: DBMS_SQL.Define_Column(l_cursor_id, 8, l_templ_attr_rec.ATTRIBUTE_TRANSLATED_VALUE, 1000);

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

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);
12892: DBMS_SQL.Define_Column(l_cursor_id, 5, l_templ_attr_rec.ATTRIBUTE_NUMBER_VALUE);
12893: DBMS_SQL.Define_Column(l_cursor_id, 6, l_templ_attr_rec.ATTRIBUTE_UOM_CODE, 3);
12894: DBMS_SQL.Define_Column(l_cursor_id, 7, l_templ_attr_rec.ATTRIBUTE_DATE_VALUE);
12895: DBMS_SQL.Define_Column(l_cursor_id, 8, l_templ_attr_rec.ATTRIBUTE_TRANSLATED_VALUE, 1000);
12896: l_rows_fetched := DBMS_SQL.Execute(l_cursor_id);

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

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);
12892: DBMS_SQL.Define_Column(l_cursor_id, 5, l_templ_attr_rec.ATTRIBUTE_NUMBER_VALUE);
12893: DBMS_SQL.Define_Column(l_cursor_id, 6, l_templ_attr_rec.ATTRIBUTE_UOM_CODE, 3);
12894: DBMS_SQL.Define_Column(l_cursor_id, 7, l_templ_attr_rec.ATTRIBUTE_DATE_VALUE);
12895: DBMS_SQL.Define_Column(l_cursor_id, 8, l_templ_attr_rec.ATTRIBUTE_TRANSLATED_VALUE, 1000);
12896: l_rows_fetched := DBMS_SQL.Execute(l_cursor_id);
12897:

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

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);
12892: DBMS_SQL.Define_Column(l_cursor_id, 5, l_templ_attr_rec.ATTRIBUTE_NUMBER_VALUE);
12893: DBMS_SQL.Define_Column(l_cursor_id, 6, l_templ_attr_rec.ATTRIBUTE_UOM_CODE, 3);
12894: DBMS_SQL.Define_Column(l_cursor_id, 7, l_templ_attr_rec.ATTRIBUTE_DATE_VALUE);
12895: DBMS_SQL.Define_Column(l_cursor_id, 8, l_templ_attr_rec.ATTRIBUTE_TRANSLATED_VALUE, 1000);
12896: l_rows_fetched := DBMS_SQL.Execute(l_cursor_id);
12897:
12898: WHILE (DBMS_SQL.Fetch_Rows(l_cursor_id) > 0)

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

12891: DBMS_SQL.Define_Column(l_cursor_id, 4, l_templ_attr_rec.ATTRIBUTE_STRING_VALUE, 150);
12892: DBMS_SQL.Define_Column(l_cursor_id, 5, l_templ_attr_rec.ATTRIBUTE_NUMBER_VALUE);
12893: DBMS_SQL.Define_Column(l_cursor_id, 6, l_templ_attr_rec.ATTRIBUTE_UOM_CODE, 3);
12894: DBMS_SQL.Define_Column(l_cursor_id, 7, l_templ_attr_rec.ATTRIBUTE_DATE_VALUE);
12895: DBMS_SQL.Define_Column(l_cursor_id, 8, l_templ_attr_rec.ATTRIBUTE_TRANSLATED_VALUE, 1000);
12896: l_rows_fetched := DBMS_SQL.Execute(l_cursor_id);
12897:
12898: WHILE (DBMS_SQL.Fetch_Rows(l_cursor_id) > 0)
12899: LOOP

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

12892: DBMS_SQL.Define_Column(l_cursor_id, 5, l_templ_attr_rec.ATTRIBUTE_NUMBER_VALUE);
12893: DBMS_SQL.Define_Column(l_cursor_id, 6, l_templ_attr_rec.ATTRIBUTE_UOM_CODE, 3);
12894: DBMS_SQL.Define_Column(l_cursor_id, 7, l_templ_attr_rec.ATTRIBUTE_DATE_VALUE);
12895: DBMS_SQL.Define_Column(l_cursor_id, 8, l_templ_attr_rec.ATTRIBUTE_TRANSLATED_VALUE, 1000);
12896: l_rows_fetched := DBMS_SQL.Execute(l_cursor_id);
12897:
12898: WHILE (DBMS_SQL.Fetch_Rows(l_cursor_id) > 0)
12899: LOOP
12900:

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

12894: DBMS_SQL.Define_Column(l_cursor_id, 7, l_templ_attr_rec.ATTRIBUTE_DATE_VALUE);
12895: DBMS_SQL.Define_Column(l_cursor_id, 8, l_templ_attr_rec.ATTRIBUTE_TRANSLATED_VALUE, 1000);
12896: l_rows_fetched := DBMS_SQL.Execute(l_cursor_id);
12897:
12898: WHILE (DBMS_SQL.Fetch_Rows(l_cursor_id) > 0)
12899: LOOP
12900:
12901: DBMS_SQL.Column_Value(l_cursor_id, 1, l_templ_attr_rec.ATTRIBUTE_GROUP_ID);
12902: DBMS_SQL.Column_Value(l_cursor_id, 2, l_templ_attr_rec.ATTRIBUTE_ID);

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

12897:
12898: WHILE (DBMS_SQL.Fetch_Rows(l_cursor_id) > 0)
12899: LOOP
12900:
12901: DBMS_SQL.Column_Value(l_cursor_id, 1, l_templ_attr_rec.ATTRIBUTE_GROUP_ID);
12902: DBMS_SQL.Column_Value(l_cursor_id, 2, l_templ_attr_rec.ATTRIBUTE_ID);
12903: DBMS_SQL.Column_Value(l_cursor_id, 3, l_templ_attr_rec.ROW_NUMBER);
12904: DBMS_SQL.Column_Value(l_cursor_id, 4, l_templ_attr_rec.ATTRIBUTE_STRING_VALUE);
12905: DBMS_SQL.Column_Value(l_cursor_id, 5, l_templ_attr_rec.ATTRIBUTE_NUMBER_VALUE);

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

12898: WHILE (DBMS_SQL.Fetch_Rows(l_cursor_id) > 0)
12899: LOOP
12900:
12901: DBMS_SQL.Column_Value(l_cursor_id, 1, l_templ_attr_rec.ATTRIBUTE_GROUP_ID);
12902: DBMS_SQL.Column_Value(l_cursor_id, 2, l_templ_attr_rec.ATTRIBUTE_ID);
12903: DBMS_SQL.Column_Value(l_cursor_id, 3, l_templ_attr_rec.ROW_NUMBER);
12904: DBMS_SQL.Column_Value(l_cursor_id, 4, l_templ_attr_rec.ATTRIBUTE_STRING_VALUE);
12905: DBMS_SQL.Column_Value(l_cursor_id, 5, l_templ_attr_rec.ATTRIBUTE_NUMBER_VALUE);
12906: DBMS_SQL.Column_Value(l_cursor_id, 6, l_templ_attr_rec.ATTRIBUTE_UOM_CODE);

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

12899: LOOP
12900:
12901: DBMS_SQL.Column_Value(l_cursor_id, 1, l_templ_attr_rec.ATTRIBUTE_GROUP_ID);
12902: DBMS_SQL.Column_Value(l_cursor_id, 2, l_templ_attr_rec.ATTRIBUTE_ID);
12903: DBMS_SQL.Column_Value(l_cursor_id, 3, l_templ_attr_rec.ROW_NUMBER);
12904: DBMS_SQL.Column_Value(l_cursor_id, 4, l_templ_attr_rec.ATTRIBUTE_STRING_VALUE);
12905: DBMS_SQL.Column_Value(l_cursor_id, 5, l_templ_attr_rec.ATTRIBUTE_NUMBER_VALUE);
12906: DBMS_SQL.Column_Value(l_cursor_id, 6, l_templ_attr_rec.ATTRIBUTE_UOM_CODE);
12907: DBMS_SQL.Column_Value(l_cursor_id, 7, l_templ_attr_rec.ATTRIBUTE_DATE_VALUE);

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

12900:
12901: DBMS_SQL.Column_Value(l_cursor_id, 1, l_templ_attr_rec.ATTRIBUTE_GROUP_ID);
12902: DBMS_SQL.Column_Value(l_cursor_id, 2, l_templ_attr_rec.ATTRIBUTE_ID);
12903: DBMS_SQL.Column_Value(l_cursor_id, 3, l_templ_attr_rec.ROW_NUMBER);
12904: DBMS_SQL.Column_Value(l_cursor_id, 4, l_templ_attr_rec.ATTRIBUTE_STRING_VALUE);
12905: DBMS_SQL.Column_Value(l_cursor_id, 5, l_templ_attr_rec.ATTRIBUTE_NUMBER_VALUE);
12906: DBMS_SQL.Column_Value(l_cursor_id, 6, l_templ_attr_rec.ATTRIBUTE_UOM_CODE);
12907: DBMS_SQL.Column_Value(l_cursor_id, 7, l_templ_attr_rec.ATTRIBUTE_DATE_VALUE);
12908: DBMS_SQL.Column_Value(l_cursor_id, 8, l_templ_attr_rec.ATTRIBUTE_TRANSLATED_VALUE);

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

12901: DBMS_SQL.Column_Value(l_cursor_id, 1, l_templ_attr_rec.ATTRIBUTE_GROUP_ID);
12902: DBMS_SQL.Column_Value(l_cursor_id, 2, l_templ_attr_rec.ATTRIBUTE_ID);
12903: DBMS_SQL.Column_Value(l_cursor_id, 3, l_templ_attr_rec.ROW_NUMBER);
12904: DBMS_SQL.Column_Value(l_cursor_id, 4, l_templ_attr_rec.ATTRIBUTE_STRING_VALUE);
12905: DBMS_SQL.Column_Value(l_cursor_id, 5, l_templ_attr_rec.ATTRIBUTE_NUMBER_VALUE);
12906: DBMS_SQL.Column_Value(l_cursor_id, 6, l_templ_attr_rec.ATTRIBUTE_UOM_CODE);
12907: DBMS_SQL.Column_Value(l_cursor_id, 7, l_templ_attr_rec.ATTRIBUTE_DATE_VALUE);
12908: DBMS_SQL.Column_Value(l_cursor_id, 8, l_templ_attr_rec.ATTRIBUTE_TRANSLATED_VALUE);
12909:

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

12902: DBMS_SQL.Column_Value(l_cursor_id, 2, l_templ_attr_rec.ATTRIBUTE_ID);
12903: DBMS_SQL.Column_Value(l_cursor_id, 3, l_templ_attr_rec.ROW_NUMBER);
12904: DBMS_SQL.Column_Value(l_cursor_id, 4, l_templ_attr_rec.ATTRIBUTE_STRING_VALUE);
12905: DBMS_SQL.Column_Value(l_cursor_id, 5, l_templ_attr_rec.ATTRIBUTE_NUMBER_VALUE);
12906: DBMS_SQL.Column_Value(l_cursor_id, 6, l_templ_attr_rec.ATTRIBUTE_UOM_CODE);
12907: DBMS_SQL.Column_Value(l_cursor_id, 7, l_templ_attr_rec.ATTRIBUTE_DATE_VALUE);
12908: DBMS_SQL.Column_Value(l_cursor_id, 8, l_templ_attr_rec.ATTRIBUTE_TRANSLATED_VALUE);
12909:
12910: Debug_Msg(l_api_name ||' processing AG '||l_templ_attr_rec.ATTRIBUTE_GROUP_ID,1);

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

12903: DBMS_SQL.Column_Value(l_cursor_id, 3, l_templ_attr_rec.ROW_NUMBER);
12904: DBMS_SQL.Column_Value(l_cursor_id, 4, l_templ_attr_rec.ATTRIBUTE_STRING_VALUE);
12905: DBMS_SQL.Column_Value(l_cursor_id, 5, l_templ_attr_rec.ATTRIBUTE_NUMBER_VALUE);
12906: DBMS_SQL.Column_Value(l_cursor_id, 6, l_templ_attr_rec.ATTRIBUTE_UOM_CODE);
12907: DBMS_SQL.Column_Value(l_cursor_id, 7, l_templ_attr_rec.ATTRIBUTE_DATE_VALUE);
12908: DBMS_SQL.Column_Value(l_cursor_id, 8, l_templ_attr_rec.ATTRIBUTE_TRANSLATED_VALUE);
12909:
12910: Debug_Msg(l_api_name ||' processing AG '||l_templ_attr_rec.ATTRIBUTE_GROUP_ID,1);
12911: -----------------------------------------------------------------------

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

12904: DBMS_SQL.Column_Value(l_cursor_id, 4, l_templ_attr_rec.ATTRIBUTE_STRING_VALUE);
12905: DBMS_SQL.Column_Value(l_cursor_id, 5, l_templ_attr_rec.ATTRIBUTE_NUMBER_VALUE);
12906: DBMS_SQL.Column_Value(l_cursor_id, 6, l_templ_attr_rec.ATTRIBUTE_UOM_CODE);
12907: DBMS_SQL.Column_Value(l_cursor_id, 7, l_templ_attr_rec.ATTRIBUTE_DATE_VALUE);
12908: DBMS_SQL.Column_Value(l_cursor_id, 8, l_templ_attr_rec.ATTRIBUTE_TRANSLATED_VALUE);
12909:
12910: Debug_Msg(l_api_name ||' processing AG '||l_templ_attr_rec.ATTRIBUTE_GROUP_ID,1);
12911: -----------------------------------------------------------------------
12912: -- Find out whether we're at the beginning of an Attr Group or a row --

Line 13905: l_desc_table DBMS_SQL.Desc_Tab;

13901: l_history_tl_prod_cols_list VARCHAR2(10000);
13902: l_dynamic_sql VARCHAR2(32767); --the largest a VARCHAR2 can be
13903: l_cursor_id NUMBER;
13904: l_column_count NUMBER;
13905: l_desc_table DBMS_SQL.Desc_Tab;
13906: l_retrieved_value VARCHAR2(1000);
13907: l_dummy NUMBER;
13908: l_current_column_index NUMBER;
13909: l_current_row_language VARCHAR2(30);

Line 14241: l_cursor_id := DBMS_SQL.Open_Cursor;

14237: ' AND B.ACD_TYPE = TL.ACD_TYPE'||
14238: ' AND B.CHANGE_LINE_ID = TL.CHANGE_LINE_ID'||
14239: ' AND B.CHANGE_LINE_ID = :1';
14240:
14241: l_cursor_id := DBMS_SQL.Open_Cursor;
14242: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.Native);
14243: DBMS_SQL.Bind_Variable(l_cursor_id, ':1', p_change_line_id);
14244: DBMS_SQL.Describe_Columns(l_cursor_id, l_column_count, l_desc_table);
14245:

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

14238: ' AND B.CHANGE_LINE_ID = TL.CHANGE_LINE_ID'||
14239: ' AND B.CHANGE_LINE_ID = :1';
14240:
14241: l_cursor_id := DBMS_SQL.Open_Cursor;
14242: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.Native);
14243: DBMS_SQL.Bind_Variable(l_cursor_id, ':1', p_change_line_id);
14244: DBMS_SQL.Describe_Columns(l_cursor_id, l_column_count, l_desc_table);
14245:
14246: FOR i IN 1 .. l_column_count

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

14239: ' AND B.CHANGE_LINE_ID = :1';
14240:
14241: l_cursor_id := DBMS_SQL.Open_Cursor;
14242: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.Native);
14243: DBMS_SQL.Bind_Variable(l_cursor_id, ':1', p_change_line_id);
14244: DBMS_SQL.Describe_Columns(l_cursor_id, l_column_count, l_desc_table);
14245:
14246: FOR i IN 1 .. l_column_count
14247: LOOP

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

14240:
14241: l_cursor_id := DBMS_SQL.Open_Cursor;
14242: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.Native);
14243: DBMS_SQL.Bind_Variable(l_cursor_id, ':1', p_change_line_id);
14244: DBMS_SQL.Describe_Columns(l_cursor_id, l_column_count, l_desc_table);
14245:
14246: FOR i IN 1 .. l_column_count
14247: LOOP
14248: -------------------------------------------------------------

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

14248: -------------------------------------------------------------
14249: -- We define all columns as VARCHAR2(1000) for convenience --
14250: -- ASSUMPTION: no PKs will ever be DATE objects --
14251: -------------------------------------------------------------
14252: DBMS_SQL.Define_Column(l_cursor_id, i, l_retrieved_value, 1000);
14253: END LOOP;
14254:
14255: ----------------------------------
14256: -- Execute our dynamic query... --

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

14254:
14255: ----------------------------------
14256: -- Execute our dynamic query... --
14257: ----------------------------------
14258: l_dummy := DBMS_SQL.Execute(l_cursor_id);
14259:
14260: ----------------------------------------------------
14261: -- ...then loop through the result set, gathering --
14262: -- the column values and then calling Process_Row --

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

14260: ----------------------------------------------------
14261: -- ...then loop through the result set, gathering --
14262: -- the column values and then calling Process_Row --
14263: ----------------------------------------------------
14264: WHILE (DBMS_SQL.Fetch_Rows(l_cursor_id) > 0)
14265: LOOP
14266:
14267: l_current_column_index := 1;
14268: l_attr_name_value_pairs.DELETE();

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

14270: ------------------------------------
14271: -- Get the PK values for this row --
14272: ------------------------------------
14273: IF (l_pk_column_name_value_pairs.COUNT > 0) THEN
14274: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);
14275: l_current_column_index := l_current_column_index + 1;
14276: l_pk_column_name_value_pairs(1).VALUE := SUBSTRB(l_retrieved_value, 1, 150);
14277: END IF;
14278: IF (l_pk_column_name_value_pairs.COUNT > 1) THEN

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

14275: l_current_column_index := l_current_column_index + 1;
14276: l_pk_column_name_value_pairs(1).VALUE := SUBSTRB(l_retrieved_value, 1, 150);
14277: END IF;
14278: IF (l_pk_column_name_value_pairs.COUNT > 1) THEN
14279: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);
14280: l_current_column_index := l_current_column_index + 1;
14281: l_pk_column_name_value_pairs(2).VALUE := SUBSTRB(l_retrieved_value, 1, 150);
14282: END IF;
14283: IF (l_pk_column_name_value_pairs.COUNT > 2) THEN

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

14280: l_current_column_index := l_current_column_index + 1;
14281: l_pk_column_name_value_pairs(2).VALUE := SUBSTRB(l_retrieved_value, 1, 150);
14282: END IF;
14283: IF (l_pk_column_name_value_pairs.COUNT > 2) THEN
14284: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);
14285: l_current_column_index := l_current_column_index + 1;
14286: l_pk_column_name_value_pairs(3).VALUE := SUBSTRB(l_retrieved_value, 1, 150);
14287: END IF;
14288: IF (l_pk_column_name_value_pairs.COUNT > 3) THEN

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

14285: l_current_column_index := l_current_column_index + 1;
14286: l_pk_column_name_value_pairs(3).VALUE := SUBSTRB(l_retrieved_value, 1, 150);
14287: END IF;
14288: IF (l_pk_column_name_value_pairs.COUNT > 3) THEN
14289: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);
14290: l_current_column_index := l_current_column_index + 1;
14291: l_pk_column_name_value_pairs(4).VALUE := SUBSTRB(l_retrieved_value, 1, 150);
14292: END IF;
14293: IF (l_pk_column_name_value_pairs.COUNT > 4) THEN

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

14290: l_current_column_index := l_current_column_index + 1;
14291: l_pk_column_name_value_pairs(4).VALUE := SUBSTRB(l_retrieved_value, 1, 150);
14292: END IF;
14293: IF (l_pk_column_name_value_pairs.COUNT > 4) THEN
14294: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);
14295: l_current_column_index := l_current_column_index + 1;
14296: l_pk_column_name_value_pairs(5).VALUE := SUBSTRB(l_retrieved_value, 1, 150);
14297: END IF;
14298:

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

14301: -- and try to get related Class Codes as well --
14302: ------------------------------------------------
14303: IF (l_class_code_name_value_pairs IS NOT NULL AND
14304: l_class_code_name_value_pairs.COUNT > 0) THEN
14305: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);
14306: l_current_column_index := l_current_column_index + 1;
14307: l_class_code_name_value_pairs(1).VALUE := SUBSTRB(l_retrieved_value, 1, 150);
14308:
14309: EXECUTE IMMEDIATE 'BEGIN '||p_related_class_code_function||'(:1, :2); END;'

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

14313:
14314: ----------------------------
14315: -- Determine the ACD Type --
14316: ----------------------------
14317: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);
14318: l_current_column_index := l_current_column_index + 1;
14319: l_current_acd_type := l_retrieved_value;
14320:
14321: ---------------------------------------------------------

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

14320:
14321: ---------------------------------------------------------
14322: -- Find the Attr Group metadata from the Attr Group ID --
14323: ---------------------------------------------------------
14324: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);
14325: l_current_column_index := l_current_column_index + 1;
14326: l_attr_group_metadata_obj :=
14327: EGO_USER_ATTRS_COMMON_PVT.Get_Attr_Group_Metadata(
14328: p_attr_group_id => TO_NUMBER(l_retrieved_value)

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

14363:
14364: --------------------------
14365: -- Get the extension ID --
14366: --------------------------
14367: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);
14368: l_current_column_index := l_current_column_index + 1;
14369: l_current_pending_ext_id := TO_NUMBER(l_retrieved_value);
14370:
14371: -------------------------------------------------------------------

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

14378: -----------------------------------------------
14379: -- Get the current column name and its value --
14380: -----------------------------------------------
14381: l_current_column_name := l_desc_table(i).COL_NAME;
14382: DBMS_SQL.Column_Value(l_cursor_id, i, l_retrieved_value);
14383:
14384: ------------------------------------------------------------------------
14385: -- See whether the current column belongs to a User-Defined Attribute --
14386: ------------------------------------------------------------------------

Line 14763: DBMS_SQL.Close_Cursor(l_cursor_id);

14759: RAISE FND_API.G_EXC_ERROR;
14760: END IF;
14761: END IF;
14762: END LOOP;
14763: DBMS_SQL.Close_Cursor(l_cursor_id);
14764:
14765: ---------------------------------------------------------------------------
14766: -- Finally, set the IMPLEMENTATION_DATE for all rows we just implemented --
14767: ---------------------------------------------------------------------------

Line 14938: l_cursor := DBMS_SQL.OPEN_CURSOR;

14934: x_date_val := NULL;
14935:
14936: l_db_column_alias := EGO_USER_ATTRS_COMMON_PVT.Create_DB_Col_Alias_If_Needed(p_attr_metadata_obj);
14937:
14938: l_cursor := DBMS_SQL.OPEN_CURSOR;
14939: l_bind_index := 0;
14940:
14941: --------------------------
14942: -- SELECT, FROM clauses --

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

15079: --======================================================================--
15080: -- 2. Parse the query and bind the input variables --
15081: --======================================================================--
15082:
15083: DBMS_SQL.PARSE(l_cursor, l_dynamic_sql, DBMS_SQL.NATIVE);
15084:
15085: Debug_Msg('Get_Ext_Data(): Bind value table has ' || l_bind_value_table.COUNT || ' elements');
15086:
15087: -- Bind the attribute group ID value, and the primary key values for the object

Line 15095: DBMS_SQL.BIND_VARIABLE(

15091: l_bind_var_value := l_bind_value_table(i);
15092: l_bind_var_value_num := to_number(l_bind_var_value);
15093: Debug_Msg(l_api_name || ' Binding '|| l_bind_var_name || ' to value ' || l_bind_var_value_num);
15094:
15095: DBMS_SQL.BIND_VARIABLE(
15096: c => l_cursor, -- SQL query
15097: name => l_bind_var_name, -- bind variable name
15098: value => l_bind_var_value -- bind value (VARCHAR2(80))
15099: );

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

15102: ------------------------
15103: -- Define the outputs --
15104: ------------------------
15105: IF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
15106: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, x_num_val);
15107: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = 'X' OR p_attr_metadata_obj.DATA_TYPE_CODE = 'Y') THEN
15108: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_str,150);
15109: ELSE
15110: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, x_str_val, 150);

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

15104: ------------------------
15105: IF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
15106: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, x_num_val);
15107: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = 'X' OR p_attr_metadata_obj.DATA_TYPE_CODE = 'Y') THEN
15108: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_str,150);
15109: ELSE
15110: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, x_str_val, 150);
15111: END IF;
15112:

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

15106: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, x_num_val);
15107: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = 'X' OR p_attr_metadata_obj.DATA_TYPE_CODE = 'Y') THEN
15108: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_str,150);
15109: ELSE
15110: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, x_str_val, 150);
15111: END IF;
15112:
15113: --======================================================================--
15114: -- 3. Execute the query and fetch the attribute internal value --

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

15113: --======================================================================--
15114: -- 3. Execute the query and fetch the attribute internal value --
15115: --======================================================================--
15116:
15117: l_row_count := DBMS_SQL.EXECUTE_AND_FETCH(l_cursor, FALSE);
15118: IF (l_row_count > 0) THEN
15119:
15120: IF (p_attr_metadata_obj.DATA_TYPE_CODE = 'N') THEN
15121: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, x_num_val);

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

15117: l_row_count := DBMS_SQL.EXECUTE_AND_FETCH(l_cursor, FALSE);
15118: IF (l_row_count > 0) THEN
15119:
15120: IF (p_attr_metadata_obj.DATA_TYPE_CODE = 'N') THEN
15121: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, x_num_val);
15122: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = 'X' OR p_attr_metadata_obj.DATA_TYPE_CODE = 'Y') THEN
15123: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_str);
15124: x_date_val := TO_DATE(l_str,EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
15125: ELSE

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

15119:
15120: IF (p_attr_metadata_obj.DATA_TYPE_CODE = 'N') THEN
15121: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, x_num_val);
15122: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = 'X' OR p_attr_metadata_obj.DATA_TYPE_CODE = 'Y') THEN
15123: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_str);
15124: x_date_val := TO_DATE(l_str,EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
15125: ELSE
15126: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, x_str_val);
15127: END IF;

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

15122: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = 'X' OR p_attr_metadata_obj.DATA_TYPE_CODE = 'Y') THEN
15123: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_str);
15124: x_date_val := TO_DATE(l_str,EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
15125: ELSE
15126: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, x_str_val);
15127: END IF;
15128: END IF;
15129:
15130: DBMS_SQL.CLOSE_CURSOR(l_cursor);

Line 15130: DBMS_SQL.CLOSE_CURSOR(l_cursor);

15126: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, x_str_val);
15127: END IF;
15128: END IF;
15129:
15130: DBMS_SQL.CLOSE_CURSOR(l_cursor);
15131:
15132: Debug_Msg(l_api_name || ' Done.' );
15133:
15134: END Get_Ext_Data;