APPS.OE_LINE_FULLFILL dependencies on OE_SETS

Line 1643: oe_sets and oe_line_sets tables

1639: END Get_Activity_Result;
1640:
1641: /*
1642: This procedure gets all the lines and sets for a given line_id from
1643: oe_sets and oe_line_sets tables
1644: */
1645:
1646: PROCEDURE Get_Fulfillment_Set
1647: (

Line 1658: FROM OE_LINE_SETS OLS, OE_SETS OST

1654: IS
1655:
1656: CURSOR c_set IS
1657: SELECT OLS.LINE_ID, OLS.SET_ID
1658: FROM OE_LINE_SETS OLS, OE_SETS OST
1659: WHERE OLS.LINE_ID = p_line_id
1660: AND OLS.SET_ID = OST.SET_ID
1661: AND OST.SET_TYPE = 'FULFILLMENT_SET';
1662:

Line 3499: -- Update the set status in oe_sets to closed.

3495:
3496: l_line_tbl_index := l_line_tbl.NEXT(l_line_tbl_index);
3497: END LOOP;
3498:
3499: -- Update the set status in oe_sets to closed.
3500: l_set_tbl_index := l_set_tbl.FIRST;
3501:
3502: WHILE l_set_tbl_index IS NOT NULL
3503: LOOP

Line 3505: UPDATE OE_SETS

3501:
3502: WHILE l_set_tbl_index IS NOT NULL
3503: LOOP
3504: -- 3772947
3505: UPDATE OE_SETS
3506: SET SET_STATUS = 'C',
3507: UPDATE_DATE = SYSDATE
3508: WHERE SET_ID = l_set_tbl(l_set_tbl_index);
3509:

Line 3718: FROM OE_SETS

3714: END IF;
3715:
3716: SELECT SET_ID
3717: INTO l_set_id
3718: FROM OE_SETS
3719: WHERE SET_ID = lock_set_id
3720: FOR UPDATE NOWAIT;
3721:
3722: IF l_debug_level > 0 THEN

Line 4856: oe_sets s

4852:
4853: select count(*)
4854: into l_howmany
4855: from oe_line_sets l,
4856: oe_sets s
4857: where l.line_id = p_line_id
4858: and l.set_id = s.set_id
4859: and s.set_id <> p_set_id
4860: and s.set_type = 'FULFILLMENT_SET';

Line 4884: oe_sets s1,

4880: select count(*) -- added for 2525203
4881: into l_howmany
4882: from oe_line_sets l1,
4883: oe_line_sets l2,
4884: oe_sets s1,
4885: oe_order_lines ol
4886: where l1.line_id <> p_line_id
4887: and l1.set_id = s1.set_id
4888: and s1.set_type = 'FULFILLMENT_SET'

Line 4911: oe_sets s1,

4907: into l_common_sets
4908: from oe_line_sets l1,
4909: oe_line_sets l2,
4910: oe_line_sets l3,
4911: oe_sets s1,
4912: oe_order_lines ol
4913: where l1.line_id = p_line_id
4914: and l1.set_id = s1.set_id
4915: and s1.set_type = 'FULFILLMENT_SET'

Line 5398: -- Update the set status in oe_sets to closed.

5394: END IF; /*Top Model */
5395: END LOOP;
5396:
5397: END IF; --Count of l_ful_set_tbl is 0
5398: -- Update the set status in oe_sets to closed.
5399: l_close_tbl_index := l_close_tbl.FIRST;
5400:
5401: WHILE l_close_tbl_index IS NOT NULL
5402: LOOP

Line 5407: UPDATE OE_SETS

5403: IF l_complete_fulfillment OR -- This IF added for 2525203
5404: l_set_f AND l_close_tbl(l_close_tbl_index) = l_set_id OR
5405: l_oth_f AND l_close_tbl(l_close_tbl_index) <> l_set_id THEN
5406: -- 3772947
5407: UPDATE OE_SETS
5408: SET SET_STATUS = 'C',
5409: UPDATE_DATE = SYSDATE
5410: WHERE SET_ID = l_close_tbl(l_close_tbl_index);
5411: