APPS.MSD_SCE_RECEIVE_FORECAST_PKG dependencies on MSD_CS_DATA_HEADERS

Line 459: /* This procedure will delete the data from the msd_cs_data_headers

455:
456: End get_sr_tp_site_id;
457:
458:
459: /* This procedure will delete the data from the msd_cs_data_headers
460: * table.
461: *
462: * Bug 2488293.
463: */

Line 471: DELETE from msd_cs_data_headers mcdh

467: p_designator in varchar2) IS
468:
469: BEGIN
470:
471: DELETE from msd_cs_data_headers mcdh
472: where
473: cs_definition_id = p_cs_definition_id
474: and cs_name = p_designator
475: and not exists

Line 486: fnd_file.put_line(fnd_file.log, 'Error in deleting from MSD_CS_DATA_HEADERS');

482: and rownum = 1);
483:
484: Exception
485: When others then
486: fnd_file.put_line(fnd_file.log, 'Error in deleting from MSD_CS_DATA_HEADERS');
487: fnd_file.put_line(fnd_file.log, sqlerrm);
488: raise;
489:
490: End delete_from_headers;

Line 494: * msd_cs_data_headers table.

490: End delete_from_headers;
491:
492:
493: /* This procedure will insert cs_definition_id, cs_name, and instance into
494: * msd_cs_data_headers table.
495: * Bug 2488293.
496: */
497: Procedure Insert_Data_Into_Headers
498: (p_cs_definition_id in number,

Line 504: insert into msd_cs_data_headers

500: p_refresh_num in number) IS
501:
502: BEGIN
503:
504: insert into msd_cs_data_headers
505: (
506: cs_data_header_id,
507: instance,
508: cs_definition_id,

Line 517: select msd_cs_data_headers_s.nextval,

513: created_by,
514: last_update_login,
515: last_refresh_num
516: )
517: select msd_cs_data_headers_s.nextval,
518: mcd.instance,
519: mcd.cs_definition_id,
520: mcd.cs_name,
521: sysdate,

Line 535: from msd_cs_data_headers

531: where cs_definition_id = p_cs_definition_id
532: and cs_name = p_designator
533: minus
534: select instance, cs_definition_id, cs_name
535: from msd_cs_data_headers
536: ) mcd;
537:
538: if (sql%rowcount = 0) then
539:

Line 540: update msd_cs_data_headers

536: ) mcd;
537:
538: if (sql%rowcount = 0) then
539:
540: update msd_cs_data_headers
541: set last_refresh_num = p_refresh_num,
542: last_update_date = sysdate,
543: last_updated_by = fnd_global.user_id,
544: last_update_login = fnd_global.login_id

Line 552: fnd_file.put_line(fnd_file.log, 'Error in inserting into MSD_CS_DATA_HEADERS');

548: end if;
549:
550: Exception
551: When others then
552: fnd_file.put_line(fnd_file.log, 'Error in inserting into MSD_CS_DATA_HEADERS');
553: fnd_file.put_line(fnd_file.log, sqlerrm);
554: raise;
555:
556: END Insert_Data_Into_Headers;