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.

APPS.MSC_SDA_PKG dependencies on MSC_SDA_UTILS

Line 20: p_items_data IN OUT NOCOPY msc_sda_utils.maxCharTbl,

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,

Line 21: p_comments_data IN OUT NOCOPY msc_sda_utils.maxCharTbl,

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,

Line 22: p_excp_data IN OUT NOCOPY msc_sda_utils.maxCharTbl) ;

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,

Line 26: p_rheader_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,

Line 27: p_out_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,

Line 30: p_bucket_data IN OUT NOCOPY msc_sda_utils.maxCharTbl,

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,

Line 31: p_week_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,

Line 32: p_period_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);

Line 34: procedure sendRowTypes(p_sd_data IN OUT NOCOPY msc_sda_utils.maxCharTbl,

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,

Line 35: p_fcst_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,

Line 36: p_hist_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,

Line 40: p_rheader_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;

Line 41: p_out_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;

Line 42: p_out_data2 in out nocopy msc_sda_utils.maxCharTbl);

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,

Line 60: procedure sendNlsMessages(p_out_data IN OUT NOCOPY msc_sda_utils.maxCharTbl);

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);

Line 61: procedure spreadTableMessages(p_out_data in out nocopy msc_sda_utils.maxCharTbl);

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:

Line 78: procedure getCommentsData(p_out_data in out nocopy msc_sda_utils.maxCharTbl);

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:

Line 81: procedure getWorkSheetPrefData(p_out_data IN OUT NOCOPY msc_sda_utils.maxCharTbl, p_refresh_flag number);

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:

Line 91: p_bucket_data IN OUT NOCOPY msc_sda_utils.maxCharTbl,

87: function populateSupersessionChain(p_plan number, p_item number) return number;
88:
89: --for engine
90: procedure sendTimeBucketEng(p_plan_id number, p_view_type number,
91: p_bucket_data IN OUT NOCOPY msc_sda_utils.maxCharTbl,
92: p_week_data IN OUT NOCOPY msc_sda_utils.maxCharTbl,
93: p_period_data IN OUT NOCOPY msc_sda_utils.maxCharTbl);
94:
95: end MSC_SDA_PKG;

Line 92: p_week_data IN OUT NOCOPY msc_sda_utils.maxCharTbl,

88:
89: --for engine
90: procedure sendTimeBucketEng(p_plan_id number, p_view_type number,
91: p_bucket_data IN OUT NOCOPY msc_sda_utils.maxCharTbl,
92: p_week_data IN OUT NOCOPY msc_sda_utils.maxCharTbl,
93: p_period_data IN OUT NOCOPY msc_sda_utils.maxCharTbl);
94:
95: end MSC_SDA_PKG;

Line 93: p_period_data IN OUT NOCOPY msc_sda_utils.maxCharTbl);

89: --for engine
90: procedure sendTimeBucketEng(p_plan_id number, p_view_type number,
91: p_bucket_data IN OUT NOCOPY msc_sda_utils.maxCharTbl,
92: p_week_data IN OUT NOCOPY msc_sda_utils.maxCharTbl,
93: p_period_data IN OUT NOCOPY msc_sda_utils.maxCharTbl);
94:
95: end MSC_SDA_PKG;