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

Line 464: l_attr_id_table DBMS_SQL.NUMBER_TABLE;

460: TYPE VARCHAR_TBL_TYPE IS TABLE OF VARCHAR2(256)
461: INDEX BY BINARY_INTEGER;
462: l_prod_col_name_tbl VARCHAR_TBL_TYPE;
463: l_intf_col_name_tbl VARCHAR_TBL_TYPE;
464: l_attr_id_table DBMS_SQL.NUMBER_TABLE;
465: l_intf_col_name_table DBMS_SQL.VARCHAR2_TABLE;
466: l_usr_attr_data_tbl L_USER_ATTR_TBL_TYPE;
467: l_pk_id_char VARCHAR(15);
468: l_pk1_id_char VARCHAR(15);

Line 465: l_intf_col_name_table DBMS_SQL.VARCHAR2_TABLE;

461: INDEX BY BINARY_INTEGER;
462: l_prod_col_name_tbl VARCHAR_TBL_TYPE;
463: l_intf_col_name_tbl VARCHAR_TBL_TYPE;
464: l_attr_id_table DBMS_SQL.NUMBER_TABLE;
465: l_intf_col_name_table DBMS_SQL.VARCHAR2_TABLE;
466: l_usr_attr_data_tbl L_USER_ATTR_TBL_TYPE;
467: l_pk_id_char VARCHAR(15);
468: l_pk1_id_char VARCHAR(15);
469: l_pk2_id_char VARCHAR(15);

Line 484: l_attr_group_id_table DBMS_SQL.NUMBER_TABLE;

480: l_attr_int_name EGO_ATTRS_V.ATTR_NAME%TYPE;
481:
482: l_attr_group_id NUMBER(15);
483: l_party_id NUMBER(15);
484: l_attr_group_id_table DBMS_SQL.NUMBER_TABLE;
485: ---------------------------------------------------------
486: -- Example Data Types to be used in Bind Variable.
487: ---------------------------------------------------------
488: l_varchar_example VARCHAR2(10000);

Line 498: -- DBMS_SQL Open Cursor integers.

494: l_varchar_data VARCHAR2(10000);
495: l_number_data NUMBER;
496: l_date_data DATE;
497: ---------------------------------------------------------
498: -- DBMS_SQL Open Cursor integers.
499: ---------------------------------------------------------
500: l_cursor_select INTEGER;
501: l_cursor_execute INTEGER;
502: l_cursor_attr_id_val INTEGER;

Line 557: l_cursor_select := DBMS_SQL.OPEN_CURSOR;

553: 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 ';
554: l_dyn_sql := l_dyn_sql || ' FROM ego_results_fmt_usages ';
555: l_dyn_sql := l_dyn_sql || ' WHERE resultfmt_usage_id = :RESULTFMT_USAGE_ID';
556: l_dyn_sql := l_dyn_sql || ' AND attribute_code LIKE :ATTRIBUTE_CODE ';
557: l_cursor_select := DBMS_SQL.OPEN_CURSOR;
558: DBMS_SQL.PARSE(l_cursor_select, l_dyn_sql, DBMS_SQL.NATIVE);
559: DBMS_SQL.DEFINE_ARRAY(l_cursor_select, 1,l_attr_id_table,2500, l_temp);
560: DBMS_SQL.DEFINE_ARRAY(l_cursor_select, 2,l_intf_col_name_table,2500, l_temp);
561: DBMS_SQL.DEFINE_ARRAY(l_cursor_select, 3,l_attr_group_id_table,2500, l_temp);

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

554: l_dyn_sql := l_dyn_sql || ' FROM ego_results_fmt_usages ';
555: l_dyn_sql := l_dyn_sql || ' WHERE resultfmt_usage_id = :RESULTFMT_USAGE_ID';
556: l_dyn_sql := l_dyn_sql || ' AND attribute_code LIKE :ATTRIBUTE_CODE ';
557: l_cursor_select := DBMS_SQL.OPEN_CURSOR;
558: DBMS_SQL.PARSE(l_cursor_select, l_dyn_sql, DBMS_SQL.NATIVE);
559: DBMS_SQL.DEFINE_ARRAY(l_cursor_select, 1,l_attr_id_table,2500, l_temp);
560: DBMS_SQL.DEFINE_ARRAY(l_cursor_select, 2,l_intf_col_name_table,2500, l_temp);
561: DBMS_SQL.DEFINE_ARRAY(l_cursor_select, 3,l_attr_group_id_table,2500, l_temp);
562:

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

555: l_dyn_sql := l_dyn_sql || ' WHERE resultfmt_usage_id = :RESULTFMT_USAGE_ID';
556: l_dyn_sql := l_dyn_sql || ' AND attribute_code LIKE :ATTRIBUTE_CODE ';
557: l_cursor_select := DBMS_SQL.OPEN_CURSOR;
558: DBMS_SQL.PARSE(l_cursor_select, l_dyn_sql, DBMS_SQL.NATIVE);
559: DBMS_SQL.DEFINE_ARRAY(l_cursor_select, 1,l_attr_id_table,2500, l_temp);
560: DBMS_SQL.DEFINE_ARRAY(l_cursor_select, 2,l_intf_col_name_table,2500, l_temp);
561: DBMS_SQL.DEFINE_ARRAY(l_cursor_select, 3,l_attr_group_id_table,2500, l_temp);
562:
563:

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

556: l_dyn_sql := l_dyn_sql || ' AND attribute_code LIKE :ATTRIBUTE_CODE ';
557: l_cursor_select := DBMS_SQL.OPEN_CURSOR;
558: DBMS_SQL.PARSE(l_cursor_select, l_dyn_sql, DBMS_SQL.NATIVE);
559: DBMS_SQL.DEFINE_ARRAY(l_cursor_select, 1,l_attr_id_table,2500, l_temp);
560: DBMS_SQL.DEFINE_ARRAY(l_cursor_select, 2,l_intf_col_name_table,2500, l_temp);
561: DBMS_SQL.DEFINE_ARRAY(l_cursor_select, 3,l_attr_group_id_table,2500, l_temp);
562:
563:
564: DBMS_SQL.BIND_VARIABLE(l_cursor_select,':RESULTFMT_USAGE_ID', p_resultfmt_usage_id);

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

557: l_cursor_select := DBMS_SQL.OPEN_CURSOR;
558: DBMS_SQL.PARSE(l_cursor_select, l_dyn_sql, DBMS_SQL.NATIVE);
559: DBMS_SQL.DEFINE_ARRAY(l_cursor_select, 1,l_attr_id_table,2500, l_temp);
560: DBMS_SQL.DEFINE_ARRAY(l_cursor_select, 2,l_intf_col_name_table,2500, l_temp);
561: DBMS_SQL.DEFINE_ARRAY(l_cursor_select, 3,l_attr_group_id_table,2500, l_temp);
562:
563:
564: DBMS_SQL.BIND_VARIABLE(l_cursor_select,':RESULTFMT_USAGE_ID', p_resultfmt_usage_id);
565: DBMS_SQL.BIND_VARIABLE(l_cursor_select,':ATTRIBUTE_CODE', c_attr_grp_rec.attr_group_id||'$$%');

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

560: DBMS_SQL.DEFINE_ARRAY(l_cursor_select, 2,l_intf_col_name_table,2500, l_temp);
561: DBMS_SQL.DEFINE_ARRAY(l_cursor_select, 3,l_attr_group_id_table,2500, l_temp);
562:
563:
564: DBMS_SQL.BIND_VARIABLE(l_cursor_select,':RESULTFMT_USAGE_ID', p_resultfmt_usage_id);
565: DBMS_SQL.BIND_VARIABLE(l_cursor_select,':ATTRIBUTE_CODE', c_attr_grp_rec.attr_group_id||'$$%');
566: l_cursor_execute := DBMS_SQL.EXECUTE(l_cursor_select);
567:
568: l_count := DBMS_SQL.FETCH_ROWS(l_cursor_select);

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

561: DBMS_SQL.DEFINE_ARRAY(l_cursor_select, 3,l_attr_group_id_table,2500, l_temp);
562:
563:
564: DBMS_SQL.BIND_VARIABLE(l_cursor_select,':RESULTFMT_USAGE_ID', p_resultfmt_usage_id);
565: DBMS_SQL.BIND_VARIABLE(l_cursor_select,':ATTRIBUTE_CODE', c_attr_grp_rec.attr_group_id||'$$%');
566: l_cursor_execute := DBMS_SQL.EXECUTE(l_cursor_select);
567:
568: l_count := DBMS_SQL.FETCH_ROWS(l_cursor_select);
569: DBMS_SQL.COLUMN_VALUE(l_cursor_select, 1, l_attr_id_table);

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

562:
563:
564: DBMS_SQL.BIND_VARIABLE(l_cursor_select,':RESULTFMT_USAGE_ID', p_resultfmt_usage_id);
565: DBMS_SQL.BIND_VARIABLE(l_cursor_select,':ATTRIBUTE_CODE', c_attr_grp_rec.attr_group_id||'$$%');
566: l_cursor_execute := DBMS_SQL.EXECUTE(l_cursor_select);
567:
568: l_count := DBMS_SQL.FETCH_ROWS(l_cursor_select);
569: DBMS_SQL.COLUMN_VALUE(l_cursor_select, 1, l_attr_id_table);
570: DBMS_SQL.COLUMN_VALUE(l_cursor_select, 2, l_intf_col_name_table);

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

564: DBMS_SQL.BIND_VARIABLE(l_cursor_select,':RESULTFMT_USAGE_ID', p_resultfmt_usage_id);
565: DBMS_SQL.BIND_VARIABLE(l_cursor_select,':ATTRIBUTE_CODE', c_attr_grp_rec.attr_group_id||'$$%');
566: l_cursor_execute := DBMS_SQL.EXECUTE(l_cursor_select);
567:
568: l_count := DBMS_SQL.FETCH_ROWS(l_cursor_select);
569: DBMS_SQL.COLUMN_VALUE(l_cursor_select, 1, l_attr_id_table);
570: DBMS_SQL.COLUMN_VALUE(l_cursor_select, 2, l_intf_col_name_table);
571: DBMS_SQL.COLUMN_VALUE(l_cursor_select, 3, l_attr_group_id_table);
572:

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

565: DBMS_SQL.BIND_VARIABLE(l_cursor_select,':ATTRIBUTE_CODE', c_attr_grp_rec.attr_group_id||'$$%');
566: l_cursor_execute := DBMS_SQL.EXECUTE(l_cursor_select);
567:
568: l_count := DBMS_SQL.FETCH_ROWS(l_cursor_select);
569: DBMS_SQL.COLUMN_VALUE(l_cursor_select, 1, l_attr_id_table);
570: DBMS_SQL.COLUMN_VALUE(l_cursor_select, 2, l_intf_col_name_table);
571: DBMS_SQL.COLUMN_VALUE(l_cursor_select, 3, l_attr_group_id_table);
572:
573:

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

566: l_cursor_execute := DBMS_SQL.EXECUTE(l_cursor_select);
567:
568: l_count := DBMS_SQL.FETCH_ROWS(l_cursor_select);
569: DBMS_SQL.COLUMN_VALUE(l_cursor_select, 1, l_attr_id_table);
570: DBMS_SQL.COLUMN_VALUE(l_cursor_select, 2, l_intf_col_name_table);
571: DBMS_SQL.COLUMN_VALUE(l_cursor_select, 3, l_attr_group_id_table);
572:
573:
574:

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

567:
568: l_count := DBMS_SQL.FETCH_ROWS(l_cursor_select);
569: DBMS_SQL.COLUMN_VALUE(l_cursor_select, 1, l_attr_id_table);
570: DBMS_SQL.COLUMN_VALUE(l_cursor_select, 2, l_intf_col_name_table);
571: DBMS_SQL.COLUMN_VALUE(l_cursor_select, 3, l_attr_group_id_table);
572:
573:
574:
575: DBMS_SQL.CLOSE_CURSOR(l_cursor_select);

Line 575: DBMS_SQL.CLOSE_CURSOR(l_cursor_select);

571: DBMS_SQL.COLUMN_VALUE(l_cursor_select, 3, l_attr_group_id_table);
572:
573:
574:
575: DBMS_SQL.CLOSE_CURSOR(l_cursor_select);
576: --------------------------------------------------------------------
577: -- New DBMS_SQL Cursor for Select Attr Values.
578: --------------------------------------------------------------------
579: l_cursor_attr_id_val := DBMS_SQL.OPEN_CURSOR;

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

573:
574:
575: DBMS_SQL.CLOSE_CURSOR(l_cursor_select);
576: --------------------------------------------------------------------
577: -- New DBMS_SQL Cursor for Select Attr Values.
578: --------------------------------------------------------------------
579: l_cursor_attr_id_val := DBMS_SQL.OPEN_CURSOR;
580: l_dyn_attr_id_val_sql := '';
581: l_dyn_attr_id_val_sql := ' SELECT ';

Line 579: l_cursor_attr_id_val := DBMS_SQL.OPEN_CURSOR;

575: DBMS_SQL.CLOSE_CURSOR(l_cursor_select);
576: --------------------------------------------------------------------
577: -- New DBMS_SQL Cursor for Select Attr Values.
578: --------------------------------------------------------------------
579: l_cursor_attr_id_val := DBMS_SQL.OPEN_CURSOR;
580: l_dyn_attr_id_val_sql := '';
581: l_dyn_attr_id_val_sql := ' SELECT ';
582: l_dyn_attr_id_val_sql := l_dyn_attr_id_val_sql || ' TRANSACTION_ID , ';
583: --Bug 16384042 since always pass SUPP_ADDR_SITE as p_entity_name parameter, always get the most number of PKs whether used or not determined by datalevel

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

603: END LOOP; --end: FOR i IN 1..l_attr_id_table.COUNT LOOP
604: l_dyn_attr_id_val_sql := l_dyn_attr_id_val_sql || ' FROM EGO_BULKLOAD_INTF ' ;
605: l_dyn_attr_id_val_sql := l_dyn_attr_id_val_sql || ' WHERE RESULTFMT_USAGE_ID = :RESULTFMT_USAGE_ID';
606: l_dyn_attr_id_val_sql := l_dyn_attr_id_val_sql || ' AND PROCESS_STATUS = :PROCESS_STATUS ';
607: DBMS_SQL.PARSE(l_cursor_attr_id_val, l_dyn_attr_id_val_sql, DBMS_SQL.NATIVE);
608: --------------------------------------------------------------------
609: --Setting Data Type for Trasaction ID
610: --------------------------------------------------------------------
611: DBMS_SQL.DEFINE_COLUMN(l_cursor_attr_id_val, 1, l_number_example);

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

607: DBMS_SQL.PARSE(l_cursor_attr_id_val, l_dyn_attr_id_val_sql, DBMS_SQL.NATIVE);
608: --------------------------------------------------------------------
609: --Setting Data Type for Trasaction ID
610: --------------------------------------------------------------------
611: DBMS_SQL.DEFINE_COLUMN(l_cursor_attr_id_val, 1, l_number_example);
612: --------------------------------------------------------------------
613: --Setting Data Type for INSTANCE_PKx_VALUE
614: -- Also since TRANSACTION_ID, INSTANCE_PK1_VALUE, INSTANCE_PK2_VALUE,
615: -- INSTANCE_PK3_VALUE,INSTANCE_PK4_VALUE are added to the SELECT before the User-Defined

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

616: -- Attrs, we need to adjust the index as follows.
617: ------------------------------------------------------------------------
618:
619: IF p_entity_name = 'SUPP' THEN
620: DBMS_SQL.DEFINE_COLUMN(l_cursor_attr_id_val, 2, l_varchar_example, 1000);
621: DBMS_SQL.DEFINE_COLUMN(l_cursor_attr_id_val, 3, l_varchar_example, 1000);
622: l_userattr_indx_adj := 3;
623: ELSIF p_entity_name = 'SUPP_ADDR' THEN
624: DBMS_SQL.DEFINE_COLUMN(l_cursor_attr_id_val, 2, l_varchar_example, 1000);

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

617: ------------------------------------------------------------------------
618:
619: IF p_entity_name = 'SUPP' THEN
620: DBMS_SQL.DEFINE_COLUMN(l_cursor_attr_id_val, 2, l_varchar_example, 1000);
621: DBMS_SQL.DEFINE_COLUMN(l_cursor_attr_id_val, 3, l_varchar_example, 1000);
622: l_userattr_indx_adj := 3;
623: ELSIF p_entity_name = 'SUPP_ADDR' THEN
624: DBMS_SQL.DEFINE_COLUMN(l_cursor_attr_id_val, 2, l_varchar_example, 1000);
625: DBMS_SQL.DEFINE_COLUMN(l_cursor_attr_id_val, 3, l_varchar_example, 1000);

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

620: DBMS_SQL.DEFINE_COLUMN(l_cursor_attr_id_val, 2, l_varchar_example, 1000);
621: DBMS_SQL.DEFINE_COLUMN(l_cursor_attr_id_val, 3, l_varchar_example, 1000);
622: l_userattr_indx_adj := 3;
623: ELSIF p_entity_name = 'SUPP_ADDR' THEN
624: DBMS_SQL.DEFINE_COLUMN(l_cursor_attr_id_val, 2, l_varchar_example, 1000);
625: DBMS_SQL.DEFINE_COLUMN(l_cursor_attr_id_val, 3, l_varchar_example, 1000);
626: DBMS_SQL.DEFINE_COLUMN(l_cursor_attr_id_val, 4, l_varchar_example, 1000);
627: l_userattr_indx_adj := 4;
628: ELSIF p_entity_name = 'SUPP_ADDR_SITE' THEN

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

621: DBMS_SQL.DEFINE_COLUMN(l_cursor_attr_id_val, 3, l_varchar_example, 1000);
622: l_userattr_indx_adj := 3;
623: ELSIF p_entity_name = 'SUPP_ADDR' THEN
624: DBMS_SQL.DEFINE_COLUMN(l_cursor_attr_id_val, 2, l_varchar_example, 1000);
625: DBMS_SQL.DEFINE_COLUMN(l_cursor_attr_id_val, 3, l_varchar_example, 1000);
626: DBMS_SQL.DEFINE_COLUMN(l_cursor_attr_id_val, 4, l_varchar_example, 1000);
627: l_userattr_indx_adj := 4;
628: ELSIF p_entity_name = 'SUPP_ADDR_SITE' THEN
629: DBMS_SQL.DEFINE_COLUMN(l_cursor_attr_id_val, 2, l_varchar_example, 1000);

Line 626: DBMS_SQL.DEFINE_COLUMN(l_cursor_attr_id_val, 4, l_varchar_example, 1000);

622: l_userattr_indx_adj := 3;
623: ELSIF p_entity_name = 'SUPP_ADDR' THEN
624: DBMS_SQL.DEFINE_COLUMN(l_cursor_attr_id_val, 2, l_varchar_example, 1000);
625: DBMS_SQL.DEFINE_COLUMN(l_cursor_attr_id_val, 3, l_varchar_example, 1000);
626: DBMS_SQL.DEFINE_COLUMN(l_cursor_attr_id_val, 4, l_varchar_example, 1000);
627: l_userattr_indx_adj := 4;
628: ELSIF p_entity_name = 'SUPP_ADDR_SITE' THEN
629: DBMS_SQL.DEFINE_COLUMN(l_cursor_attr_id_val, 2, l_varchar_example, 1000);
630: DBMS_SQL.DEFINE_COLUMN(l_cursor_attr_id_val, 3, l_varchar_example, 1000);

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

625: DBMS_SQL.DEFINE_COLUMN(l_cursor_attr_id_val, 3, l_varchar_example, 1000);
626: DBMS_SQL.DEFINE_COLUMN(l_cursor_attr_id_val, 4, l_varchar_example, 1000);
627: l_userattr_indx_adj := 4;
628: ELSIF p_entity_name = 'SUPP_ADDR_SITE' THEN
629: DBMS_SQL.DEFINE_COLUMN(l_cursor_attr_id_val, 2, l_varchar_example, 1000);
630: DBMS_SQL.DEFINE_COLUMN(l_cursor_attr_id_val, 3, l_varchar_example, 1000);
631: DBMS_SQL.DEFINE_COLUMN(l_cursor_attr_id_val, 4, l_varchar_example, 1000);
632: DBMS_SQL.DEFINE_COLUMN(l_cursor_attr_id_val, 5, l_varchar_example, 1000);
633: l_userattr_indx_adj := 5;

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

626: DBMS_SQL.DEFINE_COLUMN(l_cursor_attr_id_val, 4, l_varchar_example, 1000);
627: l_userattr_indx_adj := 4;
628: ELSIF p_entity_name = 'SUPP_ADDR_SITE' THEN
629: DBMS_SQL.DEFINE_COLUMN(l_cursor_attr_id_val, 2, l_varchar_example, 1000);
630: DBMS_SQL.DEFINE_COLUMN(l_cursor_attr_id_val, 3, l_varchar_example, 1000);
631: DBMS_SQL.DEFINE_COLUMN(l_cursor_attr_id_val, 4, l_varchar_example, 1000);
632: DBMS_SQL.DEFINE_COLUMN(l_cursor_attr_id_val, 5, l_varchar_example, 1000);
633: l_userattr_indx_adj := 5;
634: END IF; -- p_entity_name

Line 631: DBMS_SQL.DEFINE_COLUMN(l_cursor_attr_id_val, 4, l_varchar_example, 1000);

627: l_userattr_indx_adj := 4;
628: ELSIF p_entity_name = 'SUPP_ADDR_SITE' THEN
629: DBMS_SQL.DEFINE_COLUMN(l_cursor_attr_id_val, 2, l_varchar_example, 1000);
630: DBMS_SQL.DEFINE_COLUMN(l_cursor_attr_id_val, 3, l_varchar_example, 1000);
631: DBMS_SQL.DEFINE_COLUMN(l_cursor_attr_id_val, 4, l_varchar_example, 1000);
632: DBMS_SQL.DEFINE_COLUMN(l_cursor_attr_id_val, 5, l_varchar_example, 1000);
633: l_userattr_indx_adj := 5;
634: END IF; -- p_entity_name
635:

Line 632: DBMS_SQL.DEFINE_COLUMN(l_cursor_attr_id_val, 5, l_varchar_example, 1000);

628: ELSIF p_entity_name = 'SUPP_ADDR_SITE' THEN
629: DBMS_SQL.DEFINE_COLUMN(l_cursor_attr_id_val, 2, l_varchar_example, 1000);
630: DBMS_SQL.DEFINE_COLUMN(l_cursor_attr_id_val, 3, l_varchar_example, 1000);
631: DBMS_SQL.DEFINE_COLUMN(l_cursor_attr_id_val, 4, l_varchar_example, 1000);
632: DBMS_SQL.DEFINE_COLUMN(l_cursor_attr_id_val, 5, l_varchar_example, 1000);
633: l_userattr_indx_adj := 5;
634: END IF; -- p_entity_name
635:
636:

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

647: ------------------------------------------------------------------------
648: -- Based on the Data Type of the attribute, define the column
649: ------------------------------------------------------------------------
650: IF (l_data_type_code = 'C') THEN
651: DBMS_SQL.DEFINE_COLUMN(l_cursor_attr_id_val, l_actual_userattr_indx, l_varchar_example, 1000);
652: ELSIF (l_data_type_code = 'N') THEN
653: DBMS_SQL.DEFINE_COLUMN(l_cursor_attr_id_val, l_actual_userattr_indx, l_number_example);
654: ELSE --IF (l_data_type_code = 'D') THEN
655: DBMS_SQL.DEFINE_COLUMN(l_cursor_attr_id_val, l_actual_userattr_indx, l_date_example);

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

649: ------------------------------------------------------------------------
650: IF (l_data_type_code = 'C') THEN
651: DBMS_SQL.DEFINE_COLUMN(l_cursor_attr_id_val, l_actual_userattr_indx, l_varchar_example, 1000);
652: ELSIF (l_data_type_code = 'N') THEN
653: DBMS_SQL.DEFINE_COLUMN(l_cursor_attr_id_val, l_actual_userattr_indx, l_number_example);
654: ELSE --IF (l_data_type_code = 'D') THEN
655: DBMS_SQL.DEFINE_COLUMN(l_cursor_attr_id_val, l_actual_userattr_indx, l_date_example);
656: END IF; --IF (l_data_type_code = 'C') THEN
657: END LOOP; --FOR i IN 1..l_attr_id_table.COUNT LOOP

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

651: DBMS_SQL.DEFINE_COLUMN(l_cursor_attr_id_val, l_actual_userattr_indx, l_varchar_example, 1000);
652: ELSIF (l_data_type_code = 'N') THEN
653: DBMS_SQL.DEFINE_COLUMN(l_cursor_attr_id_val, l_actual_userattr_indx, l_number_example);
654: ELSE --IF (l_data_type_code = 'D') THEN
655: DBMS_SQL.DEFINE_COLUMN(l_cursor_attr_id_val, l_actual_userattr_indx, l_date_example);
656: END IF; --IF (l_data_type_code = 'C') THEN
657: END LOOP; --FOR i IN 1..l_attr_id_table.COUNT LOOP
658: DBMS_SQL.BIND_VARIABLE(l_cursor_attr_id_val,':RESULTFMT_USAGE_ID',p_resultfmt_usage_id);
659: DBMS_SQL.BIND_VARIABLE(l_cursor_attr_id_val,':PROCESS_STATUS',G_PS_IN_PROCESS); -- 2

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

654: ELSE --IF (l_data_type_code = 'D') THEN
655: DBMS_SQL.DEFINE_COLUMN(l_cursor_attr_id_val, l_actual_userattr_indx, l_date_example);
656: END IF; --IF (l_data_type_code = 'C') THEN
657: END LOOP; --FOR i IN 1..l_attr_id_table.COUNT LOOP
658: DBMS_SQL.BIND_VARIABLE(l_cursor_attr_id_val,':RESULTFMT_USAGE_ID',p_resultfmt_usage_id);
659: DBMS_SQL.BIND_VARIABLE(l_cursor_attr_id_val,':PROCESS_STATUS',G_PS_IN_PROCESS); -- 2
660:
661: ------------------------------------------------------------------------
662: -- Execute to get the Item User-Defined Attr values.

Line 659: DBMS_SQL.BIND_VARIABLE(l_cursor_attr_id_val,':PROCESS_STATUS',G_PS_IN_PROCESS); -- 2

655: DBMS_SQL.DEFINE_COLUMN(l_cursor_attr_id_val, l_actual_userattr_indx, l_date_example);
656: END IF; --IF (l_data_type_code = 'C') THEN
657: END LOOP; --FOR i IN 1..l_attr_id_table.COUNT LOOP
658: DBMS_SQL.BIND_VARIABLE(l_cursor_attr_id_val,':RESULTFMT_USAGE_ID',p_resultfmt_usage_id);
659: DBMS_SQL.BIND_VARIABLE(l_cursor_attr_id_val,':PROCESS_STATUS',G_PS_IN_PROCESS); -- 2
660:
661: ------------------------------------------------------------------------
662: -- Execute to get the Item User-Defined Attr values.
663: ------------------------------------------------------------------------

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

660:
661: ------------------------------------------------------------------------
662: -- Execute to get the Item User-Defined Attr values.
663: ------------------------------------------------------------------------
664: l_cursor_execute := DBMS_SQL.EXECUTE(l_cursor_attr_id_val);
665: l_rows_per_attr_grp_indx := 0;
666: L_ATTR_GRP_ROW_IDENT := 0;
667: ------------------------------------------------------------------------
668: -- Loop for each row found in EBI

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

668: -- Loop for each row found in EBI
669: ------------------------------------------------------------------------
670: Write_Conclog('Executing LOOP FOR CURSOR_ATTR_ID_VAL ');
671: LOOP --LOOP FOR CURSOR_ATTR_ID_VAL
672: IF DBMS_SQL.FETCH_ROWS(l_cursor_attr_id_val)>0 THEN
673: ------------------------------------------------------------------------
674: --Increment Row Identifier per (Attribute Group + Row) Combination.
675: ------------------------------------------------------------------------
676: L_ATTR_GRP_ROW_IDENT := L_ATTR_GRP_ROW_IDENT + 1;

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

678: -- First column is Transaction ID.
679: ------------------------------------------------------------------------
680:
681: IF p_entity_name = 'SUPP' THEN
682: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 1, l_transaction_id);
683: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 2, l_pk1_id_char);
684: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 3, l_pk2_id_char);
685:
686:

Line 683: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 2, l_pk1_id_char);

679: ------------------------------------------------------------------------
680:
681: IF p_entity_name = 'SUPP' THEN
682: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 1, l_transaction_id);
683: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 2, l_pk1_id_char);
684: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 3, l_pk2_id_char);
685:
686:
687: ELSIF p_entity_name = 'SUPP_ADDR' THEN

Line 684: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 3, l_pk2_id_char);

680:
681: IF p_entity_name = 'SUPP' THEN
682: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 1, l_transaction_id);
683: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 2, l_pk1_id_char);
684: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 3, l_pk2_id_char);
685:
686:
687: ELSIF p_entity_name = 'SUPP_ADDR' THEN
688: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 1, l_transaction_id);

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

684: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 3, l_pk2_id_char);
685:
686:
687: ELSIF p_entity_name = 'SUPP_ADDR' THEN
688: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 1, l_transaction_id);
689: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 2, l_pk1_id_char);
690: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 3, l_pk2_id_char);
691: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 4, l_pk3_id_char);
692: ELSIF p_entity_name = 'SUPP_ADDR_SITE' THEN

Line 689: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 2, l_pk1_id_char);

685:
686:
687: ELSIF p_entity_name = 'SUPP_ADDR' THEN
688: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 1, l_transaction_id);
689: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 2, l_pk1_id_char);
690: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 3, l_pk2_id_char);
691: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 4, l_pk3_id_char);
692: ELSIF p_entity_name = 'SUPP_ADDR_SITE' THEN
693: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 1, l_transaction_id);

Line 690: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 3, l_pk2_id_char);

686:
687: ELSIF p_entity_name = 'SUPP_ADDR' THEN
688: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 1, l_transaction_id);
689: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 2, l_pk1_id_char);
690: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 3, l_pk2_id_char);
691: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 4, l_pk3_id_char);
692: ELSIF p_entity_name = 'SUPP_ADDR_SITE' THEN
693: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 1, l_transaction_id);
694: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 2, l_pk1_id_char);

Line 691: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 4, l_pk3_id_char);

687: ELSIF p_entity_name = 'SUPP_ADDR' THEN
688: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 1, l_transaction_id);
689: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 2, l_pk1_id_char);
690: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 3, l_pk2_id_char);
691: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 4, l_pk3_id_char);
692: ELSIF p_entity_name = 'SUPP_ADDR_SITE' THEN
693: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 1, l_transaction_id);
694: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 2, l_pk1_id_char);
695: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 3, l_pk2_id_char);

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

689: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 2, l_pk1_id_char);
690: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 3, l_pk2_id_char);
691: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 4, l_pk3_id_char);
692: ELSIF p_entity_name = 'SUPP_ADDR_SITE' THEN
693: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 1, l_transaction_id);
694: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 2, l_pk1_id_char);
695: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 3, l_pk2_id_char);
696: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 4, l_pk3_id_char);
697: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 5, l_pk4_id_char);

Line 694: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 2, l_pk1_id_char);

690: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 3, l_pk2_id_char);
691: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 4, l_pk3_id_char);
692: ELSIF p_entity_name = 'SUPP_ADDR_SITE' THEN
693: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 1, l_transaction_id);
694: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 2, l_pk1_id_char);
695: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 3, l_pk2_id_char);
696: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 4, l_pk3_id_char);
697: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 5, l_pk4_id_char);
698:

Line 695: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 3, l_pk2_id_char);

691: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 4, l_pk3_id_char);
692: ELSIF p_entity_name = 'SUPP_ADDR_SITE' THEN
693: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 1, l_transaction_id);
694: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 2, l_pk1_id_char);
695: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 3, l_pk2_id_char);
696: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 4, l_pk3_id_char);
697: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 5, l_pk4_id_char);
698:
699: END IF; -- p_entity_name

Line 696: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 4, l_pk3_id_char);

692: ELSIF p_entity_name = 'SUPP_ADDR_SITE' THEN
693: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 1, l_transaction_id);
694: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 2, l_pk1_id_char);
695: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 3, l_pk2_id_char);
696: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 4, l_pk3_id_char);
697: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 5, l_pk4_id_char);
698:
699: END IF; -- p_entity_name
700:

Line 697: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 5, l_pk4_id_char);

693: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 1, l_transaction_id);
694: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 2, l_pk1_id_char);
695: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 3, l_pk2_id_char);
696: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 4, l_pk3_id_char);
697: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, 5, l_pk4_id_char);
698:
699: END IF; -- p_entity_name
700:
701:

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

797: -- Depending upon the Data Type, populate corresponding field in the
798: -- User-Defined Attribute Data record.
799: ------------------------------------------------------------------------
800: IF (l_usr_attr_data_tbl(l_rows_per_attr_grp_indx).ATTR_DATATYPE_CODE = 'C') THEN
801: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, l_actual_userattr_indx, l_varchar_data);
802: l_usr_attr_data_tbl(l_rows_per_attr_grp_indx).ATTR_VALUE_STR := l_varchar_data;
803: ELSIF (l_usr_attr_data_tbl(l_rows_per_attr_grp_indx).ATTR_DATATYPE_CODE = 'N') THEN
804: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, l_actual_userattr_indx, l_number_data);
805: l_usr_attr_data_tbl(l_rows_per_attr_grp_indx).ATTR_VALUE_NUM := l_number_data;

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

800: IF (l_usr_attr_data_tbl(l_rows_per_attr_grp_indx).ATTR_DATATYPE_CODE = 'C') THEN
801: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, l_actual_userattr_indx, l_varchar_data);
802: l_usr_attr_data_tbl(l_rows_per_attr_grp_indx).ATTR_VALUE_STR := l_varchar_data;
803: ELSIF (l_usr_attr_data_tbl(l_rows_per_attr_grp_indx).ATTR_DATATYPE_CODE = 'N') THEN
804: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, l_actual_userattr_indx, l_number_data);
805: l_usr_attr_data_tbl(l_rows_per_attr_grp_indx).ATTR_VALUE_NUM := l_number_data;
806: ELSE --IF (l_usr_attr_data_tbl(l_rows_per_attr_grp_indx).ATTR_DATATYPE_CODE = 'D') THEN
807: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, l_actual_userattr_indx, l_date_data);
808: l_usr_attr_data_tbl(l_rows_per_attr_grp_indx).ATTR_VALUE_DATE := l_date_data;

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

803: ELSIF (l_usr_attr_data_tbl(l_rows_per_attr_grp_indx).ATTR_DATATYPE_CODE = 'N') THEN
804: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, l_actual_userattr_indx, l_number_data);
805: l_usr_attr_data_tbl(l_rows_per_attr_grp_indx).ATTR_VALUE_NUM := l_number_data;
806: ELSE --IF (l_usr_attr_data_tbl(l_rows_per_attr_grp_indx).ATTR_DATATYPE_CODE = 'D') THEN
807: DBMS_SQL.COLUMN_VALUE(l_cursor_attr_id_val, l_actual_userattr_indx, l_date_data);
808: l_usr_attr_data_tbl(l_rows_per_attr_grp_indx).ATTR_VALUE_DATE := l_date_data;
809: END IF; --end: IF (l_usr_attr_data_tbl(l_rows_per_attr_grp_indx).ATTR_DATATYPE_CODE = 'C') THEN
810: l_usr_attr_data_tbl(l_rows_per_attr_grp_indx).INTF_COLUMN_NAME := l_intf_col_name_table(i);
811: ------------------------------------------------------------------------

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

826: END IF; --end: IF ((l_usr_attr_data_tbl(l_rows_per_attr_grp_indx).ATTR_VALUE_STR...
827: END IF; --end: IF c_attr_grp_n_attr_int_names%FOUND THEN
828: CLOSE c_attr_grp_n_attr_int_names;
829: END LOOP; --end: FOR i IN 1..l_attr_id_table.COUNT LOOP
830: ELSE --end: IF DBMS_SQL.FETCH_ROWS(l_cursor_attr_id_val)>0 THEN
831: Write_Conclog('No Rows Found (or) All rows are Done.');
832: EXIT;
833: END IF; --IF DBMS_SQL.FETCH_ROWS(l_cursor_attr_id_val)>0 THEN
834: END LOOP; --END: LOOP FOR CURSOR_ATTR_ID_VAL

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

829: END LOOP; --end: FOR i IN 1..l_attr_id_table.COUNT LOOP
830: ELSE --end: IF DBMS_SQL.FETCH_ROWS(l_cursor_attr_id_val)>0 THEN
831: Write_Conclog('No Rows Found (or) All rows are Done.');
832: EXIT;
833: END IF; --IF DBMS_SQL.FETCH_ROWS(l_cursor_attr_id_val)>0 THEN
834: END LOOP; --END: LOOP FOR CURSOR_ATTR_ID_VAL
835: l_attr_id_table.DELETE;
836: l_intf_col_name_table.DELETE;
837: ------------------------------------------------------------------------

Line 838: DBMS_SQL.CLOSE_CURSOR(l_cursor_attr_id_val);

834: END LOOP; --END: LOOP FOR CURSOR_ATTR_ID_VAL
835: l_attr_id_table.DELETE;
836: l_intf_col_name_table.DELETE;
837: ------------------------------------------------------------------------
838: DBMS_SQL.CLOSE_CURSOR(l_cursor_attr_id_val);
839: -------------------------------------------------------------------
840: -- Loop for all the rows to be inserted per Attribute Group.
841: -------------------------------------------------------------------
842: FOR i IN 1..l_rows_per_attr_grp_indx LOOP