APPS.MSD_SCE_RECEIVE_FORECAST_PKG dependencies on MSD_CS_DATA_HEADERS

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

418:
419: End get_sr_tp_site_id;
420:
421:
422: /* This procedure will delete the data from the msd_cs_data_headers
423: * table.
424: *
425: * Bug 2488293.
426: */

Line 434: DELETE from msd_cs_data_headers mcdh

430: p_designator in varchar2) IS
431:
432: BEGIN
433:
434: DELETE from msd_cs_data_headers mcdh
435: where
436: cs_definition_id = p_cs_definition_id
437: and cs_name = p_designator
438: and not exists

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

445: and rownum = 1);
446:
447: Exception
448: When others then
449: fnd_file.put_line(fnd_file.log, 'Error in deleting from MSD_CS_DATA_HEADERS');
450: fnd_file.put_line(fnd_file.log, sqlerrm);
451: raise;
452:
453: End delete_from_headers;

Line 457: * msd_cs_data_headers table.

453: End delete_from_headers;
454:
455:
456: /* This procedure will insert cs_definition_id, cs_name, and instance into
457: * msd_cs_data_headers table.
458: * Bug 2488293.
459: */
460: Procedure Insert_Data_Into_Headers
461: (p_cs_definition_id in number,

Line 467: insert into msd_cs_data_headers

463: p_refresh_num in number) IS
464:
465: BEGIN
466:
467: insert into msd_cs_data_headers
468: (
469: cs_data_header_id,
470: instance,
471: cs_definition_id,

Line 480: select msd_cs_data_headers_s.nextval,

476: created_by,
477: last_update_login,
478: last_refresh_num
479: )
480: select msd_cs_data_headers_s.nextval,
481: mcd.instance,
482: mcd.cs_definition_id,
483: mcd.cs_name,
484: sysdate,

Line 498: from msd_cs_data_headers

494: where cs_definition_id = p_cs_definition_id
495: and cs_name = p_designator
496: minus
497: select instance, cs_definition_id, cs_name
498: from msd_cs_data_headers
499: ) mcd;
500:
501: if (sql%rowcount = 0) then
502:

Line 503: update msd_cs_data_headers

499: ) mcd;
500:
501: if (sql%rowcount = 0) then
502:
503: update msd_cs_data_headers
504: set last_refresh_num = p_refresh_num,
505: last_update_date = sysdate,
506: last_updated_by = fnd_global.user_id,
507: last_update_login = fnd_global.login_id

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

511: end if;
512:
513: Exception
514: When others then
515: fnd_file.put_line(fnd_file.log, 'Error in inserting into MSD_CS_DATA_HEADERS');
516: fnd_file.put_line(fnd_file.log, sqlerrm);
517: raise;
518:
519: END Insert_Data_Into_Headers;