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.WIP_WICTPG dependencies on WIP_CONSTANTS

Line 2330: ' and wdj.status_type = 12 ' || -- WIP_CONSTANTS.CLOSED

2326: ' wip_entities we ' ||
2327: /* Fix for bug#4902938 - Convert Literal to Bind variable*/
2328: ' where we.organization_id = :l_organization_id' ||
2329: ' and we.organization_id = wdj.organization_id ' ||
2330: ' and wdj.status_type = 12 ' || -- WIP_CONSTANTS.CLOSED
2331: /* Fix for bug#4902938 - Convert Literal to Bind variable*/
2332: /* Fix for bug#5137027 - remove '' for date bind variables */
2333: -- bug 5129924
2334: -- Commented out this condition as its handled

Line 2357: x_sql_stm1 := x_sql_stm1 || ' and we.entity_type = 3 ' ; -- WIP_CONSTANTS.CLOSED_DISCRETE_JOBS

2353: ' and wdj.date_closed between :l_from_date and :l_cutoff_date ' ;
2354: end if ;
2355:
2356: if (p_purge_type = PURGE_JOBS) then
2357: x_sql_stm1 := x_sql_stm1 || ' and we.entity_type = 3 ' ; -- WIP_CONSTANTS.CLOSED_DISCRETE_JOBS
2358: elsif (p_purge_type = PURGE_LOTBASED) then
2359: x_sql_stm1 := x_sql_stm1 || ' and we.entity_type = 8 ' ; -- WIP_CONSTANTS.CLOSED_OSFM
2360: elsif (p_purge_type = PURGE_ALL) then
2361: x_sql_stm1 := x_sql_stm1 || ' and we.entity_type in (3, 8) ' ;

Line 2359: x_sql_stm1 := x_sql_stm1 || ' and we.entity_type = 8 ' ; -- WIP_CONSTANTS.CLOSED_OSFM

2355:
2356: if (p_purge_type = PURGE_JOBS) then
2357: x_sql_stm1 := x_sql_stm1 || ' and we.entity_type = 3 ' ; -- WIP_CONSTANTS.CLOSED_DISCRETE_JOBS
2358: elsif (p_purge_type = PURGE_LOTBASED) then
2359: x_sql_stm1 := x_sql_stm1 || ' and we.entity_type = 8 ' ; -- WIP_CONSTANTS.CLOSED_OSFM
2360: elsif (p_purge_type = PURGE_ALL) then
2361: x_sql_stm1 := x_sql_stm1 || ' and we.entity_type in (3, 8) ' ;
2362: end if ;
2363:

Line 2467: ' and wrs.status_type in ( 7,5 ) ' ; -- WIP_CONSTANTS.COMP_NOCHRG, CANCELLED

2463: -- bug 5129924
2464: -- Commented this where clause as its handled below
2465: -- ntungare
2466: -- ' and wrs.date_closed <= :l_cutoff_date '||
2467: ' and wrs.status_type in ( 7,5 ) ' ; -- WIP_CONSTANTS.COMP_NOCHRG, CANCELLED
2468:
2469: -- bug 5129924
2470: -- Added following if statement and
2471: -- removed wrs.date_closed condition in

Line 2724: and (x_purge_request.entity_type <> WIP_CONSTANTS.CLOSED_OSFM)) ) then

2720: if (nvl(p_header_flag,FALSE)) then
2721: -- For Jobs
2722: if ( (p_purge_type = PURGE_JOBS) or
2723: ( (p_purge_type = PURGE_ALL) and (x_purge_request.line_id is NULL)
2724: and (x_purge_request.entity_type <> WIP_CONSTANTS.CLOSED_OSFM)) ) then
2725: delete_job_header(
2726: p_option => nvl(p_option,REPORT_ONLY),
2727: p_group_id => x_group_id,
2728: p_purge_request => x_purge_request);