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

Line 387: l_num_exception_id_tab DBMS_SQL.Number_Table;

383: l_ignore NUMBER;
384: l_tempStr VARCHAR2(10000) := ' ';
385:
386: --Declaration Section For Bulk Select PL/SQL Tables
387: l_num_exception_id_tab DBMS_SQL.Number_Table;
388: l_varchar_status_tab DBMS_SQL.Varchar2_Table;
389: l_num_location_id_tab DBMS_SQL.Number_Table;
390: l_num_delivery_id_tab DBMS_SQL.Number_Table;
391: l_varchar_delivery_name_tab DBMS_SQL.Varchar2_Table;

Line 388: l_varchar_status_tab DBMS_SQL.Varchar2_Table;

384: l_tempStr VARCHAR2(10000) := ' ';
385:
386: --Declaration Section For Bulk Select PL/SQL Tables
387: l_num_exception_id_tab DBMS_SQL.Number_Table;
388: l_varchar_status_tab DBMS_SQL.Varchar2_Table;
389: l_num_location_id_tab DBMS_SQL.Number_Table;
390: l_num_delivery_id_tab DBMS_SQL.Number_Table;
391: l_varchar_delivery_name_tab DBMS_SQL.Varchar2_Table;
392:

Line 389: l_num_location_id_tab DBMS_SQL.Number_Table;

385:
386: --Declaration Section For Bulk Select PL/SQL Tables
387: l_num_exception_id_tab DBMS_SQL.Number_Table;
388: l_varchar_status_tab DBMS_SQL.Varchar2_Table;
389: l_num_location_id_tab DBMS_SQL.Number_Table;
390: l_num_delivery_id_tab DBMS_SQL.Number_Table;
391: l_varchar_delivery_name_tab DBMS_SQL.Varchar2_Table;
392:
393: --AJPRABHA for inserting DATA into Transactions History.

Line 390: l_num_delivery_id_tab DBMS_SQL.Number_Table;

386: --Declaration Section For Bulk Select PL/SQL Tables
387: l_num_exception_id_tab DBMS_SQL.Number_Table;
388: l_varchar_status_tab DBMS_SQL.Varchar2_Table;
389: l_num_location_id_tab DBMS_SQL.Number_Table;
390: l_num_delivery_id_tab DBMS_SQL.Number_Table;
391: l_varchar_delivery_name_tab DBMS_SQL.Varchar2_Table;
392:
393: --AJPRABHA for inserting DATA into Transactions History.
394: l_tranx_history_rec WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;

Line 391: l_varchar_delivery_name_tab DBMS_SQL.Varchar2_Table;

387: l_num_exception_id_tab DBMS_SQL.Number_Table;
388: l_varchar_status_tab DBMS_SQL.Varchar2_Table;
389: l_num_location_id_tab DBMS_SQL.Number_Table;
390: l_num_delivery_id_tab DBMS_SQL.Number_Table;
391: l_varchar_delivery_name_tab DBMS_SQL.Varchar2_Table;
392:
393: --AJPRABHA for inserting DATA into Transactions History.
394: l_tranx_history_rec WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;
395: x_txns_id NUMBER;

Line 407: l_num_organization_id_tab DBMS_SQL.Number_Table;

403:
404: --Added for Raising tracking Workflows
405: l_wf_event_name VARCHAR2(1000);
406: l_wf_return_status VARCHAR2(1);
407: l_num_organization_id_tab DBMS_SQL.Number_Table;
408: l_parameter_list wf_parameter_list_t;
409: --BUG 6700736 Added variable to store master_organization_id
410: l_num_master_org_id_tab DBMS_SQL.Number_Table;
411:

Line 410: l_num_master_org_id_tab DBMS_SQL.Number_Table;

406: l_wf_return_status VARCHAR2(1);
407: l_num_organization_id_tab DBMS_SQL.Number_Table;
408: l_parameter_list wf_parameter_list_t;
409: --BUG 6700736 Added variable to store master_organization_id
410: l_num_master_org_id_tab DBMS_SQL.Number_Table;
411:
412: l_debug_on BOOLEAN;
413: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' ||'SCREEN_EVENT_DELIVERIES';
414:

Line 545: l_CursorID := DBMS_SQL.Open_Cursor;

541:
542:
543: -- This sub section executes the query and collects the result set into PL/SQL Tables
544:
545: l_CursorID := DBMS_SQL.Open_Cursor;
546: DBMS_SQL.PARSE(l_CursorID, l_exp_compliance_dlvy_query, DBMS_SQL.v7);
547: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 1, l_num_exception_id_tab, 100, 0);
548: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 2, l_num_location_id_tab, 100, 0);
549: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 3, l_num_delivery_id_tab, 100, 0);

Line 546: DBMS_SQL.PARSE(l_CursorID, l_exp_compliance_dlvy_query, DBMS_SQL.v7);

542:
543: -- This sub section executes the query and collects the result set into PL/SQL Tables
544:
545: l_CursorID := DBMS_SQL.Open_Cursor;
546: DBMS_SQL.PARSE(l_CursorID, l_exp_compliance_dlvy_query, DBMS_SQL.v7);
547: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 1, l_num_exception_id_tab, 100, 0);
548: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 2, l_num_location_id_tab, 100, 0);
549: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 3, l_num_delivery_id_tab, 100, 0);
550: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 4, l_varchar_status_tab, 100, 0);

Line 547: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 1, l_num_exception_id_tab, 100, 0);

543: -- This sub section executes the query and collects the result set into PL/SQL Tables
544:
545: l_CursorID := DBMS_SQL.Open_Cursor;
546: DBMS_SQL.PARSE(l_CursorID, l_exp_compliance_dlvy_query, DBMS_SQL.v7);
547: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 1, l_num_exception_id_tab, 100, 0);
548: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 2, l_num_location_id_tab, 100, 0);
549: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 3, l_num_delivery_id_tab, 100, 0);
550: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 4, l_varchar_status_tab, 100, 0);
551: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 6, l_num_organization_id_tab, 100, 0);

Line 548: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 2, l_num_location_id_tab, 100, 0);

544:
545: l_CursorID := DBMS_SQL.Open_Cursor;
546: DBMS_SQL.PARSE(l_CursorID, l_exp_compliance_dlvy_query, DBMS_SQL.v7);
547: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 1, l_num_exception_id_tab, 100, 0);
548: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 2, l_num_location_id_tab, 100, 0);
549: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 3, l_num_delivery_id_tab, 100, 0);
550: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 4, l_varchar_status_tab, 100, 0);
551: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 6, l_num_organization_id_tab, 100, 0);
552: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 5, l_varchar_delivery_name_tab, 100, 0);

Line 549: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 3, l_num_delivery_id_tab, 100, 0);

545: l_CursorID := DBMS_SQL.Open_Cursor;
546: DBMS_SQL.PARSE(l_CursorID, l_exp_compliance_dlvy_query, DBMS_SQL.v7);
547: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 1, l_num_exception_id_tab, 100, 0);
548: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 2, l_num_location_id_tab, 100, 0);
549: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 3, l_num_delivery_id_tab, 100, 0);
550: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 4, l_varchar_status_tab, 100, 0);
551: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 6, l_num_organization_id_tab, 100, 0);
552: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 5, l_varchar_delivery_name_tab, 100, 0);
553: --Bug 6700736 Defined array for master_organization_id

Line 550: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 4, l_varchar_status_tab, 100, 0);

546: DBMS_SQL.PARSE(l_CursorID, l_exp_compliance_dlvy_query, DBMS_SQL.v7);
547: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 1, l_num_exception_id_tab, 100, 0);
548: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 2, l_num_location_id_tab, 100, 0);
549: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 3, l_num_delivery_id_tab, 100, 0);
550: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 4, l_varchar_status_tab, 100, 0);
551: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 6, l_num_organization_id_tab, 100, 0);
552: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 5, l_varchar_delivery_name_tab, 100, 0);
553: --Bug 6700736 Defined array for master_organization_id
554: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 7, l_num_master_org_id_tab, 100, 0);

Line 551: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 6, l_num_organization_id_tab, 100, 0);

547: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 1, l_num_exception_id_tab, 100, 0);
548: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 2, l_num_location_id_tab, 100, 0);
549: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 3, l_num_delivery_id_tab, 100, 0);
550: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 4, l_varchar_status_tab, 100, 0);
551: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 6, l_num_organization_id_tab, 100, 0);
552: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 5, l_varchar_delivery_name_tab, 100, 0);
553: --Bug 6700736 Defined array for master_organization_id
554: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 7, l_num_master_org_id_tab, 100, 0);
555:

Line 552: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 5, l_varchar_delivery_name_tab, 100, 0);

548: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 2, l_num_location_id_tab, 100, 0);
549: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 3, l_num_delivery_id_tab, 100, 0);
550: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 4, l_varchar_status_tab, 100, 0);
551: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 6, l_num_organization_id_tab, 100, 0);
552: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 5, l_varchar_delivery_name_tab, 100, 0);
553: --Bug 6700736 Defined array for master_organization_id
554: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 7, l_num_master_org_id_tab, 100, 0);
555:
556: WSH_ITM_QUERY_CUSTOM.BIND_VALUES(l_Delivery_Table,l_CursorID);

Line 554: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 7, l_num_master_org_id_tab, 100, 0);

550: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 4, l_varchar_status_tab, 100, 0);
551: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 6, l_num_organization_id_tab, 100, 0);
552: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 5, l_varchar_delivery_name_tab, 100, 0);
553: --Bug 6700736 Defined array for master_organization_id
554: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 7, l_num_master_org_id_tab, 100, 0);
555:
556: WSH_ITM_QUERY_CUSTOM.BIND_VALUES(l_Delivery_Table,l_CursorID);
557: l_ignore := DBMS_SQL.EXECUTE(l_CursorID);
558:

Line 557: l_ignore := DBMS_SQL.EXECUTE(l_CursorID);

553: --Bug 6700736 Defined array for master_organization_id
554: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 7, l_num_master_org_id_tab, 100, 0);
555:
556: WSH_ITM_QUERY_CUSTOM.BIND_VALUES(l_Delivery_Table,l_CursorID);
557: l_ignore := DBMS_SQL.EXECUTE(l_CursorID);
558:
559:
560: LOOP
561: l_ignore := DBMS_SQL.FETCH_ROWS(l_CursorID);

Line 561: l_ignore := DBMS_SQL.FETCH_ROWS(l_CursorID);

557: l_ignore := DBMS_SQL.EXECUTE(l_CursorID);
558:
559:
560: LOOP
561: l_ignore := DBMS_SQL.FETCH_ROWS(l_CursorID);
562: DBMS_SQL.COLUMN_VALUE(l_CursorID, 1,l_num_exception_id_tab);
563: DBMS_SQL.COLUMN_VALUE(l_CursorID, 2,l_num_location_id_tab);
564: DBMS_SQL.COLUMN_VALUE(l_CursorID, 3,l_num_delivery_id_tab );
565: DBMS_SQL.COLUMN_VALUE(l_CursorID, 4,l_varchar_status_tab);

Line 562: DBMS_SQL.COLUMN_VALUE(l_CursorID, 1,l_num_exception_id_tab);

558:
559:
560: LOOP
561: l_ignore := DBMS_SQL.FETCH_ROWS(l_CursorID);
562: DBMS_SQL.COLUMN_VALUE(l_CursorID, 1,l_num_exception_id_tab);
563: DBMS_SQL.COLUMN_VALUE(l_CursorID, 2,l_num_location_id_tab);
564: DBMS_SQL.COLUMN_VALUE(l_CursorID, 3,l_num_delivery_id_tab );
565: DBMS_SQL.COLUMN_VALUE(l_CursorID, 4,l_varchar_status_tab);
566: DBMS_SQL.COLUMN_VALUE(l_CursorID, 5,l_varchar_delivery_name_tab );

Line 563: DBMS_SQL.COLUMN_VALUE(l_CursorID, 2,l_num_location_id_tab);

559:
560: LOOP
561: l_ignore := DBMS_SQL.FETCH_ROWS(l_CursorID);
562: DBMS_SQL.COLUMN_VALUE(l_CursorID, 1,l_num_exception_id_tab);
563: DBMS_SQL.COLUMN_VALUE(l_CursorID, 2,l_num_location_id_tab);
564: DBMS_SQL.COLUMN_VALUE(l_CursorID, 3,l_num_delivery_id_tab );
565: DBMS_SQL.COLUMN_VALUE(l_CursorID, 4,l_varchar_status_tab);
566: DBMS_SQL.COLUMN_VALUE(l_CursorID, 5,l_varchar_delivery_name_tab );
567: DBMS_SQL.COLUMN_VALUE(l_CursorID, 6, l_num_organization_id_tab);

Line 564: DBMS_SQL.COLUMN_VALUE(l_CursorID, 3,l_num_delivery_id_tab );

560: LOOP
561: l_ignore := DBMS_SQL.FETCH_ROWS(l_CursorID);
562: DBMS_SQL.COLUMN_VALUE(l_CursorID, 1,l_num_exception_id_tab);
563: DBMS_SQL.COLUMN_VALUE(l_CursorID, 2,l_num_location_id_tab);
564: DBMS_SQL.COLUMN_VALUE(l_CursorID, 3,l_num_delivery_id_tab );
565: DBMS_SQL.COLUMN_VALUE(l_CursorID, 4,l_varchar_status_tab);
566: DBMS_SQL.COLUMN_VALUE(l_CursorID, 5,l_varchar_delivery_name_tab );
567: DBMS_SQL.COLUMN_VALUE(l_CursorID, 6, l_num_organization_id_tab);
568: --Bug 6700736 Associated array variables master_organization_id

Line 565: DBMS_SQL.COLUMN_VALUE(l_CursorID, 4,l_varchar_status_tab);

561: l_ignore := DBMS_SQL.FETCH_ROWS(l_CursorID);
562: DBMS_SQL.COLUMN_VALUE(l_CursorID, 1,l_num_exception_id_tab);
563: DBMS_SQL.COLUMN_VALUE(l_CursorID, 2,l_num_location_id_tab);
564: DBMS_SQL.COLUMN_VALUE(l_CursorID, 3,l_num_delivery_id_tab );
565: DBMS_SQL.COLUMN_VALUE(l_CursorID, 4,l_varchar_status_tab);
566: DBMS_SQL.COLUMN_VALUE(l_CursorID, 5,l_varchar_delivery_name_tab );
567: DBMS_SQL.COLUMN_VALUE(l_CursorID, 6, l_num_organization_id_tab);
568: --Bug 6700736 Associated array variables master_organization_id
569: DBMS_SQL.COLUMN_VALUE(l_CursorID, 7,l_num_master_org_id_tab );

Line 566: DBMS_SQL.COLUMN_VALUE(l_CursorID, 5,l_varchar_delivery_name_tab );

562: DBMS_SQL.COLUMN_VALUE(l_CursorID, 1,l_num_exception_id_tab);
563: DBMS_SQL.COLUMN_VALUE(l_CursorID, 2,l_num_location_id_tab);
564: DBMS_SQL.COLUMN_VALUE(l_CursorID, 3,l_num_delivery_id_tab );
565: DBMS_SQL.COLUMN_VALUE(l_CursorID, 4,l_varchar_status_tab);
566: DBMS_SQL.COLUMN_VALUE(l_CursorID, 5,l_varchar_delivery_name_tab );
567: DBMS_SQL.COLUMN_VALUE(l_CursorID, 6, l_num_organization_id_tab);
568: --Bug 6700736 Associated array variables master_organization_id
569: DBMS_SQL.COLUMN_VALUE(l_CursorID, 7,l_num_master_org_id_tab );
570: EXIT WHEN l_ignore <> 100;

Line 567: DBMS_SQL.COLUMN_VALUE(l_CursorID, 6, l_num_organization_id_tab);

563: DBMS_SQL.COLUMN_VALUE(l_CursorID, 2,l_num_location_id_tab);
564: DBMS_SQL.COLUMN_VALUE(l_CursorID, 3,l_num_delivery_id_tab );
565: DBMS_SQL.COLUMN_VALUE(l_CursorID, 4,l_varchar_status_tab);
566: DBMS_SQL.COLUMN_VALUE(l_CursorID, 5,l_varchar_delivery_name_tab );
567: DBMS_SQL.COLUMN_VALUE(l_CursorID, 6, l_num_organization_id_tab);
568: --Bug 6700736 Associated array variables master_organization_id
569: DBMS_SQL.COLUMN_VALUE(l_CursorID, 7,l_num_master_org_id_tab );
570: EXIT WHEN l_ignore <> 100;
571: END LOOP;

Line 569: DBMS_SQL.COLUMN_VALUE(l_CursorID, 7,l_num_master_org_id_tab );

565: DBMS_SQL.COLUMN_VALUE(l_CursorID, 4,l_varchar_status_tab);
566: DBMS_SQL.COLUMN_VALUE(l_CursorID, 5,l_varchar_delivery_name_tab );
567: DBMS_SQL.COLUMN_VALUE(l_CursorID, 6, l_num_organization_id_tab);
568: --Bug 6700736 Associated array variables master_organization_id
569: DBMS_SQL.COLUMN_VALUE(l_CursorID, 7,l_num_master_org_id_tab );
570: EXIT WHEN l_ignore <> 100;
571: END LOOP;
572:
573: DBMS_SQL.CLOSE_CURSOR(l_CursorID);

Line 573: DBMS_SQL.CLOSE_CURSOR(l_CursorID);

569: DBMS_SQL.COLUMN_VALUE(l_CursorID, 7,l_num_master_org_id_tab );
570: EXIT WHEN l_ignore <> 100;
571: END LOOP;
572:
573: DBMS_SQL.CLOSE_CURSOR(l_CursorID);
574:
575: IF l_debug_on THEN
576: WSH_DEBUG_SV.log(l_module_name,' No Of Deliveries Selected For Screening ',l_num_delivery_id_tab.count);
577: END IF;