APPS.WSM_LBJ_INTERFACE_PVT dependencies on WIP_PERIOD_BALANCES

Line 11109: delete from wip_period_balances

11105:
11106: l_stmt_num := 930;
11107: Begin
11108: if l_cur_status_type <> 1 AND v_wlji_status_type(v_idx) = 1 then
11109: delete from wip_period_balances
11110: where wip_entity_id = v_wlji_wip_entity_id(v_idx)
11111: and organization_id = v_wlji_org_id(v_idx);
11112: if lbji_debug = 'Y' then
11113: fnd_file.put_line(fnd_file.log,

Line 11114: 'Deleted '||SQL%ROWCOUNT||' rows from WIP_PERIOD_BALANCES');

11110: where wip_entity_id = v_wlji_wip_entity_id(v_idx)
11111: and organization_id = v_wlji_org_id(v_idx);
11112: if lbji_debug = 'Y' then
11113: fnd_file.put_line(fnd_file.log,
11114: 'Deleted '||SQL%ROWCOUNT||' rows from WIP_PERIOD_BALANCES');
11115: end if;
11116: end if;
11117:
11118: l_stmt_num := 940;

Line 20249: wip_period_balances wpb

20245:
20246: cursor check_discrete_charges is
20247: select distinct 'x'
20248: from wip_discrete_jobs wdj,
20249: wip_period_balances wpb
20250: where wdj.wip_entity_id = wpb.wip_entity_id
20251: and wdj.organization_id = wpb.organization_id
20252: and wdj.wip_entity_id = p_wip_entity_id
20253: and wdj.organization_id = p_organization_id

Line 20335: wip_period_balances wpb

20331:
20332: cursor check_discrete_charges_1 is
20333: select distinct 'x'
20334: from wip_discrete_jobs wdj,
20335: wip_period_balances wpb
20336: where wdj.wip_entity_id = wpb.wip_entity_id
20337: and wdj.organization_id = wpb.organization_id
20338: and wdj.wip_entity_id = p_wip_entity_id
20339: and wdj.organization_id = p_organization_id

Line 20455: insert into wip_period_balances (

20451: -- return;
20452: --end if;
20453: -- ED: bugfix 3299811
20454:
20455: insert into wip_period_balances (
20456: acct_period_id,
20457: wip_entity_id,
20458: last_update_date,
20459: last_updated_by,

Line 20512: from wip_period_balances wpb

20508: p_organization_id))
20509: and oap.period_close_date is null
20510: and not exists (
20511: select 'balance record already there'
20512: from wip_period_balances wpb
20513: where wpb.wip_entity_id = p_wip_entity_id
20514: and wpb.acct_period_id = oap.acct_period_id
20515: and wpb.organization_id = oap.organization_id);
20516:

Line 20534: -- from wip_period_balances wpb

20530: --where wc.class_code = p_class_code
20531: --and wc.organization_id = p_organization_id
20532: --and not exists (
20533: -- select 'balance record already there'
20534: -- from wip_period_balances wpb
20535: -- where wpb.wip_entity_id = p_wip_entity_id
20536: -- and wpb.acct_period_id = l_inv_period_id
20537: -- and wpb.organization_id = p_organization_id);
20538: -- ED: bugfix 3299811

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

20538: -- ED: bugfix 3299811
20539:
20540:
20541: if lbji_debug = 'Y' then
20542: fnd_file.put_line(fnd_file.log, 'Inserted '||l_cnt||' rows into wip_period_balances');
20543: end if;
20544:
20545: --if SQL%NOTFOUND then -- bug 3571360
20546: if l_cnt <= 0 then -- bug 3571360