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 441: l_Delivery_Table WSH_ITM_QUERY_CUSTOM.g_CondnValTableType;

437: ' WSH_DELIVERY_ASSIGNMENTS WDA '||
438: ' WHERE '||
439: ' WDA.DELIVERY_ID = WND.DELIVERY_ID '||
440: ' AND ROWNUM = 1) ' ;
441: l_Delivery_Table WSH_ITM_QUERY_CUSTOM.g_CondnValTableType;
442: l_Delivery_Condn1Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
443: l_Delivery_Condn2Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
444: l_Delivery_Condn3Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
445: l_Delivery_Condn4Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;

Line 442: l_Delivery_Condn1Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;

438: ' WHERE '||
439: ' WDA.DELIVERY_ID = WND.DELIVERY_ID '||
440: ' AND ROWNUM = 1) ' ;
441: l_Delivery_Table WSH_ITM_QUERY_CUSTOM.g_CondnValTableType;
442: l_Delivery_Condn1Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
443: l_Delivery_Condn2Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
444: l_Delivery_Condn3Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
445: l_Delivery_Condn4Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
446: l_Delivery_Condn5Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;

Line 443: l_Delivery_Condn2Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;

439: ' WDA.DELIVERY_ID = WND.DELIVERY_ID '||
440: ' AND ROWNUM = 1) ' ;
441: l_Delivery_Table WSH_ITM_QUERY_CUSTOM.g_CondnValTableType;
442: l_Delivery_Condn1Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
443: l_Delivery_Condn2Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
444: l_Delivery_Condn3Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
445: l_Delivery_Condn4Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
446: l_Delivery_Condn5Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
447: l_Delivery_Condn6Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;

Line 444: l_Delivery_Condn3Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;

440: ' AND ROWNUM = 1) ' ;
441: l_Delivery_Table WSH_ITM_QUERY_CUSTOM.g_CondnValTableType;
442: l_Delivery_Condn1Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
443: l_Delivery_Condn2Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
444: l_Delivery_Condn3Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
445: l_Delivery_Condn4Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
446: l_Delivery_Condn5Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
447: l_Delivery_Condn6Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
448: l_Delivery_Condn7Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;

Line 445: l_Delivery_Condn4Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;

441: l_Delivery_Table WSH_ITM_QUERY_CUSTOM.g_CondnValTableType;
442: l_Delivery_Condn1Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
443: l_Delivery_Condn2Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
444: l_Delivery_Condn3Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
445: l_Delivery_Condn4Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
446: l_Delivery_Condn5Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
447: l_Delivery_Condn6Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
448: l_Delivery_Condn7Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
449: l_Delivery_Condn71Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;

Line 446: l_Delivery_Condn5Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;

442: l_Delivery_Condn1Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
443: l_Delivery_Condn2Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
444: l_Delivery_Condn3Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
445: l_Delivery_Condn4Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
446: l_Delivery_Condn5Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
447: l_Delivery_Condn6Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
448: l_Delivery_Condn7Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
449: l_Delivery_Condn71Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
450: l_Delivery_Condn8Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;

Line 447: l_Delivery_Condn6Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;

443: l_Delivery_Condn2Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
444: l_Delivery_Condn3Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
445: l_Delivery_Condn4Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
446: l_Delivery_Condn5Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
447: l_Delivery_Condn6Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
448: l_Delivery_Condn7Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
449: l_Delivery_Condn71Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
450: l_Delivery_Condn8Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
451: l_Delivery_Condn9Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;

Line 448: l_Delivery_Condn7Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;

444: l_Delivery_Condn3Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
445: l_Delivery_Condn4Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
446: l_Delivery_Condn5Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
447: l_Delivery_Condn6Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
448: l_Delivery_Condn7Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
449: l_Delivery_Condn71Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
450: l_Delivery_Condn8Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
451: l_Delivery_Condn9Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
452: BEGIN

Line 449: l_Delivery_Condn71Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;

445: l_Delivery_Condn4Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
446: l_Delivery_Condn5Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
447: l_Delivery_Condn6Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
448: l_Delivery_Condn7Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
449: l_Delivery_Condn71Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
450: l_Delivery_Condn8Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
451: l_Delivery_Condn9Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
452: BEGIN
453:

Line 450: l_Delivery_Condn8Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;

446: l_Delivery_Condn5Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
447: l_Delivery_Condn6Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
448: l_Delivery_Condn7Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
449: l_Delivery_Condn71Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
450: l_Delivery_Condn8Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
451: l_Delivery_Condn9Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
452: BEGIN
453:
454: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 451: l_Delivery_Condn9Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;

447: l_Delivery_Condn6Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
448: l_Delivery_Condn7Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
449: l_Delivery_Condn71Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
450: l_Delivery_Condn8Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
451: l_Delivery_Condn9Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
452: BEGIN
453:
454: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
455: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;

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

480: -- This sub section prepares the query to pick up the Deliveries which require screening
481: IF p_event_name = G_PICK_RELEASE_EVENT THEN
482: l_Delivery_Condn1Tab(1).g_varchar_val := G_REQ_PICK_RELEASE_EXCEPTION;
483: l_Delivery_Condn1Tab(1).g_Bind_Literal := ':b_req_pick_release';
484: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Delivery_Table, ' AND WE.EXCEPTION_NAME = :b_req_pick_release', l_Delivery_Condn1Tab, 'VARCHAR');
485: ELSIF p_event_name = G_SHIP_CONFIRM_EVENT THEN
486: l_Delivery_Condn2Tab(1).g_varchar_val := G_REQ_SHIP_CONFIRM_EXCEPTION;
487: l_Delivery_Condn2Tab(1).g_Bind_Literal := ':b_req_ship_confirm';
488: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Delivery_Table, ' AND WE.EXCEPTION_NAME = :b_req_ship_confirm', l_Delivery_Condn2Tab, 'VARCHAR');

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

484: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Delivery_Table, ' AND WE.EXCEPTION_NAME = :b_req_pick_release', l_Delivery_Condn1Tab, 'VARCHAR');
485: ELSIF p_event_name = G_SHIP_CONFIRM_EVENT THEN
486: l_Delivery_Condn2Tab(1).g_varchar_val := G_REQ_SHIP_CONFIRM_EXCEPTION;
487: l_Delivery_Condn2Tab(1).g_Bind_Literal := ':b_req_ship_confirm';
488: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Delivery_Table, ' AND WE.EXCEPTION_NAME = :b_req_ship_confirm', l_Delivery_Condn2Tab, 'VARCHAR');
489: END IF;
490:
491: IF p_organization_id is not null THEN
492: l_Delivery_Condn3Tab(1).g_number_val := p_organization_id;

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

490:
491: IF p_organization_id is not null THEN
492: l_Delivery_Condn3Tab(1).g_number_val := p_organization_id;
493: l_Delivery_Condn3Tab(1).g_Bind_Literal := ':b_org_id';
494: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Delivery_Table, ' AND WND.ORGANIZATION_ID = :b_org_id', l_Delivery_Condn3Tab, 'NUMBER');
495: END IF;
496:
497: IF p_delivery_from_id is not null THEN
498: l_Delivery_Condn4Tab(1).g_number_val := p_delivery_from_id;

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

496:
497: IF p_delivery_from_id is not null THEN
498: l_Delivery_Condn4Tab(1).g_number_val := p_delivery_from_id;
499: l_Delivery_Condn4Tab(1).g_Bind_Literal := ':b_delivery_from_id';
500: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Delivery_Table, ' AND WE.DELIVERY_ID >= :b_delivery_from_id', l_Delivery_Condn4Tab, 'NUMBER');
501: END IF;
502:
503:
504: IF p_delivery_to_id is not null THEN

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

503:
504: IF p_delivery_to_id is not null THEN
505: l_Delivery_Condn5Tab(1).g_number_val := p_delivery_to_id;
506: l_Delivery_Condn5Tab(1).g_Bind_Literal := ':b_delivery_to_id';
507: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Delivery_Table, ' AND WE.DELIVERY_ID <= :b_delivery_to_id', l_Delivery_Condn5Tab, 'NUMBER');
508: END IF;
509:
510:
511: IF p_ship_method_code is not null THEN

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

510:
511: IF p_ship_method_code is not null THEN
512: l_Delivery_Condn6Tab(1).g_varchar_val := p_ship_method_code;
513: l_Delivery_Condn6Tab(1).g_Bind_Literal := ':b_ship_method_code';
514: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Delivery_Table, ' AND WND.SHIP_METHOD_CODE = :b_ship_method_code', l_Delivery_Condn6Tab, 'VARCHAR');
515: END IF;
516:
517: IF p_pickup_date_from is not null THEN
518: l_Delivery_Condn8Tab(1).g_date_val := FND_DATE.CANONICAL_TO_DATE(p_pickup_date_from);

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

516:
517: IF p_pickup_date_from is not null THEN
518: l_Delivery_Condn8Tab(1).g_date_val := FND_DATE.CANONICAL_TO_DATE(p_pickup_date_from);
519: l_Delivery_Condn8Tab(1).g_Bind_Literal := ':b_pickup_date_from';
520: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Delivery_Table, ' AND WND.INITIAL_PICKUP_DATE >= :b_pickup_date_from', l_Delivery_Condn8Tab, 'DATE');
521: END IF;
522:
523: IF p_pickup_date_to is not null THEN
524: l_Delivery_Condn9Tab(1).g_date_val := FND_DATE.CANONICAL_TO_DATE(p_pickup_date_to);

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

522:
523: IF p_pickup_date_to is not null THEN
524: l_Delivery_Condn9Tab(1).g_date_val := FND_DATE.CANONICAL_TO_DATE(p_pickup_date_to);
525: l_Delivery_Condn9Tab(1).g_Bind_Literal := ':b_pickup_date_to';
526: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Delivery_Table, ' AND WND.INITIAL_PICKUP_DATE <= :b_pickup_date_to', l_Delivery_Condn9Tab, 'DATE');
527: END IF;
528:
529: FOR I IN 1..l_Delivery_Table.COUNT
530: LOOP

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

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:
559:
560: LOOP