DBA Data[Home] [Help]

APPS.WIP_CALENDAR dependencies on WIP_CONSTANTS

Line 69: IF (x_sched_dir = WIP_CONSTANTS.FUSD) THEN

65: BEGIN
66: new_quantity := x_quantity;
67: new_fixed_lead := NVL(x_fixed_lead,0);
68: new_proc_days := x_proc_days;
69: IF (x_sched_dir = WIP_CONSTANTS.FUSD) THEN
70: x_sched_date := x_fusd;
71: ELSIF(x_sched_dir = WIP_CONSTANTS.FUCD) THEN
72: x_sched_date := x_fucd;
73: ELSIF(x_sched_dir = WIP_CONSTANTS.LUSD) THEN

Line 71: ELSIF(x_sched_dir = WIP_CONSTANTS.FUCD) THEN

67: new_fixed_lead := NVL(x_fixed_lead,0);
68: new_proc_days := x_proc_days;
69: IF (x_sched_dir = WIP_CONSTANTS.FUSD) THEN
70: x_sched_date := x_fusd;
71: ELSIF(x_sched_dir = WIP_CONSTANTS.FUCD) THEN
72: x_sched_date := x_fucd;
73: ELSIF(x_sched_dir = WIP_CONSTANTS.LUSD) THEN
74: x_sched_date := x_lusd;
75: ELSIF(x_sched_dir = WIP_CONSTANTS.LUCD) THEN

Line 73: ELSIF(x_sched_dir = WIP_CONSTANTS.LUSD) THEN

69: IF (x_sched_dir = WIP_CONSTANTS.FUSD) THEN
70: x_sched_date := x_fusd;
71: ELSIF(x_sched_dir = WIP_CONSTANTS.FUCD) THEN
72: x_sched_date := x_fucd;
73: ELSIF(x_sched_dir = WIP_CONSTANTS.LUSD) THEN
74: x_sched_date := x_lusd;
75: ELSIF(x_sched_dir = WIP_CONSTANTS.LUCD) THEN
76: x_sched_date := x_lucd;
77: END IF;

Line 75: ELSIF(x_sched_dir = WIP_CONSTANTS.LUCD) THEN

71: ELSIF(x_sched_dir = WIP_CONSTANTS.FUCD) THEN
72: x_sched_date := x_fucd;
73: ELSIF(x_sched_dir = WIP_CONSTANTS.LUSD) THEN
74: x_sched_date := x_lusd;
75: ELSIF(x_sched_dir = WIP_CONSTANTS.LUCD) THEN
76: x_sched_date := x_lucd;
77: END IF;
78:
79: IF (x_entity_type = WIP_CONSTANTS.REPETITIVE) THEN

Line 79: IF (x_entity_type = WIP_CONSTANTS.REPETITIVE) THEN

75: ELSIF(x_sched_dir = WIP_CONSTANTS.LUCD) THEN
76: x_sched_date := x_lucd;
77: END IF;
78:
79: IF (x_entity_type = WIP_CONSTANTS.REPETITIVE) THEN
80: IF (x_sched_dir = WIP_CONSTANTS.LUSD) /* LUSD = 3 */ THEN
81: new_quantity := 0.0;
82: new_fixed_lead := 0.0;
83: ELSE

Line 80: IF (x_sched_dir = WIP_CONSTANTS.LUSD) /* LUSD = 3 */ THEN

76: x_sched_date := x_lucd;
77: END IF;
78:
79: IF (x_entity_type = WIP_CONSTANTS.REPETITIVE) THEN
80: IF (x_sched_dir = WIP_CONSTANTS.LUSD) /* LUSD = 3 */ THEN
81: new_quantity := 0.0;
82: new_fixed_lead := 0.0;
83: ELSE
84: new_quantity := 1.0;

Line 88: IF (((x_sched_dir = WIP_CONSTANTS.FUCD) /* FUCD = 2 */ AND

84: new_quantity := 1.0;
85: END IF;
86: END IF;
87:
88: IF (((x_sched_dir = WIP_CONSTANTS.FUCD) /* FUCD = 2 */ AND
89: (x_entity_type = WIP_CONSTANTS.REPETITIVE)) OR
90: -- anything other than repetitive is scheduled the same
91: (nvl(x_entity_type, WIP_CONSTANTS.DISCRETE)
92: <> WIP_CONSTANTS.REPETITIVE)) THEN

Line 89: (x_entity_type = WIP_CONSTANTS.REPETITIVE)) OR

85: END IF;
86: END IF;
87:
88: IF (((x_sched_dir = WIP_CONSTANTS.FUCD) /* FUCD = 2 */ AND
89: (x_entity_type = WIP_CONSTANTS.REPETITIVE)) OR
90: -- anything other than repetitive is scheduled the same
91: (nvl(x_entity_type, WIP_CONSTANTS.DISCRETE)
92: <> WIP_CONSTANTS.REPETITIVE)) THEN
93: new_proc_days := 1.0;

Line 91: (nvl(x_entity_type, WIP_CONSTANTS.DISCRETE)

87:
88: IF (((x_sched_dir = WIP_CONSTANTS.FUCD) /* FUCD = 2 */ AND
89: (x_entity_type = WIP_CONSTANTS.REPETITIVE)) OR
90: -- anything other than repetitive is scheduled the same
91: (nvl(x_entity_type, WIP_CONSTANTS.DISCRETE)
92: <> WIP_CONSTANTS.REPETITIVE)) THEN
93: new_proc_days := 1.0;
94: END IF;
95:

Line 92: <> WIP_CONSTANTS.REPETITIVE)) THEN

88: IF (((x_sched_dir = WIP_CONSTANTS.FUCD) /* FUCD = 2 */ AND
89: (x_entity_type = WIP_CONSTANTS.REPETITIVE)) OR
90: -- anything other than repetitive is scheduled the same
91: (nvl(x_entity_type, WIP_CONSTANTS.DISCRETE)
92: <> WIP_CONSTANTS.REPETITIVE)) THEN
93: new_proc_days := 1.0;
94: END IF;
95:
96: lt := new_fixed_lead + NVL(x_var_lead,0) * new_quantity;

Line 102: IF((x_sched_dir = WIP_CONSTANTS.LUCD) AND

98: /* Fix for bug 3410450. The following piece of code is added for the specific case of
99: LUCD for all entity types other than 'REPETITIVE'.
100: */
101:
102: IF((x_sched_dir = WIP_CONSTANTS.LUCD) AND
103: (nvl(x_entity_type, WIP_CONSTANTS.DISCRETE)
104: <> WIP_CONSTANTS.REPETITIVE)) THEN
105:
106: /* To check if total lead time is an integer.

Line 103: (nvl(x_entity_type, WIP_CONSTANTS.DISCRETE)

99: LUCD for all entity types other than 'REPETITIVE'.
100: */
101:
102: IF((x_sched_dir = WIP_CONSTANTS.LUCD) AND
103: (nvl(x_entity_type, WIP_CONSTANTS.DISCRETE)
104: <> WIP_CONSTANTS.REPETITIVE)) THEN
105:
106: /* To check if total lead time is an integer.
107: If the total lead time is integral, new_proc_days is set to 0 otherwise

Line 104: <> WIP_CONSTANTS.REPETITIVE)) THEN

100: */
101:
102: IF((x_sched_dir = WIP_CONSTANTS.LUCD) AND
103: (nvl(x_entity_type, WIP_CONSTANTS.DISCRETE)
104: <> WIP_CONSTANTS.REPETITIVE)) THEN
105:
106: /* To check if total lead time is an integer.
107: If the total lead time is integral, new_proc_days is set to 0 otherwise
108: it retains the prior value 1.

Line 129: IF (x_sched_dir = WIP_CONSTANTS.FUSD) /* FUSD = 1 */ THEN

125: close cursor_working_day;
126: END IF;
127:
128: /*End of fix for bug 3410450 */
129: IF (x_sched_dir = WIP_CONSTANTS.FUSD) /* FUSD = 1 */ THEN
130: new_date := x_sched_date;
131: open cursor_forward;
132: fetch cursor_forward into new_date;
133: IF (cursor_forward%NOTFOUND) THEN