eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OPI_EDW_IDS_CALC dependencies on OPI_IDS_PUSH_LOG

Line 5: ( beg_int_qty opi_ids_push_log.beg_int_qty%TYPE,

1: PACKAGE BODY opi_edw_ids_calc as
2: /*$Header: OPIMPPBB.pls 120.1 2005/06/07 03:30:10 appldev $*/
3:
4: TYPE bal_rec IS RECORD
5: ( beg_int_qty opi_ids_push_log.beg_int_qty%TYPE,
6: beg_int_val_b opi_ids_push_log.beg_int_val_b%TYPE,
7: beg_onh_qty opi_ids_push_log.beg_onh_qty%TYPE,
8: beg_onh_val_b opi_ids_push_log.beg_onh_val_b%TYPE,
9: beg_wip_qty opi_ids_push_log.beg_wip_qty%TYPE,

Line 6: beg_int_val_b opi_ids_push_log.beg_int_val_b%TYPE,

2: /*$Header: OPIMPPBB.pls 120.1 2005/06/07 03:30:10 appldev $*/
3:
4: TYPE bal_rec IS RECORD
5: ( beg_int_qty opi_ids_push_log.beg_int_qty%TYPE,
6: beg_int_val_b opi_ids_push_log.beg_int_val_b%TYPE,
7: beg_onh_qty opi_ids_push_log.beg_onh_qty%TYPE,
8: beg_onh_val_b opi_ids_push_log.beg_onh_val_b%TYPE,
9: beg_wip_qty opi_ids_push_log.beg_wip_qty%TYPE,
10: beg_wip_val_b opi_ids_push_log.beg_wip_val_b%TYPE,

Line 7: beg_onh_qty opi_ids_push_log.beg_onh_qty%TYPE,

3:
4: TYPE bal_rec IS RECORD
5: ( beg_int_qty opi_ids_push_log.beg_int_qty%TYPE,
6: beg_int_val_b opi_ids_push_log.beg_int_val_b%TYPE,
7: beg_onh_qty opi_ids_push_log.beg_onh_qty%TYPE,
8: beg_onh_val_b opi_ids_push_log.beg_onh_val_b%TYPE,
9: beg_wip_qty opi_ids_push_log.beg_wip_qty%TYPE,
10: beg_wip_val_b opi_ids_push_log.beg_wip_val_b%TYPE,
11: end_int_qty opi_ids_push_log.end_int_qty%TYPE,

Line 8: beg_onh_val_b opi_ids_push_log.beg_onh_val_b%TYPE,

4: TYPE bal_rec IS RECORD
5: ( beg_int_qty opi_ids_push_log.beg_int_qty%TYPE,
6: beg_int_val_b opi_ids_push_log.beg_int_val_b%TYPE,
7: beg_onh_qty opi_ids_push_log.beg_onh_qty%TYPE,
8: beg_onh_val_b opi_ids_push_log.beg_onh_val_b%TYPE,
9: beg_wip_qty opi_ids_push_log.beg_wip_qty%TYPE,
10: beg_wip_val_b opi_ids_push_log.beg_wip_val_b%TYPE,
11: end_int_qty opi_ids_push_log.end_int_qty%TYPE,
12: end_int_val_b opi_ids_push_log.end_int_val_b%TYPE,

Line 9: beg_wip_qty opi_ids_push_log.beg_wip_qty%TYPE,

5: ( beg_int_qty opi_ids_push_log.beg_int_qty%TYPE,
6: beg_int_val_b opi_ids_push_log.beg_int_val_b%TYPE,
7: beg_onh_qty opi_ids_push_log.beg_onh_qty%TYPE,
8: beg_onh_val_b opi_ids_push_log.beg_onh_val_b%TYPE,
9: beg_wip_qty opi_ids_push_log.beg_wip_qty%TYPE,
10: beg_wip_val_b opi_ids_push_log.beg_wip_val_b%TYPE,
11: end_int_qty opi_ids_push_log.end_int_qty%TYPE,
12: end_int_val_b opi_ids_push_log.end_int_val_b%TYPE,
13: end_onh_qty opi_ids_push_log.end_onh_qty%TYPE,

Line 10: beg_wip_val_b opi_ids_push_log.beg_wip_val_b%TYPE,

6: beg_int_val_b opi_ids_push_log.beg_int_val_b%TYPE,
7: beg_onh_qty opi_ids_push_log.beg_onh_qty%TYPE,
8: beg_onh_val_b opi_ids_push_log.beg_onh_val_b%TYPE,
9: beg_wip_qty opi_ids_push_log.beg_wip_qty%TYPE,
10: beg_wip_val_b opi_ids_push_log.beg_wip_val_b%TYPE,
11: end_int_qty opi_ids_push_log.end_int_qty%TYPE,
12: end_int_val_b opi_ids_push_log.end_int_val_b%TYPE,
13: end_onh_qty opi_ids_push_log.end_onh_qty%TYPE,
14: end_onh_val_b opi_ids_push_log.end_onh_val_b%TYPE,

Line 11: end_int_qty opi_ids_push_log.end_int_qty%TYPE,

7: beg_onh_qty opi_ids_push_log.beg_onh_qty%TYPE,
8: beg_onh_val_b opi_ids_push_log.beg_onh_val_b%TYPE,
9: beg_wip_qty opi_ids_push_log.beg_wip_qty%TYPE,
10: beg_wip_val_b opi_ids_push_log.beg_wip_val_b%TYPE,
11: end_int_qty opi_ids_push_log.end_int_qty%TYPE,
12: end_int_val_b opi_ids_push_log.end_int_val_b%TYPE,
13: end_onh_qty opi_ids_push_log.end_onh_qty%TYPE,
14: end_onh_val_b opi_ids_push_log.end_onh_val_b%TYPE,
15: end_wip_qty opi_ids_push_log.end_wip_qty%TYPE,

Line 12: end_int_val_b opi_ids_push_log.end_int_val_b%TYPE,

8: beg_onh_val_b opi_ids_push_log.beg_onh_val_b%TYPE,
9: beg_wip_qty opi_ids_push_log.beg_wip_qty%TYPE,
10: beg_wip_val_b opi_ids_push_log.beg_wip_val_b%TYPE,
11: end_int_qty opi_ids_push_log.end_int_qty%TYPE,
12: end_int_val_b opi_ids_push_log.end_int_val_b%TYPE,
13: end_onh_qty opi_ids_push_log.end_onh_qty%TYPE,
14: end_onh_val_b opi_ids_push_log.end_onh_val_b%TYPE,
15: end_wip_qty opi_ids_push_log.end_wip_qty%TYPE,
16: end_wip_val_b opi_ids_push_log.end_wip_val_b%TYPE,

Line 13: end_onh_qty opi_ids_push_log.end_onh_qty%TYPE,

9: beg_wip_qty opi_ids_push_log.beg_wip_qty%TYPE,
10: beg_wip_val_b opi_ids_push_log.beg_wip_val_b%TYPE,
11: end_int_qty opi_ids_push_log.end_int_qty%TYPE,
12: end_int_val_b opi_ids_push_log.end_int_val_b%TYPE,
13: end_onh_qty opi_ids_push_log.end_onh_qty%TYPE,
14: end_onh_val_b opi_ids_push_log.end_onh_val_b%TYPE,
15: end_wip_qty opi_ids_push_log.end_wip_qty%TYPE,
16: end_wip_val_b opi_ids_push_log.end_wip_val_b%TYPE,
17: trx_date opi_ids_push_log.trx_date%TYPE,

Line 14: end_onh_val_b opi_ids_push_log.end_onh_val_b%TYPE,

10: beg_wip_val_b opi_ids_push_log.beg_wip_val_b%TYPE,
11: end_int_qty opi_ids_push_log.end_int_qty%TYPE,
12: end_int_val_b opi_ids_push_log.end_int_val_b%TYPE,
13: end_onh_qty opi_ids_push_log.end_onh_qty%TYPE,
14: end_onh_val_b opi_ids_push_log.end_onh_val_b%TYPE,
15: end_wip_qty opi_ids_push_log.end_wip_qty%TYPE,
16: end_wip_val_b opi_ids_push_log.end_wip_val_b%TYPE,
17: trx_date opi_ids_push_log.trx_date%TYPE,
18: base_uom opi_ids_push_log.base_uom%TYPE,

Line 15: end_wip_qty opi_ids_push_log.end_wip_qty%TYPE,

11: end_int_qty opi_ids_push_log.end_int_qty%TYPE,
12: end_int_val_b opi_ids_push_log.end_int_val_b%TYPE,
13: end_onh_qty opi_ids_push_log.end_onh_qty%TYPE,
14: end_onh_val_b opi_ids_push_log.end_onh_val_b%TYPE,
15: end_wip_qty opi_ids_push_log.end_wip_qty%TYPE,
16: end_wip_val_b opi_ids_push_log.end_wip_val_b%TYPE,
17: trx_date opi_ids_push_log.trx_date%TYPE,
18: base_uom opi_ids_push_log.base_uom%TYPE,
19: item_status opi_ids_push_log.item_status%TYPE,

Line 16: end_wip_val_b opi_ids_push_log.end_wip_val_b%TYPE,

12: end_int_val_b opi_ids_push_log.end_int_val_b%TYPE,
13: end_onh_qty opi_ids_push_log.end_onh_qty%TYPE,
14: end_onh_val_b opi_ids_push_log.end_onh_val_b%TYPE,
15: end_wip_qty opi_ids_push_log.end_wip_qty%TYPE,
16: end_wip_val_b opi_ids_push_log.end_wip_val_b%TYPE,
17: trx_date opi_ids_push_log.trx_date%TYPE,
18: base_uom opi_ids_push_log.base_uom%TYPE,
19: item_status opi_ids_push_log.item_status%TYPE,
20: item_type opi_ids_push_log.item_type%TYPE,

Line 17: trx_date opi_ids_push_log.trx_date%TYPE,

13: end_onh_qty opi_ids_push_log.end_onh_qty%TYPE,
14: end_onh_val_b opi_ids_push_log.end_onh_val_b%TYPE,
15: end_wip_qty opi_ids_push_log.end_wip_qty%TYPE,
16: end_wip_val_b opi_ids_push_log.end_wip_val_b%TYPE,
17: trx_date opi_ids_push_log.trx_date%TYPE,
18: base_uom opi_ids_push_log.base_uom%TYPE,
19: item_status opi_ids_push_log.item_status%TYPE,
20: item_type opi_ids_push_log.item_type%TYPE,
21: nettable_flag opi_ids_push_log.nettable_flag%TYPE

Line 18: base_uom opi_ids_push_log.base_uom%TYPE,

14: end_onh_val_b opi_ids_push_log.end_onh_val_b%TYPE,
15: end_wip_qty opi_ids_push_log.end_wip_qty%TYPE,
16: end_wip_val_b opi_ids_push_log.end_wip_val_b%TYPE,
17: trx_date opi_ids_push_log.trx_date%TYPE,
18: base_uom opi_ids_push_log.base_uom%TYPE,
19: item_status opi_ids_push_log.item_status%TYPE,
20: item_type opi_ids_push_log.item_type%TYPE,
21: nettable_flag opi_ids_push_log.nettable_flag%TYPE
22: );

Line 19: item_status opi_ids_push_log.item_status%TYPE,

15: end_wip_qty opi_ids_push_log.end_wip_qty%TYPE,
16: end_wip_val_b opi_ids_push_log.end_wip_val_b%TYPE,
17: trx_date opi_ids_push_log.trx_date%TYPE,
18: base_uom opi_ids_push_log.base_uom%TYPE,
19: item_status opi_ids_push_log.item_status%TYPE,
20: item_type opi_ids_push_log.item_type%TYPE,
21: nettable_flag opi_ids_push_log.nettable_flag%TYPE
22: );
23:

Line 20: item_type opi_ids_push_log.item_type%TYPE,

16: end_wip_val_b opi_ids_push_log.end_wip_val_b%TYPE,
17: trx_date opi_ids_push_log.trx_date%TYPE,
18: base_uom opi_ids_push_log.base_uom%TYPE,
19: item_status opi_ids_push_log.item_status%TYPE,
20: item_type opi_ids_push_log.item_type%TYPE,
21: nettable_flag opi_ids_push_log.nettable_flag%TYPE
22: );
23:
24: TYPE key_rec IS RECORD

Line 21: nettable_flag opi_ids_push_log.nettable_flag%TYPE

17: trx_date opi_ids_push_log.trx_date%TYPE,
18: base_uom opi_ids_push_log.base_uom%TYPE,
19: item_status opi_ids_push_log.item_status%TYPE,
20: item_type opi_ids_push_log.item_type%TYPE,
21: nettable_flag opi_ids_push_log.nettable_flag%TYPE
22: );
23:
24: TYPE key_rec IS RECORD
25: ( inventory_item_id opi_ids_push_log.inventory_item_id%TYPE,

Line 25: ( inventory_item_id opi_ids_push_log.inventory_item_id%TYPE,

21: nettable_flag opi_ids_push_log.nettable_flag%TYPE
22: );
23:
24: TYPE key_rec IS RECORD
25: ( inventory_item_id opi_ids_push_log.inventory_item_id%TYPE,
26: organization_id opi_ids_push_log.organization_id%TYPE,
27: cost_group_id opi_ids_push_log.cost_group_id%TYPE,
28: revision opi_ids_push_log.revision%TYPE,
29: lot_number opi_ids_push_log.lot_number%TYPE,

Line 26: organization_id opi_ids_push_log.organization_id%TYPE,

22: );
23:
24: TYPE key_rec IS RECORD
25: ( inventory_item_id opi_ids_push_log.inventory_item_id%TYPE,
26: organization_id opi_ids_push_log.organization_id%TYPE,
27: cost_group_id opi_ids_push_log.cost_group_id%TYPE,
28: revision opi_ids_push_log.revision%TYPE,
29: lot_number opi_ids_push_log.lot_number%TYPE,
30: subinventory_code opi_ids_push_log.subinventory_code%TYPE,

Line 27: cost_group_id opi_ids_push_log.cost_group_id%TYPE,

23:
24: TYPE key_rec IS RECORD
25: ( inventory_item_id opi_ids_push_log.inventory_item_id%TYPE,
26: organization_id opi_ids_push_log.organization_id%TYPE,
27: cost_group_id opi_ids_push_log.cost_group_id%TYPE,
28: revision opi_ids_push_log.revision%TYPE,
29: lot_number opi_ids_push_log.lot_number%TYPE,
30: subinventory_code opi_ids_push_log.subinventory_code%TYPE,
31: locator_id opi_ids_push_log.locator_id%TYPE,

Line 28: revision opi_ids_push_log.revision%TYPE,

24: TYPE key_rec IS RECORD
25: ( inventory_item_id opi_ids_push_log.inventory_item_id%TYPE,
26: organization_id opi_ids_push_log.organization_id%TYPE,
27: cost_group_id opi_ids_push_log.cost_group_id%TYPE,
28: revision opi_ids_push_log.revision%TYPE,
29: lot_number opi_ids_push_log.lot_number%TYPE,
30: subinventory_code opi_ids_push_log.subinventory_code%TYPE,
31: locator_id opi_ids_push_log.locator_id%TYPE,
32: project_locator_id opi_ids_push_log.project_locator_id%TYPE);

Line 29: lot_number opi_ids_push_log.lot_number%TYPE,

25: ( inventory_item_id opi_ids_push_log.inventory_item_id%TYPE,
26: organization_id opi_ids_push_log.organization_id%TYPE,
27: cost_group_id opi_ids_push_log.cost_group_id%TYPE,
28: revision opi_ids_push_log.revision%TYPE,
29: lot_number opi_ids_push_log.lot_number%TYPE,
30: subinventory_code opi_ids_push_log.subinventory_code%TYPE,
31: locator_id opi_ids_push_log.locator_id%TYPE,
32: project_locator_id opi_ids_push_log.project_locator_id%TYPE);
33:

Line 30: subinventory_code opi_ids_push_log.subinventory_code%TYPE,

26: organization_id opi_ids_push_log.organization_id%TYPE,
27: cost_group_id opi_ids_push_log.cost_group_id%TYPE,
28: revision opi_ids_push_log.revision%TYPE,
29: lot_number opi_ids_push_log.lot_number%TYPE,
30: subinventory_code opi_ids_push_log.subinventory_code%TYPE,
31: locator_id opi_ids_push_log.locator_id%TYPE,
32: project_locator_id opi_ids_push_log.project_locator_id%TYPE);
33:
34: PROCEDURE update_ids_push_log (p_ids_key VARCHAR2,

Line 31: locator_id opi_ids_push_log.locator_id%TYPE,

27: cost_group_id opi_ids_push_log.cost_group_id%TYPE,
28: revision opi_ids_push_log.revision%TYPE,
29: lot_number opi_ids_push_log.lot_number%TYPE,
30: subinventory_code opi_ids_push_log.subinventory_code%TYPE,
31: locator_id opi_ids_push_log.locator_id%TYPE,
32: project_locator_id opi_ids_push_log.project_locator_id%TYPE);
33:
34: PROCEDURE update_ids_push_log (p_ids_key VARCHAR2,
35: p_bal_rec bal_rec ) IS

Line 32: project_locator_id opi_ids_push_log.project_locator_id%TYPE);

28: revision opi_ids_push_log.revision%TYPE,
29: lot_number opi_ids_push_log.lot_number%TYPE,
30: subinventory_code opi_ids_push_log.subinventory_code%TYPE,
31: locator_id opi_ids_push_log.locator_id%TYPE,
32: project_locator_id opi_ids_push_log.project_locator_id%TYPE);
33:
34: PROCEDURE update_ids_push_log (p_ids_key VARCHAR2,
35: p_bal_rec bal_rec ) IS
36: BEGIN

Line 37: UPDATE opi_ids_push_log

33:
34: PROCEDURE update_ids_push_log (p_ids_key VARCHAR2,
35: p_bal_rec bal_rec ) IS
36: BEGIN
37: UPDATE opi_ids_push_log
38: SET
39: beg_int_qty = p_bal_rec.end_int_qty,
40: beg_int_val_b = p_bal_rec.end_int_val_b,
41: beg_onh_qty = p_bal_rec.end_onh_qty,

Line 69: INSERT INTO opi_ids_push_log

65: BEGIN
66:
67: --dbms_output.put_line('count = 1 ' || p_key.organization_id);
68:
69: INSERT INTO opi_ids_push_log
70: (ids_key,
71: cost_group_id,
72: organization_id,
73: inventory_item_id,

Line 141: FROM opi_ids_push_log

137: lot_number,
138: subinventory_code,
139: locator_id,
140: project_locator_id
141: FROM opi_ids_push_log
142: WHERE trx_date BETWEEN (p_from_date -1) AND p_to_date
143: AND organization_id = p_organization_id;
144:
145: CURSOR l_extraction_periods_csr ( l_organization_id NUMBER) IS

Line 169: FROM opi_ids_push_log

165: end_int_qty, end_int_val_b,
166: end_onh_qty, end_onh_val_b,
167: end_wip_qty, end_wip_val_b,
168: trx_date, base_uom, item_status, item_type, nettable_flag
169: FROM opi_ids_push_log
170: WHERE ids_key = l_ids_key
171: AND period_flag = 1;
172:
173: CURSOR l_period_start_entry_csr ( l_ids_key VARCHAR2,

Line 182: FROM opi_ids_push_log

178: end_int_qty, end_int_val_b,
179: end_onh_qty, end_onh_val_b,
180: end_wip_qty, end_wip_val_b,
181: trx_date, base_uom, item_status, item_type, nettable_flag
182: FROM opi_ids_push_log
183: WHERE ids_key = l_ids_key;
184:
185: CURSOR l_latest_activity_csr (l_inventory_item_id NUMBER,
186: l_organization_id NUMBER,

Line 201: FROM opi_ids_push_log

197: end_int_qty, end_int_val_b,
198: end_onh_qty, end_onh_val_b,
199: end_wip_qty, end_wip_val_b,
200: trx_date, base_uom, item_status, item_type, nettable_flag
201: FROM opi_ids_push_log
202: WHERE inventory_item_id = l_inventory_item_id
203: AND organization_id = l_organization_id
204: AND Nvl(cost_group_id, -999) = Nvl(l_cost_group_id, -999)
205: AND Nvl(revision, '-999') = Nvl(l_revision, '-999')

Line 210: FROM opi_ids_push_log

206: AND Nvl(lot_number, '-999') = Nvl(l_lot_number, '-999')
207: AND Nvl(subinventory_code, '-999') = Nvl(l_subinventory_code, '-999')
208: AND Nvl(project_locator_id, -999) = Nvl(l_locator_id, -999)
209: AND trx_date IN ( SELECT MAX(trx_date)
210: FROM opi_ids_push_log
211: WHERE inventory_item_id = l_inventory_item_id
212: AND organization_id = l_organization_id
213: AND Nvl(cost_group_id, -999) = Nvl(l_cost_group_id, -999)
214: AND Nvl(revision, '-999') = Nvl(l_revision, '-999')

Line 293: FROM opi_ids_push_log

289: Decode( Nvl(wip_issue_val_b,0),0,
290: 0, -- no activity at all
291: 1), 1), 1), 1), 1), 1), 1), 1), 1), 1), 1), 1), 1), 1),1), 1),
292: 1), 1), 1), 1), 1), 1), 1), 1), 1), 1) activity_flag
293: FROM opi_ids_push_log
294: WHERE ids_key = l_ids_key;
295: /*
296: Decode(Nvl(beg_int_qty,0), 0,
297: Decode(Nvl(beg_int_val_b,0), 0,

Line 347: from opi_ids_push_log

343:
344: -- get the very first period start date for which the beg_inv_bal is created
345: select Trunc( min(trx_date) )
346: into l_first_push_date
347: from opi_ids_push_log
348: where organization_id = p_organization_id;
349:
350: open get_max_push_from_date_csr;
351: fetch get_max_push_from_date_csr into l_inv_txn_date, l_wip_txn_date;

Line 546: INSERT INTO opi_ids_push_log

542: IF l_period_start_flag <> 1 THEN
543: IF l_start_activity_flag <>1
544: AND l_period_start_flag <> 999 THEN
545:
546: INSERT INTO opi_ids_push_log
547: (ids_key, cost_group_id,
548: organization_id,inventory_item_id,
549: revision, subinventory_code,
550: locator_id, project_locator_id,

Line 581: UPDATE opi_ids_push_log

577: -- if l_start_activity_flag = 1,
578: -- we have activity on start date-> update
579: -- if l_period_start_flag = 999,
580: -- we have beg_inv_bal entry on start_date --> update
581: UPDATE opi_ids_push_log
582: SET period_flag = 0,
583: push_flag =1
584: WHERE ids_key = l_prd_start_ids_key;
585:

Line 597: UPDATE opi_ids_push_log

593: -- if the entry is not for the beg_inv_val
594: -- entry
595: IF l_period.start_date <> l_first_push_date
596: THEN
597: UPDATE opi_ids_push_log
598: SET
599: beg_int_qty = 0,
600: beg_int_val_b = 0,
601: beg_onh_qty = 0,

Line 642: UPDATE opi_ids_push_log

638:
639: --edw_log.put_line('1 start insert 2');
640:
641: ELSIF l_period_start_flag = 999 THEN
642: UPDATE opi_ids_push_log
643: SET period_flag = 0,
644: push_flag =1
645: WHERE ids_key = l_prd_start_ids_key;
646: END IF;

Line 651: UPDATE opi_ids_push_log

647: ELSE
648: -- activity on period_start, but
649: -- no period_start_entry
650: -- turn on the flag
651: UPDATE opi_ids_push_log
652: SET period_flag = 0,
653: push_flag =1
654: WHERE ids_key = l_prd_start_ids_key;
655:

Line 705: UPDATE opi_ids_push_log

701: -- there is acitivity on period_end date
702: -- turn on the flag
703: -- l_end_activity_flag = 0 or 1,
704: -- l_period_end_flag = 999
705: UPDATE opi_ids_push_log
706: SET period_flag = 1, push_flag = 1
707: WHERE ids_key = l_prd_end_ids_key;
708:
709: --edw_log.put_line('1 end update 2');

Line 730: DELETE opi_ids_push_log

726: IF l_last_period_end_flag <> 1 THEN
727: -- delete the period_start entry if it exists
728: IF l_period_start_flag = 1 THEN
729: IF l_period.start_date <> l_first_push_date THEN
730: DELETE opi_ids_push_log
731: WHERE ids_key = l_prd_start_ids_key;
732:
733: --edw_log.put_line('2 start del 0');
734:

Line 762: DELETE opi_ids_push_log

758: AND Nvl(l_beg_inv_bal_prd_start_entry.end_wip_qty, 0) = 0
759: AND Nvl(l_beg_inv_bal_prd_start_entry.end_wip_val_b,0) = 0
760: THEN
761: -- delete the period_start entry if it exists
762: DELETE opi_ids_push_log
763: WHERE ids_key = l_prd_start_ids_key;
764:
765: l_period_start_flag := 0;
766:

Line 770: UPDATE opi_ids_push_log

766:
767: --edw_log.put_line('2 start del 1');
768: ELSE -- a).
769:
770: UPDATE opi_ids_push_log
771: SET period_flag = 0, push_flag = 1
772: WHERE ids_key = l_prd_start_ids_key;
773:
774: l_beg_inv_bal_flag := 1;

Line 796: DELETE opi_ids_push_log

792: AND Nvl(l_last_period_end_entry.end_wip_val_b,0)= 0
793: THEN
794: -- delete the period_start entry if it exists
795: IF l_period_start_flag = 1 THEN
796: DELETE opi_ids_push_log
797: WHERE ids_key = l_prd_start_ids_key;
798: l_period_start_flag := 0;
799:
800: --edw_log.put_line('2 start del 2');

Line 822: UPDATE opi_ids_push_log

818: l_period_start_flag := 1;
819:
820: --edw_log.put_line('2 start insert 2');
821: ELSIF l_period_start_flag = 999 THEN
822: UPDATE opi_ids_push_log
823: SET period_flag = 0, push_flag = 1
824: WHERE ids_key = l_prd_start_ids_key;
825:
826: --edw_log.put_line('2 start update 2.5');

Line 904: UPDATE opi_ids_push_log

900:
901: --edw_log.put_line('2 end insert 2');
902: END IF;
903: ELSIF l_period_end_flag = 999 THEN
904: UPDATE opi_ids_push_log
905: SET period_flag = 1, push_flag = 1
906: WHERE ids_key = l_prd_end_ids_key;
907: --edw_log.put_line('2 end update 2.5');
908: END IF;

Line 913: DELETE opi_ids_push_log

909:
910: l_period_end_flag := 1;
911: END IF;
912: ELSE
913: DELETE opi_ids_push_log
914: WHERE ids_key = l_prd_end_ids_key;
915:
916: l_period_end_flag := 0;
917:

Line 1018: -- and org in the opi_ids_push_log.

1014:
1015: -- activity_on_day function.
1016: -- Returns true if there is activity on a given day (date is argument)
1017: -- and false if there is no activity on the day for a given item
1018: -- and org in the opi_ids_push_log.
1019: FUNCTION activity_on_day (day_to_check IN DATE, p_organization_id IN NUMBER,
1020: inv_item_id IN NUMBER)
1021: RETURN BOOLEAN
1022:

Line 1028: -- the opi_ids_push_log.

1024:
1025: -- Cursor to see if there is any acitvity on the given day.
1026: -- If so, this cursor will return some data in it,
1027: -- else, it will not for the specified date, item and org in
1028: -- the opi_ids_push_log.
1029: CURSOR activity_log_csr (day_to_check DATE, p_organization_id NUMBER,
1030: inv_item_id NUMBER)
1031: IS
1032: SELECT ids_key

Line 1033: FROM opi_ids_push_log

1029: CURSOR activity_log_csr (day_to_check DATE, p_organization_id NUMBER,
1030: inv_item_id NUMBER)
1031: IS
1032: SELECT ids_key
1033: FROM opi_ids_push_log
1034: WHERE organization_id = p_organization_id
1035: AND inventory_item_id = inv_item_id
1036: AND trx_date = day_to_check
1037: AND ( NVL(beg_int_val_b,0) - NVL(end_int_val_b,0) <> 0

Line 1077: FROM opi_ids_push_log push_log

1073: p_organization_id NUMBER,
1074: p_inventory_item_id NUMBER)
1075: IS
1076: SELECT min(push_log.trx_date)
1077: FROM opi_ids_push_log push_log
1078: WHERE push_log.period_flag = 0
1079: AND push_log.organization_id = p_organization_id
1080: AND push_log.inventory_item_id = p_inventory_item_id
1081: AND push_log.trx_date > v_curr_date;

Line 1118: -- period_flag = 1 for end of period entries in the opi_ids_push_log

1114: -- standard cost update transaction type IDs in mtl_material_transaction
1115: -- table is 24
1116: COST_UPDATE_TRX_ID CONSTANT NUMBER := 24;
1117:
1118: -- period_flag = 1 for end of period entries in the opi_ids_push_log
1119: PERIOD_END_ENTRY_FLAG_VAL CONSTANT NUMBER := 1;
1120:
1121: -- period_flag = 0 for start of period entries in the opi_ids_push_log
1122: PERIOD_START_ENTRY_FLAG_VAL CONSTANT NUMBER := 0;

Line 1121: -- period_flag = 0 for start of period entries in the opi_ids_push_log

1117:
1118: -- period_flag = 1 for end of period entries in the opi_ids_push_log
1119: PERIOD_END_ENTRY_FLAG_VAL CONSTANT NUMBER := 1;
1120:
1121: -- period_flag = 0 for start of period entries in the opi_ids_push_log
1122: PERIOD_START_ENTRY_FLAG_VAL CONSTANT NUMBER := 0;
1123:
1124: -- push_flag = 1 for transactions just pushed into the opi_ids_push_log
1125: JUST_PUSHED_FLAG_VAL CONSTANT NUMBER:= 1;

Line 1124: -- push_flag = 1 for transactions just pushed into the opi_ids_push_log

1120:
1121: -- period_flag = 0 for start of period entries in the opi_ids_push_log
1122: PERIOD_START_ENTRY_FLAG_VAL CONSTANT NUMBER := 0;
1123:
1124: -- push_flag = 1 for transactions just pushed into the opi_ids_push_log
1125: JUST_PUSHED_FLAG_VAL CONSTANT NUMBER:= 1;
1126:
1127: -- primary cost method for standard cost update is 1
1128: PRIMARY_COST_METHOD_UPDATE CONSTANT NUMBER := 1;

Line 1160: -- org in the opi_ids_push_log.

1156:
1157:
1158: -- Cursor of all the distinct period end entry dates within the period
1159: -- start and period end dates (inclusive) with the specified item and
1160: -- org in the opi_ids_push_log.
1161: -- This means that the period_flag is set, the push_flag is set
1162: CURSOR period_end_dates_csr (p_organization_id NUMBER,
1163: p_inventory_item_id NUMBER,
1164: p_from_date DATE)

Line 1167: FROM opi_ids_push_log push_log

1163: p_inventory_item_id NUMBER,
1164: p_from_date DATE)
1165: IS
1166: SELECT push_log.trx_date trx_date
1167: FROM opi_ids_push_log push_log
1168: WHERE push_log.organization_id = p_organization_id
1169: AND push_log.inventory_item_id = p_inventory_item_id
1170: AND push_log.period_flag = 1
1171: AND push_log.push_flag = 1

Line 1268: UPDATE opi_ids_push_log

1264:
1265:
1266: -- Now update the end of day balances after checking if there
1267: -- was activity on the day
1268: UPDATE opi_ids_push_log
1269: SET
1270: beg_int_val_b = beg_int_qty * period_end_beg_unit_cost,
1271: beg_onh_val_b = beg_onh_qty * period_end_beg_unit_cost,
1272: beg_wip_val_b = beg_wip_qty * period_end_beg_unit_cost,

Line 1320: UPDATE opi_ids_push_log

1316: -- The beginning balance is always the ending balance of
1317: -- the previous period. We can set this after checking
1318: -- if there was any activity on this day. The cost
1319: -- is the same as the end of the previous period.
1320: UPDATE opi_ids_push_log
1321: SET
1322: beg_int_val_b = beg_int_qty * period_end_unit_cost,
1323: beg_onh_val_b = beg_onh_qty * period_end_unit_cost,
1324: beg_wip_val_b = beg_wip_qty * period_end_unit_cost,