APPS.WSM_LBJ_INTERFACE_PVT dependencies on WIP_PERIOD_BALANCES

Line 11211: delete from wip_period_balances

11207:
11208: l_stmt_num := 930;
11209: Begin
11210: if l_cur_status_type <> 1 AND v_wlji_status_type(v_idx) = 1 then
11211: delete from wip_period_balances
11212: where wip_entity_id = v_wlji_wip_entity_id(v_idx)
11213: and organization_id = v_wlji_org_id(v_idx);
11214: if lbji_debug = 'Y' then
11215: fnd_file.put_line(fnd_file.log,

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

11212: where wip_entity_id = v_wlji_wip_entity_id(v_idx)
11213: and organization_id = v_wlji_org_id(v_idx);
11214: if lbji_debug = 'Y' then
11215: fnd_file.put_line(fnd_file.log,
11216: 'Deleted '||SQL%ROWCOUNT||' rows from WIP_PERIOD_BALANCES');
11217: end if;
11218: end if;
11219:
11220: l_stmt_num := 940;

Line 20905: wip_period_balances wpb

20901:
20902: cursor check_discrete_charges is
20903: select distinct 'x'
20904: from wip_discrete_jobs wdj,
20905: wip_period_balances wpb
20906: where wdj.wip_entity_id = wpb.wip_entity_id
20907: and wdj.organization_id = wpb.organization_id
20908: and wdj.wip_entity_id = p_wip_entity_id
20909: and wdj.organization_id = p_organization_id

Line 21000: wip_period_balances wpb

20996:
20997: cursor check_discrete_charges_1 is
20998: select distinct 'x'
20999: from wip_discrete_jobs wdj,
21000: wip_period_balances wpb
21001: where wdj.wip_entity_id = wpb.wip_entity_id
21002: and wdj.organization_id = wpb.organization_id
21003: and wdj.wip_entity_id = p_wip_entity_id
21004: and wdj.organization_id = p_organization_id

Line 21120: insert into wip_period_balances (

21116: -- return;
21117: --end if;
21118: -- ED: bugfix 3299811
21119:
21120: insert into wip_period_balances (
21121: acct_period_id,
21122: wip_entity_id,
21123: last_update_date,
21124: last_updated_by,

Line 21177: from wip_period_balances wpb

21173: p_organization_id))
21174: and oap.period_close_date is null
21175: and not exists (
21176: select 'balance record already there'
21177: from wip_period_balances wpb
21178: where wpb.wip_entity_id = p_wip_entity_id
21179: and wpb.acct_period_id = oap.acct_period_id
21180: and wpb.organization_id = oap.organization_id);
21181:

Line 21199: -- from wip_period_balances wpb

21195: --where wc.class_code = p_class_code
21196: --and wc.organization_id = p_organization_id
21197: --and not exists (
21198: -- select 'balance record already there'
21199: -- from wip_period_balances wpb
21200: -- where wpb.wip_entity_id = p_wip_entity_id
21201: -- and wpb.acct_period_id = l_inv_period_id
21202: -- and wpb.organization_id = p_organization_id);
21203: -- ED: bugfix 3299811

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

21203: -- ED: bugfix 3299811
21204:
21205:
21206: if lbji_debug = 'Y' then
21207: fnd_file.put_line(fnd_file.log, 'Inserted '||l_cnt||' rows into wip_period_balances');
21208: end if;
21209:
21210: --if SQL%NOTFOUND then -- bug 3571360
21211: if l_cnt <= 0 then -- bug 3571360