APPS.WSMPLBJI dependencies on WIP_PERIOD_BALANCES

Line 2114: FROM WIP_DISCRETE_JOBS DJ, WIP_PERIOD_BALANCES WPB

2110: l_stmt_num NUMBER;
2111:
2112: cursor check_discrete_charges is
2113: SELECT DISTINCT 'X'
2114: FROM WIP_DISCRETE_JOBS DJ, WIP_PERIOD_BALANCES WPB
2115: WHERE DJ.WIP_ENTITY_ID = WPB.WIP_ENTITY_ID
2116: AND DJ.ORGANIZATION_ID = WPB.ORGANIZATION_ID
2117: AND DJ.WIP_ENTITY_ID = p_wip_entity_id
2118: AND DJ.ORGANIZATION_ID = p_organization_id

Line 2185: FROM WIP_DISCRETE_JOBS DJ, WIP_PERIOD_BALANCES WPB

2181: --check for only shop floor transactions
2182:
2183: cursor check_discrete_charges_1 is
2184: SELECT DISTINCT 'X'
2185: FROM WIP_DISCRETE_JOBS DJ, WIP_PERIOD_BALANCES WPB
2186: WHERE DJ.WIP_ENTITY_ID = WPB.WIP_ENTITY_ID
2187: AND DJ.ORGANIZATION_ID = WPB.ORGANIZATION_ID
2188: AND DJ.WIP_ENTITY_ID = p_wip_entity_id
2189: AND DJ.ORGANIZATION_ID = p_organization_id

Line 2306: insert into wip_period_balances (

2302: -- return;
2303: --end if;
2304: -- ED: bugfix 3299811
2305:
2306: insert into wip_period_balances (
2307: acct_period_id,
2308: wip_entity_id,
2309: last_update_date,
2310: last_updated_by,

Line 2363: from wip_period_balances wpb

2359: p_organization_id))
2360: and oap.period_close_date is null
2361: and not exists (
2362: select 'balance record already there'
2363: from wip_period_balances wpb
2364: where wpb.wip_entity_id = p_wip_entity_id
2365: and wpb.acct_period_id = oap.acct_period_id
2366: and wpb.organization_id = oap.organization_id);
2367:

Line 2385: -- from wip_period_balances wpb

2381: --where wc.class_code = p_class_code
2382: --and wc.organization_id = p_organization_id
2383: --and not exists (
2384: -- select 'balance record already there'
2385: -- from wip_period_balances wpb
2386: -- where wpb.wip_entity_id = p_wip_entity_id
2387: -- and wpb.acct_period_id = l_inv_period_id
2388: -- and wpb.organization_id = p_organization_id);
2389: -- ED: bugfix 3299811

Line 2393: fnd_file.put_line(fnd_file.log, 'Inserted '|| l_cnt ||' rows into wip_period_balances');

2389: -- ED: bugfix 3299811
2390:
2391:
2392: if lbji_debug = 'Y' then
2393: fnd_file.put_line(fnd_file.log, 'Inserted '|| l_cnt ||' rows into wip_period_balances');
2394: end if;
2395:
2396: --if SQL%NOTFOUND then -- bug 3571360
2397: if l_cnt <= 0 then -- bug 3571360

Line 7049: delete from wip_period_balances

7045: end if; --p_skip_updt
7046: l_stmt_num := 1071;
7047: Begin
7048: if p_old_status_type <> 1 AND v_wlji_status_type(v_index) = 1 then
7049: delete from wip_period_balances
7050: where wip_entity_id = v_wlji_wip_entity_id(v_index)
7051: and organization_id = v_wlji_org(v_index);
7052: if lbji_debug = 'Y' then
7053: fnd_file.put_line(fnd_file.log, 'Deleted '||SQL%ROWCOUNT||' rows from wpb');