APPS.MSD_APPLY_TEMPLATE_DEMAND_PLAN dependencies on MSD_DP_SEEDED_DOCUMENTS

Line 655: from msd_dp_seeded_documents

651: cursor c2 is
652:
653: select document_name,document_id
654:
655: from msd_dp_seeded_documents
656:
657: where demand_plan_id = p_demand_plan_id;
658:
659:

Line 665: from msd_dp_seeded_documents

661: cursor c3(p_template_id in number, p_document_name in varchar2) is
662:
663: select document_id
664:
665: from msd_dp_seeded_documents
666:
667: where demand_plan_id = p_template_id
668:
669: and document_name = p_document_name;

Line 707: from msd_dp_seeded_documents

703: l_template_id number;
704:
705: cursor watefall_document_id is
706: select document_id
707: from msd_dp_seeded_documents
708: where demand_plan_id=p_demand_plan_id
709: and document_name = 'MSD_SD_EOL_LWF';
710:
711: waterfall_doc_id number;

Line 1688: from msd_dp_seeded_documents

1684: cursor c2 is
1685:
1686: select document_id, description
1687:
1688: from msd_dp_seeded_documents
1689:
1690: where demand_plan_id = p_new_dp_id;
1691:
1692:

Line 1736: update msd_dp_seeded_documents

1732:
1733:
1734: -- update the description seeded as message with message text
1735:
1736: update msd_dp_seeded_documents
1737:
1738: --set description = fnd_message.get
1739:
1740: set description = fnd_message.get_string('MSD',c2_cur.description)

Line 2772: and document_id <> (select document_id from msd_dp_seeded_documents where demand_plan_id=p_new_dp_id and

2768:
2769: where demand_plan_id = p_new_dp_id
2770:
2771: and dimension_code = 'MEAS'
2772: and document_id <> (select document_id from msd_dp_seeded_documents where demand_plan_id=p_new_dp_id and
2773: document_name='MSD_EOL_WHEREUSED_RE');
2774:
2775:
2776:

Line 2860: update msd_dp_seeded_documents

2856:
2857:
2858: -- validate all documents first
2859:
2860: update msd_dp_seeded_documents
2861:
2862: set valid_flag = 'Y'
2863:
2864: where demand_plan_id = p_new_dp_id;

Line 2874: update msd_dp_seeded_documents

2870:
2871:
2872: -- invalidate documents if any of the mandatory dimension is disabled
2873:
2874: update msd_dp_seeded_documents
2875:
2876: set valid_flag = 'N'
2877:
2878: where demand_plan_id = p_new_dp_id

Line 3864: from msd_dp_seeded_documents

3860: cursor c2 is
3861:
3862: select distinct document_id
3863:
3864: from msd_dp_seeded_documents
3865:
3866: where demand_plan_id = p_demand_plan_id;
3867:
3868:

Line 4178: from msd_dp_seeded_documents

4174: cursor c5 is
4175:
4176: select distinct document_id
4177:
4178: from msd_dp_seeded_documents
4179:
4180: where demand_plan_id = p_demand_plan_id;
4181:
4182:

Line 6478: from msd_dp_seeded_documents msd

6474: cursor c1 is
6475:
6476: select msd.document_id, msd.document_name
6477:
6478: from msd_dp_seeded_documents msd
6479:
6480: where msd.demand_plan_id = p_new_dp_id;
6481:
6482:

Line 6488: from msd_dp_seeded_documents

6484: cursor c2(p_document_name in varchar2) is
6485:
6486: select document_id
6487:
6488: from msd_dp_seeded_documents
6489:
6490: where document_name = p_document_name
6491:
6492: and demand_plan_id =

Line 7044: from msd_dp_seeded_documents

7040: and document_id in
7041:
7042: (select document_id
7043:
7044: from msd_dp_seeded_documents
7045:
7046: where demand_plan_id = p_demand_plan_id
7047:
7048: and document_name in ('MSD_LB_DETAILED_REPORT','MSD_LB_SUMMARY_REPORT'))