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_FIFO,
49: WIP_CONSTANTS.COST_LIFO ) ) then
50: p_auto_cmp := WIP_CONSTANTS.NO;
51: return;

Line 48: WIP_CONSTANTS.COST_FIFO,

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_FIFO,
49: WIP_CONSTANTS.COST_LIFO ) ) then
50: p_auto_cmp := WIP_CONSTANTS.NO;
51: return;
52: end if;

Line 49: WIP_CONSTANTS.COST_LIFO ) ) then

45:
46: -- if not actual costing, nothing to do
47: if (x_pri_cost not in ( WIP_CONSTANTS.COST_AVG,
48: WIP_CONSTANTS.COST_FIFO,
49: WIP_CONSTANTS.COST_LIFO ) ) then
50: p_auto_cmp := WIP_CONSTANTS.NO;
51: return;
52: end if;
53:

Line 50: p_auto_cmp := WIP_CONSTANTS.NO;

46: -- if not actual costing, nothing to do
47: if (x_pri_cost not in ( WIP_CONSTANTS.COST_AVG,
48: WIP_CONSTANTS.COST_FIFO,
49: WIP_CONSTANTS.COST_LIFO ) ) then
50: p_auto_cmp := WIP_CONSTANTS.NO;
51: return;
52: end if;
53:
54: -- get final completion flag

Line 103: and transaction_action_id in (WIP_CONSTANTS.CPLASSY_ACTION,

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

Line 104: WIP_CONSTANTS.RETASSY_ACTION);

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

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

148: return;
149: end if;
150:
151: -- if not auto completion then nothing to do
152: if (x_auto_cmp <> WIP_CONSTANTS.YES) then
153: return;
154: end if;
155:
156: get_rem_qty(p_org_id, p_wip_id, x_rem_qty);

Line 183: and mmtt.transaction_action_id = WIP_CONSTANTS.CPLASSY_ACTION

179: select mmtt.rowid,
180: mmtt.primary_quantity
181: from mtl_material_transactions_temp mmtt
182: where mmtt.transaction_header_id = c_mtl_hdr_id
183: and mmtt.transaction_action_id = WIP_CONSTANTS.CPLASSY_ACTION
184: order by mmtt.source_line_id;
185:
186: x_auto_cmp number;
187: x_cost_method number;

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

212: return;
213: end if;
214:
215: -- if not auto completion then nothing to do
216: if (x_auto_cmp <> WIP_CONSTANTS.YES) then
217: return;
218: end if;
219:
220: get_rem_qty(p_org_id, p_wip_id, x_rem_qty);