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_PARTY_SYNC dependencies on WSH_ITM_QUERY_CUSTOM

Line 316: l_Party_Table WSH_ITM_QUERY_CUSTOM.g_CondnValTableType;

312:
313: -- gtm
314: l_itm_intg_gtm VARCHAR2(1) := 'N';
315:
316: l_Party_Table WSH_ITM_QUERY_CUSTOM.g_CondnValTableType;
317:
318: l_Party_Condn1Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
319: l_Party_Condn11Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
320: l_Party_Condn2Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;

Line 318: l_Party_Condn1Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;

314: l_itm_intg_gtm VARCHAR2(1) := 'N';
315:
316: l_Party_Table WSH_ITM_QUERY_CUSTOM.g_CondnValTableType;
317:
318: l_Party_Condn1Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
319: l_Party_Condn11Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
320: l_Party_Condn2Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
321: l_Party_Condn3Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
322: l_Party_Condn4Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;

Line 319: l_Party_Condn11Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;

315:
316: l_Party_Table WSH_ITM_QUERY_CUSTOM.g_CondnValTableType;
317:
318: l_Party_Condn1Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
319: l_Party_Condn11Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
320: l_Party_Condn2Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
321: l_Party_Condn3Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
322: l_Party_Condn4Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
323:

Line 320: l_Party_Condn2Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;

316: l_Party_Table WSH_ITM_QUERY_CUSTOM.g_CondnValTableType;
317:
318: l_Party_Condn1Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
319: l_Party_Condn11Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
320: l_Party_Condn2Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
321: l_Party_Condn3Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
322: l_Party_Condn4Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
323:
324:

Line 321: l_Party_Condn3Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;

317:
318: l_Party_Condn1Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
319: l_Party_Condn11Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
320: l_Party_Condn2Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
321: l_Party_Condn3Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
322: l_Party_Condn4Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
323:
324:
325: l_Carrier_Table WSH_ITM_QUERY_CUSTOM.g_CondnValTableType;

Line 322: l_Party_Condn4Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;

318: l_Party_Condn1Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
319: l_Party_Condn11Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
320: l_Party_Condn2Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
321: l_Party_Condn3Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
322: l_Party_Condn4Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
323:
324:
325: l_Carrier_Table WSH_ITM_QUERY_CUSTOM.g_CondnValTableType;
326:

Line 325: l_Carrier_Table WSH_ITM_QUERY_CUSTOM.g_CondnValTableType;

321: l_Party_Condn3Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
322: l_Party_Condn4Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
323:
324:
325: l_Carrier_Table WSH_ITM_QUERY_CUSTOM.g_CondnValTableType;
326:
327: l_Carrier_Condn1Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
328: l_Carrier_Condn11Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
329: l_Carrier_Condn2Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;

Line 327: l_Carrier_Condn1Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;

323:
324:
325: l_Carrier_Table WSH_ITM_QUERY_CUSTOM.g_CondnValTableType;
326:
327: l_Carrier_Condn1Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
328: l_Carrier_Condn11Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
329: l_Carrier_Condn2Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
330: l_Carrier_Condn3Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
331:

Line 328: l_Carrier_Condn11Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;

324:
325: l_Carrier_Table WSH_ITM_QUERY_CUSTOM.g_CondnValTableType;
326:
327: l_Carrier_Condn1Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
328: l_Carrier_Condn11Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
329: l_Carrier_Condn2Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
330: l_Carrier_Condn3Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
331:
332: -- gtm

Line 329: l_Carrier_Condn2Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;

325: l_Carrier_Table WSH_ITM_QUERY_CUSTOM.g_CondnValTableType;
326:
327: l_Carrier_Condn1Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
328: l_Carrier_Condn11Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
329: l_Carrier_Condn2Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
330: l_Carrier_Condn3Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
331:
332: -- gtm
333: l_gtm_Condn1Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;

Line 330: l_Carrier_Condn3Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;

326:
327: l_Carrier_Condn1Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
328: l_Carrier_Condn11Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
329: l_Carrier_Condn2Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
330: l_Carrier_Condn3Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
331:
332: -- gtm
333: l_gtm_Condn1Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
334:

Line 333: l_gtm_Condn1Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;

329: l_Carrier_Condn2Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
330: l_Carrier_Condn3Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
331:
332: -- gtm
333: l_gtm_Condn1Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
334:
335:
336: l_tempStr1 VARCHAR2(10000) := ' ';
337: l_tempStr2 VARCHAR2(10000) := ' ';

Line 577: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);

573: --
574: -- Debug Statements
575: --
576: IF l_debug_on THEN
577: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);
578: END IF;
579: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' AND PARTY.PARTY_NAME >= :b_from_party', l_Party_Condn1Tab, 'VARCHAR');
580:
581: ELSIF (p_party_type = 'CARRIER' ) THEN

Line 579: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' AND PARTY.PARTY_NAME >= :b_from_party', l_Party_Condn1Tab, 'VARCHAR');

575: --
576: IF l_debug_on THEN
577: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);
578: END IF;
579: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' AND PARTY.PARTY_NAME >= :b_from_party', l_Party_Condn1Tab, 'VARCHAR');
580:
581: ELSIF (p_party_type = 'CARRIER' ) THEN
582:
583: OPEN cur_carrier_party_name(p_from_party_code);

Line 593: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);

589: --
590: -- Debug Statements
591: --
592: IF l_debug_on THEN
593: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);
594: END IF;
595: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' AND PARTY.PARTY_NAME >= :b_from_party', l_Carrier_Condn1Tab, 'VARCHAR');
596:
597: ELSE

Line 595: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' AND PARTY.PARTY_NAME >= :b_from_party', l_Carrier_Condn1Tab, 'VARCHAR');

591: --
592: IF l_debug_on THEN
593: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);
594: END IF;
595: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' AND PARTY.PARTY_NAME >= :b_from_party', l_Carrier_Condn1Tab, 'VARCHAR');
596:
597: ELSE
598:
599: OPEN cur_other_party_name(p_from_party_code);

Line 609: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);

605: --
606: -- Debug Statements
607: --
608: IF l_debug_on THEN
609: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);
610: END IF;
611: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' AND PARTY.PARTY_NAME >= :b_from_party', l_Carrier_Condn1Tab, 'VARCHAR');
612:
613: END IF; -- } party_type

Line 611: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' AND PARTY.PARTY_NAME >= :b_from_party', l_Carrier_Condn1Tab, 'VARCHAR');

607: --
608: IF l_debug_on THEN
609: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);
610: END IF;
611: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' AND PARTY.PARTY_NAME >= :b_from_party', l_Carrier_Condn1Tab, 'VARCHAR');
612:
613: END IF; -- } party_type
614: END IF; -- } party_code not null
615:

Line 631: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);

627: --
628: -- Debug Statements
629: --
630: IF l_debug_on THEN
631: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);
632: END IF;
633: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' AND PARTY.PARTY_NAME <= :b_to_party', l_Party_Condn11Tab, 'VARCHAR');
634:
635: ELSIF (p_party_type = 'CARRIER' ) THEN

Line 633: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' AND PARTY.PARTY_NAME <= :b_to_party', l_Party_Condn11Tab, 'VARCHAR');

629: --
630: IF l_debug_on THEN
631: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);
632: END IF;
633: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' AND PARTY.PARTY_NAME <= :b_to_party', l_Party_Condn11Tab, 'VARCHAR');
634:
635: ELSIF (p_party_type = 'CARRIER' ) THEN
636:
637: OPEN cur_carrier_party_name(p_to_party_code);

Line 647: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);

643: --
644: -- Debug Statements
645: --
646: IF l_debug_on THEN
647: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);
648: END IF;
649: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' AND PARTY.PARTY_NAME <= :b_to_party', l_Carrier_Condn11Tab, 'VARCHAR');
650:
651: -- gtm

Line 649: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' AND PARTY.PARTY_NAME <= :b_to_party', l_Carrier_Condn11Tab, 'VARCHAR');

645: --
646: IF l_debug_on THEN
647: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);
648: END IF;
649: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' AND PARTY.PARTY_NAME <= :b_to_party', l_Carrier_Condn11Tab, 'VARCHAR');
650:
651: -- gtm
652: ELSE
653:

Line 664: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);

660: --
661: -- Debug Statements
662: --
663: IF l_debug_on THEN
664: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);
665: END IF;
666: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' AND PARTY.PARTY_NAME <= :b_to_party', l_Carrier_Condn11Tab, 'VARCHAR');
667:
668: END IF; -- } party_type

Line 666: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' AND PARTY.PARTY_NAME <= :b_to_party', l_Carrier_Condn11Tab, 'VARCHAR');

662: --
663: IF l_debug_on THEN
664: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);
665: END IF;
666: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' AND PARTY.PARTY_NAME <= :b_to_party', l_Carrier_Condn11Tab, 'VARCHAR');
667:
668: END IF; -- } party_type
669: END IF; -- } to party_code not null
670:

Line 680: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);

676: --
677: -- Debug Statements
678: --
679: IF l_debug_on THEN
680: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);
681: END IF;
682: --
683: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' AND PARTY.PARTY_TYPE = :b_party_type', l_gtm_Condn1Tab, 'VARCHAR');
684: END IF;

Line 683: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' AND PARTY.PARTY_TYPE = :b_party_type', l_gtm_Condn1Tab, 'VARCHAR');

679: IF l_debug_on THEN
680: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);
681: END IF;
682: --
683: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' AND PARTY.PARTY_TYPE = :b_party_type', l_gtm_Condn1Tab, 'VARCHAR');
684: END IF;
685: --}
686: --Adding Business Purpose Condn
687: IF p_site_use_code IS NOT NULL THEN

Line 694: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);

690: --
691: -- Debug Statements
692: --
693: IF l_debug_on THEN
694: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);
695: END IF;
696: --
697: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' AND SITE_USES.SITE_USE_CODE = :b_site_use_code', l_Party_Condn2Tab, 'VARCHAR');
698: END IF;

Line 697: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' AND SITE_USES.SITE_USE_CODE = :b_site_use_code', l_Party_Condn2Tab, 'VARCHAR');

693: IF l_debug_on THEN
694: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);
695: END IF;
696: --
697: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' AND SITE_USES.SITE_USE_CODE = :b_site_use_code', l_Party_Condn2Tab, 'VARCHAR');
698: END IF;
699:
700: --Adding Creates Last N Days Condn
701: IF p_created_n_days IS NOT NULL THEN

Line 716: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);

712: --
713: -- Debug Statements
714: --
715: IF l_debug_on THEN
716: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);
717: END IF;
718: --
719: IF p_party_type = 'CUSTOMER' OR p_party_type is NULL THEN
720:

Line 721: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' AND (SITE_USES.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');

717: END IF;
718: --
719: IF p_party_type = 'CUSTOMER' OR p_party_type is NULL THEN
720:
721: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' AND (SITE_USES.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
722: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR ACCT.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
723: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR ACCT_SITE.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
724: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR PARTY_SITE.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
725: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR LOC.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');

Line 722: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR ACCT.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');

718: --
719: IF p_party_type = 'CUSTOMER' OR p_party_type is NULL THEN
720:
721: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' AND (SITE_USES.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
722: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR ACCT.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
723: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR ACCT_SITE.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
724: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR PARTY_SITE.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
725: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR LOC.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
726: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR PARTY.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');

Line 723: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR ACCT_SITE.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');

719: IF p_party_type = 'CUSTOMER' OR p_party_type is NULL THEN
720:
721: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' AND (SITE_USES.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
722: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR ACCT.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
723: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR ACCT_SITE.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
724: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR PARTY_SITE.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
725: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR LOC.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
726: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR PARTY.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
727: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, l_ContactQuery || ' and ( hoc.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');

Line 724: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR PARTY_SITE.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');

720:
721: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' AND (SITE_USES.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
722: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR ACCT.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
723: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR ACCT_SITE.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
724: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR PARTY_SITE.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
725: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR LOC.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
726: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR PARTY.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
727: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, l_ContactQuery || ' and ( hoc.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
728: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' or hcp.CREATION_DATE >= SYSDATE - :b_created_n_days))) ', l_Party_Condn3Tab, 'NUMBER');

Line 725: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR LOC.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');

721: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' AND (SITE_USES.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
722: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR ACCT.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
723: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR ACCT_SITE.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
724: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR PARTY_SITE.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
725: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR LOC.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
726: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR PARTY.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
727: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, l_ContactQuery || ' and ( hoc.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
728: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' or hcp.CREATION_DATE >= SYSDATE - :b_created_n_days))) ', l_Party_Condn3Tab, 'NUMBER');
729: END IF;

Line 726: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR PARTY.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');

722: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR ACCT.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
723: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR ACCT_SITE.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
724: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR PARTY_SITE.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
725: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR LOC.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
726: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR PARTY.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
727: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, l_ContactQuery || ' and ( hoc.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
728: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' or hcp.CREATION_DATE >= SYSDATE - :b_created_n_days))) ', l_Party_Condn3Tab, 'NUMBER');
729: END IF;
730: -- gtm

Line 727: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, l_ContactQuery || ' and ( hoc.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');

723: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR ACCT_SITE.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
724: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR PARTY_SITE.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
725: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR LOC.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
726: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR PARTY.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
727: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, l_ContactQuery || ' and ( hoc.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
728: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' or hcp.CREATION_DATE >= SYSDATE - :b_created_n_days))) ', l_Party_Condn3Tab, 'NUMBER');
729: END IF;
730: -- gtm
731: IF (p_party_type <> 'CUSTOMER' OR p_party_type is NULL) THEN

Line 728: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' or hcp.CREATION_DATE >= SYSDATE - :b_created_n_days))) ', l_Party_Condn3Tab, 'NUMBER');

724: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR PARTY_SITE.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
725: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR LOC.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
726: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR PARTY.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
727: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, l_ContactQuery || ' and ( hoc.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
728: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' or hcp.CREATION_DATE >= SYSDATE - :b_created_n_days))) ', l_Party_Condn3Tab, 'NUMBER');
729: END IF;
730: -- gtm
731: IF (p_party_type <> 'CUSTOMER' OR p_party_type is NULL) THEN
732: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' AND ( PARTY_SITE.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Carrier_Condn2Tab, 'NUMBER');

Line 732: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' AND ( PARTY_SITE.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Carrier_Condn2Tab, 'NUMBER');

728: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' or hcp.CREATION_DATE >= SYSDATE - :b_created_n_days))) ', l_Party_Condn3Tab, 'NUMBER');
729: END IF;
730: -- gtm
731: IF (p_party_type <> 'CUSTOMER' OR p_party_type is NULL) THEN
732: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' AND ( PARTY_SITE.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Carrier_Condn2Tab, 'NUMBER');
733: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' OR PARTY.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Carrier_Condn2Tab, 'NUMBER');
734: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' OR LOC.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Carrier_Condn2Tab, 'NUMBER');
735: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, l_ContactQuery || ' and ( hoc.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Carrier_Condn2Tab, 'NUMBER');
736: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' or hcp.CREATION_DATE >= SYSDATE - :b_created_n_days))) ', l_Carrier_Condn2Tab, 'NUMBER');

Line 733: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' OR PARTY.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Carrier_Condn2Tab, 'NUMBER');

729: END IF;
730: -- gtm
731: IF (p_party_type <> 'CUSTOMER' OR p_party_type is NULL) THEN
732: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' AND ( PARTY_SITE.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Carrier_Condn2Tab, 'NUMBER');
733: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' OR PARTY.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Carrier_Condn2Tab, 'NUMBER');
734: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' OR LOC.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Carrier_Condn2Tab, 'NUMBER');
735: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, l_ContactQuery || ' and ( hoc.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Carrier_Condn2Tab, 'NUMBER');
736: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' or hcp.CREATION_DATE >= SYSDATE - :b_created_n_days))) ', l_Carrier_Condn2Tab, 'NUMBER');
737:

Line 734: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' OR LOC.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Carrier_Condn2Tab, 'NUMBER');

730: -- gtm
731: IF (p_party_type <> 'CUSTOMER' OR p_party_type is NULL) THEN
732: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' AND ( PARTY_SITE.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Carrier_Condn2Tab, 'NUMBER');
733: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' OR PARTY.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Carrier_Condn2Tab, 'NUMBER');
734: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' OR LOC.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Carrier_Condn2Tab, 'NUMBER');
735: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, l_ContactQuery || ' and ( hoc.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Carrier_Condn2Tab, 'NUMBER');
736: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' or hcp.CREATION_DATE >= SYSDATE - :b_created_n_days))) ', l_Carrier_Condn2Tab, 'NUMBER');
737:
738: END IF;

Line 735: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, l_ContactQuery || ' and ( hoc.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Carrier_Condn2Tab, 'NUMBER');

731: IF (p_party_type <> 'CUSTOMER' OR p_party_type is NULL) THEN
732: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' AND ( PARTY_SITE.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Carrier_Condn2Tab, 'NUMBER');
733: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' OR PARTY.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Carrier_Condn2Tab, 'NUMBER');
734: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' OR LOC.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Carrier_Condn2Tab, 'NUMBER');
735: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, l_ContactQuery || ' and ( hoc.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Carrier_Condn2Tab, 'NUMBER');
736: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' or hcp.CREATION_DATE >= SYSDATE - :b_created_n_days))) ', l_Carrier_Condn2Tab, 'NUMBER');
737:
738: END IF;
739: END IF;

Line 736: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' or hcp.CREATION_DATE >= SYSDATE - :b_created_n_days))) ', l_Carrier_Condn2Tab, 'NUMBER');

732: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' AND ( PARTY_SITE.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Carrier_Condn2Tab, 'NUMBER');
733: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' OR PARTY.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Carrier_Condn2Tab, 'NUMBER');
734: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' OR LOC.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Carrier_Condn2Tab, 'NUMBER');
735: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, l_ContactQuery || ' and ( hoc.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Carrier_Condn2Tab, 'NUMBER');
736: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' or hcp.CREATION_DATE >= SYSDATE - :b_created_n_days))) ', l_Carrier_Condn2Tab, 'NUMBER');
737:
738: END IF;
739: END IF;
740:

Line 758: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);

754: --
755: -- Debug Statements
756: --
757: IF l_debug_on THEN
758: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);
759: END IF;
760: --
761: IF p_party_type = 'CUSTOMER' OR p_party_type is NULL THEN
762: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' AND (SITE_USES.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');

Line 762: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' AND (SITE_USES.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');

758: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);
759: END IF;
760: --
761: IF p_party_type = 'CUSTOMER' OR p_party_type is NULL THEN
762: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' AND (SITE_USES.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
763: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR ACCT.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
764: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR ACCT_SITE.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
765: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR PARTY_SITE.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
766: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR LOC.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');

Line 763: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR ACCT.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');

759: END IF;
760: --
761: IF p_party_type = 'CUSTOMER' OR p_party_type is NULL THEN
762: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' AND (SITE_USES.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
763: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR ACCT.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
764: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR ACCT_SITE.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
765: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR PARTY_SITE.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
766: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR LOC.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
767: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR PARTY.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');

Line 764: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR ACCT_SITE.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');

760: --
761: IF p_party_type = 'CUSTOMER' OR p_party_type is NULL THEN
762: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' AND (SITE_USES.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
763: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR ACCT.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
764: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR ACCT_SITE.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
765: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR PARTY_SITE.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
766: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR LOC.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
767: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR PARTY.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
768: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, l_ContactQuery || ' and ( hoc.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');

Line 765: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR PARTY_SITE.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');

761: IF p_party_type = 'CUSTOMER' OR p_party_type is NULL THEN
762: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' AND (SITE_USES.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
763: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR ACCT.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
764: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR ACCT_SITE.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
765: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR PARTY_SITE.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
766: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR LOC.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
767: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR PARTY.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
768: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, l_ContactQuery || ' and ( hoc.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
769: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' or hcp.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days))) ', l_Party_Condn4Tab, 'NUMBER');

Line 766: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR LOC.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');

762: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' AND (SITE_USES.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
763: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR ACCT.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
764: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR ACCT_SITE.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
765: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR PARTY_SITE.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
766: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR LOC.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
767: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR PARTY.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
768: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, l_ContactQuery || ' and ( hoc.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
769: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' or hcp.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days))) ', l_Party_Condn4Tab, 'NUMBER');
770:

Line 767: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR PARTY.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');

763: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR ACCT.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
764: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR ACCT_SITE.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
765: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR PARTY_SITE.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
766: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR LOC.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
767: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR PARTY.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
768: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, l_ContactQuery || ' and ( hoc.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
769: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' or hcp.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days))) ', l_Party_Condn4Tab, 'NUMBER');
770:
771: END IF;

Line 768: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, l_ContactQuery || ' and ( hoc.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');

764: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR ACCT_SITE.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
765: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR PARTY_SITE.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
766: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR LOC.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
767: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR PARTY.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
768: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, l_ContactQuery || ' and ( hoc.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
769: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' or hcp.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days))) ', l_Party_Condn4Tab, 'NUMBER');
770:
771: END IF;
772: -- gtm

Line 769: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' or hcp.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days))) ', l_Party_Condn4Tab, 'NUMBER');

765: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR PARTY_SITE.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
766: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR LOC.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
767: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR PARTY.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
768: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, l_ContactQuery || ' and ( hoc.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
769: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' or hcp.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days))) ', l_Party_Condn4Tab, 'NUMBER');
770:
771: END IF;
772: -- gtm
773: IF p_party_type <> 'CUSTOMER' OR p_party_type is NULL THEN

Line 774: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' AND (PARTY_SITE.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Carrier_Condn3Tab, 'NUMBER');

770:
771: END IF;
772: -- gtm
773: IF p_party_type <> 'CUSTOMER' OR p_party_type is NULL THEN
774: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' AND (PARTY_SITE.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Carrier_Condn3Tab, 'NUMBER');
775: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' OR PARTY.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Carrier_Condn3Tab, 'NUMBER');
776: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' OR LOC.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Carrier_Condn3Tab, 'NUMBER');
777: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, l_ContactQuery || ' and ( hoc.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ',l_Carrier_Condn3Tab, 'NUMBER');
778: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' or hcp.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days))) ', l_Carrier_Condn3Tab, 'NUMBER');

Line 775: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' OR PARTY.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Carrier_Condn3Tab, 'NUMBER');

771: END IF;
772: -- gtm
773: IF p_party_type <> 'CUSTOMER' OR p_party_type is NULL THEN
774: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' AND (PARTY_SITE.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Carrier_Condn3Tab, 'NUMBER');
775: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' OR PARTY.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Carrier_Condn3Tab, 'NUMBER');
776: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' OR LOC.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Carrier_Condn3Tab, 'NUMBER');
777: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, l_ContactQuery || ' and ( hoc.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ',l_Carrier_Condn3Tab, 'NUMBER');
778: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' or hcp.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days))) ', l_Carrier_Condn3Tab, 'NUMBER');
779: END IF;

Line 776: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' OR LOC.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Carrier_Condn3Tab, 'NUMBER');

772: -- gtm
773: IF p_party_type <> 'CUSTOMER' OR p_party_type is NULL THEN
774: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' AND (PARTY_SITE.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Carrier_Condn3Tab, 'NUMBER');
775: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' OR PARTY.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Carrier_Condn3Tab, 'NUMBER');
776: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' OR LOC.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Carrier_Condn3Tab, 'NUMBER');
777: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, l_ContactQuery || ' and ( hoc.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ',l_Carrier_Condn3Tab, 'NUMBER');
778: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' or hcp.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days))) ', l_Carrier_Condn3Tab, 'NUMBER');
779: END IF;
780: END IF;

Line 777: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, l_ContactQuery || ' and ( hoc.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ',l_Carrier_Condn3Tab, 'NUMBER');

773: IF p_party_type <> 'CUSTOMER' OR p_party_type is NULL THEN
774: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' AND (PARTY_SITE.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Carrier_Condn3Tab, 'NUMBER');
775: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' OR PARTY.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Carrier_Condn3Tab, 'NUMBER');
776: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' OR LOC.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Carrier_Condn3Tab, 'NUMBER');
777: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, l_ContactQuery || ' and ( hoc.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ',l_Carrier_Condn3Tab, 'NUMBER');
778: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' or hcp.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days))) ', l_Carrier_Condn3Tab, 'NUMBER');
779: END IF;
780: END IF;
781:

Line 778: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' or hcp.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days))) ', l_Carrier_Condn3Tab, 'NUMBER');

774: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' AND (PARTY_SITE.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Carrier_Condn3Tab, 'NUMBER');
775: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' OR PARTY.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Carrier_Condn3Tab, 'NUMBER');
776: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' OR LOC.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Carrier_Condn3Tab, 'NUMBER');
777: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, l_ContactQuery || ' and ( hoc.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ',l_Carrier_Condn3Tab, 'NUMBER');
778: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' or hcp.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days))) ', l_Carrier_Condn3Tab, 'NUMBER');
779: END IF;
780: END IF;
781:
782:

Line 926: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.BIND_VALUES',WSH_DEBUG_SV.C_PROC_LEVEL);

922: --
923: -- Debug Statements
924: --
925: IF l_debug_on THEN
926: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.BIND_VALUES',WSH_DEBUG_SV.C_PROC_LEVEL);
927: END IF;
928: --
929: WSH_ITM_QUERY_CUSTOM.BIND_VALUES(l_Party_Table,l_CursorID);
930:

Line 929: WSH_ITM_QUERY_CUSTOM.BIND_VALUES(l_Party_Table,l_CursorID);

925: IF l_debug_on THEN
926: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.BIND_VALUES',WSH_DEBUG_SV.C_PROC_LEVEL);
927: END IF;
928: --
929: WSH_ITM_QUERY_CUSTOM.BIND_VALUES(l_Party_Table,l_CursorID);
930:
931: --
932: -- Debug Statements
933: --

Line 935: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.BIND_VALUES',WSH_DEBUG_SV.C_PROC_LEVEL);

931: --
932: -- Debug Statements
933: --
934: IF l_debug_on THEN
935: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.BIND_VALUES',WSH_DEBUG_SV.C_PROC_LEVEL);
936: END IF;
937: --
938: WSH_ITM_QUERY_CUSTOM.BIND_VALUES(l_Carrier_Table,l_CursorID);
939:

Line 938: WSH_ITM_QUERY_CUSTOM.BIND_VALUES(l_Carrier_Table,l_CursorID);

934: IF l_debug_on THEN
935: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.BIND_VALUES',WSH_DEBUG_SV.C_PROC_LEVEL);
936: END IF;
937: --
938: WSH_ITM_QUERY_CUSTOM.BIND_VALUES(l_Carrier_Table,l_CursorID);
939:
940: IF l_debug_on THEN
941: WSH_DEBUG_SV.LOGMSG (l_module_name,'Successfull in binding values',WSH_DEBUG_SV.C_STMT_LEVEL);
942: END IF;