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

Line 1019: AND NOT (p_inf_sch_mode IN (WIP_CONSTANTS.FORWARDS,

1015: END IF;
1016: -- End : Basic validations for the input parameters --
1017:
1018: IF ( (p_inf_sch_flag = 'Y')
1019: AND NOT (p_inf_sch_mode IN (WIP_CONSTANTS.FORWARDS,
1020: WIP_CONSTANTS.MIDPOINT_FORWARDS,
1021: WIP_CONSTANTS.CURRENT_OP,
1022: WIP_CONSTANTS.BACKWARDS,
1023: WIP_CONSTANTS.MIDPOINT_BACKWARDS)

Line 1020: WIP_CONSTANTS.MIDPOINT_FORWARDS,

1016: -- End : Basic validations for the input parameters --
1017:
1018: IF ( (p_inf_sch_flag = 'Y')
1019: AND NOT (p_inf_sch_mode IN (WIP_CONSTANTS.FORWARDS,
1020: WIP_CONSTANTS.MIDPOINT_FORWARDS,
1021: WIP_CONSTANTS.CURRENT_OP,
1022: WIP_CONSTANTS.BACKWARDS,
1023: WIP_CONSTANTS.MIDPOINT_BACKWARDS)
1024: OR p_inf_sch_mode IS NULL

Line 1021: WIP_CONSTANTS.CURRENT_OP,

1017:
1018: IF ( (p_inf_sch_flag = 'Y')
1019: AND NOT (p_inf_sch_mode IN (WIP_CONSTANTS.FORWARDS,
1020: WIP_CONSTANTS.MIDPOINT_FORWARDS,
1021: WIP_CONSTANTS.CURRENT_OP,
1022: WIP_CONSTANTS.BACKWARDS,
1023: WIP_CONSTANTS.MIDPOINT_BACKWARDS)
1024: OR p_inf_sch_mode IS NULL
1025: )

Line 1022: WIP_CONSTANTS.BACKWARDS,

1018: IF ( (p_inf_sch_flag = 'Y')
1019: AND NOT (p_inf_sch_mode IN (WIP_CONSTANTS.FORWARDS,
1020: WIP_CONSTANTS.MIDPOINT_FORWARDS,
1021: WIP_CONSTANTS.CURRENT_OP,
1022: WIP_CONSTANTS.BACKWARDS,
1023: WIP_CONSTANTS.MIDPOINT_BACKWARDS)
1024: OR p_inf_sch_mode IS NULL
1025: )
1026: )

Line 1023: WIP_CONSTANTS.MIDPOINT_BACKWARDS)

1019: AND NOT (p_inf_sch_mode IN (WIP_CONSTANTS.FORWARDS,
1020: WIP_CONSTANTS.MIDPOINT_FORWARDS,
1021: WIP_CONSTANTS.CURRENT_OP,
1022: WIP_CONSTANTS.BACKWARDS,
1023: WIP_CONSTANTS.MIDPOINT_BACKWARDS)
1024: OR p_inf_sch_mode IS NULL
1025: )
1026: )
1027: THEN

Line 3539: wip_constants.PER_LOT,

3535: BOR.activity_id,
3536: BOR.standard_rate_flag,
3537: BOR.assigned_units,
3538: decode(BOR.basis_type,
3539: wip_constants.PER_LOT,
3540: BOR.usage_rate_or_amount,
3541: BOR.usage_rate_or_amount * nvl(WCRO.QUANTITY_PER_ASSEMBLY,1)
3542: ) usage_rate_or_amount,
3543: BOR.USAGE_RATE_OR_AMOUNT_INVERSE,

Line 3950: IF (p_inf_sch_mode IN (WIP_CONSTANTS.FORWARDS,

3946: l_stmt_num := 330;
3947:
3948: IF (l_inf_sch_flag = 'Y') THEN
3949:
3950: IF (p_inf_sch_mode IN (WIP_CONSTANTS.FORWARDS,
3951: WIP_CONSTANTS.MIDPOINT_FORWARDS,
3952: WIP_CONSTANTS.CURRENT_OP)
3953: )
3954: THEN

Line 3951: WIP_CONSTANTS.MIDPOINT_FORWARDS,

3947:
3948: IF (l_inf_sch_flag = 'Y') THEN
3949:
3950: IF (p_inf_sch_mode IN (WIP_CONSTANTS.FORWARDS,
3951: WIP_CONSTANTS.MIDPOINT_FORWARDS,
3952: WIP_CONSTANTS.CURRENT_OP)
3953: )
3954: THEN
3955: l_inf_sch_start_date := nvl(p_inf_sch_date, nvl(l_curr_op_start_date, sysdate));

Line 3952: WIP_CONSTANTS.CURRENT_OP)

3948: IF (l_inf_sch_flag = 'Y') THEN
3949:
3950: IF (p_inf_sch_mode IN (WIP_CONSTANTS.FORWARDS,
3951: WIP_CONSTANTS.MIDPOINT_FORWARDS,
3952: WIP_CONSTANTS.CURRENT_OP)
3953: )
3954: THEN
3955: l_inf_sch_start_date := nvl(p_inf_sch_date, nvl(l_curr_op_start_date, sysdate));
3956: l_inf_sch_comp_date := NULL;

Line 3957: ELSIF (p_inf_sch_mode IN (WIP_CONSTANTS.BACKWARDS,

3953: )
3954: THEN
3955: l_inf_sch_start_date := nvl(p_inf_sch_date, nvl(l_curr_op_start_date, sysdate));
3956: l_inf_sch_comp_date := NULL;
3957: ELSIF (p_inf_sch_mode IN (WIP_CONSTANTS.BACKWARDS,
3958: WIP_CONSTANTS.MIDPOINT_BACKWARDS)
3959: )
3960: THEN
3961: l_inf_sch_start_date := NULL;

Line 3958: WIP_CONSTANTS.MIDPOINT_BACKWARDS)

3954: THEN
3955: l_inf_sch_start_date := nvl(p_inf_sch_date, nvl(l_curr_op_start_date, sysdate));
3956: l_inf_sch_comp_date := NULL;
3957: ELSIF (p_inf_sch_mode IN (WIP_CONSTANTS.BACKWARDS,
3958: WIP_CONSTANTS.MIDPOINT_BACKWARDS)
3959: )
3960: THEN
3961: l_inf_sch_start_date := NULL;
3962: l_inf_sch_comp_date := nvl(p_inf_sch_date, nvl(l_curr_op_compl_date, sysdate));

Line 3967: -- l_inf_sch_mode := WIP_CONSTANTS.MIDPOINT_FORWARDS;

3963: ELSIF (p_inf_sch_mode IS NULL) THEN
3964:
3965: IF (l_is_curr_op_reco = 'Y') THEN
3966: -- ST : Fix for bug 5181364 : do forward scheduling instead of midpoints_forward scheduling.
3967: -- l_inf_sch_mode := WIP_CONSTANTS.MIDPOINT_FORWARDS;
3968: l_inf_sch_mode := WIP_CONSTANTS.FORWARDS;
3969: ELSE
3970: l_inf_sch_mode := WIP_CONSTANTS.CURRENT_OP;
3971: END IF;

Line 3968: l_inf_sch_mode := WIP_CONSTANTS.FORWARDS;

3964:
3965: IF (l_is_curr_op_reco = 'Y') THEN
3966: -- ST : Fix for bug 5181364 : do forward scheduling instead of midpoints_forward scheduling.
3967: -- l_inf_sch_mode := WIP_CONSTANTS.MIDPOINT_FORWARDS;
3968: l_inf_sch_mode := WIP_CONSTANTS.FORWARDS;
3969: ELSE
3970: l_inf_sch_mode := WIP_CONSTANTS.CURRENT_OP;
3971: END IF;
3972:

Line 3970: l_inf_sch_mode := WIP_CONSTANTS.CURRENT_OP;

3966: -- ST : Fix for bug 5181364 : do forward scheduling instead of midpoints_forward scheduling.
3967: -- l_inf_sch_mode := WIP_CONSTANTS.MIDPOINT_FORWARDS;
3968: l_inf_sch_mode := WIP_CONSTANTS.FORWARDS;
3969: ELSE
3970: l_inf_sch_mode := WIP_CONSTANTS.CURRENT_OP;
3971: END IF;
3972:
3973: l_inf_sch_start_date := nvl(p_inf_sch_date, nvl(l_curr_op_start_date, sysdate));
3974: l_inf_sch_comp_date := NULL;

Line 4143: AND (p_inf_sch_mode NOT IN (WIP_CONSTANTS.MIDPOINT_FORWARDS,

4139:
4140: l_stmt_num := 10;
4141:
4142: IF ( (p_inf_sch_flag = 'Y')
4143: AND (p_inf_sch_mode NOT IN (WIP_CONSTANTS.MIDPOINT_FORWARDS,
4144: WIP_CONSTANTS.CURRENT_OP)
4145: OR p_inf_sch_mode IS NOT NULL
4146: )
4147: )

Line 4144: WIP_CONSTANTS.CURRENT_OP)

4140: l_stmt_num := 10;
4141:
4142: IF ( (p_inf_sch_flag = 'Y')
4143: AND (p_inf_sch_mode NOT IN (WIP_CONSTANTS.MIDPOINT_FORWARDS,
4144: WIP_CONSTANTS.CURRENT_OP)
4145: OR p_inf_sch_mode IS NOT NULL
4146: )
4147: )
4148: THEN

Line 4935: -- l_inf_sch_mode := WIP_CONSTANTS.MIDPOINT_FORWARDS;

4931: IF (p_inf_sch_mode IS NULL) THEN
4932:
4933: IF (l_on_rec_path = 'Y') THEN
4934: -- ST : Fix for bug 5181364 : do forward scheduling instead of midpoints_forward scheduling.
4935: -- l_inf_sch_mode := WIP_CONSTANTS.MIDPOINT_FORWARDS;
4936: l_inf_sch_mode := WIP_CONSTANTS.FORWARDS;
4937: ELSE
4938: l_inf_sch_mode := WIP_CONSTANTS.CURRENT_OP;
4939: END IF;

Line 4936: l_inf_sch_mode := WIP_CONSTANTS.FORWARDS;

4932:
4933: IF (l_on_rec_path = 'Y') THEN
4934: -- ST : Fix for bug 5181364 : do forward scheduling instead of midpoints_forward scheduling.
4935: -- l_inf_sch_mode := WIP_CONSTANTS.MIDPOINT_FORWARDS;
4936: l_inf_sch_mode := WIP_CONSTANTS.FORWARDS;
4937: ELSE
4938: l_inf_sch_mode := WIP_CONSTANTS.CURRENT_OP;
4939: END IF;
4940:

Line 4938: l_inf_sch_mode := WIP_CONSTANTS.CURRENT_OP;

4934: -- ST : Fix for bug 5181364 : do forward scheduling instead of midpoints_forward scheduling.
4935: -- l_inf_sch_mode := WIP_CONSTANTS.MIDPOINT_FORWARDS;
4936: l_inf_sch_mode := WIP_CONSTANTS.FORWARDS;
4937: ELSE
4938: l_inf_sch_mode := WIP_CONSTANTS.CURRENT_OP;
4939: END IF;
4940:
4941: END IF;
4942:

Line 5573: ROUND(nvl(WCO.RECO_SCHEDULED_QUANTITY, wdj.start_quantity), WIP_CONSTANTS.MAX_DISPLAYED_PRECISION),

5569: WCO.STANDARD_OPERATION_ID,
5570: WCO.DEPARTMENT_ID,
5571: WCO.OPERATION_DESCRIPTION,
5572: -- Bug 5603843. Modified inside nvl clause from 0 to wdj.start_quantity
5573: ROUND(nvl(WCO.RECO_SCHEDULED_QUANTITY, wdj.start_quantity), WIP_CONSTANTS.MAX_DISPLAYED_PRECISION),
5574: (decode(wdj.status_type,3, round(wdj.start_quantity,
5575: wip_constants.max_displayed_precision), 0)),
5576: 0, 0, 0, 0, 0,
5577: decode(recommended, 'Y', nvl(RECO_START_DATE, WCO.LAST_UPDATE_DATE), WCO.LAST_UPDATE_DATE),

Line 5575: wip_constants.max_displayed_precision), 0)),

5571: WCO.OPERATION_DESCRIPTION,
5572: -- Bug 5603843. Modified inside nvl clause from 0 to wdj.start_quantity
5573: ROUND(nvl(WCO.RECO_SCHEDULED_QUANTITY, wdj.start_quantity), WIP_CONSTANTS.MAX_DISPLAYED_PRECISION),
5574: (decode(wdj.status_type,3, round(wdj.start_quantity,
5575: wip_constants.max_displayed_precision), 0)),
5576: 0, 0, 0, 0, 0,
5577: decode(recommended, 'Y', nvl(RECO_START_DATE, WCO.LAST_UPDATE_DATE), WCO.LAST_UPDATE_DATE),
5578: decode(recommended, 'Y', nvl(RECO_COMPLETION_DATE, WCO.LAST_UPDATE_DATE), WCO.LAST_UPDATE_DATE),
5579: decode(recommended, 'Y', nvl(RECO_START_DATE, WCO.LAST_UPDATE_DATE), WCO.LAST_UPDATE_DATE),