APPS.OE_UPG_SO dependencies on OE_SETS_S

Line 1021: oe_sets_s.nextval

1017: and mol.ship_method_code is not NULL) then
1018: */
1019: v_ship_set_number := mol.ship_set_number;
1020: select
1021: oe_sets_s.nextval
1022: into
1023: g_set_id
1024: from dual;
1025:

Line 1347: select oe_sets_s.nextval

1343:
1344: IF (v_received_quantity is not null and
1345: v_actual_ordered_quantity > v_received_quantity)
1346: AND v_return_lctr in (2,4) THEN
1347: select oe_sets_s.nextval
1348: into r_line_set_id from dual;
1349: -- Also Insert into oe_sets
1350: insert into oe_sets
1351: (

Line 3803: select oe_sets_s.nextval into v_set_id from dual;

3799: p_line_number := c2.line_number;
3800:
3801: /* Create a set */
3802:
3803: select oe_sets_s.nextval into v_set_id from dual;
3804:
3805: insert into oe_sets
3806: (
3807: SET_ID,

Line 3884: select oe_sets_s.nextval into v_set_id from dual;

3880: for c6 in c5 loop
3881: v_line_id := c6.line_id;
3882: p_line_number := c6.line_number;
3883:
3884: select oe_sets_s.nextval into v_set_id from dual;
3885:
3886: insert into oe_sets
3887: (
3888: SET_ID,

Line 6164: select oe_sets_s.nextval into l_line_set_id from dual;

6160: Insert_Row(l_line_rec1,p_line_id,'Y','N');
6161:
6162: ELSE
6163:
6164: select oe_sets_s.nextval into l_line_set_id from dual;
6165:
6166: insert into oe_sets
6167: ( SET_ID, SET_NAME, SET_TYPE, HEADER_ID, SHIP_FROM_ORG_ID,
6168: SHIP_TO_ORG_ID,SCHEDULE_SHIP_DATE, SCHEDULE_ARRIVAL_DATE,

Line 6351: select oe_sets_s.nextval into l_line_set_id from dual;

6347: v_received_quantity := l_rec.received_quantity;
6348:
6349: l_line_rec := Query_Row(l_line_id);
6350:
6351: select oe_sets_s.nextval into l_line_set_id from dual;
6352:
6353: insert into oe_sets
6354: ( SET_ID, SET_NAME, SET_TYPE, HEADER_ID, SHIP_FROM_ORG_ID,
6355: SHIP_TO_ORG_ID,SCHEDULE_SHIP_DATE, SCHEDULE_ARRIVAL_DATE,