APPS.OE_LINE_FULLFILL dependencies on OE_SETS

Line 1562: oe_sets and oe_line_sets tables

1558: END Get_Activity_Result;
1559:
1560: /*
1561: This procedure gets all the lines and sets for a given line_id from
1562: oe_sets and oe_line_sets tables
1563: */
1564:
1565: PROCEDURE Get_Fulfillment_Set
1566: (

Line 1577: FROM OE_LINE_SETS OLS, OE_SETS OST

1573: IS
1574:
1575: CURSOR c_set IS
1576: SELECT OLS.LINE_ID, OLS.SET_ID
1577: FROM OE_LINE_SETS OLS, OE_SETS OST
1578: WHERE OLS.LINE_ID = p_line_id
1579: AND OLS.SET_ID = OST.SET_ID
1580: AND OST.SET_TYPE = 'FULFILLMENT_SET';
1581:

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

3316:
3317: l_line_tbl_index := l_line_tbl.NEXT(l_line_tbl_index);
3318: END LOOP;
3319:
3320: -- Update the set status in oe_sets to closed.
3321: l_set_tbl_index := l_set_tbl.FIRST;
3322:
3323: WHILE l_set_tbl_index IS NOT NULL
3324: LOOP

Line 3326: UPDATE OE_SETS

3322:
3323: WHILE l_set_tbl_index IS NOT NULL
3324: LOOP
3325: -- 3772947
3326: UPDATE OE_SETS
3327: SET SET_STATUS = 'C',
3328: UPDATE_DATE = SYSDATE
3329: WHERE SET_ID = l_set_tbl(l_set_tbl_index);
3330:

Line 3531: FROM OE_SETS

3527: END IF;
3528:
3529: SELECT SET_ID
3530: INTO l_set_id
3531: FROM OE_SETS
3532: WHERE SET_ID = lock_set_id
3533: FOR UPDATE NOWAIT;
3534:
3535: IF l_debug_level > 0 THEN

Line 4625: oe_sets s

4621:
4622: select count(*)
4623: into l_howmany
4624: from oe_line_sets l,
4625: oe_sets s
4626: where l.line_id = p_line_id
4627: and l.set_id = s.set_id
4628: and s.set_id <> p_set_id
4629: and s.set_type = 'FULFILLMENT_SET';

Line 4653: oe_sets s1,

4649: select count(*) -- added for 2525203
4650: into l_howmany
4651: from oe_line_sets l1,
4652: oe_line_sets l2,
4653: oe_sets s1,
4654: oe_order_lines ol
4655: where l1.line_id <> p_line_id
4656: and l1.set_id = s1.set_id
4657: and s1.set_type = 'FULFILLMENT_SET'

Line 4680: oe_sets s1,

4676: into l_common_sets
4677: from oe_line_sets l1,
4678: oe_line_sets l2,
4679: oe_line_sets l3,
4680: oe_sets s1,
4681: oe_order_lines ol
4682: where l1.line_id = p_line_id
4683: and l1.set_id = s1.set_id
4684: and s1.set_type = 'FULFILLMENT_SET'

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

5153: END IF; /*Top Model */
5154: END LOOP;
5155:
5156: END IF; --Count of l_ful_set_tbl is 0
5157: -- Update the set status in oe_sets to closed.
5158: l_close_tbl_index := l_close_tbl.FIRST;
5159:
5160: WHILE l_close_tbl_index IS NOT NULL
5161: LOOP

Line 5166: UPDATE OE_SETS

5162: IF l_complete_fulfillment OR -- This IF added for 2525203
5163: l_set_f AND l_close_tbl(l_close_tbl_index) = l_set_id OR
5164: l_oth_f AND l_close_tbl(l_close_tbl_index) <> l_set_id THEN
5165: -- 3772947
5166: UPDATE OE_SETS
5167: SET SET_STATUS = 'C',
5168: UPDATE_DATE = SYSDATE
5169: WHERE SET_ID = l_close_tbl(l_close_tbl_index);
5170: