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.RRS_BULKLOAD_ENTITIES dependencies on DBMS_SQL

Line 244: l_attr_id_table DBMS_SQL.NUMBER_TABLE;

240: TYPE VARCHAR_TBL_TYPE IS TABLE OF VARCHAR2(256)
241: INDEX BY BINARY_INTEGER;
242: l_prod_col_name_tbl VARCHAR_TBL_TYPE;
243: l_intf_col_name_tbl VARCHAR_TBL_TYPE;
244: l_attr_id_table DBMS_SQL.NUMBER_TABLE;
245: l_intf_col_name_table DBMS_SQL.VARCHAR2_TABLE;
246: l_usr_attr_data_tbl L_USER_ATTR_TBL_TYPE;
247: l_pk_id_char VARCHAR(15);
248: l_site_num_char VARCHAR(1000);

Line 245: l_intf_col_name_table DBMS_SQL.VARCHAR2_TABLE;

241: INDEX BY BINARY_INTEGER;
242: l_prod_col_name_tbl VARCHAR_TBL_TYPE;
243: l_intf_col_name_tbl VARCHAR_TBL_TYPE;
244: l_attr_id_table DBMS_SQL.NUMBER_TABLE;
245: l_intf_col_name_table DBMS_SQL.VARCHAR2_TABLE;
246: l_usr_attr_data_tbl L_USER_ATTR_TBL_TYPE;
247: l_pk_id_char VARCHAR(15);
248: l_site_num_char VARCHAR(1000);
249: l_trade_area_num_char VARCHAR(10);

Line 258: l_attr_group_id_table DBMS_SQL.NUMBER_TABLE;

254: l_attr_int_name EGO_ATTRS_V.ATTR_NAME%TYPE;
255:
256: l_attr_group_id NUMBER(15); --bug 6493113
257: l_site_id NUMBER(15); --bug 6493113
258: l_attr_group_id_table DBMS_SQL.NUMBER_TABLE;
259: ---------------------------------------------------------
260: -- Example Data Types to be used in Bind Variable.
261: ---------------------------------------------------------
262: l_varchar_example VARCHAR2(10000);

Line 277: -- DBMS_SQL Open Cursor integers.

273: l_varchar_data VARCHAR2(10000);
274: l_number_data NUMBER;
275: l_date_data DATE;
276: ---------------------------------------------------------
277: -- DBMS_SQL Open Cursor integers.
278: ---------------------------------------------------------
279: l_cursor_select INTEGER;
280: l_cursor_execute INTEGER;
281: l_cursor_attr_id_val INTEGER;

Line 345: l_cursor_select := DBMS_SQL.OPEN_CURSOR;

341: l_dyn_sql := ' SELECT To_Number(SUBSTR(attribute_code, INSTR(attribute_code, ''$$'')+2)) attr_id, intf_column_name, To_Number(SUBSTR(attribute_code, 1, INSTR(attribute_code, ''$$'') - 1)) attr_group_id '; --bug 6493113
342: l_dyn_sql := l_dyn_sql || ' FROM ego_results_fmt_usages ';
343: l_dyn_sql := l_dyn_sql || ' WHERE resultfmt_usage_id = :RESULTFMT_USAGE_ID';
344: l_dyn_sql := l_dyn_sql || ' AND attribute_code LIKE :ATTRIBUTE_CODE ';
345: l_cursor_select := DBMS_SQL.OPEN_CURSOR;
346: DBMS_SQL.PARSE(l_cursor_select, l_dyn_sql, DBMS_SQL.NATIVE);
347: DBMS_SQL.DEFINE_ARRAY(l_cursor_select, 1,l_attr_id_table,2500, l_temp);
348: DBMS_SQL.DEFINE_ARRAY(l_cursor_select, 2,l_intf_col_name_table,2500, l_temp);
349: DBMS_SQL.DEFINE_ARRAY(l_cursor_select, 3,l_attr_group_id_table,2500, l_temp);

Line 346: DBMS_SQL.PARSE(l_cursor_select, l_dyn_sql, DBMS_SQL.NATIVE);

342: l_dyn_sql := l_dyn_sql || ' FROM ego_results_fmt_usages ';
343: l_dyn_sql := l_dyn_sql || ' WHERE resultfmt_usage_id = :RESULTFMT_USAGE_ID';
344: l_dyn_sql := l_dyn_sql || ' AND attribute_code LIKE :ATTRIBUTE_CODE ';
345: l_cursor_select := DBMS_SQL.OPEN_CURSOR;
346: DBMS_SQL.PARSE(l_cursor_select, l_dyn_sql, DBMS_SQL.NATIVE);
347: DBMS_SQL.DEFINE_ARRAY(l_cursor_select, 1,l_attr_id_table,2500, l_temp);
348: DBMS_SQL.DEFINE_ARRAY(l_cursor_select, 2,l_intf_col_name_table,2500, l_temp);
349: DBMS_SQL.DEFINE_ARRAY(l_cursor_select, 3,l_attr_group_id_table,2500, l_temp);
350:

Line 347: DBMS_SQL.DEFINE_ARRAY(l_cursor_select, 1,l_attr_id_table,2500, l_temp);

343: l_dyn_sql := l_dyn_sql || ' WHERE resultfmt_usage_id = :RESULTFMT_USAGE_ID';
344: l_dyn_sql := l_dyn_sql || ' AND attribute_code LIKE :ATTRIBUTE_CODE ';
345: l_cursor_select := DBMS_SQL.OPEN_CURSOR;
346: DBMS_SQL.PARSE(l_cursor_select, l_dyn_sql, DBMS_SQL.NATIVE);
347: DBMS_SQL.DEFINE_ARRAY(l_cursor_select, 1,l_attr_id_table,2500, l_temp);
348: DBMS_SQL.DEFINE_ARRAY(l_cursor_select, 2,l_intf_col_name_table,2500, l_temp);
349: DBMS_SQL.DEFINE_ARRAY(l_cursor_select, 3,l_attr_group_id_table,2500, l_temp);
350:
351:

Line 348: DBMS_SQL.DEFINE_ARRAY(l_cursor_select, 2,l_intf_col_name_table,2500, l_temp);

344: l_dyn_sql := l_dyn_sql || ' AND attribute_code LIKE :ATTRIBUTE_CODE ';
345: l_cursor_select := DBMS_SQL.OPEN_CURSOR;
346: DBMS_SQL.PARSE(l_cursor_select, l_dyn_sql, DBMS_SQL.NATIVE);
347: DBMS_SQL.DEFINE_ARRAY(l_cursor_select, 1,l_attr_id_table,2500, l_temp);
348: DBMS_SQL.DEFINE_ARRAY(l_cursor_select, 2,l_intf_col_name_table,2500, l_temp);
349: DBMS_SQL.DEFINE_ARRAY(l_cursor_select, 3,l_attr_group_id_table,2500, l_temp);
350:
351:
352: DBMS_SQL.BIND_VARIABLE(l_cursor_select,':RESULTFMT_USAGE_ID', p_resultfmt_usage_id);

Line 349: DBMS_SQL.DEFINE_ARRAY(l_cursor_select, 3,l_attr_group_id_table,2500, l_temp);

345: l_cursor_select := DBMS_SQL.OPEN_CURSOR;
346: DBMS_SQL.PARSE(l_cursor_select, l_dyn_sql, DBMS_SQL.NATIVE);
347: DBMS_SQL.DEFINE_ARRAY(l_cursor_select, 1,l_attr_id_table,2500, l_temp);
348: DBMS_SQL.DEFINE_ARRAY(l_cursor_select, 2,l_intf_col_name_table,2500, l_temp);
349: DBMS_SQL.DEFINE_ARRAY(l_cursor_select, 3,l_attr_group_id_table,2500, l_temp);
350:
351:
352: DBMS_SQL.BIND_VARIABLE(l_cursor_select,':RESULTFMT_USAGE_ID', p_resultfmt_usage_id);
353: DBMS_SQL.BIND_VARIABLE(l_cursor_select,':ATTRIBUTE_CODE', c_attr_grp_rec.attr_group_id||'$$%');

Line 352: DBMS_SQL.BIND_VARIABLE(l_cursor_select,':RESULTFMT_USAGE_ID', p_resultfmt_usage_id);

348: DBMS_SQL.DEFINE_ARRAY(l_cursor_select, 2,l_intf_col_name_table,2500, l_temp);
349: DBMS_SQL.DEFINE_ARRAY(l_cursor_select, 3,l_attr_group_id_table,2500, l_temp);
350:
351:
352: DBMS_SQL.BIND_VARIABLE(l_cursor_select,':RESULTFMT_USAGE_ID', p_resultfmt_usage_id);
353: DBMS_SQL.BIND_VARIABLE(l_cursor_select,':ATTRIBUTE_CODE', c_attr_grp_rec.attr_group_id||'$$%');
354: l_cursor_execute := DBMS_SQL.EXECUTE(l_cursor_select);
355:
356: l_count := DBMS_SQL.FETCH_ROWS(l_cursor_select);

Line 353: DBMS_SQL.BIND_VARIABLE(l_cursor_select,':ATTRIBUTE_CODE', c_attr_grp_rec.attr_group_id||'$$%');

349: DBMS_SQL.DEFINE_ARRAY(l_cursor_select, 3,l_attr_group_id_table,2500, l_temp);
350:
351:
352: DBMS_SQL.BIND_VARIABLE(l_cursor_select,':RESULTFMT_USAGE_ID', p_resultfmt_usage_id);
353: DBMS_SQL.BIND_VARIABLE(l_cursor_select,':ATTRIBUTE_CODE', c_attr_grp_rec.attr_group_id||'$$%');
354: l_cursor_execute := DBMS_SQL.EXECUTE(l_cursor_select);
355:
356: l_count := DBMS_SQL.FETCH_ROWS(l_cursor_select);
357: DBMS_SQL.COLUMN_VALUE(l_cursor_select, 1, l_attr_id_table);

Line 354: l_cursor_execute := DBMS_SQL.EXECUTE(l_cursor_select);

350:
351:
352: DBMS_SQL.BIND_VARIABLE(l_cursor_select,':RESULTFMT_USAGE_ID', p_resultfmt_usage_id);
353: DBMS_SQL.BIND_VARIABLE(l_cursor_select,':ATTRIBUTE_CODE', c_attr_grp_rec.attr_group_id||'$$%');
354: l_cursor_execute := DBMS_SQL.EXECUTE(l_cursor_select);
355:
356: l_count := DBMS_SQL.FETCH_ROWS(l_cursor_select);
357: DBMS_SQL.COLUMN_VALUE(l_cursor_select, 1, l_attr_id_table);
358: DBMS_SQL.COLUMN_VALUE(l_cursor_select, 2, l_intf_col_name_table);

Line 356: l_count := DBMS_SQL.FETCH_ROWS(l_cursor_select);

352: DBMS_SQL.BIND_VARIABLE(l_cursor_select,':RESULTFMT_USAGE_ID', p_resultfmt_usage_id);
353: DBMS_SQL.BIND_VARIABLE(l_cursor_select,':ATTRIBUTE_CODE', c_attr_grp_rec.attr_group_id||'$$%');
354: l_cursor_execute := DBMS_SQL.EXECUTE(l_cursor_select);
355:
356: l_count := DBMS_SQL.FETCH_ROWS(l_cursor_select);
357: DBMS_SQL.COLUMN_VALUE(l_cursor_select, 1, l_attr_id_table);
358: DBMS_SQL.COLUMN_VALUE(l_cursor_select, 2, l_intf_col_name_table);
359: DBMS_SQL.COLUMN_VALUE(l_cursor_select, 3, l_attr_group_id_table);
360: --bug:6493113

Line 357: DBMS_SQL.COLUMN_VALUE(l_cursor_select, 1, l_attr_id_table);

353: DBMS_SQL.BIND_VARIABLE(l_cursor_select,':ATTRIBUTE_CODE', c_attr_grp_rec.attr_group_id||'$$%');
354: l_cursor_execute := DBMS_SQL.EXECUTE(l_cursor_select);
355:
356: l_count := DBMS_SQL.FETCH_ROWS(l_cursor_select);
357: DBMS_SQL.COLUMN_VALUE(l_cursor_select, 1, l_attr_id_table);
358: DBMS_SQL.COLUMN_VALUE(l_cursor_select, 2, l_intf_col_name_table);
359: DBMS_SQL.COLUMN_VALUE(l_cursor_select, 3, l_attr_group_id_table);
360: --bug:6493113
361:

Line 358: DBMS_SQL.COLUMN_VALUE(l_cursor_select, 2, l_intf_col_name_table);

354: l_cursor_execute := DBMS_SQL.EXECUTE(l_cursor_select);
355:
356: l_count := DBMS_SQL.FETCH_ROWS(l_cursor_select);
357: DBMS_SQL.COLUMN_VALUE(l_cursor_select, 1, l_attr_id_table);
358: DBMS_SQL.COLUMN_VALUE(l_cursor_select, 2, l_intf_col_name_table);
359: DBMS_SQL.COLUMN_VALUE(l_cursor_select, 3, l_attr_group_id_table);
360: --bug:6493113
361:
362:

Line 359: DBMS_SQL.COLUMN_VALUE(l_cursor_select, 3, l_attr_group_id_table);

355:
356: l_count := DBMS_SQL.FETCH_ROWS(l_cursor_select);
357: DBMS_SQL.COLUMN_VALUE(l_cursor_select, 1, l_attr_id_table);
358: DBMS_SQL.COLUMN_VALUE(l_cursor_select, 2, l_intf_col_name_table);
359: DBMS_SQL.COLUMN_VALUE(l_cursor_select, 3, l_attr_group_id_table);
360: --bug:6493113
361:
362:
363: DBMS_SQL.CLOSE_CURSOR(l_cursor_select);

Line 363: DBMS_SQL.CLOSE_CURSOR(l_cursor_select);

359: DBMS_SQL.COLUMN_VALUE(l_cursor_select, 3, l_attr_group_id_table);
360: --bug:6493113
361:
362:
363: DBMS_SQL.CLOSE_CURSOR(l_cursor_select);
364: --------------------------------------------------------------------
365: -- New DBMS_SQL Cursor for Select Attr Values.
366: --------------------------------------------------------------------
367: l_cursor_attr_id_val := DBMS_SQL.OPEN_CURSOR;

Line 365: -- New DBMS_SQL Cursor for Select Attr Values.

361:
362:
363: DBMS_SQL.CLOSE_CURSOR(l_cursor_select);
364: --------------------------------------------------------------------
365: -- New DBMS_SQL Cursor for Select Attr Values.
366: --------------------------------------------------------------------
367: l_cursor_attr_id_val := DBMS_SQL.OPEN_CURSOR;
368: l_dyn_attr_id_val_sql := '';
369: l_dyn_attr_id_val_sql := ' SELECT ';

Line 367: l_cursor_attr_id_val := DBMS_SQL.OPEN_CURSOR;

363: DBMS_SQL.CLOSE_CURSOR(l_cursor_select);
364: --------------------------------------------------------------------
365: -- New DBMS_SQL Cursor for Select Attr Values.
366: --------------------------------------------------------------------
367: l_cursor_attr_id_val := DBMS_SQL.OPEN_CURSOR;
368: l_dyn_attr_id_val_sql := '';
369: l_dyn_attr_id_val_sql := ' SELECT ';
370: l_dyn_attr_id_val_sql := l_dyn_attr_id_val_sql || ' TRANSACTION_ID , ';
371: IF p_entity_name = 'RRS_SITE' THEN

Line 394: DBMS_SQL.PARSE(l_cursor_attr_id_val, l_dyn_attr_id_val_sql, DBMS_SQL.NATIVE);

390: END LOOP; --end: FOR i IN 1..l_attr_id_table.COUNT LOOP
391: l_dyn_attr_id_val_sql := l_dyn_attr_id_val_sql || ' FROM EGO_BULKLOAD_INTF ' ;
392: l_dyn_attr_id_val_sql := l_dyn_attr_id_val_sql || ' WHERE RESULTFMT_USAGE_ID = :RESULTFMT_USAGE_ID';
393: l_dyn_attr_id_val_sql := l_dyn_attr_id_val_sql || ' AND PROCESS_STATUS = :PROCESS_STATUS ';
394: DBMS_SQL.PARSE(l_cursor_attr_id_val, l_dyn_attr_id_val_sql, DBMS_SQL.NATIVE);
395: --------------------------------------------------------------------
396: --Setting Data Type for Trasaction ID
397: --------------------------------------------------------------------
398: DBMS_SQL.DEFINE_COLUMN(l_cursor_attr_id_val, 1, l_number_example);

Line 398: DBMS_SQL.DEFINE_COLUMN(l_cursor_attr_id_val, 1, l_number_example);

394: DBMS_SQL.PARSE(l_cursor_attr_id_val, l_dyn_attr_id_val_sql, DBMS_SQL.NATIVE);
395: --------------------------------------------------------------------
396: --Setting Data Type for Trasaction ID
397: --------------------------------------------------------------------
398: DBMS_SQL.DEFINE_COLUMN(l_cursor_attr_id_val, 1, l_number_example);
399: --------------------------------------------------------------------
400: --Setting Data Type for INSTANCE_PK1_VALUE (SITE ID)
401: --------------------------------------------------------------------
402: DBMS_SQL.DEFINE_COLUMN(l_cursor_attr_id_val, 2, l_varchar_example, 1000);

Line 402: DBMS_SQL.DEFINE_COLUMN(l_cursor_attr_id_val, 2, l_varchar_example, 1000);

398: DBMS_SQL.DEFINE_COLUMN(l_cursor_attr_id_val, 1, l_number_example);
399: --------------------------------------------------------------------
400: --Setting Data Type for INSTANCE_PK1_VALUE (SITE ID)
401: --------------------------------------------------------------------
402: DBMS_SQL.DEFINE_COLUMN(l_cursor_attr_id_val, 2, l_varchar_example, 1000);
403: --------------------------------------------------------------------
404: --Setting Data Type for Site Num
405: --------------------------------------------------------------------
406: -- DBMS_SQL.DEFINE_COLUMN(l_cursor_attr_id_val, 3, l_varchar_example, 1000);

Line 406: -- DBMS_SQL.DEFINE_COLUMN(l_cursor_attr_id_val, 3, l_varchar_example, 1000);

402: DBMS_SQL.DEFINE_COLUMN(l_cursor_attr_id_val, 2, l_varchar_example, 1000);
403: --------------------------------------------------------------------
404: --Setting Data Type for Site Num
405: --------------------------------------------------------------------
406: -- DBMS_SQL.DEFINE_COLUMN(l_cursor_attr_id_val, 3, l_varchar_example, 1000);
407: Write_Conclog('Executing the l_attr_id table looping');
408: --------------------------------------------------------------------
409: -- Loop to Bind the Data Types for the SELECT Columns.
410: --------------------------------------------------------------------

Line 423: DBMS_SQL.DEFINE_COLUMN(l_cursor_attr_id_val, l_actual_userattr_indx, l_varchar_example, 1000);

419: ------------------------------------------------------------------------
420: -- Based on the Data Type of the attribute, define the column
421: ------------------------------------------------------------------------
422: IF (l_data_type_code = 'C') THEN
423: DBMS_SQL.DEFINE_COLUMN(l_cursor_attr_id_val, l_actual_userattr_indx, l_varchar_example, 1000);
424: ELSIF (l_data_type_code = 'N') THEN
425: DBMS_SQL.DEFINE_COLUMN(l_cursor_attr_id_val, l_actual_userattr_indx, l_number_example);
426: ELSE --IF (l_data_type_code = 'D') THEN
427: DBMS_SQL.DEFINE_COLUMN(l_cursor_attr_id_val, l_actual_userattr_indx, l_date_example);

Line 425: DBMS_SQL.DEFINE_COLUMN(l_cursor_attr_id_val, l_actual_userattr_indx, l_number_example);

421: ------------------------------------------------------------------------
422: IF (l_data_type_code = 'C') THEN
423: DBMS_SQL.DEFINE_COLUMN(l_cursor_attr_id_val, l_actual_userattr_indx, l_varchar_example, 1000);
424: ELSIF (l_data_type_code = 'N') THEN
425: DBMS_SQL.DEFINE_COLUMN(l_cursor_attr_id_val, l_actual_userattr_indx, l_number_example);
426: ELSE --IF (l_data_type_code = 'D') THEN
427: DBMS_SQL.DEFINE_COLUMN(l_cursor_attr_id_val, l_actual_userattr_indx, l_date_example);
428: END IF; --IF (l_data_type_code = 'C') THEN
429: END LOOP; --FOR i IN 1..l_attr_id_table.COUNT LOOP

Line 427: DBMS_SQL.DEFINE_COLUMN(l_cursor_attr_id_val, l_actual_userattr_indx, l_date_example);

423: DBMS_SQL.DEFINE_COLUMN(l_cursor_attr_id_val, l_actual_userattr_indx, l_varchar_example, 1000);
424: ELSIF (l_data_type_code = 'N') THEN
425: DBMS_SQL.DEFINE_COLUMN(l_cursor_attr_id_val, l_actual_userattr_indx, l_number_example);
426: ELSE --IF (l_data_type_code = 'D') THEN
427: DBMS_SQL.DEFINE_COLUMN(l_cursor_attr_id_val, l_actual_userattr_indx, l_date_example);
428: END IF; --IF (l_data_type_code = 'C') THEN
429: END LOOP; --FOR i IN 1..l_attr_id_table.COUNT LOOP
430: DBMS_SQL.BIND_VARIABLE(l_cursor_attr_id_val,':RESULTFMT_USAGE_ID',p_resultfmt_usage_id);
431: DBMS_SQL.BIND_VARIABLE(l_cursor_attr_id_val,':PROCESS_STATUS',G_PS_IN_PROCESS);

Line 430: DBMS_SQL.BIND_VARIABLE(l_cursor_attr_id_val,':RESULTFMT_USAGE_ID',p_resultfmt_usage_id);

426: ELSE --IF (l_data_type_code = 'D') THEN
427: DBMS_SQL.DEFINE_COLUMN(l_cursor_attr_id_val, l_actual_userattr_indx, l_date_example);
428: END IF; --IF (l_data_type_code = 'C') THEN
429: END LOOP; --FOR i IN 1..l_attr_id_table.COUNT LOOP
430: DBMS_SQL.BIND_VARIABLE(l_cursor_attr_id_val,':RESULTFMT_USAGE_ID',p_resultfmt_usage_id);
431: DBMS_SQL.BIND_VARIABLE(l_cursor_attr_id_val,':PROCESS_STATUS',G_PS_IN_PROCESS);
432:
433: ------------------------------------------------------------------------
434: -- Execute to get the Item User-Defined Attr values.

Line 431: DBMS_SQL.BIND_VARIABLE(l_cursor_attr_id_val,':PROCESS_STATUS',G_PS_IN_PROCESS);

427: DBMS_SQL.DEFINE_COLUMN(l_cursor_attr_id_val, l_actual_userattr_indx, l_date_example);
428: END IF; --IF (l_data_type_code = 'C') THEN
429: END LOOP; --FOR i IN 1..l_attr_id_table.COUNT LOOP
430: DBMS_SQL.BIND_VARIABLE(l_cursor_attr_id_val,':RESULTFMT_USAGE_ID',p_resultfmt_usage_id);
431: DBMS_SQL.BIND_VARIABLE(l_cursor_attr_id_val,':PROCESS_STATUS',G_PS_IN_PROCESS);
432:
433: ------------------------------------------------------------------------
434: -- Execute to get the Item User-Defined Attr values.
435: ------------------------------------------------------------------------

Line 436: l_cursor_execute := DBMS_SQL.EXECUTE(l_cursor_attr_id_val);

432:
433: ------------------------------------------------------------------------
434: -- Execute to get the Item User-Defined Attr values.
435: ------------------------------------------------------------------------
436: l_cursor_execute := DBMS_SQL.EXECUTE(l_cursor_attr_id_val);
437: l_rows_per_attr_grp_indx := 0;
438: -- L_ATTR_GRP_ROW_IDENT := 0; /* commented by sushil for bug 10129629 */
439: ------------------------------------------------------------------------
440: -- Loop for each row found in EBI

Line 444: IF DBMS_SQL.FETCH_ROWS(l_cursor_attr_id_val)>0 THEN

440: -- Loop for each row found in EBI
441: ------------------------------------------------------------------------
442: Write_Conclog('Executing LOOP FOR CURSOR_ATTR_ID_VAL ');
443: LOOP --LOOP FOR CURSOR_ATTR_ID_VAL
444: IF DBMS_SQL.FETCH_ROWS(l_cursor_attr_id_val)>0 THEN
445: ------------------------------------------------------------------------
446: --Increment Row Identifier per (Attribute Group + Row) Combination.
447: ------------------------------------------------------------------------
448: L_ATTR_GRP_ROW_IDENT := L_ATTR_GRP_ROW_IDENT + 1;

Line 452: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 1, l_transaction_id);

448: L_ATTR_GRP_ROW_IDENT := L_ATTR_GRP_ROW_IDENT + 1;
449: ------------------------------------------------------------------------
450: -- First column is Transaction ID.
451: ------------------------------------------------------------------------
452: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 1, l_transaction_id);
453: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 2, l_pk_id_char);
454: -- DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 3, l_site_num_char);
455: FOR i IN 1..l_attr_id_table.COUNT LOOP
456: OPEN c_attr_grp_n_attr_int_names(l_attr_id_table(i),l_attr_group_type);

Line 453: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 2, l_pk_id_char);

449: ------------------------------------------------------------------------
450: -- First column is Transaction ID.
451: ------------------------------------------------------------------------
452: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 1, l_transaction_id);
453: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 2, l_pk_id_char);
454: -- DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 3, l_site_num_char);
455: FOR i IN 1..l_attr_id_table.COUNT LOOP
456: OPEN c_attr_grp_n_attr_int_names(l_attr_id_table(i),l_attr_group_type);
457: FETCH c_attr_grp_n_attr_int_names INTO

Line 454: -- DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 3, l_site_num_char);

450: -- First column is Transaction ID.
451: ------------------------------------------------------------------------
452: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 1, l_transaction_id);
453: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 2, l_pk_id_char);
454: -- DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 3, l_site_num_char);
455: FOR i IN 1..l_attr_id_table.COUNT LOOP
456: OPEN c_attr_grp_n_attr_int_names(l_attr_id_table(i),l_attr_group_type);
457: FETCH c_attr_grp_n_attr_int_names INTO
458: l_attr_group_int_name, l_attr_int_name;

Line 482: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, l_actual_userattr_indx, l_varchar_data);

478: -- Depending upon the Data Type, populate corresponding field in the
479: -- User-Defined Attribute Data record.
480: ------------------------------------------------------------------------
481: IF (l_usr_attr_data_tbl(l_rows_per_attr_grp_indx).ATTR_DATATYPE_CODE = 'C') THEN
482: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, l_actual_userattr_indx, l_varchar_data);
483: l_usr_attr_data_tbl(l_rows_per_attr_grp_indx).ATTR_VALUE_STR := l_varchar_data;
484: ELSIF (l_usr_attr_data_tbl(l_rows_per_attr_grp_indx).ATTR_DATATYPE_CODE = 'N') THEN
485: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, l_actual_userattr_indx, l_number_data);
486: l_usr_attr_data_tbl(l_rows_per_attr_grp_indx).ATTR_VALUE_NUM := l_number_data;

Line 485: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, l_actual_userattr_indx, l_number_data);

481: IF (l_usr_attr_data_tbl(l_rows_per_attr_grp_indx).ATTR_DATATYPE_CODE = 'C') THEN
482: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, l_actual_userattr_indx, l_varchar_data);
483: l_usr_attr_data_tbl(l_rows_per_attr_grp_indx).ATTR_VALUE_STR := l_varchar_data;
484: ELSIF (l_usr_attr_data_tbl(l_rows_per_attr_grp_indx).ATTR_DATATYPE_CODE = 'N') THEN
485: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, l_actual_userattr_indx, l_number_data);
486: l_usr_attr_data_tbl(l_rows_per_attr_grp_indx).ATTR_VALUE_NUM := l_number_data;
487: ELSE --IF (l_usr_attr_data_tbl(l_rows_per_attr_grp_indx).ATTR_DATATYPE_CODE = 'D') THEN
488: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, l_actual_userattr_indx, l_date_data);
489: l_usr_attr_data_tbl(l_rows_per_attr_grp_indx).ATTR_VALUE_DATE := l_date_data;

Line 488: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, l_actual_userattr_indx, l_date_data);

484: ELSIF (l_usr_attr_data_tbl(l_rows_per_attr_grp_indx).ATTR_DATATYPE_CODE = 'N') THEN
485: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, l_actual_userattr_indx, l_number_data);
486: l_usr_attr_data_tbl(l_rows_per_attr_grp_indx).ATTR_VALUE_NUM := l_number_data;
487: ELSE --IF (l_usr_attr_data_tbl(l_rows_per_attr_grp_indx).ATTR_DATATYPE_CODE = 'D') THEN
488: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, l_actual_userattr_indx, l_date_data);
489: l_usr_attr_data_tbl(l_rows_per_attr_grp_indx).ATTR_VALUE_DATE := l_date_data;
490: END IF; --end: IF (l_usr_attr_data_tbl(l_rows_per_attr_grp_indx).ATTR_DATATYPE_CODE = 'C') THEN
491: l_usr_attr_data_tbl(l_rows_per_attr_grp_indx).INTF_COLUMN_NAME := l_intf_col_name_table(i);
492: ------------------------------------------------------------------------

Line 511: ELSE --end: IF DBMS_SQL.FETCH_ROWS(l_cursor_attr_id_val)>0 THEN

507: END IF; --end: IF ((l_usr_attr_data_tbl(l_rows_per_attr_grp_indx).ATTR_VALUE_STR...
508: END IF; --end: IF c_attr_grp_n_attr_int_names%FOUND THEN
509: CLOSE c_attr_grp_n_attr_int_names;
510: END LOOP; --end: FOR i IN 1..l_attr_id_table.COUNT LOOP
511: ELSE --end: IF DBMS_SQL.FETCH_ROWS(l_cursor_attr_id_val)>0 THEN
512: Write_Conclog('No Rows Found (or) All rows are Done.');
513: EXIT;
514: END IF; --IF DBMS_SQL.FETCH_ROWS(l_cursor_attr_id_val)>0 THEN
515: END LOOP; --END: LOOP FOR CURSOR_ATTR_ID_VAL

Line 514: END IF; --IF DBMS_SQL.FETCH_ROWS(l_cursor_attr_id_val)>0 THEN

510: END LOOP; --end: FOR i IN 1..l_attr_id_table.COUNT LOOP
511: ELSE --end: IF DBMS_SQL.FETCH_ROWS(l_cursor_attr_id_val)>0 THEN
512: Write_Conclog('No Rows Found (or) All rows are Done.');
513: EXIT;
514: END IF; --IF DBMS_SQL.FETCH_ROWS(l_cursor_attr_id_val)>0 THEN
515: END LOOP; --END: LOOP FOR CURSOR_ATTR_ID_VAL
516: l_attr_id_table.DELETE;
517: l_intf_col_name_table.DELETE;
518: ------------------------------------------------------------------------

Line 519: DBMS_SQL.CLOSE_CURSOR(l_cursor_attr_id_val);

515: END LOOP; --END: LOOP FOR CURSOR_ATTR_ID_VAL
516: l_attr_id_table.DELETE;
517: l_intf_col_name_table.DELETE;
518: ------------------------------------------------------------------------
519: DBMS_SQL.CLOSE_CURSOR(l_cursor_attr_id_val);
520: -------------------------------------------------------------------
521: -- Loop for all the rows to be inserted per Attribute Group.
522: -------------------------------------------------------------------
523: FOR i IN 1..l_rows_per_attr_grp_indx LOOP