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_SFCB_UTILITIES dependencies on WIP_SFCB_UTILITIES

Line 1: PACKAGE BODY WIP_SFCB_UTILITIES AS

1: PACKAGE BODY WIP_SFCB_UTILITIES AS
2: /* $Header: wipsfcbb.pls 120.1 2006/05/18 12:44:19 shkalyan noship $ */
3:
4: /* Private Global variables for Linearity */
5:

Line 846: x_date_to := trunc(wip_sfcb_utilities.sdate_to_cdate(sysdate)) ;

842: * to be the To Date
843: ***********************************************/
844:
845: If p_date_to is null then
846: x_date_to := trunc(wip_sfcb_utilities.sdate_to_cdate(sysdate)) ;
847: ELSE
848: x_date_to := p_date_to ;
849: End if ;
850:

Line 933: trunc(wip_sfcb_utilities.sdate_to_cdate(wfs.scheduled_completion_date)),

929: program_application_id )
930: select
931: x_group_id,
932: p_line_id,
933: trunc(wip_sfcb_utilities.sdate_to_cdate(wfs.scheduled_completion_date)),
934: sum(wfs.planned_quantity),
935: x_available_quantity,
936: WIP_LINE_LOAD,
937: WIP_LINE_LOAD_PHASE_ONE,

Line 947: and trunc(wip_sfcb_utilities.sdate_to_cdate(wfs.scheduled_completion_date))

943: from
944: wip_flow_schedules wfs
945: where
946: wfs.line_id = p_line_id
947: and trunc(wip_sfcb_utilities.sdate_to_cdate(wfs.scheduled_completion_date))
948: between p_date_from and x_date_to
949: group by trunc(wip_sfcb_utilities.sdate_to_cdate(wfs.scheduled_completion_date)) ;
950:
951:

Line 949: group by trunc(wip_sfcb_utilities.sdate_to_cdate(wfs.scheduled_completion_date)) ;

945: where
946: wfs.line_id = p_line_id
947: and trunc(wip_sfcb_utilities.sdate_to_cdate(wfs.scheduled_completion_date))
948: between p_date_from and x_date_to
949: group by trunc(wip_sfcb_utilities.sdate_to_cdate(wfs.scheduled_completion_date)) ;
950:
951:
952: /* bug 2644622 - from meeting with richard and adrian, should only display
953: days with a schedule. So commenting this section out.

Line 1294: x_date_to := trunc(wip_sfcb_utilities.sdate_to_cdate(sysdate)) ;

1290: * to be the To Date
1291: ***********************************************/
1292:
1293: If p_date_to is null then
1294: x_date_to := trunc(wip_sfcb_utilities.sdate_to_cdate(sysdate)) ;
1295: ELSE
1296: x_date_to := p_date_to ;
1297: End if ;
1298:

Line 1342: s_time_from := wip_sfcb_utilities.cdate_to_sdate(x_date_from);

1338: x_date_from := p_date_from ;
1339: x_date_to := p_date_to ;
1340:
1341: -- compute the corresponding server times before hand
1342: s_time_from := wip_sfcb_utilities.cdate_to_sdate(x_date_from);
1343: s_time_to := wip_sfcb_utilities.cdate_to_sdate(x_date_to) + 1;
1344:
1345: -- Gets the Minimum Start Date and Maximum End Date to run
1346: -- the simulation for the line resource load.

Line 1343: s_time_to := wip_sfcb_utilities.cdate_to_sdate(x_date_to) + 1;

1339: x_date_to := p_date_to ;
1340:
1341: -- compute the corresponding server times before hand
1342: s_time_from := wip_sfcb_utilities.cdate_to_sdate(x_date_from);
1343: s_time_to := wip_sfcb_utilities.cdate_to_sdate(x_date_to) + 1;
1344:
1345: -- Gets the Minimum Start Date and Maximum End Date to run
1346: -- the simulation for the line resource load.
1347:

Line 1396: and WIP_SFCB_Utilities.line_op_is_pending (

1392: and bos.routing_sequence_id = bor.common_routing_sequence_id
1393: and wl.line_id = wfs.line_id
1394: and wl.organization_id = wfs.organization_id
1395: and wfs.status <> 2
1396: and WIP_SFCB_Utilities.line_op_is_pending (
1397: BOS.operation_seq_num,
1398: BOR.common_routing_sequence_id,
1399: WFS.primary_item_id,
1400: WFS.organization_id,

Line 1415: x_sim_date_from := trunc(wip_sfcb_utilities.sdate_to_cdate(x_sim_date_from));

1411: ( wfs.scheduled_completion_date >= s_time_from
1412: and wfs.scheduled_completion_date >= s_time_to )
1413: ) ;
1414:
1415: x_sim_date_from := trunc(wip_sfcb_utilities.sdate_to_cdate(x_sim_date_from));
1416: x_sim_date_to := trunc(wip_sfcb_utilities.sdate_to_cdate(x_sim_date_to));
1417:
1418: exception
1419: when others then

Line 1416: x_sim_date_to := trunc(wip_sfcb_utilities.sdate_to_cdate(x_sim_date_to));

1412: and wfs.scheduled_completion_date >= s_time_to )
1413: ) ;
1414:
1415: x_sim_date_from := trunc(wip_sfcb_utilities.sdate_to_cdate(x_sim_date_from));
1416: x_sim_date_to := trunc(wip_sfcb_utilities.sdate_to_cdate(x_sim_date_to));
1417:
1418: exception
1419: when others then
1420: --dbms_output.put_line('Exception in the simulation date calculation section');

Line 1488: WIP_SFCB_UTILITIES.get_Workday_factor

1484: 1,
1485: (NVL( bors.usage_rate_or_amount *
1486: (wofsv.planned_quantity-wofsv.quantity_completed),0
1487: )*
1488: WIP_SFCB_UTILITIES.get_Workday_factor
1489: (trunc(wip_sfcb_utilities.sdate_to_cdate(wofsv.scheduled_start_date)),
1490: trunc(wip_sfcb_utilities.sdate_to_cdate(wofsv.scheduled_completion_date)),
1491: trunc(x_date_from),
1492: trunc(x_date_to),

Line 1489: (trunc(wip_sfcb_utilities.sdate_to_cdate(wofsv.scheduled_start_date)),

1485: (NVL( bors.usage_rate_or_amount *
1486: (wofsv.planned_quantity-wofsv.quantity_completed),0
1487: )*
1488: WIP_SFCB_UTILITIES.get_Workday_factor
1489: (trunc(wip_sfcb_utilities.sdate_to_cdate(wofsv.scheduled_start_date)),
1490: trunc(wip_sfcb_utilities.sdate_to_cdate(wofsv.scheduled_completion_date)),
1491: trunc(x_date_from),
1492: trunc(x_date_to),
1493: bors.resource_id,

Line 1490: trunc(wip_sfcb_utilities.sdate_to_cdate(wofsv.scheduled_completion_date)),

1486: (wofsv.planned_quantity-wofsv.quantity_completed),0
1487: )*
1488: WIP_SFCB_UTILITIES.get_Workday_factor
1489: (trunc(wip_sfcb_utilities.sdate_to_cdate(wofsv.scheduled_start_date)),
1490: trunc(wip_sfcb_utilities.sdate_to_cdate(wofsv.scheduled_completion_date)),
1491: trunc(x_date_from),
1492: trunc(x_date_to),
1493: bors.resource_id,
1494: wofsv.organization_id)),

Line 1496: DECODE(sign(trunc(wip_sfcb_utilities.sdate_to_cdate(wofsv.scheduled_completion_date)) -

1492: trunc(x_date_to),
1493: bors.resource_id,
1494: wofsv.organization_id)),
1495: 2,
1496: DECODE(sign(trunc(wip_sfcb_utilities.sdate_to_cdate(wofsv.scheduled_completion_date)) -
1497: x_date_to),
1498: 1,
1499: 0,
1500: bors.usage_rate_or_amount

Line 2128: END WIP_SFCB_UTILITIES;

2124:
2125: end check_attachment_and_contract;
2126:
2127:
2128: END WIP_SFCB_UTILITIES;