APPS.MSC_X_RECEIVE_CAPACITY_PKG dependencies on DUAL

Line 425: from dual;

421: get the refresh number
422: ----------------------------------------------------------*/
423: select msc_collection_s.nextval
424: into l_refresh_number
425: from dual;
426:
427: /*----------------------------------------------------------
428: get the instance id for the Default Calendar
429: Added this code for bug# 3431898

Line 1199: select to_char(sysdate, 'MON') into l_month from dual;

1195:
1196: l_from_date := p_receipt_date;
1197: l_quantity := p_capacity;
1198:
1199: select to_char(sysdate, 'MON') into l_month from dual;
1200: select to_char(sysdate, 'YYYY') into l_year from dual;
1201: select to_char(sysdate, 'W') into l_week from dual;
1202:
1203:

Line 1200: select to_char(sysdate, 'YYYY') into l_year from dual;

1196: l_from_date := p_receipt_date;
1197: l_quantity := p_capacity;
1198:
1199: select to_char(sysdate, 'MON') into l_month from dual;
1200: select to_char(sysdate, 'YYYY') into l_year from dual;
1201: select to_char(sysdate, 'W') into l_week from dual;
1202:
1203:
1204: --log_message('p_receipt_date : ' ||p_receipt_date);

Line 1201: select to_char(sysdate, 'W') into l_week from dual;

1197: l_quantity := p_capacity;
1198:
1199: select to_char(sysdate, 'MON') into l_month from dual;
1200: select to_char(sysdate, 'YYYY') into l_year from dual;
1201: select to_char(sysdate, 'W') into l_week from dual;
1202:
1203:
1204: --log_message('p_receipt_date : ' ||p_receipt_date);
1205: IF p_bucket_type = 3 THEN

Line 1206: --select last_day(l_from_date) into l_to_date from dual;

1202:
1203:
1204: --log_message('p_receipt_date : ' ||p_receipt_date);
1205: IF p_bucket_type = 3 THEN
1206: --select last_day(l_from_date) into l_to_date from dual;
1207:
1208: IF (to_char(p_receipt_date, 'MON') = l_month and
1209: to_char(p_receipt_date, 'YYYY') = l_year ) THEN
1210: l_from_date := sysdate + 1;

Line 1215: --select p_receipt_date + 6 into l_to_date from dual;

1211: END IF;
1212:
1213: ELSIF p_bucket_type = 2 THEN
1214:
1215: --select p_receipt_date + 6 into l_to_date from dual;
1216:
1217: IF (to_char(p_receipt_date, 'MON') = l_month and
1218: to_char(p_receipt_date, 'YYYY') = l_year and
1219: to_char(p_receipt_date, 'W') = l_week) THEN

Line 1557: from dual;

1553:
1554: LOG_MESSAGE('insert capacity');
1555: select msc_supplier_capacities_s.nextval
1556: into l_nextid
1557: from dual;
1558: BEGIN
1559: insert into msc_supplier_capacities (
1560: transaction_id,
1561: plan_id,

Line 1629: SELECT 1 into l_exist from dual

1625: l_exist Number := 0;
1626:
1627: BEGIN
1628: begin
1629: SELECT 1 into l_exist from dual
1630: WHERE exists (SELECT 1
1631: from msc_supplier_capacities
1632: where plan_id = -1
1633: and sr_instance_id = p_sr_instance_id

Line 1726: FROM dual;

1722: SELECT 'CP' ||
1723: substr(p_mod_org_code,1,instr(p_mod_org_code,':')-1) ||
1724: '-' || substr(p_mod_org_code,instr(p_mod_org_code,':')+1,7)
1725: INTO l_mps_designator
1726: FROM dual;
1727:
1728: begin
1729: SELECT designator_id, designator
1730: INTO l_mps_designator_id, l_mps_designator

Line 1815: from dual;

1811:
1812: LOG_MESSAGE('insert mps designator');
1813: select msc_designators_s.nextval
1814: into p_mps_designator_id
1815: from dual;
1816: LOG_MESSAGE('MPS Designator ' || p_mps_designator);
1817:
1818: begin
1819: select partner_name

Line 1927: from dual;

1923:
1924: LOG_MESSAGE('insert msc supplies');
1925: select msc_supplies_s.nextval
1926: into l_nextid
1927: from dual;
1928:
1929: insert into msc_supplies (plan_id,
1930: transaction_id,
1931: organization_id,