eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.MSC_SDA_PKG

Source


1 package MSC_SDA_PKG AUTHID CURRENT_USER as
2 /* $Header: MSCSDAPS.pls 120.13 2010/11/24 23:09:34 pabram ship $ */
3 
4   -- p_view_type - 1 sdview, 2 fcst view
5   -- p_plan_id - plan_id
6   -- p_region_type - 1 region_list, 2 region_id
7   -- p_org_type - 1 org_list, 2 org_id
8   -- p_org_list - org_list_id, (inst_id-org-id)
9   -- p_item_id - inventory_item_id
10   -- p_item_view_type - 1 item, 2 prime, 3 supersession
11   procedure SdFCSTHistoryView(p_query_id in out nocopy number,
12     p_view_type number,
13     p_plan_id number,
14     p_org_type number, p_org_list varchar2,
15     p_region_type number, p_region_list varchar2,
16     p_item_list number, p_item_view_type number,
17     p_refresh_view boolean default false,
18     p_error_code out nocopy varchar2,
19     p_item_folder number,
20     p_items_data IN OUT NOCOPY msc_sda_utils.maxCharTbl,
21     p_comments_data IN OUT NOCOPY msc_sda_utils.maxCharTbl,
22     p_excp_data  IN OUT NOCOPY msc_sda_utils.maxCharTbl) ;
23 
24   procedure sendSDData(p_row_index number,
25     p_orglist_action number, p_itemlist_action number, p_action_node number,
26     p_rheader_data in out nocopy msc_sda_utils.maxCharTbl,
27     p_out_data in out nocopy msc_sda_utils.maxCharTbl);
28 
29   procedure sendTimeBucket(p_view_type number,
30     p_bucket_data IN OUT NOCOPY msc_sda_utils.maxCharTbl,
31     p_week_data IN OUT NOCOPY msc_sda_utils.maxCharTbl,
32     p_period_data IN OUT NOCOPY msc_sda_utils.maxCharTbl);
33 
34   procedure sendRowTypes(p_sd_data IN OUT NOCOPY msc_sda_utils.maxCharTbl,
35     p_fcst_data IN OUT NOCOPY msc_sda_utils.maxCharTbl,
36     p_hist_data IN OUT NOCOPY msc_sda_utils.maxCharTbl);
37 
38   procedure sendFCSTHistoryData(p_view_type number, p_row_index number,
39     p_reglist_action number, p_orglist_action number, p_itemlist_action number, p_action_node number,
40     p_rheader_data in out nocopy msc_sda_utils.maxCharTbl,
41     p_out_data in out nocopy msc_sda_utils.maxCharTbl,
42     p_out_data2 in out nocopy msc_sda_utils.maxCharTbl);
43 
44   function getSDStartDate(p_bkt_start_date date, p_plan_start_date date, p_plan_end_date date, p_sd_date date) return date;
45   function getSDEndDate(p_bkt_end_date date, p_plan_start_date date, p_plan_end_date date, p_sd_date date) return date;
46   function getSupplyRowTypeOffset(p_order_type number, p_item_type_id number,
47     p_item_type_value number, p_type_flag number, p_source_organization_id number) return number;
48   function getDemandRowTypeOffset(p_order_type number, p_item_type_id number, p_item_type_value number, p_type_flag number,
49     p_disposition_id number, p_org_type number) return number;
50 
51   function getHistStartDate(p_bkt_start_date date, p_plan_start_date date, p_plan_end_date date, p_sd_date date) return date;
52   function getHistEndDate(p_bkt_end_date date, p_plan_start_date date, p_plan_end_date date, p_sd_date date) return date;
53   function getHistRowTypeOffset(p_order_type number, p_item_type_id number, p_item_type_value number, p_type_flag number) return number;
54 
55   function getFcstStartDate(p_bkt_start_date date, p_plan_start_date date, p_plan_end_date date, p_sd_date date) return date;
56   function getFcstEndDate(p_bkt_end_date date, p_plan_start_date date, p_plan_end_date date, p_sd_date date) return date;
57   function getFcstRowTypeOffset(p_supply_demand_flag number, p_order_type number, p_item_type_id number, p_item_type_value number, p_type_flag number,
58     p_inst_id number, p_org_id number, p_region_id number, p_schedule_designator_id number, p_item_id number) return number;
59 
60   procedure sendNlsMessages(p_out_data IN OUT NOCOPY msc_sda_utils.maxCharTbl);
61   procedure spreadTableMessages(p_out_data in out nocopy msc_sda_utils.maxCharTbl);
62 
63   procedure set_shuttle_from_to(p_lookup_type varchar2, p_lookup_code_list varchar2,
64     p_from_list out nocopy varchar2, p_to_list out nocopy varchar2);
65 
66   procedure update_pref_set (p_name varchar2, p_desc varchar2,
67     p_days number, p_weeks number, p_periods number,
68     p_factor number, p_decimal_places number,
69     p_sd_row_list varchar2, p_fcst_row_list varchar2);
70 
71   procedure save_item_folder(p_folder_name varchar, p_folder_value varchar,
72     p_default_flag number, p_public_flag number);
73 
74   procedure update_close_settings(p_event varchar2, p_event_list varchar2);
75   procedure send_close_settings(p_item_folder_save_list out nocopy varchar2,
76     p_save_settings_list out nocopy varchar2);
77 
78   procedure getCommentsData(p_out_data in out nocopy msc_sda_utils.maxCharTbl);
79   procedure getItemList(p_out_data out nocopy varchar2);
80   procedure getOrgList(p_out_data out nocopy varchar2);
81   procedure getWorkSheetPrefData(p_out_data IN OUT NOCOPY msc_sda_utils.maxCharTbl, p_refresh_flag number);
82 
83   procedure getDrillDownDetails(p_view_type number, p_row_index number, p_row_offset number,
84     p_date1 varchar2, p_date2 varchar2, p_from_table out nocopy varchar2, p_mfq_id out nocopy number);
85 
86 --for supersession window
87 function populateSupersessionChain(p_plan number, p_item number,
88   p_related_flag number default null) return number;
89 
90 --for engine
91   procedure sendTimeBucketEng(p_plan_id number, p_view_type number,
92     p_bucket_data IN OUT NOCOPY msc_sda_utils.maxCharTbl,
93     p_week_data IN OUT NOCOPY msc_sda_utils.maxCharTbl,
94     p_period_data IN OUT NOCOPY msc_sda_utils.maxCharTbl);
95 
96 end MSC_SDA_PKG;