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

Line 21: l_Item_Table IN OUT NOCOPY WSH_ITM_QUERY_CUSTOM.g_CondnValTableType

17: -- Private method to Build Item Where Condition
18: PROCEDURE BUILD_ITEM_WHERE_CLAUSE(
19: p_item_from IN VARCHAR2,
20: p_item_to IN VARCHAR2,
21: l_Item_Table IN OUT NOCOPY WSH_ITM_QUERY_CUSTOM.g_CondnValTableType
22: )
23:
24: IS
25: l_flexfield_rec FND_FLEX_KEY_API.flexfield_type;

Line 30: l_Item_Condn2Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;

26: l_structure_rec FND_FLEX_KEY_API.structure_type;
27: l_segment_rec FND_FLEX_KEY_API.segment_type;
28: l_segment_tbl FND_FLEX_KEY_API.segment_list;
29:
30: l_Item_Condn2Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
31: l_Item_Condn22Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
32:
33: l_segment_number NUMBER;
34: l_mstk_segs VARCHAR2(850);

Line 31: l_Item_Condn22Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;

27: l_segment_rec FND_FLEX_KEY_API.segment_type;
28: l_segment_tbl FND_FLEX_KEY_API.segment_list;
29:
30: l_Item_Condn2Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
31: l_Item_Condn22Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
32:
33: l_segment_number NUMBER;
34: l_mstk_segs VARCHAR2(850);
35: l_mcat_segs VARCHAR2(850);

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

96: --
97: -- Debug Statements
98: --
99: IF l_debug_on THEN
100: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);
101: END IF;
102: --
103: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Item_Table, l_mstk_w, l_Item_Condn2Tab, 'VARCHAR');
104:

Line 103: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Item_Table, l_mstk_w, l_Item_Condn2Tab, 'VARCHAR');

99: IF l_debug_on THEN
100: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);
101: END IF;
102: --
103: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Item_Table, l_mstk_w, l_Item_Condn2Tab, 'VARCHAR');
104:
105: l_mstk_w := ' AND '||l_mstk_segs||' <= :b_item_to ';
106: l_Item_Condn22Tab(1).g_varchar_val := p_item_to;
107: l_Item_Condn22Tab(1).g_Bind_Literal := ':b_item_to';

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

108: --
109: -- Debug Statements
110: --
111: IF l_debug_on THEN
112: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);
113: END IF;
114: --
115: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Item_Table, l_mstk_w, l_Item_Condn22Tab, 'VARCHAR');
116: ELSIF p_item_from IS NOT NULL AND p_item_to IS NULL THEN

Line 115: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Item_Table, l_mstk_w, l_Item_Condn22Tab, 'VARCHAR');

111: IF l_debug_on THEN
112: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);
113: END IF;
114: --
115: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Item_Table, l_mstk_w, l_Item_Condn22Tab, 'VARCHAR');
116: ELSIF p_item_from IS NOT NULL AND p_item_to IS NULL THEN
117: l_mstk_w := ' AND '||l_mstk_segs||' >= :b_item_from';
118: l_Item_Condn2Tab(1).g_varchar_val := p_item_from;
119: l_Item_Condn2Tab(1).g_Bind_Literal := ':b_item_from';

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

120: --
121: -- Debug Statements
122: --
123: IF l_debug_on THEN
124: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);
125: END IF;
126: --
127: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Item_Table, l_mstk_w, l_Item_Condn2Tab, 'VARCHAR');
128: ELSIF p_item_from IS NULL AND p_item_to IS NOT NULL THEN

Line 127: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Item_Table, l_mstk_w, l_Item_Condn2Tab, 'VARCHAR');

123: IF l_debug_on THEN
124: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);
125: END IF;
126: --
127: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Item_Table, l_mstk_w, l_Item_Condn2Tab, 'VARCHAR');
128: ELSIF p_item_from IS NULL AND p_item_to IS NOT NULL THEN
129: l_mstk_w := ' AND '||l_mstk_segs||' <= :b_item_to';
130: l_Item_Condn2Tab(1).g_varchar_val := p_item_to;
131: l_Item_Condn2Tab(1).g_Bind_Literal := ':b_item_to';

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

132: --
133: -- Debug Statements
134: --
135: IF l_debug_on THEN
136: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);
137: END IF;
138: --
139: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Item_Table, l_mstk_w, l_Item_Condn2Tab, 'VARCHAR');
140: END IF;

Line 139: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Item_Table, l_mstk_w, l_Item_Condn2Tab, 'VARCHAR');

135: IF l_debug_on THEN
136: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);
137: END IF;
138: --
139: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Item_Table, l_mstk_w, l_Item_Condn2Tab, 'VARCHAR');
140: END IF;
141: end BUILD_ITEM_WHERE_CLAUSE;
142:
143:

Line 219: l_Item_Table WSH_ITM_QUERY_CUSTOM.g_CondnValTableType;

215: ' AND B.ORGANIZATION_ID = MP.ORGANIZATION_ID '||
216: ' AND OOD.ORGANIZATION_ID = MP.ORGANIZATION_ID' ;
217:
218:
219: l_Item_Table WSH_ITM_QUERY_CUSTOM.g_CondnValTableType;
220:
221: l_Item_Condn1Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
222: l_Item_Condn11Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
223: l_Item_Condn2Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;

Line 221: l_Item_Condn1Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;

217:
218:
219: l_Item_Table WSH_ITM_QUERY_CUSTOM.g_CondnValTableType;
220:
221: l_Item_Condn1Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
222: l_Item_Condn11Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
223: l_Item_Condn2Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
224: l_item_where_clause VARCHAR(1000);
225: l_Item_Condn3Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;

Line 222: l_Item_Condn11Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;

218:
219: l_Item_Table WSH_ITM_QUERY_CUSTOM.g_CondnValTableType;
220:
221: l_Item_Condn1Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
222: l_Item_Condn11Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
223: l_Item_Condn2Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
224: l_item_where_clause VARCHAR(1000);
225: l_Item_Condn3Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
226: l_Item_Condn4Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;

Line 223: l_Item_Condn2Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;

219: l_Item_Table WSH_ITM_QUERY_CUSTOM.g_CondnValTableType;
220:
221: l_Item_Condn1Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
222: l_Item_Condn11Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
223: l_Item_Condn2Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
224: l_item_where_clause VARCHAR(1000);
225: l_Item_Condn3Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
226: l_Item_Condn4Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
227: l_Item_Condn5Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;

Line 225: l_Item_Condn3Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;

221: l_Item_Condn1Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
222: l_Item_Condn11Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
223: l_Item_Condn2Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
224: l_item_where_clause VARCHAR(1000);
225: l_Item_Condn3Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
226: l_Item_Condn4Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
227: l_Item_Condn5Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
228: l_Item_Condn6Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
229:

Line 226: l_Item_Condn4Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;

222: l_Item_Condn11Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
223: l_Item_Condn2Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
224: l_item_where_clause VARCHAR(1000);
225: l_Item_Condn3Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
226: l_Item_Condn4Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
227: l_Item_Condn5Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
228: l_Item_Condn6Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
229:
230: l_tempStr VARCHAR2(10000) := ' ';

Line 227: l_Item_Condn5Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;

223: l_Item_Condn2Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
224: l_item_where_clause VARCHAR(1000);
225: l_Item_Condn3Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
226: l_Item_Condn4Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
227: l_Item_Condn5Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
228: l_Item_Condn6Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
229:
230: l_tempStr VARCHAR2(10000) := ' ';
231: l_CursorID NUMBER;

Line 228: l_Item_Condn6Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;

224: l_item_where_clause VARCHAR(1000);
225: l_Item_Condn3Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
226: l_Item_Condn4Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
227: l_Item_Condn5Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
228: l_Item_Condn6Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
229:
230: l_tempStr VARCHAR2(10000) := ' ';
231: l_CursorID NUMBER;
232: l_ignore NUMBER;

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

319: --
320: -- Debug Statements
321: --
322: IF l_debug_on THEN
323: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);
324: END IF;
325: --
326: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Item_Table, ' AND MP.ORGANIZATION_CODE >= :b_from_organization_code', l_Item_Condn1Tab, 'VARCHAR');
327:

Line 326: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Item_Table, ' AND MP.ORGANIZATION_CODE >= :b_from_organization_code', l_Item_Condn1Tab, 'VARCHAR');

322: IF l_debug_on THEN
323: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);
324: END IF;
325: --
326: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Item_Table, ' AND MP.ORGANIZATION_CODE >= :b_from_organization_code', l_Item_Condn1Tab, 'VARCHAR');
327:
328: l_Item_Condn11Tab(1).g_varchar_val := p_to_organization_code;
329: l_Item_Condn11Tab(1).g_Bind_Literal := ':b_to_organization_code';
330: --

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

330: --
331: -- Debug Statements
332: --
333: IF l_debug_on THEN
334: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);
335: END IF;
336: --
337: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Item_Table, ' AND MP.ORGANIZATION_CODE <= :b_to_organization_code', l_Item_Condn11Tab, 'VARCHAR');
338:

Line 337: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Item_Table, ' AND MP.ORGANIZATION_CODE <= :b_to_organization_code', l_Item_Condn11Tab, 'VARCHAR');

333: IF l_debug_on THEN
334: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);
335: END IF;
336: --
337: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Item_Table, ' AND MP.ORGANIZATION_CODE <= :b_to_organization_code', l_Item_Condn11Tab, 'VARCHAR');
338:
339: ELSIF p_from_organization_code IS NOT NULL THEN
340: --Adding a ORGANIZATION_CODE Condn
341: l_Item_Condn1Tab(1).g_varchar_val := p_from_organization_code;

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

343: --
344: -- Debug Statements
345: --
346: IF l_debug_on THEN
347: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);
348: END IF;
349: --
350: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Item_Table, ' AND MP.ORGANIZATION_CODE >= :b_from_organization_code ', l_Item_Condn1Tab, 'VARCHAR');
351:

Line 350: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Item_Table, ' AND MP.ORGANIZATION_CODE >= :b_from_organization_code ', l_Item_Condn1Tab, 'VARCHAR');

346: IF l_debug_on THEN
347: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);
348: END IF;
349: --
350: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Item_Table, ' AND MP.ORGANIZATION_CODE >= :b_from_organization_code ', l_Item_Condn1Tab, 'VARCHAR');
351:
352: ELSIF p_to_organization_code IS NOT NULL THEN
353: --Adding a ORGANIZATION_CODE Condn
354: l_Item_Condn1Tab(1).g_varchar_val := p_to_organization_code;

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

356: --
357: -- Debug Statements
358: --
359: IF l_debug_on THEN
360: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);
361: END IF;
362: --
363: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Item_Table, ' AND MP.ORGANIZATION_CODE <= :b_to_organization_code', l_Item_Condn1Tab, 'VARCHAR');
364: END IF;

Line 363: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Item_Table, ' AND MP.ORGANIZATION_CODE <= :b_to_organization_code', l_Item_Condn1Tab, 'VARCHAR');

359: IF l_debug_on THEN
360: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);
361: END IF;
362: --
363: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Item_Table, ' AND MP.ORGANIZATION_CODE <= :b_to_organization_code', l_Item_Condn1Tab, 'VARCHAR');
364: END IF;
365:
366: IF p_from_item IS NOT NULL OR p_to_item IS NOT NULL THEN
367: --

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

380: --
381: -- Debug Statements
382: --
383: IF l_debug_on THEN
384: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);
385: END IF;
386: --
387: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Item_Table, ' AND B.ITEM_TYPE = :b_user_item_type ', l_Item_Condn3Tab, 'VARCHAR');
388: END IF;

Line 387: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Item_Table, ' AND B.ITEM_TYPE = :b_user_item_type ', l_Item_Condn3Tab, 'VARCHAR');

383: IF l_debug_on THEN
384: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);
385: END IF;
386: --
387: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Item_Table, ' AND B.ITEM_TYPE = :b_user_item_type ', l_Item_Condn3Tab, 'VARCHAR');
388: END IF;
389:
390: --Adding Creates LAst N Days Condn
391: IF p_created_n_days IS NOT NULL THEN

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

394: --
395: -- Debug Statements
396: --
397: IF l_debug_on THEN
398: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);
399: END IF;
400: --
401: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Item_Table, ' AND B.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Item_Condn4Tab, 'NUMBER');
402: END IF;

Line 401: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Item_Table, ' AND B.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Item_Condn4Tab, 'NUMBER');

397: IF l_debug_on THEN
398: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);
399: END IF;
400: --
401: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Item_Table, ' AND B.CREATION_DATE >= SYSDATE - :b_created_n_days ', l_Item_Condn4Tab, 'NUMBER');
402: END IF;
403:
404: --Adding Creates LAst N Days Condn
405: IF p_updated_n_days IS NOT NULL THEN

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

408: --
409: -- Debug Statements
410: --
411: IF l_debug_on THEN
412: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);
413: END IF;
414: --
415: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Item_Table, ' AND B.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Item_Condn5Tab, 'NUMBER');
416: END IF;

Line 415: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Item_Table, ' AND B.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Item_Condn5Tab, 'NUMBER');

411: IF l_debug_on THEN
412: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);
413: END IF;
414: --
415: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Item_Table, ' AND B.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Item_Condn5Tab, 'NUMBER');
416: END IF;
417:
418:
419: --Printing the SQL before calling Customization procedure

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

489: --
490: -- Debug Statements
491: --
492: IF l_debug_on THEN
493: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.BIND_VALUES',WSH_DEBUG_SV.C_PROC_LEVEL);
494: END IF;
495: --
496: WSH_ITM_QUERY_CUSTOM.BIND_VALUES(l_Item_Table,l_CursorID);
497:

Line 496: WSH_ITM_QUERY_CUSTOM.BIND_VALUES(l_Item_Table,l_CursorID);

492: IF l_debug_on THEN
493: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.BIND_VALUES',WSH_DEBUG_SV.C_PROC_LEVEL);
494: END IF;
495: --
496: WSH_ITM_QUERY_CUSTOM.BIND_VALUES(l_Item_Table,l_CursorID);
497:
498:
499: IF l_debug_on THEN
500: WSH_DEBUG_SV.LOGMSG (l_module_name,'Successfull bind values',WSH_DEBUG_SV.C_STMT_LEVEL);