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 WSH_ITM_QUERY_CUSTOM

Line 454: l_Delivery_Table WSH_ITM_QUERY_CUSTOM.g_CondnValTableType;

450: ' WSH_DELIVERY_ASSIGNMENTS WDA '||
451: ' WHERE '||
452: ' WDA.DELIVERY_ID = WND.DELIVERY_ID '||
453: ' AND ROWNUM = 1) ' ;
454: l_Delivery_Table WSH_ITM_QUERY_CUSTOM.g_CondnValTableType;
455: l_Delivery_Condn1Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
456: l_Delivery_Condn2Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
457: l_Delivery_Condn3Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
458: l_Delivery_Condn4Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;

Line 455: l_Delivery_Condn1Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;

451: ' WHERE '||
452: ' WDA.DELIVERY_ID = WND.DELIVERY_ID '||
453: ' AND ROWNUM = 1) ' ;
454: l_Delivery_Table WSH_ITM_QUERY_CUSTOM.g_CondnValTableType;
455: l_Delivery_Condn1Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
456: l_Delivery_Condn2Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
457: l_Delivery_Condn3Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
458: l_Delivery_Condn4Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
459: l_Delivery_Condn5Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;

Line 456: l_Delivery_Condn2Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;

452: ' WDA.DELIVERY_ID = WND.DELIVERY_ID '||
453: ' AND ROWNUM = 1) ' ;
454: l_Delivery_Table WSH_ITM_QUERY_CUSTOM.g_CondnValTableType;
455: l_Delivery_Condn1Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
456: l_Delivery_Condn2Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
457: l_Delivery_Condn3Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
458: l_Delivery_Condn4Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
459: l_Delivery_Condn5Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
460: l_Delivery_Condn6Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;

Line 457: l_Delivery_Condn3Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;

453: ' AND ROWNUM = 1) ' ;
454: l_Delivery_Table WSH_ITM_QUERY_CUSTOM.g_CondnValTableType;
455: l_Delivery_Condn1Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
456: l_Delivery_Condn2Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
457: l_Delivery_Condn3Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
458: l_Delivery_Condn4Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
459: l_Delivery_Condn5Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
460: l_Delivery_Condn6Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
461: l_Delivery_Condn7Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;

Line 458: l_Delivery_Condn4Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;

454: l_Delivery_Table WSH_ITM_QUERY_CUSTOM.g_CondnValTableType;
455: l_Delivery_Condn1Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
456: l_Delivery_Condn2Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
457: l_Delivery_Condn3Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
458: l_Delivery_Condn4Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
459: l_Delivery_Condn5Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
460: l_Delivery_Condn6Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
461: l_Delivery_Condn7Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
462: l_Delivery_Condn71Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;

Line 459: l_Delivery_Condn5Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;

455: l_Delivery_Condn1Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
456: l_Delivery_Condn2Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
457: l_Delivery_Condn3Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
458: l_Delivery_Condn4Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
459: l_Delivery_Condn5Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
460: l_Delivery_Condn6Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
461: l_Delivery_Condn7Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
462: l_Delivery_Condn71Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
463: l_Delivery_Condn8Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;

Line 460: l_Delivery_Condn6Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;

456: l_Delivery_Condn2Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
457: l_Delivery_Condn3Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
458: l_Delivery_Condn4Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
459: l_Delivery_Condn5Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
460: l_Delivery_Condn6Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
461: l_Delivery_Condn7Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
462: l_Delivery_Condn71Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
463: l_Delivery_Condn8Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
464: l_Delivery_Condn9Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;

Line 461: l_Delivery_Condn7Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;

457: l_Delivery_Condn3Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
458: l_Delivery_Condn4Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
459: l_Delivery_Condn5Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
460: l_Delivery_Condn6Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
461: l_Delivery_Condn7Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
462: l_Delivery_Condn71Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
463: l_Delivery_Condn8Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
464: l_Delivery_Condn9Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
465: BEGIN

Line 462: l_Delivery_Condn71Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;

458: l_Delivery_Condn4Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
459: l_Delivery_Condn5Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
460: l_Delivery_Condn6Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
461: l_Delivery_Condn7Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
462: l_Delivery_Condn71Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
463: l_Delivery_Condn8Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
464: l_Delivery_Condn9Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
465: BEGIN
466:

Line 463: l_Delivery_Condn8Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;

459: l_Delivery_Condn5Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
460: l_Delivery_Condn6Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
461: l_Delivery_Condn7Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
462: l_Delivery_Condn71Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
463: l_Delivery_Condn8Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
464: l_Delivery_Condn9Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
465: BEGIN
466:
467: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 464: l_Delivery_Condn9Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;

460: l_Delivery_Condn6Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
461: l_Delivery_Condn7Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
462: l_Delivery_Condn71Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
463: l_Delivery_Condn8Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
464: l_Delivery_Condn9Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
465: BEGIN
466:
467: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
468: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;

Line 497: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Delivery_Table, ' AND WE.EXCEPTION_NAME = :b_req_pick_release', l_Delivery_Condn1Tab, 'VARCHAR');

493: -- This sub section prepares the query to pick up the Deliveries which require screening
494: IF p_event_name = G_PICK_RELEASE_EVENT THEN
495: l_Delivery_Condn1Tab(1).g_varchar_val := G_REQ_PICK_RELEASE_EXCEPTION;
496: l_Delivery_Condn1Tab(1).g_Bind_Literal := ':b_req_pick_release';
497: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Delivery_Table, ' AND WE.EXCEPTION_NAME = :b_req_pick_release', l_Delivery_Condn1Tab, 'VARCHAR');
498: ELSIF p_event_name = G_SHIP_CONFIRM_EVENT THEN
499: l_Delivery_Condn2Tab(1).g_varchar_val := G_REQ_SHIP_CONFIRM_EXCEPTION;
500: l_Delivery_Condn2Tab(1).g_Bind_Literal := ':b_req_ship_confirm';
501: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Delivery_Table, ' AND WE.EXCEPTION_NAME = :b_req_ship_confirm', l_Delivery_Condn2Tab, 'VARCHAR');

Line 501: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Delivery_Table, ' AND WE.EXCEPTION_NAME = :b_req_ship_confirm', l_Delivery_Condn2Tab, 'VARCHAR');

497: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Delivery_Table, ' AND WE.EXCEPTION_NAME = :b_req_pick_release', l_Delivery_Condn1Tab, 'VARCHAR');
498: ELSIF p_event_name = G_SHIP_CONFIRM_EVENT THEN
499: l_Delivery_Condn2Tab(1).g_varchar_val := G_REQ_SHIP_CONFIRM_EXCEPTION;
500: l_Delivery_Condn2Tab(1).g_Bind_Literal := ':b_req_ship_confirm';
501: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Delivery_Table, ' AND WE.EXCEPTION_NAME = :b_req_ship_confirm', l_Delivery_Condn2Tab, 'VARCHAR');
502: END IF;
503:
504: IF p_organization_id is not null THEN
505: l_Delivery_Condn3Tab(1).g_number_val := p_organization_id;

Line 507: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Delivery_Table, ' AND WND.ORGANIZATION_ID = :b_org_id', l_Delivery_Condn3Tab, 'NUMBER');

503:
504: IF p_organization_id is not null THEN
505: l_Delivery_Condn3Tab(1).g_number_val := p_organization_id;
506: l_Delivery_Condn3Tab(1).g_Bind_Literal := ':b_org_id';
507: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Delivery_Table, ' AND WND.ORGANIZATION_ID = :b_org_id', l_Delivery_Condn3Tab, 'NUMBER');
508: END IF;
509:
510: IF p_delivery_from_id is not null THEN
511: l_Delivery_Condn4Tab(1).g_number_val := p_delivery_from_id;

Line 513: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Delivery_Table, ' AND WE.DELIVERY_ID >= :b_delivery_from_id', l_Delivery_Condn4Tab, 'NUMBER');

509:
510: IF p_delivery_from_id is not null THEN
511: l_Delivery_Condn4Tab(1).g_number_val := p_delivery_from_id;
512: l_Delivery_Condn4Tab(1).g_Bind_Literal := ':b_delivery_from_id';
513: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Delivery_Table, ' AND WE.DELIVERY_ID >= :b_delivery_from_id', l_Delivery_Condn4Tab, 'NUMBER');
514: END IF;
515:
516:
517: IF p_delivery_to_id is not null THEN

Line 520: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Delivery_Table, ' AND WE.DELIVERY_ID <= :b_delivery_to_id', l_Delivery_Condn5Tab, 'NUMBER');

516:
517: IF p_delivery_to_id is not null THEN
518: l_Delivery_Condn5Tab(1).g_number_val := p_delivery_to_id;
519: l_Delivery_Condn5Tab(1).g_Bind_Literal := ':b_delivery_to_id';
520: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Delivery_Table, ' AND WE.DELIVERY_ID <= :b_delivery_to_id', l_Delivery_Condn5Tab, 'NUMBER');
521: END IF;
522:
523:
524: IF p_ship_method_code is not null THEN

Line 527: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Delivery_Table, ' AND WND.SHIP_METHOD_CODE = :b_ship_method_code', l_Delivery_Condn6Tab, 'VARCHAR');

523:
524: IF p_ship_method_code is not null THEN
525: l_Delivery_Condn6Tab(1).g_varchar_val := p_ship_method_code;
526: l_Delivery_Condn6Tab(1).g_Bind_Literal := ':b_ship_method_code';
527: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Delivery_Table, ' AND WND.SHIP_METHOD_CODE = :b_ship_method_code', l_Delivery_Condn6Tab, 'VARCHAR');
528: END IF;
529:
530: IF p_pickup_date_from is not null THEN
531: l_Delivery_Condn8Tab(1).g_date_val := FND_DATE.CANONICAL_TO_DATE(p_pickup_date_from);

Line 533: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Delivery_Table, ' AND WND.INITIAL_PICKUP_DATE >= :b_pickup_date_from', l_Delivery_Condn8Tab, 'DATE');

529:
530: IF p_pickup_date_from is not null THEN
531: l_Delivery_Condn8Tab(1).g_date_val := FND_DATE.CANONICAL_TO_DATE(p_pickup_date_from);
532: l_Delivery_Condn8Tab(1).g_Bind_Literal := ':b_pickup_date_from';
533: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Delivery_Table, ' AND WND.INITIAL_PICKUP_DATE >= :b_pickup_date_from', l_Delivery_Condn8Tab, 'DATE');
534: END IF;
535:
536: IF p_pickup_date_to is not null THEN
537: l_Delivery_Condn9Tab(1).g_date_val := FND_DATE.CANONICAL_TO_DATE(p_pickup_date_to);

Line 539: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Delivery_Table, ' AND WND.INITIAL_PICKUP_DATE <= :b_pickup_date_to', l_Delivery_Condn9Tab, 'DATE');

535:
536: IF p_pickup_date_to is not null THEN
537: l_Delivery_Condn9Tab(1).g_date_val := FND_DATE.CANONICAL_TO_DATE(p_pickup_date_to);
538: l_Delivery_Condn9Tab(1).g_Bind_Literal := ':b_pickup_date_to';
539: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Delivery_Table, ' AND WND.INITIAL_PICKUP_DATE <= :b_pickup_date_to', l_Delivery_Condn9Tab, 'DATE');
540: END IF;
541:
542: FOR I IN 1..l_Delivery_Table.COUNT
543: LOOP

Line 569: WSH_ITM_QUERY_CUSTOM.BIND_VALUES(l_Delivery_Table,l_CursorID);

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:
572:
573: LOOP