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_ITEM_PEOPLE_IMPORT_PKG dependencies on DBMS_SQL

Line 560: l_item_id_table DBMS_SQL.NUMBER_TABLE;

556: -- cursor_insert INTEGER;
557: -- Bug 13637215 comment out End
558: cursor_select INTEGER;
559: cursor_execute INTEGER;
560: l_item_id_table DBMS_SQL.NUMBER_TABLE;
561: l_org_id_table DBMS_SQL.NUMBER_TABLE;
562: l_conc_req_id_table DBMS_SQL.NUMBER_TABLE;
563: indx NUMBER(10) := 1;
564:

Line 561: l_org_id_table DBMS_SQL.NUMBER_TABLE;

557: -- Bug 13637215 comment out End
558: cursor_select INTEGER;
559: cursor_execute INTEGER;
560: l_item_id_table DBMS_SQL.NUMBER_TABLE;
561: l_org_id_table DBMS_SQL.NUMBER_TABLE;
562: l_conc_req_id_table DBMS_SQL.NUMBER_TABLE;
563: indx NUMBER(10) := 1;
564:
565: l_program_name VARCHAR2(99) := 'INITIALIZE_ACCESS_ITEMS';

Line 562: l_conc_req_id_table DBMS_SQL.NUMBER_TABLE;

558: cursor_select INTEGER;
559: cursor_execute INTEGER;
560: l_item_id_table DBMS_SQL.NUMBER_TABLE;
561: l_org_id_table DBMS_SQL.NUMBER_TABLE;
562: l_conc_req_id_table DBMS_SQL.NUMBER_TABLE;
563: indx NUMBER(10) := 1;
564:
565: l_program_name VARCHAR2(99) := 'INITIALIZE_ACCESS_ITEMS';
566:

Line 703: cursor_select := DBMS_SQL.OPEN_CURSOR;

699: l_insert_sql := l_insert_sql || ' VALUES (:l_item_id_table, :l_org_id_table, :l_conc_req_id_table) ';
700: */
701: --Bug 13637215 comment out end
702:
703: cursor_select := DBMS_SQL.OPEN_CURSOR;
704: -- Bug 13637215 comment out cursor_insert := DBMS_SQL.OPEN_CURSOR;
705: DBMS_SQL.PARSE(cursor_select,l_select_sql,DBMS_SQL.NATIVE);
706: DBMS_SQL.BIND_VARIABLE( cursor_select, ':o', l_object_id ); --Bug 13637215 BINDING
707: DBMS_SQL.BIND_VARIABLE( cursor_select, ':u', l_user_name ); --Bug 13637215 BINDING

Line 704: -- Bug 13637215 comment out cursor_insert := DBMS_SQL.OPEN_CURSOR;

700: */
701: --Bug 13637215 comment out end
702:
703: cursor_select := DBMS_SQL.OPEN_CURSOR;
704: -- Bug 13637215 comment out cursor_insert := DBMS_SQL.OPEN_CURSOR;
705: DBMS_SQL.PARSE(cursor_select,l_select_sql,DBMS_SQL.NATIVE);
706: DBMS_SQL.BIND_VARIABLE( cursor_select, ':o', l_object_id ); --Bug 13637215 BINDING
707: DBMS_SQL.BIND_VARIABLE( cursor_select, ':u', l_user_name ); --Bug 13637215 BINDING
708: DBMS_SQL.BIND_VARIABLE( cursor_select, ':g', l_group_info ); --Bug 13637215 BINDING

Line 705: DBMS_SQL.PARSE(cursor_select,l_select_sql,DBMS_SQL.NATIVE);

701: --Bug 13637215 comment out end
702:
703: cursor_select := DBMS_SQL.OPEN_CURSOR;
704: -- Bug 13637215 comment out cursor_insert := DBMS_SQL.OPEN_CURSOR;
705: DBMS_SQL.PARSE(cursor_select,l_select_sql,DBMS_SQL.NATIVE);
706: DBMS_SQL.BIND_VARIABLE( cursor_select, ':o', l_object_id ); --Bug 13637215 BINDING
707: DBMS_SQL.BIND_VARIABLE( cursor_select, ':u', l_user_name ); --Bug 13637215 BINDING
708: DBMS_SQL.BIND_VARIABLE( cursor_select, ':g', l_group_info ); --Bug 13637215 BINDING
709: DBMS_SQL.BIND_VARIABLE( cursor_select, ':c', l_company_info ); --Bug 13637215 BINDING

Line 706: DBMS_SQL.BIND_VARIABLE( cursor_select, ':o', l_object_id ); --Bug 13637215 BINDING

702:
703: cursor_select := DBMS_SQL.OPEN_CURSOR;
704: -- Bug 13637215 comment out cursor_insert := DBMS_SQL.OPEN_CURSOR;
705: DBMS_SQL.PARSE(cursor_select,l_select_sql,DBMS_SQL.NATIVE);
706: DBMS_SQL.BIND_VARIABLE( cursor_select, ':o', l_object_id ); --Bug 13637215 BINDING
707: DBMS_SQL.BIND_VARIABLE( cursor_select, ':u', l_user_name ); --Bug 13637215 BINDING
708: DBMS_SQL.BIND_VARIABLE( cursor_select, ':g', l_group_info ); --Bug 13637215 BINDING
709: DBMS_SQL.BIND_VARIABLE( cursor_select, ':c', l_company_info ); --Bug 13637215 BINDING
710: -- Bug 13637215 comment out DBMS_SQL.PARSE(cursor_insert,l_insert_sql,DBMS_SQL.NATIVE);

Line 707: DBMS_SQL.BIND_VARIABLE( cursor_select, ':u', l_user_name ); --Bug 13637215 BINDING

703: cursor_select := DBMS_SQL.OPEN_CURSOR;
704: -- Bug 13637215 comment out cursor_insert := DBMS_SQL.OPEN_CURSOR;
705: DBMS_SQL.PARSE(cursor_select,l_select_sql,DBMS_SQL.NATIVE);
706: DBMS_SQL.BIND_VARIABLE( cursor_select, ':o', l_object_id ); --Bug 13637215 BINDING
707: DBMS_SQL.BIND_VARIABLE( cursor_select, ':u', l_user_name ); --Bug 13637215 BINDING
708: DBMS_SQL.BIND_VARIABLE( cursor_select, ':g', l_group_info ); --Bug 13637215 BINDING
709: DBMS_SQL.BIND_VARIABLE( cursor_select, ':c', l_company_info ); --Bug 13637215 BINDING
710: -- Bug 13637215 comment out DBMS_SQL.PARSE(cursor_insert,l_insert_sql,DBMS_SQL.NATIVE);
711:

Line 708: DBMS_SQL.BIND_VARIABLE( cursor_select, ':g', l_group_info ); --Bug 13637215 BINDING

704: -- Bug 13637215 comment out cursor_insert := DBMS_SQL.OPEN_CURSOR;
705: DBMS_SQL.PARSE(cursor_select,l_select_sql,DBMS_SQL.NATIVE);
706: DBMS_SQL.BIND_VARIABLE( cursor_select, ':o', l_object_id ); --Bug 13637215 BINDING
707: DBMS_SQL.BIND_VARIABLE( cursor_select, ':u', l_user_name ); --Bug 13637215 BINDING
708: DBMS_SQL.BIND_VARIABLE( cursor_select, ':g', l_group_info ); --Bug 13637215 BINDING
709: DBMS_SQL.BIND_VARIABLE( cursor_select, ':c', l_company_info ); --Bug 13637215 BINDING
710: -- Bug 13637215 comment out DBMS_SQL.PARSE(cursor_insert,l_insert_sql,DBMS_SQL.NATIVE);
711:
712: DBMS_SQL.DEFINE_ARRAY(cursor_select, 1,l_item_id_table, 2500, indx);

Line 709: DBMS_SQL.BIND_VARIABLE( cursor_select, ':c', l_company_info ); --Bug 13637215 BINDING

705: DBMS_SQL.PARSE(cursor_select,l_select_sql,DBMS_SQL.NATIVE);
706: DBMS_SQL.BIND_VARIABLE( cursor_select, ':o', l_object_id ); --Bug 13637215 BINDING
707: DBMS_SQL.BIND_VARIABLE( cursor_select, ':u', l_user_name ); --Bug 13637215 BINDING
708: DBMS_SQL.BIND_VARIABLE( cursor_select, ':g', l_group_info ); --Bug 13637215 BINDING
709: DBMS_SQL.BIND_VARIABLE( cursor_select, ':c', l_company_info ); --Bug 13637215 BINDING
710: -- Bug 13637215 comment out DBMS_SQL.PARSE(cursor_insert,l_insert_sql,DBMS_SQL.NATIVE);
711:
712: DBMS_SQL.DEFINE_ARRAY(cursor_select, 1,l_item_id_table, 2500, indx);
713: DBMS_SQL.DEFINE_ARRAY(cursor_select, 2,l_org_id_table, 2500, indx);

Line 710: -- Bug 13637215 comment out DBMS_SQL.PARSE(cursor_insert,l_insert_sql,DBMS_SQL.NATIVE);

706: DBMS_SQL.BIND_VARIABLE( cursor_select, ':o', l_object_id ); --Bug 13637215 BINDING
707: DBMS_SQL.BIND_VARIABLE( cursor_select, ':u', l_user_name ); --Bug 13637215 BINDING
708: DBMS_SQL.BIND_VARIABLE( cursor_select, ':g', l_group_info ); --Bug 13637215 BINDING
709: DBMS_SQL.BIND_VARIABLE( cursor_select, ':c', l_company_info ); --Bug 13637215 BINDING
710: -- Bug 13637215 comment out DBMS_SQL.PARSE(cursor_insert,l_insert_sql,DBMS_SQL.NATIVE);
711:
712: DBMS_SQL.DEFINE_ARRAY(cursor_select, 1,l_item_id_table, 2500, indx);
713: DBMS_SQL.DEFINE_ARRAY(cursor_select, 2,l_org_id_table, 2500, indx);
714: DBMS_SQL.DEFINE_ARRAY(cursor_select, 3,l_conc_req_id_table,2500, indx);

Line 712: DBMS_SQL.DEFINE_ARRAY(cursor_select, 1,l_item_id_table, 2500, indx);

708: DBMS_SQL.BIND_VARIABLE( cursor_select, ':g', l_group_info ); --Bug 13637215 BINDING
709: DBMS_SQL.BIND_VARIABLE( cursor_select, ':c', l_company_info ); --Bug 13637215 BINDING
710: -- Bug 13637215 comment out DBMS_SQL.PARSE(cursor_insert,l_insert_sql,DBMS_SQL.NATIVE);
711:
712: DBMS_SQL.DEFINE_ARRAY(cursor_select, 1,l_item_id_table, 2500, indx);
713: DBMS_SQL.DEFINE_ARRAY(cursor_select, 2,l_org_id_table, 2500, indx);
714: DBMS_SQL.DEFINE_ARRAY(cursor_select, 3,l_conc_req_id_table,2500, indx);
715:
716: Write_Debug('Select Access Items execute...');

Line 713: DBMS_SQL.DEFINE_ARRAY(cursor_select, 2,l_org_id_table, 2500, indx);

709: DBMS_SQL.BIND_VARIABLE( cursor_select, ':c', l_company_info ); --Bug 13637215 BINDING
710: -- Bug 13637215 comment out DBMS_SQL.PARSE(cursor_insert,l_insert_sql,DBMS_SQL.NATIVE);
711:
712: DBMS_SQL.DEFINE_ARRAY(cursor_select, 1,l_item_id_table, 2500, indx);
713: DBMS_SQL.DEFINE_ARRAY(cursor_select, 2,l_org_id_table, 2500, indx);
714: DBMS_SQL.DEFINE_ARRAY(cursor_select, 3,l_conc_req_id_table,2500, indx);
715:
716: Write_Debug('Select Access Items execute...');
717: cursor_execute := DBMS_SQL.EXECUTE(cursor_select);

Line 714: DBMS_SQL.DEFINE_ARRAY(cursor_select, 3,l_conc_req_id_table,2500, indx);

710: -- Bug 13637215 comment out DBMS_SQL.PARSE(cursor_insert,l_insert_sql,DBMS_SQL.NATIVE);
711:
712: DBMS_SQL.DEFINE_ARRAY(cursor_select, 1,l_item_id_table, 2500, indx);
713: DBMS_SQL.DEFINE_ARRAY(cursor_select, 2,l_org_id_table, 2500, indx);
714: DBMS_SQL.DEFINE_ARRAY(cursor_select, 3,l_conc_req_id_table,2500, indx);
715:
716: Write_Debug('Select Access Items execute...');
717: cursor_execute := DBMS_SQL.EXECUTE(cursor_select);
718:

Line 717: cursor_execute := DBMS_SQL.EXECUTE(cursor_select);

713: DBMS_SQL.DEFINE_ARRAY(cursor_select, 2,l_org_id_table, 2500, indx);
714: DBMS_SQL.DEFINE_ARRAY(cursor_select, 3,l_conc_req_id_table,2500, indx);
715:
716: Write_Debug('Select Access Items execute...');
717: cursor_execute := DBMS_SQL.EXECUTE(cursor_select);
718:
719: LOOP
720: l_count := DBMS_SQL.FETCH_ROWS(cursor_select);
721: DBMS_SQL.COLUMN_VALUE(cursor_select, 1, l_item_id_table);

Line 720: l_count := DBMS_SQL.FETCH_ROWS(cursor_select);

716: Write_Debug('Select Access Items execute...');
717: cursor_execute := DBMS_SQL.EXECUTE(cursor_select);
718:
719: LOOP
720: l_count := DBMS_SQL.FETCH_ROWS(cursor_select);
721: DBMS_SQL.COLUMN_VALUE(cursor_select, 1, l_item_id_table);
722: DBMS_SQL.COLUMN_VALUE(cursor_select, 2, l_org_id_table);
723: DBMS_SQL.COLUMN_VALUE(cursor_select, 3, l_conc_req_id_table);
724:

Line 721: DBMS_SQL.COLUMN_VALUE(cursor_select, 1, l_item_id_table);

717: cursor_execute := DBMS_SQL.EXECUTE(cursor_select);
718:
719: LOOP
720: l_count := DBMS_SQL.FETCH_ROWS(cursor_select);
721: DBMS_SQL.COLUMN_VALUE(cursor_select, 1, l_item_id_table);
722: DBMS_SQL.COLUMN_VALUE(cursor_select, 2, l_org_id_table);
723: DBMS_SQL.COLUMN_VALUE(cursor_select, 3, l_conc_req_id_table);
724:
725: -- Bug 13637215 comment out DBMS_SQL.BIND_ARRAY(cursor_insert,':l_item_id_table',l_item_id_table);

Line 722: DBMS_SQL.COLUMN_VALUE(cursor_select, 2, l_org_id_table);

718:
719: LOOP
720: l_count := DBMS_SQL.FETCH_ROWS(cursor_select);
721: DBMS_SQL.COLUMN_VALUE(cursor_select, 1, l_item_id_table);
722: DBMS_SQL.COLUMN_VALUE(cursor_select, 2, l_org_id_table);
723: DBMS_SQL.COLUMN_VALUE(cursor_select, 3, l_conc_req_id_table);
724:
725: -- Bug 13637215 comment out DBMS_SQL.BIND_ARRAY(cursor_insert,':l_item_id_table',l_item_id_table);
726: -- Bug 13637215 comment out DBMS_SQL.BIND_ARRAY(cursor_insert,':l_org_id_table',l_org_id_table);

Line 723: DBMS_SQL.COLUMN_VALUE(cursor_select, 3, l_conc_req_id_table);

719: LOOP
720: l_count := DBMS_SQL.FETCH_ROWS(cursor_select);
721: DBMS_SQL.COLUMN_VALUE(cursor_select, 1, l_item_id_table);
722: DBMS_SQL.COLUMN_VALUE(cursor_select, 2, l_org_id_table);
723: DBMS_SQL.COLUMN_VALUE(cursor_select, 3, l_conc_req_id_table);
724:
725: -- Bug 13637215 comment out DBMS_SQL.BIND_ARRAY(cursor_insert,':l_item_id_table',l_item_id_table);
726: -- Bug 13637215 comment out DBMS_SQL.BIND_ARRAY(cursor_insert,':l_org_id_table',l_org_id_table);
727: -- Bug 13637215 comment out DBMS_SQL.BIND_ARRAY(cursor_insert,':l_conc_req_id_table',l_conc_req_id_table);

Line 725: -- Bug 13637215 comment out DBMS_SQL.BIND_ARRAY(cursor_insert,':l_item_id_table',l_item_id_table);

721: DBMS_SQL.COLUMN_VALUE(cursor_select, 1, l_item_id_table);
722: DBMS_SQL.COLUMN_VALUE(cursor_select, 2, l_org_id_table);
723: DBMS_SQL.COLUMN_VALUE(cursor_select, 3, l_conc_req_id_table);
724:
725: -- Bug 13637215 comment out DBMS_SQL.BIND_ARRAY(cursor_insert,':l_item_id_table',l_item_id_table);
726: -- Bug 13637215 comment out DBMS_SQL.BIND_ARRAY(cursor_insert,':l_org_id_table',l_org_id_table);
727: -- Bug 13637215 comment out DBMS_SQL.BIND_ARRAY(cursor_insert,':l_conc_req_id_table',l_conc_req_id_table);
728:
729: -- Bug 13637215 comment out Write_Debug('Inserting ''Access Items'' into table');

Line 726: -- Bug 13637215 comment out DBMS_SQL.BIND_ARRAY(cursor_insert,':l_org_id_table',l_org_id_table);

722: DBMS_SQL.COLUMN_VALUE(cursor_select, 2, l_org_id_table);
723: DBMS_SQL.COLUMN_VALUE(cursor_select, 3, l_conc_req_id_table);
724:
725: -- Bug 13637215 comment out DBMS_SQL.BIND_ARRAY(cursor_insert,':l_item_id_table',l_item_id_table);
726: -- Bug 13637215 comment out DBMS_SQL.BIND_ARRAY(cursor_insert,':l_org_id_table',l_org_id_table);
727: -- Bug 13637215 comment out DBMS_SQL.BIND_ARRAY(cursor_insert,':l_conc_req_id_table',l_conc_req_id_table);
728:
729: -- Bug 13637215 comment out Write_Debug('Inserting ''Access Items'' into table');
730: -- Bug 13637215 comment out cursor_execute := DBMS_SQL.EXECUTE(cursor_insert);

Line 727: -- Bug 13637215 comment out DBMS_SQL.BIND_ARRAY(cursor_insert,':l_conc_req_id_table',l_conc_req_id_table);

723: DBMS_SQL.COLUMN_VALUE(cursor_select, 3, l_conc_req_id_table);
724:
725: -- Bug 13637215 comment out DBMS_SQL.BIND_ARRAY(cursor_insert,':l_item_id_table',l_item_id_table);
726: -- Bug 13637215 comment out DBMS_SQL.BIND_ARRAY(cursor_insert,':l_org_id_table',l_org_id_table);
727: -- Bug 13637215 comment out DBMS_SQL.BIND_ARRAY(cursor_insert,':l_conc_req_id_table',l_conc_req_id_table);
728:
729: -- Bug 13637215 comment out Write_Debug('Inserting ''Access Items'' into table');
730: -- Bug 13637215 comment out cursor_execute := DBMS_SQL.EXECUTE(cursor_insert);
731: l_item_id_table.DELETE;

Line 730: -- Bug 13637215 comment out cursor_execute := DBMS_SQL.EXECUTE(cursor_insert);

726: -- Bug 13637215 comment out DBMS_SQL.BIND_ARRAY(cursor_insert,':l_org_id_table',l_org_id_table);
727: -- Bug 13637215 comment out DBMS_SQL.BIND_ARRAY(cursor_insert,':l_conc_req_id_table',l_conc_req_id_table);
728:
729: -- Bug 13637215 comment out Write_Debug('Inserting ''Access Items'' into table');
730: -- Bug 13637215 comment out cursor_execute := DBMS_SQL.EXECUTE(cursor_insert);
731: l_item_id_table.DELETE;
732: l_org_id_table.DELETE;
733: l_conc_req_id_table.DELETE;
734:

Line 739: DBMS_SQL.CLOSE_CURSOR(cursor_select);

735: --For the final batch of records, either it will be 0 or < 2500
736: EXIT WHEN l_count <> 2500;
737: END LOOP;
738:
739: DBMS_SQL.CLOSE_CURSOR(cursor_select);
740: -- Bug 13637215 comment out DBMS_SQL.CLOSE_CURSOR(cursor_insert);
741: -- Bug 13637215 BINDING End
742:
743: Write_Debug('Cursors Insert Access Items and Select Access Items closed...');

Line 740: -- Bug 13637215 comment out DBMS_SQL.CLOSE_CURSOR(cursor_insert);

736: EXIT WHEN l_count <> 2500;
737: END LOOP;
738:
739: DBMS_SQL.CLOSE_CURSOR(cursor_select);
740: -- Bug 13637215 comment out DBMS_SQL.CLOSE_CURSOR(cursor_insert);
741: -- Bug 13637215 BINDING End
742:
743: Write_Debug('Cursors Insert Access Items and Select Access Items closed...');
744: EXCEPTION

Line 748: IF DBMS_SQL.IS_OPEN(cursor_select) THEN

744: EXCEPTION
745: WHEN OTHERS THEN
746: Write_Debug(' EXCEPTION in Initialize_Access_items');
747: x_retcode := RETCODE_ERROR;
748: IF DBMS_SQL.IS_OPEN(cursor_select) THEN
749: DBMS_SQL.CLOSE_CURSOR(cursor_select);
750: END IF;
751: -- Bug 13637215 comment out Start
752: /*

Line 749: DBMS_SQL.CLOSE_CURSOR(cursor_select);

745: WHEN OTHERS THEN
746: Write_Debug(' EXCEPTION in Initialize_Access_items');
747: x_retcode := RETCODE_ERROR;
748: IF DBMS_SQL.IS_OPEN(cursor_select) THEN
749: DBMS_SQL.CLOSE_CURSOR(cursor_select);
750: END IF;
751: -- Bug 13637215 comment out Start
752: /*
753: IF DBMS_SQL.IS_OPEN(cursor_insert) THEN

Line 753: IF DBMS_SQL.IS_OPEN(cursor_insert) THEN

749: DBMS_SQL.CLOSE_CURSOR(cursor_select);
750: END IF;
751: -- Bug 13637215 comment out Start
752: /*
753: IF DBMS_SQL.IS_OPEN(cursor_insert) THEN
754: DBMS_SQL.CLOSE_CURSOR(cursor_insert);
755: END IF;
756: */
757: -- Bug 13637215 comment out End

Line 754: DBMS_SQL.CLOSE_CURSOR(cursor_insert);

750: END IF;
751: -- Bug 13637215 comment out Start
752: /*
753: IF DBMS_SQL.IS_OPEN(cursor_insert) THEN
754: DBMS_SQL.CLOSE_CURSOR(cursor_insert);
755: END IF;
756: */
757: -- Bug 13637215 comment out End
758: RAISE;

Line 2931: cursor_update := DBMS_SQL.OPEN_CURSOR;

2927:
2928:
2929: l_update_sql := l_update_sql || l_select_sql || ' ) ';
2930: Write_Debug('l_update_sql: '|| l_update_sql);
2931: cursor_update := DBMS_SQL.OPEN_CURSOR;
2932: DBMS_SQL.PARSE(cursor_update, l_update_sql, DBMS_SQL.NATIVE);
2933: DBMS_SQL.BIND_VARIABLE( cursor_update, ':e', G_PS_ERROR ); --Bug 13637215 BINDING
2934: DBMS_SQL.BIND_VARIABLE( cursor_update, ':d', G_DATA_SET_ID ); --Bug 13637215 BINDING
2935: DBMS_SQL.BIND_VARIABLE( cursor_update, ':f', G_FROM_LINE_NUMBER ); --Bug 13637215 BINDING

Line 2932: DBMS_SQL.PARSE(cursor_update, l_update_sql, DBMS_SQL.NATIVE);

2928:
2929: l_update_sql := l_update_sql || l_select_sql || ' ) ';
2930: Write_Debug('l_update_sql: '|| l_update_sql);
2931: cursor_update := DBMS_SQL.OPEN_CURSOR;
2932: DBMS_SQL.PARSE(cursor_update, l_update_sql, DBMS_SQL.NATIVE);
2933: DBMS_SQL.BIND_VARIABLE( cursor_update, ':e', G_PS_ERROR ); --Bug 13637215 BINDING
2934: DBMS_SQL.BIND_VARIABLE( cursor_update, ':d', G_DATA_SET_ID ); --Bug 13637215 BINDING
2935: DBMS_SQL.BIND_VARIABLE( cursor_update, ':f', G_FROM_LINE_NUMBER ); --Bug 13637215 BINDING
2936: DBMS_SQL.BIND_VARIABLE( cursor_update, ':t', G_TO_LINE_NUMBER ); --Bug 13637215 BINDING

Line 2933: DBMS_SQL.BIND_VARIABLE( cursor_update, ':e', G_PS_ERROR ); --Bug 13637215 BINDING

2929: l_update_sql := l_update_sql || l_select_sql || ' ) ';
2930: Write_Debug('l_update_sql: '|| l_update_sql);
2931: cursor_update := DBMS_SQL.OPEN_CURSOR;
2932: DBMS_SQL.PARSE(cursor_update, l_update_sql, DBMS_SQL.NATIVE);
2933: DBMS_SQL.BIND_VARIABLE( cursor_update, ':e', G_PS_ERROR ); --Bug 13637215 BINDING
2934: DBMS_SQL.BIND_VARIABLE( cursor_update, ':d', G_DATA_SET_ID ); --Bug 13637215 BINDING
2935: DBMS_SQL.BIND_VARIABLE( cursor_update, ':f', G_FROM_LINE_NUMBER ); --Bug 13637215 BINDING
2936: DBMS_SQL.BIND_VARIABLE( cursor_update, ':t', G_TO_LINE_NUMBER ); --Bug 13637215 BINDING
2937: DBMS_SQL.BIND_VARIABLE( cursor_update, ':p', G_PS_IN_PROCESS ); --Bug 13637215 BINDING

Line 2934: DBMS_SQL.BIND_VARIABLE( cursor_update, ':d', G_DATA_SET_ID ); --Bug 13637215 BINDING

2930: Write_Debug('l_update_sql: '|| l_update_sql);
2931: cursor_update := DBMS_SQL.OPEN_CURSOR;
2932: DBMS_SQL.PARSE(cursor_update, l_update_sql, DBMS_SQL.NATIVE);
2933: DBMS_SQL.BIND_VARIABLE( cursor_update, ':e', G_PS_ERROR ); --Bug 13637215 BINDING
2934: DBMS_SQL.BIND_VARIABLE( cursor_update, ':d', G_DATA_SET_ID ); --Bug 13637215 BINDING
2935: DBMS_SQL.BIND_VARIABLE( cursor_update, ':f', G_FROM_LINE_NUMBER ); --Bug 13637215 BINDING
2936: DBMS_SQL.BIND_VARIABLE( cursor_update, ':t', G_TO_LINE_NUMBER ); --Bug 13637215 BINDING
2937: DBMS_SQL.BIND_VARIABLE( cursor_update, ':p', G_PS_IN_PROCESS ); --Bug 13637215 BINDING
2938: DBMS_SQL.BIND_VARIABLE( cursor_update, ':o', l_object_id ); --Bug 13637215 BINDING

Line 2935: DBMS_SQL.BIND_VARIABLE( cursor_update, ':f', G_FROM_LINE_NUMBER ); --Bug 13637215 BINDING

2931: cursor_update := DBMS_SQL.OPEN_CURSOR;
2932: DBMS_SQL.PARSE(cursor_update, l_update_sql, DBMS_SQL.NATIVE);
2933: DBMS_SQL.BIND_VARIABLE( cursor_update, ':e', G_PS_ERROR ); --Bug 13637215 BINDING
2934: DBMS_SQL.BIND_VARIABLE( cursor_update, ':d', G_DATA_SET_ID ); --Bug 13637215 BINDING
2935: DBMS_SQL.BIND_VARIABLE( cursor_update, ':f', G_FROM_LINE_NUMBER ); --Bug 13637215 BINDING
2936: DBMS_SQL.BIND_VARIABLE( cursor_update, ':t', G_TO_LINE_NUMBER ); --Bug 13637215 BINDING
2937: DBMS_SQL.BIND_VARIABLE( cursor_update, ':p', G_PS_IN_PROCESS ); --Bug 13637215 BINDING
2938: DBMS_SQL.BIND_VARIABLE( cursor_update, ':o', l_object_id ); --Bug 13637215 BINDING
2939: DBMS_SQL.BIND_VARIABLE( cursor_update, ':u', l_user_name ); --Bug 13637215 BINDING

Line 2936: DBMS_SQL.BIND_VARIABLE( cursor_update, ':t', G_TO_LINE_NUMBER ); --Bug 13637215 BINDING

2932: DBMS_SQL.PARSE(cursor_update, l_update_sql, DBMS_SQL.NATIVE);
2933: DBMS_SQL.BIND_VARIABLE( cursor_update, ':e', G_PS_ERROR ); --Bug 13637215 BINDING
2934: DBMS_SQL.BIND_VARIABLE( cursor_update, ':d', G_DATA_SET_ID ); --Bug 13637215 BINDING
2935: DBMS_SQL.BIND_VARIABLE( cursor_update, ':f', G_FROM_LINE_NUMBER ); --Bug 13637215 BINDING
2936: DBMS_SQL.BIND_VARIABLE( cursor_update, ':t', G_TO_LINE_NUMBER ); --Bug 13637215 BINDING
2937: DBMS_SQL.BIND_VARIABLE( cursor_update, ':p', G_PS_IN_PROCESS ); --Bug 13637215 BINDING
2938: DBMS_SQL.BIND_VARIABLE( cursor_update, ':o', l_object_id ); --Bug 13637215 BINDING
2939: DBMS_SQL.BIND_VARIABLE( cursor_update, ':u', l_user_name ); --Bug 13637215 BINDING
2940: DBMS_SQL.BIND_VARIABLE( cursor_update, ':g', l_group_info ); --Bug 13637215 BINDING

Line 2937: DBMS_SQL.BIND_VARIABLE( cursor_update, ':p', G_PS_IN_PROCESS ); --Bug 13637215 BINDING

2933: DBMS_SQL.BIND_VARIABLE( cursor_update, ':e', G_PS_ERROR ); --Bug 13637215 BINDING
2934: DBMS_SQL.BIND_VARIABLE( cursor_update, ':d', G_DATA_SET_ID ); --Bug 13637215 BINDING
2935: DBMS_SQL.BIND_VARIABLE( cursor_update, ':f', G_FROM_LINE_NUMBER ); --Bug 13637215 BINDING
2936: DBMS_SQL.BIND_VARIABLE( cursor_update, ':t', G_TO_LINE_NUMBER ); --Bug 13637215 BINDING
2937: DBMS_SQL.BIND_VARIABLE( cursor_update, ':p', G_PS_IN_PROCESS ); --Bug 13637215 BINDING
2938: DBMS_SQL.BIND_VARIABLE( cursor_update, ':o', l_object_id ); --Bug 13637215 BINDING
2939: DBMS_SQL.BIND_VARIABLE( cursor_update, ':u', l_user_name ); --Bug 13637215 BINDING
2940: DBMS_SQL.BIND_VARIABLE( cursor_update, ':g', l_group_info ); --Bug 13637215 BINDING
2941: DBMS_SQL.BIND_VARIABLE( cursor_update, ':c', l_company_info ); --Bug 13637215 BINDING

Line 2938: DBMS_SQL.BIND_VARIABLE( cursor_update, ':o', l_object_id ); --Bug 13637215 BINDING

2934: DBMS_SQL.BIND_VARIABLE( cursor_update, ':d', G_DATA_SET_ID ); --Bug 13637215 BINDING
2935: DBMS_SQL.BIND_VARIABLE( cursor_update, ':f', G_FROM_LINE_NUMBER ); --Bug 13637215 BINDING
2936: DBMS_SQL.BIND_VARIABLE( cursor_update, ':t', G_TO_LINE_NUMBER ); --Bug 13637215 BINDING
2937: DBMS_SQL.BIND_VARIABLE( cursor_update, ':p', G_PS_IN_PROCESS ); --Bug 13637215 BINDING
2938: DBMS_SQL.BIND_VARIABLE( cursor_update, ':o', l_object_id ); --Bug 13637215 BINDING
2939: DBMS_SQL.BIND_VARIABLE( cursor_update, ':u', l_user_name ); --Bug 13637215 BINDING
2940: DBMS_SQL.BIND_VARIABLE( cursor_update, ':g', l_group_info ); --Bug 13637215 BINDING
2941: DBMS_SQL.BIND_VARIABLE( cursor_update, ':c', l_company_info ); --Bug 13637215 BINDING
2942: cursor_execute := DBMS_SQL.EXECUTE(cursor_update);

Line 2939: DBMS_SQL.BIND_VARIABLE( cursor_update, ':u', l_user_name ); --Bug 13637215 BINDING

2935: DBMS_SQL.BIND_VARIABLE( cursor_update, ':f', G_FROM_LINE_NUMBER ); --Bug 13637215 BINDING
2936: DBMS_SQL.BIND_VARIABLE( cursor_update, ':t', G_TO_LINE_NUMBER ); --Bug 13637215 BINDING
2937: DBMS_SQL.BIND_VARIABLE( cursor_update, ':p', G_PS_IN_PROCESS ); --Bug 13637215 BINDING
2938: DBMS_SQL.BIND_VARIABLE( cursor_update, ':o', l_object_id ); --Bug 13637215 BINDING
2939: DBMS_SQL.BIND_VARIABLE( cursor_update, ':u', l_user_name ); --Bug 13637215 BINDING
2940: DBMS_SQL.BIND_VARIABLE( cursor_update, ':g', l_group_info ); --Bug 13637215 BINDING
2941: DBMS_SQL.BIND_VARIABLE( cursor_update, ':c', l_company_info ); --Bug 13637215 BINDING
2942: cursor_execute := DBMS_SQL.EXECUTE(cursor_update);
2943: DBMS_SQL.CLOSE_CURSOR(cursor_update);

Line 2940: DBMS_SQL.BIND_VARIABLE( cursor_update, ':g', l_group_info ); --Bug 13637215 BINDING

2936: DBMS_SQL.BIND_VARIABLE( cursor_update, ':t', G_TO_LINE_NUMBER ); --Bug 13637215 BINDING
2937: DBMS_SQL.BIND_VARIABLE( cursor_update, ':p', G_PS_IN_PROCESS ); --Bug 13637215 BINDING
2938: DBMS_SQL.BIND_VARIABLE( cursor_update, ':o', l_object_id ); --Bug 13637215 BINDING
2939: DBMS_SQL.BIND_VARIABLE( cursor_update, ':u', l_user_name ); --Bug 13637215 BINDING
2940: DBMS_SQL.BIND_VARIABLE( cursor_update, ':g', l_group_info ); --Bug 13637215 BINDING
2941: DBMS_SQL.BIND_VARIABLE( cursor_update, ':c', l_company_info ); --Bug 13637215 BINDING
2942: cursor_execute := DBMS_SQL.EXECUTE(cursor_update);
2943: DBMS_SQL.CLOSE_CURSOR(cursor_update);
2944: -- Bug 13637215 modification end

Line 2941: DBMS_SQL.BIND_VARIABLE( cursor_update, ':c', l_company_info ); --Bug 13637215 BINDING

2937: DBMS_SQL.BIND_VARIABLE( cursor_update, ':p', G_PS_IN_PROCESS ); --Bug 13637215 BINDING
2938: DBMS_SQL.BIND_VARIABLE( cursor_update, ':o', l_object_id ); --Bug 13637215 BINDING
2939: DBMS_SQL.BIND_VARIABLE( cursor_update, ':u', l_user_name ); --Bug 13637215 BINDING
2940: DBMS_SQL.BIND_VARIABLE( cursor_update, ':g', l_group_info ); --Bug 13637215 BINDING
2941: DBMS_SQL.BIND_VARIABLE( cursor_update, ':c', l_company_info ); --Bug 13637215 BINDING
2942: cursor_execute := DBMS_SQL.EXECUTE(cursor_update);
2943: DBMS_SQL.CLOSE_CURSOR(cursor_update);
2944: -- Bug 13637215 modification end
2945:

Line 2942: cursor_execute := DBMS_SQL.EXECUTE(cursor_update);

2938: DBMS_SQL.BIND_VARIABLE( cursor_update, ':o', l_object_id ); --Bug 13637215 BINDING
2939: DBMS_SQL.BIND_VARIABLE( cursor_update, ':u', l_user_name ); --Bug 13637215 BINDING
2940: DBMS_SQL.BIND_VARIABLE( cursor_update, ':g', l_group_info ); --Bug 13637215 BINDING
2941: DBMS_SQL.BIND_VARIABLE( cursor_update, ':c', l_company_info ); --Bug 13637215 BINDING
2942: cursor_execute := DBMS_SQL.EXECUTE(cursor_update);
2943: DBMS_SQL.CLOSE_CURSOR(cursor_update);
2944: -- Bug 13637215 modification end
2945:
2946: Write_Debug('Flashing messages for all items on which user does not have any privilege ');

Line 2943: DBMS_SQL.CLOSE_CURSOR(cursor_update);

2939: DBMS_SQL.BIND_VARIABLE( cursor_update, ':u', l_user_name ); --Bug 13637215 BINDING
2940: DBMS_SQL.BIND_VARIABLE( cursor_update, ':g', l_group_info ); --Bug 13637215 BINDING
2941: DBMS_SQL.BIND_VARIABLE( cursor_update, ':c', l_company_info ); --Bug 13637215 BINDING
2942: cursor_execute := DBMS_SQL.EXECUTE(cursor_update);
2943: DBMS_SQL.CLOSE_CURSOR(cursor_update);
2944: -- Bug 13637215 modification end
2945:
2946: Write_Debug('Flashing messages for all items on which user does not have any privilege ');
2947: FOR cr IN c_err_access_items LOOP

Line 3088: IF DBMS_SQL.IS_OPEN(cursor_update) THEN

3084: Conc_Output (p_msg => x_errbuff);
3085: Write_Debug (x_errbuff ||': Details => ' || SQLERRM(SQLCODE));
3086:
3087: -- Bug 13637215 Start
3088: IF DBMS_SQL.IS_OPEN(cursor_update) THEN
3089: DBMS_SQL.CLOSE_CURSOR(cursor_update);
3090: END IF;
3091: -- Bug 13637215 End
3092:

Line 3089: DBMS_SQL.CLOSE_CURSOR(cursor_update);

3085: Write_Debug (x_errbuff ||': Details => ' || SQLERRM(SQLCODE));
3086:
3087: -- Bug 13637215 Start
3088: IF DBMS_SQL.IS_OPEN(cursor_update) THEN
3089: DBMS_SQL.CLOSE_CURSOR(cursor_update);
3090: END IF;
3091: -- Bug 13637215 End
3092:
3093: IF c_user_party_id%ISOPEN THEN