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 179: l_Party_Table WSH_ITM_QUERY_CUSTOM.g_CondnValTableType;

175: ' party_site.party_id = party.party_id'||
176: ' AND wsh_car.ACTIVE = ''A'' '||
177: ' AND party.party_id = wsh_car.carrier_id'||
178: ' AND loc.location_id = party_site.location_id';
179: l_Party_Table WSH_ITM_QUERY_CUSTOM.g_CondnValTableType;
180:
181: l_Party_Condn1Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
182: l_Party_Condn11Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
183: l_Party_Condn2Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;

Line 181: l_Party_Condn1Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;

177: ' AND party.party_id = wsh_car.carrier_id'||
178: ' AND loc.location_id = party_site.location_id';
179: l_Party_Table WSH_ITM_QUERY_CUSTOM.g_CondnValTableType;
180:
181: l_Party_Condn1Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
182: l_Party_Condn11Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
183: l_Party_Condn2Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
184: l_Party_Condn3Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
185: l_Party_Condn4Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;

Line 182: l_Party_Condn11Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;

178: ' AND loc.location_id = party_site.location_id';
179: l_Party_Table WSH_ITM_QUERY_CUSTOM.g_CondnValTableType;
180:
181: l_Party_Condn1Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
182: l_Party_Condn11Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
183: l_Party_Condn2Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
184: l_Party_Condn3Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
185: l_Party_Condn4Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
186:

Line 183: l_Party_Condn2Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;

179: l_Party_Table WSH_ITM_QUERY_CUSTOM.g_CondnValTableType;
180:
181: l_Party_Condn1Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
182: l_Party_Condn11Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
183: l_Party_Condn2Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
184: l_Party_Condn3Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
185: l_Party_Condn4Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
186:
187:

Line 184: l_Party_Condn3Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;

180:
181: l_Party_Condn1Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
182: l_Party_Condn11Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
183: l_Party_Condn2Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
184: l_Party_Condn3Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
185: l_Party_Condn4Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
186:
187:
188: l_Carrier_Table WSH_ITM_QUERY_CUSTOM.g_CondnValTableType;

Line 185: l_Party_Condn4Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;

181: l_Party_Condn1Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
182: l_Party_Condn11Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
183: l_Party_Condn2Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
184: l_Party_Condn3Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
185: l_Party_Condn4Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
186:
187:
188: l_Carrier_Table WSH_ITM_QUERY_CUSTOM.g_CondnValTableType;
189:

Line 188: l_Carrier_Table WSH_ITM_QUERY_CUSTOM.g_CondnValTableType;

184: l_Party_Condn3Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
185: l_Party_Condn4Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
186:
187:
188: l_Carrier_Table WSH_ITM_QUERY_CUSTOM.g_CondnValTableType;
189:
190: l_Carrier_Condn1Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
191: l_Carrier_Condn11Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
192: l_Carrier_Condn2Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;

Line 190: l_Carrier_Condn1Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;

186:
187:
188: l_Carrier_Table WSH_ITM_QUERY_CUSTOM.g_CondnValTableType;
189:
190: l_Carrier_Condn1Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
191: l_Carrier_Condn11Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
192: l_Carrier_Condn2Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
193: l_Carrier_Condn3Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
194:

Line 191: l_Carrier_Condn11Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;

187:
188: l_Carrier_Table WSH_ITM_QUERY_CUSTOM.g_CondnValTableType;
189:
190: l_Carrier_Condn1Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
191: l_Carrier_Condn11Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
192: l_Carrier_Condn2Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
193: l_Carrier_Condn3Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
194:
195:

Line 192: l_Carrier_Condn2Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;

188: l_Carrier_Table WSH_ITM_QUERY_CUSTOM.g_CondnValTableType;
189:
190: l_Carrier_Condn1Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
191: l_Carrier_Condn11Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
192: l_Carrier_Condn2Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
193: l_Carrier_Condn3Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
194:
195:
196: l_tempStr1 VARCHAR2(10000) := ' ';

Line 193: l_Carrier_Condn3Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;

189:
190: l_Carrier_Condn1Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
191: l_Carrier_Condn11Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
192: l_Carrier_Condn2Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
193: l_Carrier_Condn3Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
194:
195:
196: l_tempStr1 VARCHAR2(10000) := ' ';
197: l_tempStr2 VARCHAR2(10000) := ' ';

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

381: --
382: -- Debug Statements
383: --
384: IF l_debug_on THEN
385: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);
386: END IF;
387: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' AND PARTY.PARTY_NAME >= :b_from_party', l_Party_Condn1Tab, 'VARCHAR');
388:
389: ELSE

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

383: --
384: IF l_debug_on THEN
385: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);
386: END IF;
387: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' AND PARTY.PARTY_NAME >= :b_from_party', l_Party_Condn1Tab, 'VARCHAR');
388:
389: ELSE
390:
391: OPEN cur_carrier_party_name(p_from_party_code);

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

397: --
398: -- Debug Statements
399: --
400: IF l_debug_on THEN
401: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);
402: END IF;
403: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' AND PARTY.PARTY_NAME >= :b_from_party', l_Carrier_Condn1Tab, 'VARCHAR');
404:
405: END IF;

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

399: --
400: IF l_debug_on THEN
401: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);
402: END IF;
403: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' AND PARTY.PARTY_NAME >= :b_from_party', l_Carrier_Condn1Tab, 'VARCHAR');
404:
405: END IF;
406: END IF;
407:

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

418: --
419: -- Debug Statements
420: --
421: IF l_debug_on THEN
422: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);
423: END IF;
424: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' AND PARTY.PARTY_NAME <= :b_to_party', l_Party_Condn11Tab, 'VARCHAR');
425: ELSE
426:

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

420: --
421: IF l_debug_on THEN
422: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);
423: END IF;
424: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' AND PARTY.PARTY_NAME <= :b_to_party', l_Party_Condn11Tab, 'VARCHAR');
425: ELSE
426:
427: OPEN cur_carrier_party_name(p_to_party_code);
428: FETCH cur_carrier_party_name into l_to_party;

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

433: --
434: -- Debug Statements
435: --
436: IF l_debug_on THEN
437: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);
438: END IF;
439: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' AND PARTY.PARTY_NAME <= :b_to_party', l_Carrier_Condn11Tab, 'VARCHAR');
440:
441: END IF;

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

435: --
436: IF l_debug_on THEN
437: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);
438: END IF;
439: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' AND PARTY.PARTY_NAME <= :b_to_party', l_Carrier_Condn11Tab, 'VARCHAR');
440:
441: END IF;
442: END IF;
443:

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

450: --
451: -- Debug Statements
452: --
453: IF l_debug_on THEN
454: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);
455: END IF;
456: --
457: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' AND SITE_USES.SITE_USE_CODE = :b_site_use_code', l_Party_Condn2Tab, 'VARCHAR');
458: END IF;

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

453: IF l_debug_on THEN
454: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);
455: END IF;
456: --
457: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' AND SITE_USES.SITE_USE_CODE = :b_site_use_code', l_Party_Condn2Tab, 'VARCHAR');
458: END IF;
459:
460: --Adding Creates Last N Days Condn
461: IF p_created_n_days IS NOT NULL THEN

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

471: --
472: -- Debug Statements
473: --
474: IF l_debug_on THEN
475: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);
476: END IF;
477: --
478: IF p_party_type = 'CUSTOMER' OR p_party_type is NULL THEN
479:

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

476: END IF;
477: --
478: IF p_party_type = 'CUSTOMER' OR p_party_type is NULL THEN
479:
480: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' AND (SITE_USES.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
481: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR ACCT.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
482: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR ACCT_SITE.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
483: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR PARTY_SITE.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
484: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR LOC.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');

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

477: --
478: IF p_party_type = 'CUSTOMER' OR p_party_type is NULL THEN
479:
480: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' AND (SITE_USES.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
481: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR ACCT.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
482: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR ACCT_SITE.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
483: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR PARTY_SITE.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
484: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR LOC.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
485: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR PARTY.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');

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

478: IF p_party_type = 'CUSTOMER' OR p_party_type is NULL THEN
479:
480: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' AND (SITE_USES.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
481: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR ACCT.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
482: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR ACCT_SITE.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
483: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR PARTY_SITE.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
484: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR LOC.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
485: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR PARTY.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
486: 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 483: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR PARTY_SITE.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');

479:
480: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' AND (SITE_USES.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
481: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR ACCT.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
482: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR ACCT_SITE.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
483: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR PARTY_SITE.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
484: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR LOC.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
485: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR PARTY.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
486: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, l_ContactQuery || ' and ( hoc.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
487: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' or hcp.CREATION_DATE >= SYSDATE - :b_created_n_days))) ', l_Party_Condn3Tab, 'NUMBER');

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

480: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' AND (SITE_USES.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
481: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR ACCT.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
482: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR ACCT_SITE.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
483: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR PARTY_SITE.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
484: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR LOC.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
485: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR PARTY.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
486: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, l_ContactQuery || ' and ( hoc.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
487: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' or hcp.CREATION_DATE >= SYSDATE - :b_created_n_days))) ', l_Party_Condn3Tab, 'NUMBER');
488: END IF;

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

481: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR ACCT.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
482: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR ACCT_SITE.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
483: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR PARTY_SITE.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
484: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR LOC.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
485: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR PARTY.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
486: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, l_ContactQuery || ' and ( hoc.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
487: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' or hcp.CREATION_DATE >= SYSDATE - :b_created_n_days))) ', l_Party_Condn3Tab, 'NUMBER');
488: END IF;
489: IF p_party_type = 'CARRIER' OR p_party_type is NULL THEN

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

482: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR ACCT_SITE.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
483: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR PARTY_SITE.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
484: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR LOC.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
485: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR PARTY.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
486: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, l_ContactQuery || ' and ( hoc.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
487: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' or hcp.CREATION_DATE >= SYSDATE - :b_created_n_days))) ', l_Party_Condn3Tab, 'NUMBER');
488: END IF;
489: IF p_party_type = 'CARRIER' OR p_party_type is NULL THEN
490: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' AND ( PARTY_SITE.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Carrier_Condn2Tab, 'NUMBER');

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

483: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR PARTY_SITE.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
484: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR LOC.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
485: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR PARTY.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
486: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, l_ContactQuery || ' and ( hoc.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
487: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' or hcp.CREATION_DATE >= SYSDATE - :b_created_n_days))) ', l_Party_Condn3Tab, 'NUMBER');
488: END IF;
489: IF p_party_type = 'CARRIER' OR p_party_type is NULL THEN
490: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' AND ( PARTY_SITE.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Carrier_Condn2Tab, 'NUMBER');
491: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' OR PARTY.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Carrier_Condn2Tab, 'NUMBER');

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

486: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, l_ContactQuery || ' and ( hoc.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Party_Condn3Tab, 'NUMBER');
487: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' or hcp.CREATION_DATE >= SYSDATE - :b_created_n_days))) ', l_Party_Condn3Tab, 'NUMBER');
488: END IF;
489: IF p_party_type = 'CARRIER' OR p_party_type is NULL THEN
490: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' AND ( PARTY_SITE.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Carrier_Condn2Tab, 'NUMBER');
491: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' OR PARTY.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Carrier_Condn2Tab, 'NUMBER');
492: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' OR LOC.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Carrier_Condn2Tab, 'NUMBER');
493: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, l_ContactQuery || ' and ( hoc.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Carrier_Condn2Tab, 'NUMBER');
494: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' or hcp.CREATION_DATE >= SYSDATE - :b_created_n_days))) ', l_Carrier_Condn2Tab, 'NUMBER');

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

487: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' or hcp.CREATION_DATE >= SYSDATE - :b_created_n_days))) ', l_Party_Condn3Tab, 'NUMBER');
488: END IF;
489: IF p_party_type = 'CARRIER' OR p_party_type is NULL THEN
490: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' AND ( PARTY_SITE.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Carrier_Condn2Tab, 'NUMBER');
491: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' OR PARTY.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Carrier_Condn2Tab, 'NUMBER');
492: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' OR LOC.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Carrier_Condn2Tab, 'NUMBER');
493: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, l_ContactQuery || ' and ( hoc.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Carrier_Condn2Tab, 'NUMBER');
494: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' or hcp.CREATION_DATE >= SYSDATE - :b_created_n_days))) ', l_Carrier_Condn2Tab, 'NUMBER');
495:

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

488: END IF;
489: IF p_party_type = 'CARRIER' OR p_party_type is NULL THEN
490: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' AND ( PARTY_SITE.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Carrier_Condn2Tab, 'NUMBER');
491: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' OR PARTY.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Carrier_Condn2Tab, 'NUMBER');
492: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' OR LOC.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Carrier_Condn2Tab, 'NUMBER');
493: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, l_ContactQuery || ' and ( hoc.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Carrier_Condn2Tab, 'NUMBER');
494: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' or hcp.CREATION_DATE >= SYSDATE - :b_created_n_days))) ', l_Carrier_Condn2Tab, 'NUMBER');
495:
496: END IF;

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

489: IF p_party_type = 'CARRIER' OR p_party_type is NULL THEN
490: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' AND ( PARTY_SITE.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Carrier_Condn2Tab, 'NUMBER');
491: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' OR PARTY.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Carrier_Condn2Tab, 'NUMBER');
492: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' OR LOC.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Carrier_Condn2Tab, 'NUMBER');
493: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, l_ContactQuery || ' and ( hoc.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Carrier_Condn2Tab, 'NUMBER');
494: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' or hcp.CREATION_DATE >= SYSDATE - :b_created_n_days))) ', l_Carrier_Condn2Tab, 'NUMBER');
495:
496: END IF;
497: END IF;

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

490: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' AND ( PARTY_SITE.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Carrier_Condn2Tab, 'NUMBER');
491: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' OR PARTY.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Carrier_Condn2Tab, 'NUMBER');
492: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' OR LOC.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Carrier_Condn2Tab, 'NUMBER');
493: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, l_ContactQuery || ' and ( hoc.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Carrier_Condn2Tab, 'NUMBER');
494: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' or hcp.CREATION_DATE >= SYSDATE - :b_created_n_days))) ', l_Carrier_Condn2Tab, 'NUMBER');
495:
496: END IF;
497: END IF;
498:

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

511: --
512: -- Debug Statements
513: --
514: IF l_debug_on THEN
515: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);
516: END IF;
517: --
518: IF p_party_type = 'CUSTOMER' OR p_party_type is NULL THEN
519: 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 519: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' AND (SITE_USES.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');

515: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);
516: END IF;
517: --
518: IF p_party_type = 'CUSTOMER' OR p_party_type is NULL THEN
519: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' AND (SITE_USES.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
520: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR ACCT.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
521: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR ACCT_SITE.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
522: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR PARTY_SITE.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
523: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR LOC.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');

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

516: END IF;
517: --
518: IF p_party_type = 'CUSTOMER' OR p_party_type is NULL THEN
519: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' AND (SITE_USES.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
520: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR ACCT.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
521: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR ACCT_SITE.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
522: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR PARTY_SITE.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
523: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR LOC.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
524: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR PARTY.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');

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

517: --
518: IF p_party_type = 'CUSTOMER' OR p_party_type is NULL THEN
519: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' AND (SITE_USES.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
520: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR ACCT.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
521: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR ACCT_SITE.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
522: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR PARTY_SITE.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
523: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR LOC.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
524: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR PARTY.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
525: 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 522: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR PARTY_SITE.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');

518: IF p_party_type = 'CUSTOMER' OR p_party_type is NULL THEN
519: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' AND (SITE_USES.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
520: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR ACCT.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
521: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR ACCT_SITE.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
522: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR PARTY_SITE.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
523: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR LOC.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
524: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR PARTY.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
525: 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');
526: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' or hcp.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days))) ', l_Party_Condn4Tab, 'NUMBER');

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

519: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' AND (SITE_USES.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
520: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR ACCT.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
521: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR ACCT_SITE.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
522: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR PARTY_SITE.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
523: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR LOC.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
524: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR PARTY.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
525: 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');
526: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' or hcp.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days))) ', l_Party_Condn4Tab, 'NUMBER');
527:

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

520: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR ACCT.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
521: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR ACCT_SITE.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
522: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR PARTY_SITE.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
523: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR LOC.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
524: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR PARTY.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
525: 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');
526: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' or hcp.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days))) ', l_Party_Condn4Tab, 'NUMBER');
527:
528: END IF;

Line 525: 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');

521: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR ACCT_SITE.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
522: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR PARTY_SITE.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
523: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR LOC.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
524: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR PARTY.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
525: 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');
526: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' or hcp.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days))) ', l_Party_Condn4Tab, 'NUMBER');
527:
528: END IF;
529: IF p_party_type = 'CARRIER' OR p_party_type is NULL THEN

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

522: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR PARTY_SITE.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
523: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR LOC.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
524: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' OR PARTY.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');
525: 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');
526: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' or hcp.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days))) ', l_Party_Condn4Tab, 'NUMBER');
527:
528: END IF;
529: IF p_party_type = 'CARRIER' OR p_party_type is NULL THEN
530: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' AND (PARTY_SITE.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Carrier_Condn3Tab, 'NUMBER');

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

526: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' or hcp.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days))) ', l_Party_Condn4Tab, 'NUMBER');
527:
528: END IF;
529: IF p_party_type = 'CARRIER' OR p_party_type is NULL THEN
530: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' AND (PARTY_SITE.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Carrier_Condn3Tab, 'NUMBER');
531: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' OR PARTY.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Carrier_Condn3Tab, 'NUMBER');
532: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' OR LOC.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Carrier_Condn3Tab, 'NUMBER');
533: 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');
534: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' or hcp.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days))) ', l_Carrier_Condn3Tab, 'NUMBER');

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

527:
528: END IF;
529: IF p_party_type = 'CARRIER' OR p_party_type is NULL THEN
530: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' AND (PARTY_SITE.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Carrier_Condn3Tab, 'NUMBER');
531: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' OR PARTY.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Carrier_Condn3Tab, 'NUMBER');
532: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' OR LOC.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Carrier_Condn3Tab, 'NUMBER');
533: 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');
534: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' or hcp.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days))) ', l_Carrier_Condn3Tab, 'NUMBER');
535: END IF;

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

528: END IF;
529: IF p_party_type = 'CARRIER' OR p_party_type is NULL THEN
530: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' AND (PARTY_SITE.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Carrier_Condn3Tab, 'NUMBER');
531: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' OR PARTY.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Carrier_Condn3Tab, 'NUMBER');
532: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' OR LOC.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Carrier_Condn3Tab, 'NUMBER');
533: 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');
534: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' or hcp.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days))) ', l_Carrier_Condn3Tab, 'NUMBER');
535: END IF;
536: END IF;

Line 533: 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');

529: IF p_party_type = 'CARRIER' OR p_party_type is NULL THEN
530: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' AND (PARTY_SITE.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Carrier_Condn3Tab, 'NUMBER');
531: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' OR PARTY.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Carrier_Condn3Tab, 'NUMBER');
532: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' OR LOC.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Carrier_Condn3Tab, 'NUMBER');
533: 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');
534: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' or hcp.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days))) ', l_Carrier_Condn3Tab, 'NUMBER');
535: END IF;
536: END IF;
537:

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

530: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' AND (PARTY_SITE.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Carrier_Condn3Tab, 'NUMBER');
531: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' OR PARTY.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Carrier_Condn3Tab, 'NUMBER');
532: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' OR LOC.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Carrier_Condn3Tab, 'NUMBER');
533: 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');
534: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' or hcp.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days))) ', l_Carrier_Condn3Tab, 'NUMBER');
535: END IF;
536: END IF;
537:
538:

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

647: --
648: -- Debug Statements
649: --
650: IF l_debug_on THEN
651: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.BIND_VALUES',WSH_DEBUG_SV.C_PROC_LEVEL);
652: END IF;
653: --
654: WSH_ITM_QUERY_CUSTOM.BIND_VALUES(l_Party_Table,l_CursorID);
655:

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

650: IF l_debug_on THEN
651: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.BIND_VALUES',WSH_DEBUG_SV.C_PROC_LEVEL);
652: END IF;
653: --
654: WSH_ITM_QUERY_CUSTOM.BIND_VALUES(l_Party_Table,l_CursorID);
655:
656: --
657: -- Debug Statements
658: --

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

656: --
657: -- Debug Statements
658: --
659: IF l_debug_on THEN
660: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.BIND_VALUES',WSH_DEBUG_SV.C_PROC_LEVEL);
661: END IF;
662: --
663: WSH_ITM_QUERY_CUSTOM.BIND_VALUES(l_Carrier_Table,l_CursorID);
664:

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

659: IF l_debug_on THEN
660: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.BIND_VALUES',WSH_DEBUG_SV.C_PROC_LEVEL);
661: END IF;
662: --
663: WSH_ITM_QUERY_CUSTOM.BIND_VALUES(l_Carrier_Table,l_CursorID);
664:
665: IF l_debug_on THEN
666: WSH_DEBUG_SV.LOGMSG (l_module_name,'Successfull in binding values',WSH_DEBUG_SV.C_STMT_LEVEL);
667: END IF;