APPS.WIP_WEIGHTED_AVG dependencies on WIP_CONSTANTS

Line 12: select nvl(wp.auto_compute_final_completion, WIP_CONSTANTS.NO)

8: p_ret_code out nocopy number,
9: p_ret_msg out nocopy varchar2) is
10:
11: cursor get_final_cmp_flag(c_org_id number) is
12: select nvl(wp.auto_compute_final_completion, WIP_CONSTANTS.NO)
13: from wip_parameters wp
14: where wp.organization_id = c_org_id;
15:
16: cursor get_cost_method(c_org_id number) is

Line 47: if (x_pri_cost not in ( WIP_CONSTANTS.COST_AVG,

43: return;
44: end if;
45:
46: -- if not actual costing, nothing to do
47: if (x_pri_cost not in ( WIP_CONSTANTS.COST_AVG,
48: WIP_CONSTANTS.COST_STD, /*Fix for bug 8472985(FP 8320930)*/
49: WIP_CONSTANTS.COST_FIFO,
50: WIP_CONSTANTS.COST_LIFO ) ) then
51: p_auto_cmp := WIP_CONSTANTS.NO;

Line 48: WIP_CONSTANTS.COST_STD, /*Fix for bug 8472985(FP 8320930)*/

44: end if;
45:
46: -- if not actual costing, nothing to do
47: if (x_pri_cost not in ( WIP_CONSTANTS.COST_AVG,
48: WIP_CONSTANTS.COST_STD, /*Fix for bug 8472985(FP 8320930)*/
49: WIP_CONSTANTS.COST_FIFO,
50: WIP_CONSTANTS.COST_LIFO ) ) then
51: p_auto_cmp := WIP_CONSTANTS.NO;
52: return;

Line 49: WIP_CONSTANTS.COST_FIFO,

45:
46: -- if not actual costing, nothing to do
47: if (x_pri_cost not in ( WIP_CONSTANTS.COST_AVG,
48: WIP_CONSTANTS.COST_STD, /*Fix for bug 8472985(FP 8320930)*/
49: WIP_CONSTANTS.COST_FIFO,
50: WIP_CONSTANTS.COST_LIFO ) ) then
51: p_auto_cmp := WIP_CONSTANTS.NO;
52: return;
53: end if;

Line 50: WIP_CONSTANTS.COST_LIFO ) ) then

46: -- if not actual costing, nothing to do
47: if (x_pri_cost not in ( WIP_CONSTANTS.COST_AVG,
48: WIP_CONSTANTS.COST_STD, /*Fix for bug 8472985(FP 8320930)*/
49: WIP_CONSTANTS.COST_FIFO,
50: WIP_CONSTANTS.COST_LIFO ) ) then
51: p_auto_cmp := WIP_CONSTANTS.NO;
52: return;
53: end if;
54:

Line 51: p_auto_cmp := WIP_CONSTANTS.NO;

47: if (x_pri_cost not in ( WIP_CONSTANTS.COST_AVG,
48: WIP_CONSTANTS.COST_STD, /*Fix for bug 8472985(FP 8320930)*/
49: WIP_CONSTANTS.COST_FIFO,
50: WIP_CONSTANTS.COST_LIFO ) ) then
51: p_auto_cmp := WIP_CONSTANTS.NO;
52: return;
53: end if;
54:
55: -- get final completion flag

Line 104: and transaction_action_id in (WIP_CONSTANTS.CPLASSY_ACTION,

100: from mtl_material_transactions
101: where transaction_source_type_id = 5
102: and transaction_source_id = c_wip_id
103: and organization_id = c_org_id
104: and transaction_action_id in (WIP_CONSTANTS.CPLASSY_ACTION,
105: WIP_CONSTANTS.RETASSY_ACTION);
106: begin
107:
108: open get_net_job_qty(p_org_id, p_wip_id);

Line 105: WIP_CONSTANTS.RETASSY_ACTION);

101: where transaction_source_type_id = 5
102: and transaction_source_id = c_wip_id
103: and organization_id = c_org_id
104: and transaction_action_id in (WIP_CONSTANTS.CPLASSY_ACTION,
105: WIP_CONSTANTS.RETASSY_ACTION);
106: begin
107:
108: open get_net_job_qty(p_org_id, p_wip_id);
109: fetch get_net_job_qty into l_net_job_qty;

Line 154: if (x_auto_cmp <> WIP_CONSTANTS.YES) then

150: return;
151: end if;
152:
153: -- if not auto completion then nothing to do
154: if (x_auto_cmp <> WIP_CONSTANTS.YES) then
155: return;
156: end if;
157:
158: -- Fix bug 13826369

Line 206: and mmtt.transaction_action_id = WIP_CONSTANTS.CPLASSY_ACTION

202: select mmtt.rowid,
203: mmtt.primary_quantity
204: from mtl_material_transactions_temp mmtt
205: where mmtt.transaction_header_id = c_mtl_hdr_id
206: and mmtt.transaction_action_id = WIP_CONSTANTS.CPLASSY_ACTION
207: order by mmtt.source_line_id;
208:
209: x_auto_cmp number;
210: x_cost_method number;

Line 240: if (x_auto_cmp <> WIP_CONSTANTS.YES) then

236: return;
237: end if;
238:
239: -- if not auto completion then nothing to do
240: if (x_auto_cmp <> WIP_CONSTANTS.YES) then
241: return;
242: end if;
243:
244: get_rem_qty(p_org_id, p_wip_id, x_rem_qty);