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 400: l_num_exception_id_tab DBMS_SQL.Number_Table;

396: l_ignore NUMBER;
397: l_tempStr VARCHAR2(10000) := ' ';
398:
399: --Declaration Section For Bulk Select PL/SQL Tables
400: l_num_exception_id_tab DBMS_SQL.Number_Table;
401: l_varchar_status_tab DBMS_SQL.Varchar2_Table;
402: l_num_location_id_tab DBMS_SQL.Number_Table;
403: l_num_delivery_id_tab DBMS_SQL.Number_Table;
404: l_varchar_delivery_name_tab DBMS_SQL.Varchar2_Table;

Line 401: l_varchar_status_tab DBMS_SQL.Varchar2_Table;

397: l_tempStr VARCHAR2(10000) := ' ';
398:
399: --Declaration Section For Bulk Select PL/SQL Tables
400: l_num_exception_id_tab DBMS_SQL.Number_Table;
401: l_varchar_status_tab DBMS_SQL.Varchar2_Table;
402: l_num_location_id_tab DBMS_SQL.Number_Table;
403: l_num_delivery_id_tab DBMS_SQL.Number_Table;
404: l_varchar_delivery_name_tab DBMS_SQL.Varchar2_Table;
405:

Line 402: l_num_location_id_tab DBMS_SQL.Number_Table;

398:
399: --Declaration Section For Bulk Select PL/SQL Tables
400: l_num_exception_id_tab DBMS_SQL.Number_Table;
401: l_varchar_status_tab DBMS_SQL.Varchar2_Table;
402: l_num_location_id_tab DBMS_SQL.Number_Table;
403: l_num_delivery_id_tab DBMS_SQL.Number_Table;
404: l_varchar_delivery_name_tab DBMS_SQL.Varchar2_Table;
405:
406: --AJPRABHA for inserting DATA into Transactions History.

Line 403: l_num_delivery_id_tab DBMS_SQL.Number_Table;

399: --Declaration Section For Bulk Select PL/SQL Tables
400: l_num_exception_id_tab DBMS_SQL.Number_Table;
401: l_varchar_status_tab DBMS_SQL.Varchar2_Table;
402: l_num_location_id_tab DBMS_SQL.Number_Table;
403: l_num_delivery_id_tab DBMS_SQL.Number_Table;
404: l_varchar_delivery_name_tab DBMS_SQL.Varchar2_Table;
405:
406: --AJPRABHA for inserting DATA into Transactions History.
407: l_tranx_history_rec WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;

Line 404: l_varchar_delivery_name_tab DBMS_SQL.Varchar2_Table;

400: l_num_exception_id_tab DBMS_SQL.Number_Table;
401: l_varchar_status_tab DBMS_SQL.Varchar2_Table;
402: l_num_location_id_tab DBMS_SQL.Number_Table;
403: l_num_delivery_id_tab DBMS_SQL.Number_Table;
404: l_varchar_delivery_name_tab DBMS_SQL.Varchar2_Table;
405:
406: --AJPRABHA for inserting DATA into Transactions History.
407: l_tranx_history_rec WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;
408: x_txns_id NUMBER;

Line 420: l_num_organization_id_tab DBMS_SQL.Number_Table;

416:
417: --Added for Raising tracking Workflows
418: l_wf_event_name VARCHAR2(1000);
419: l_wf_return_status VARCHAR2(1);
420: l_num_organization_id_tab DBMS_SQL.Number_Table;
421: l_parameter_list wf_parameter_list_t;
422: --BUG 6700736 Added variable to store master_organization_id
423: l_num_master_org_id_tab DBMS_SQL.Number_Table;
424:

Line 423: l_num_master_org_id_tab DBMS_SQL.Number_Table;

419: l_wf_return_status VARCHAR2(1);
420: l_num_organization_id_tab DBMS_SQL.Number_Table;
421: l_parameter_list wf_parameter_list_t;
422: --BUG 6700736 Added variable to store master_organization_id
423: l_num_master_org_id_tab DBMS_SQL.Number_Table;
424:
425: l_debug_on BOOLEAN;
426: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' ||'SCREEN_EVENT_DELIVERIES';
427:

Line 558: l_CursorID := DBMS_SQL.Open_Cursor;

554:
555:
556: -- This sub section executes the query and collects the result set into PL/SQL Tables
557:
558: l_CursorID := DBMS_SQL.Open_Cursor;
559: DBMS_SQL.PARSE(l_CursorID, l_exp_compliance_dlvy_query, DBMS_SQL.v7);
560: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 1, l_num_exception_id_tab, 100, 0);
561: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 2, l_num_location_id_tab, 100, 0);
562: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 3, l_num_delivery_id_tab, 100, 0);

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

555:
556: -- This sub section executes the query and collects the result set into PL/SQL Tables
557:
558: l_CursorID := DBMS_SQL.Open_Cursor;
559: DBMS_SQL.PARSE(l_CursorID, l_exp_compliance_dlvy_query, DBMS_SQL.v7);
560: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 1, l_num_exception_id_tab, 100, 0);
561: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 2, l_num_location_id_tab, 100, 0);
562: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 3, l_num_delivery_id_tab, 100, 0);
563: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 4, l_varchar_status_tab, 100, 0);

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

556: -- This sub section executes the query and collects the result set into PL/SQL Tables
557:
558: l_CursorID := DBMS_SQL.Open_Cursor;
559: DBMS_SQL.PARSE(l_CursorID, l_exp_compliance_dlvy_query, DBMS_SQL.v7);
560: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 1, l_num_exception_id_tab, 100, 0);
561: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 2, l_num_location_id_tab, 100, 0);
562: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 3, l_num_delivery_id_tab, 100, 0);
563: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 4, l_varchar_status_tab, 100, 0);
564: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 6, l_num_organization_id_tab, 100, 0);

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

557:
558: l_CursorID := DBMS_SQL.Open_Cursor;
559: DBMS_SQL.PARSE(l_CursorID, l_exp_compliance_dlvy_query, DBMS_SQL.v7);
560: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 1, l_num_exception_id_tab, 100, 0);
561: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 2, l_num_location_id_tab, 100, 0);
562: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 3, l_num_delivery_id_tab, 100, 0);
563: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 4, l_varchar_status_tab, 100, 0);
564: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 6, l_num_organization_id_tab, 100, 0);
565: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 5, l_varchar_delivery_name_tab, 100, 0);

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

558: l_CursorID := DBMS_SQL.Open_Cursor;
559: DBMS_SQL.PARSE(l_CursorID, l_exp_compliance_dlvy_query, DBMS_SQL.v7);
560: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 1, l_num_exception_id_tab, 100, 0);
561: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 2, l_num_location_id_tab, 100, 0);
562: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 3, l_num_delivery_id_tab, 100, 0);
563: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 4, l_varchar_status_tab, 100, 0);
564: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 6, l_num_organization_id_tab, 100, 0);
565: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 5, l_varchar_delivery_name_tab, 100, 0);
566: --Bug 6700736 Defined array for master_organization_id

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

559: DBMS_SQL.PARSE(l_CursorID, l_exp_compliance_dlvy_query, DBMS_SQL.v7);
560: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 1, l_num_exception_id_tab, 100, 0);
561: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 2, l_num_location_id_tab, 100, 0);
562: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 3, l_num_delivery_id_tab, 100, 0);
563: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 4, l_varchar_status_tab, 100, 0);
564: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 6, l_num_organization_id_tab, 100, 0);
565: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 5, l_varchar_delivery_name_tab, 100, 0);
566: --Bug 6700736 Defined array for master_organization_id
567: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 7, l_num_master_org_id_tab, 100, 0);

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

560: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 1, l_num_exception_id_tab, 100, 0);
561: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 2, l_num_location_id_tab, 100, 0);
562: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 3, l_num_delivery_id_tab, 100, 0);
563: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 4, l_varchar_status_tab, 100, 0);
564: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 6, l_num_organization_id_tab, 100, 0);
565: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 5, l_varchar_delivery_name_tab, 100, 0);
566: --Bug 6700736 Defined array for master_organization_id
567: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 7, l_num_master_org_id_tab, 100, 0);
568:

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

561: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 2, l_num_location_id_tab, 100, 0);
562: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 3, l_num_delivery_id_tab, 100, 0);
563: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 4, l_varchar_status_tab, 100, 0);
564: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 6, l_num_organization_id_tab, 100, 0);
565: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 5, l_varchar_delivery_name_tab, 100, 0);
566: --Bug 6700736 Defined array for master_organization_id
567: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 7, l_num_master_org_id_tab, 100, 0);
568:
569: WSH_ITM_QUERY_CUSTOM.BIND_VALUES(l_Delivery_Table,l_CursorID);

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

563: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 4, l_varchar_status_tab, 100, 0);
564: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 6, l_num_organization_id_tab, 100, 0);
565: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 5, l_varchar_delivery_name_tab, 100, 0);
566: --Bug 6700736 Defined array for master_organization_id
567: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 7, l_num_master_org_id_tab, 100, 0);
568:
569: WSH_ITM_QUERY_CUSTOM.BIND_VALUES(l_Delivery_Table,l_CursorID);
570: l_ignore := DBMS_SQL.EXECUTE(l_CursorID);
571:

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

566: --Bug 6700736 Defined array for master_organization_id
567: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 7, l_num_master_org_id_tab, 100, 0);
568:
569: WSH_ITM_QUERY_CUSTOM.BIND_VALUES(l_Delivery_Table,l_CursorID);
570: l_ignore := DBMS_SQL.EXECUTE(l_CursorID);
571:
572:
573: LOOP
574: l_ignore := DBMS_SQL.FETCH_ROWS(l_CursorID);

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

570: l_ignore := DBMS_SQL.EXECUTE(l_CursorID);
571:
572:
573: LOOP
574: l_ignore := DBMS_SQL.FETCH_ROWS(l_CursorID);
575: DBMS_SQL.COLUMN_VALUE(l_CursorID, 1,l_num_exception_id_tab);
576: DBMS_SQL.COLUMN_VALUE(l_CursorID, 2,l_num_location_id_tab);
577: DBMS_SQL.COLUMN_VALUE(l_CursorID, 3,l_num_delivery_id_tab );
578: DBMS_SQL.COLUMN_VALUE(l_CursorID, 4,l_varchar_status_tab);

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

571:
572:
573: LOOP
574: l_ignore := DBMS_SQL.FETCH_ROWS(l_CursorID);
575: DBMS_SQL.COLUMN_VALUE(l_CursorID, 1,l_num_exception_id_tab);
576: DBMS_SQL.COLUMN_VALUE(l_CursorID, 2,l_num_location_id_tab);
577: DBMS_SQL.COLUMN_VALUE(l_CursorID, 3,l_num_delivery_id_tab );
578: DBMS_SQL.COLUMN_VALUE(l_CursorID, 4,l_varchar_status_tab);
579: DBMS_SQL.COLUMN_VALUE(l_CursorID, 5,l_varchar_delivery_name_tab );

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

572:
573: LOOP
574: l_ignore := DBMS_SQL.FETCH_ROWS(l_CursorID);
575: DBMS_SQL.COLUMN_VALUE(l_CursorID, 1,l_num_exception_id_tab);
576: DBMS_SQL.COLUMN_VALUE(l_CursorID, 2,l_num_location_id_tab);
577: DBMS_SQL.COLUMN_VALUE(l_CursorID, 3,l_num_delivery_id_tab );
578: DBMS_SQL.COLUMN_VALUE(l_CursorID, 4,l_varchar_status_tab);
579: DBMS_SQL.COLUMN_VALUE(l_CursorID, 5,l_varchar_delivery_name_tab );
580: DBMS_SQL.COLUMN_VALUE(l_CursorID, 6, l_num_organization_id_tab);

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

573: LOOP
574: l_ignore := DBMS_SQL.FETCH_ROWS(l_CursorID);
575: DBMS_SQL.COLUMN_VALUE(l_CursorID, 1,l_num_exception_id_tab);
576: DBMS_SQL.COLUMN_VALUE(l_CursorID, 2,l_num_location_id_tab);
577: DBMS_SQL.COLUMN_VALUE(l_CursorID, 3,l_num_delivery_id_tab );
578: DBMS_SQL.COLUMN_VALUE(l_CursorID, 4,l_varchar_status_tab);
579: DBMS_SQL.COLUMN_VALUE(l_CursorID, 5,l_varchar_delivery_name_tab );
580: DBMS_SQL.COLUMN_VALUE(l_CursorID, 6, l_num_organization_id_tab);
581: --Bug 6700736 Associated array variables master_organization_id

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

574: l_ignore := DBMS_SQL.FETCH_ROWS(l_CursorID);
575: DBMS_SQL.COLUMN_VALUE(l_CursorID, 1,l_num_exception_id_tab);
576: DBMS_SQL.COLUMN_VALUE(l_CursorID, 2,l_num_location_id_tab);
577: DBMS_SQL.COLUMN_VALUE(l_CursorID, 3,l_num_delivery_id_tab );
578: DBMS_SQL.COLUMN_VALUE(l_CursorID, 4,l_varchar_status_tab);
579: DBMS_SQL.COLUMN_VALUE(l_CursorID, 5,l_varchar_delivery_name_tab );
580: DBMS_SQL.COLUMN_VALUE(l_CursorID, 6, l_num_organization_id_tab);
581: --Bug 6700736 Associated array variables master_organization_id
582: DBMS_SQL.COLUMN_VALUE(l_CursorID, 7,l_num_master_org_id_tab );

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

575: DBMS_SQL.COLUMN_VALUE(l_CursorID, 1,l_num_exception_id_tab);
576: DBMS_SQL.COLUMN_VALUE(l_CursorID, 2,l_num_location_id_tab);
577: DBMS_SQL.COLUMN_VALUE(l_CursorID, 3,l_num_delivery_id_tab );
578: DBMS_SQL.COLUMN_VALUE(l_CursorID, 4,l_varchar_status_tab);
579: DBMS_SQL.COLUMN_VALUE(l_CursorID, 5,l_varchar_delivery_name_tab );
580: DBMS_SQL.COLUMN_VALUE(l_CursorID, 6, l_num_organization_id_tab);
581: --Bug 6700736 Associated array variables master_organization_id
582: DBMS_SQL.COLUMN_VALUE(l_CursorID, 7,l_num_master_org_id_tab );
583: EXIT WHEN l_ignore <> 100;

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

576: DBMS_SQL.COLUMN_VALUE(l_CursorID, 2,l_num_location_id_tab);
577: DBMS_SQL.COLUMN_VALUE(l_CursorID, 3,l_num_delivery_id_tab );
578: DBMS_SQL.COLUMN_VALUE(l_CursorID, 4,l_varchar_status_tab);
579: DBMS_SQL.COLUMN_VALUE(l_CursorID, 5,l_varchar_delivery_name_tab );
580: DBMS_SQL.COLUMN_VALUE(l_CursorID, 6, l_num_organization_id_tab);
581: --Bug 6700736 Associated array variables master_organization_id
582: DBMS_SQL.COLUMN_VALUE(l_CursorID, 7,l_num_master_org_id_tab );
583: EXIT WHEN l_ignore <> 100;
584: END LOOP;

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

578: DBMS_SQL.COLUMN_VALUE(l_CursorID, 4,l_varchar_status_tab);
579: DBMS_SQL.COLUMN_VALUE(l_CursorID, 5,l_varchar_delivery_name_tab );
580: DBMS_SQL.COLUMN_VALUE(l_CursorID, 6, l_num_organization_id_tab);
581: --Bug 6700736 Associated array variables master_organization_id
582: DBMS_SQL.COLUMN_VALUE(l_CursorID, 7,l_num_master_org_id_tab );
583: EXIT WHEN l_ignore <> 100;
584: END LOOP;
585:
586: DBMS_SQL.CLOSE_CURSOR(l_CursorID);

Line 586: DBMS_SQL.CLOSE_CURSOR(l_CursorID);

582: DBMS_SQL.COLUMN_VALUE(l_CursorID, 7,l_num_master_org_id_tab );
583: EXIT WHEN l_ignore <> 100;
584: END LOOP;
585:
586: DBMS_SQL.CLOSE_CURSOR(l_CursorID);
587:
588: IF l_debug_on THEN
589: WSH_DEBUG_SV.log(l_module_name,' No Of Deliveries Selected For Screening ',l_num_delivery_id_tab.count);
590: END IF;