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 2179: FROM WIP_DISCRETE_JOBS DJ, WIP_PERIOD_BALANCES WPB

2175: --check for only shop floor transactions
2176:
2177: cursor check_discrete_charges_1 is
2178: SELECT DISTINCT 'X'
2179: FROM WIP_DISCRETE_JOBS DJ, WIP_PERIOD_BALANCES WPB
2180: WHERE DJ.WIP_ENTITY_ID = WPB.WIP_ENTITY_ID
2181: AND DJ.ORGANIZATION_ID = WPB.ORGANIZATION_ID
2182: AND DJ.WIP_ENTITY_ID = p_wip_entity_id
2183: AND DJ.ORGANIZATION_ID = p_organization_id

Line 2300: insert into wip_period_balances (

2296: -- return;
2297: --end if;
2298: -- ED: bugfix 3299811
2299:
2300: insert into wip_period_balances (
2301: acct_period_id,
2302: wip_entity_id,
2303: last_update_date,
2304: last_updated_by,

Line 2357: from wip_period_balances wpb

2353: p_organization_id))
2354: and oap.period_close_date is null
2355: and not exists (
2356: select 'balance record already there'
2357: from wip_period_balances wpb
2358: where wpb.wip_entity_id = p_wip_entity_id
2359: and wpb.acct_period_id = oap.acct_period_id
2360: and wpb.organization_id = oap.organization_id);
2361:

Line 2379: -- from wip_period_balances wpb

2375: --where wc.class_code = p_class_code
2376: --and wc.organization_id = p_organization_id
2377: --and not exists (
2378: -- select 'balance record already there'
2379: -- from wip_period_balances wpb
2380: -- where wpb.wip_entity_id = p_wip_entity_id
2381: -- and wpb.acct_period_id = l_inv_period_id
2382: -- and wpb.organization_id = p_organization_id);
2383: -- ED: bugfix 3299811

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

2383: -- ED: bugfix 3299811
2384:
2385:
2386: if lbji_debug = 'Y' then
2387: fnd_file.put_line(fnd_file.log, 'Inserted '|| l_cnt ||' rows into wip_period_balances');
2388: end if;
2389:
2390: --if SQL%NOTFOUND then -- bug 3571360
2391: if l_cnt <= 0 then -- bug 3571360

Line 7043: delete from wip_period_balances

7039: end if; --p_skip_updt
7040: l_stmt_num := 1071;
7041: Begin
7042: if p_old_status_type <> 1 AND v_wlji_status_type(v_index) = 1 then
7043: delete from wip_period_balances
7044: where wip_entity_id = v_wlji_wip_entity_id(v_index)
7045: and organization_id = v_wlji_org(v_index);
7046: if lbji_debug = 'Y' then
7047: fnd_file.put_line(fnd_file.log, 'Deleted '||SQL%ROWCOUNT||' rows from wpb');