APPS.OE_UPG_SO dependencies on OE_SETS

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 1028: insert into oe_sets

1024: from dual;
1025:
1026: G_ERROR_LOCATION := 704;
1027:
1028: insert into oe_sets
1029: (
1030: set_id,
1031: set_name,
1032: set_type,

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 1349: -- Also Insert into oe_sets

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: (
1352: SET_ID,
1353: SET_NAME,

Line 1350: insert into oe_sets

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: (
1352: SET_ID,
1353: SET_NAME,
1354: SET_TYPE,

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 3805: insert into oe_sets

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,
3808: SET_NAME,
3809: SET_TYPE,

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 3886: insert into oe_sets

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,
3889: SET_NAME,
3890: SET_TYPE,

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 6166: insert into oe_sets

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,
6169: FREIGHT_CARRIER_CODE, SHIPPING_METHOD_CODE,
6170: SHIPMENT_PRIORITY_CODE, SET_STATUS,

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,

Line 6353: insert into oe_sets

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,
6356: FREIGHT_CARRIER_CODE, SHIPPING_METHOD_CODE,
6357: SHIPMENT_PRIORITY_CODE, SET_STATUS,