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_PHUB_PKG dependencies on FND_PROFILE

Line 104: l_category_set_id1 varchar2(200) := fnd_profile.value('MSC_HUB_CAT_SET_ID_1');

100: return null;
101: end get_plan_type_meaning;
102:
103: function check_apcc_setup return number is
104: l_category_set_id1 varchar2(200) := fnd_profile.value('MSC_HUB_CAT_SET_ID_1');
105: l_category_set_id2 varchar2(200) := fnd_profile.value('MSC_HUB_CAT_SET_ID_2');
106: l_category_set_id3 varchar2(200) := fnd_profile.value('MSC_HUB_CAT_SET_ID_3');
107: l_hub_cal_code varchar2(200) := fnd_profile.value('MSC_HUB_CAL_CODE');
108: l_hub_pr_set varchar2(200) := fnd_profile.value('MSC_HUB_PERIOD_SET_NAME');

Line 105: l_category_set_id2 varchar2(200) := fnd_profile.value('MSC_HUB_CAT_SET_ID_2');

101: end get_plan_type_meaning;
102:
103: function check_apcc_setup return number is
104: l_category_set_id1 varchar2(200) := fnd_profile.value('MSC_HUB_CAT_SET_ID_1');
105: l_category_set_id2 varchar2(200) := fnd_profile.value('MSC_HUB_CAT_SET_ID_2');
106: l_category_set_id3 varchar2(200) := fnd_profile.value('MSC_HUB_CAT_SET_ID_3');
107: l_hub_cal_code varchar2(200) := fnd_profile.value('MSC_HUB_CAL_CODE');
108: l_hub_pr_set varchar2(200) := fnd_profile.value('MSC_HUB_PERIOD_SET_NAME');
109: l_hub_cur_code varchar2(200) := fnd_profile.value('MSC_HUB_CUR_CODE_RPT');

Line 106: l_category_set_id3 varchar2(200) := fnd_profile.value('MSC_HUB_CAT_SET_ID_3');

102:
103: function check_apcc_setup return number is
104: l_category_set_id1 varchar2(200) := fnd_profile.value('MSC_HUB_CAT_SET_ID_1');
105: l_category_set_id2 varchar2(200) := fnd_profile.value('MSC_HUB_CAT_SET_ID_2');
106: l_category_set_id3 varchar2(200) := fnd_profile.value('MSC_HUB_CAT_SET_ID_3');
107: l_hub_cal_code varchar2(200) := fnd_profile.value('MSC_HUB_CAL_CODE');
108: l_hub_pr_set varchar2(200) := fnd_profile.value('MSC_HUB_PERIOD_SET_NAME');
109: l_hub_cur_code varchar2(200) := fnd_profile.value('MSC_HUB_CUR_CODE_RPT');
110: l_hur_reg_instance varchar2(200) := fnd_profile.value('MSC_HUB_REGION_INSTANCE');

Line 107: l_hub_cal_code varchar2(200) := fnd_profile.value('MSC_HUB_CAL_CODE');

103: function check_apcc_setup return number is
104: l_category_set_id1 varchar2(200) := fnd_profile.value('MSC_HUB_CAT_SET_ID_1');
105: l_category_set_id2 varchar2(200) := fnd_profile.value('MSC_HUB_CAT_SET_ID_2');
106: l_category_set_id3 varchar2(200) := fnd_profile.value('MSC_HUB_CAT_SET_ID_3');
107: l_hub_cal_code varchar2(200) := fnd_profile.value('MSC_HUB_CAL_CODE');
108: l_hub_pr_set varchar2(200) := fnd_profile.value('MSC_HUB_PERIOD_SET_NAME');
109: l_hub_cur_code varchar2(200) := fnd_profile.value('MSC_HUB_CUR_CODE_RPT');
110: l_hur_reg_instance varchar2(200) := fnd_profile.value('MSC_HUB_REGION_INSTANCE');
111: l_top_bottom_n varchar2(200) := fnd_profile.value('MSC_HUB_TOP_BOTTOM_N_VALUE');

Line 108: l_hub_pr_set varchar2(200) := fnd_profile.value('MSC_HUB_PERIOD_SET_NAME');

104: l_category_set_id1 varchar2(200) := fnd_profile.value('MSC_HUB_CAT_SET_ID_1');
105: l_category_set_id2 varchar2(200) := fnd_profile.value('MSC_HUB_CAT_SET_ID_2');
106: l_category_set_id3 varchar2(200) := fnd_profile.value('MSC_HUB_CAT_SET_ID_3');
107: l_hub_cal_code varchar2(200) := fnd_profile.value('MSC_HUB_CAL_CODE');
108: l_hub_pr_set varchar2(200) := fnd_profile.value('MSC_HUB_PERIOD_SET_NAME');
109: l_hub_cur_code varchar2(200) := fnd_profile.value('MSC_HUB_CUR_CODE_RPT');
110: l_hur_reg_instance varchar2(200) := fnd_profile.value('MSC_HUB_REGION_INSTANCE');
111: l_top_bottom_n varchar2(200) := fnd_profile.value('MSC_HUB_TOP_BOTTOM_N_VALUE');
112: begin

Line 109: l_hub_cur_code varchar2(200) := fnd_profile.value('MSC_HUB_CUR_CODE_RPT');

105: l_category_set_id2 varchar2(200) := fnd_profile.value('MSC_HUB_CAT_SET_ID_2');
106: l_category_set_id3 varchar2(200) := fnd_profile.value('MSC_HUB_CAT_SET_ID_3');
107: l_hub_cal_code varchar2(200) := fnd_profile.value('MSC_HUB_CAL_CODE');
108: l_hub_pr_set varchar2(200) := fnd_profile.value('MSC_HUB_PERIOD_SET_NAME');
109: l_hub_cur_code varchar2(200) := fnd_profile.value('MSC_HUB_CUR_CODE_RPT');
110: l_hur_reg_instance varchar2(200) := fnd_profile.value('MSC_HUB_REGION_INSTANCE');
111: l_top_bottom_n varchar2(200) := fnd_profile.value('MSC_HUB_TOP_BOTTOM_N_VALUE');
112: begin
113: if l_category_set_id1 is null then

Line 110: l_hur_reg_instance varchar2(200) := fnd_profile.value('MSC_HUB_REGION_INSTANCE');

106: l_category_set_id3 varchar2(200) := fnd_profile.value('MSC_HUB_CAT_SET_ID_3');
107: l_hub_cal_code varchar2(200) := fnd_profile.value('MSC_HUB_CAL_CODE');
108: l_hub_pr_set varchar2(200) := fnd_profile.value('MSC_HUB_PERIOD_SET_NAME');
109: l_hub_cur_code varchar2(200) := fnd_profile.value('MSC_HUB_CUR_CODE_RPT');
110: l_hur_reg_instance varchar2(200) := fnd_profile.value('MSC_HUB_REGION_INSTANCE');
111: l_top_bottom_n varchar2(200) := fnd_profile.value('MSC_HUB_TOP_BOTTOM_N_VALUE');
112: begin
113: if l_category_set_id1 is null then
114: return 2;

Line 111: l_top_bottom_n varchar2(200) := fnd_profile.value('MSC_HUB_TOP_BOTTOM_N_VALUE');

107: l_hub_cal_code varchar2(200) := fnd_profile.value('MSC_HUB_CAL_CODE');
108: l_hub_pr_set varchar2(200) := fnd_profile.value('MSC_HUB_PERIOD_SET_NAME');
109: l_hub_cur_code varchar2(200) := fnd_profile.value('MSC_HUB_CUR_CODE_RPT');
110: l_hur_reg_instance varchar2(200) := fnd_profile.value('MSC_HUB_REGION_INSTANCE');
111: l_top_bottom_n varchar2(200) := fnd_profile.value('MSC_HUB_TOP_BOTTOM_N_VALUE');
112: begin
113: if l_category_set_id1 is null then
114: return 2;
115: end if;

Line 368: where daio.organization_id=nvl(fnd_profile.value('MSD_DEM_MASTER_ORG'), -23453)

364: msd_dp_scenario_revisions dsr,
365: msd_dem_transfer_query tq,
366: (select mtp.sr_instance_id, mtp.sr_tp_id
367: from msc_trading_partners mtp, msd_dem_app_instance_orgs daio
368: where daio.organization_id=nvl(fnd_profile.value('MSD_DEM_MASTER_ORG'), -23453)
369: and mtp.organization_code=daio.organization_code
370: and mtp.partner_type=3
371: union all select to_number(-23453), to_number(-23453) from dual) o
372: where das.demand_plan_name=substr(tq.query_name(+), 1, 30)

Line 512: l_db_name varchar2(30) := fnd_profile.value('MSC_APCC_BACK_TO_SELF_DBLINK');

508: p_plan_id number, p_plan_run_id number,
509: p_target_plan_name varchar2, p_dblink varchar2,
510: p_include_ods number, p_archive_flag number)
511: is
512: l_db_name varchar2(30) := fnd_profile.value('MSC_APCC_BACK_TO_SELF_DBLINK');
513: l_sql varchar2(2000);
514: l_pi plan_info;
515: l_suffix varchar2(32) := msc_phub_util.suffix(p_dblink);
516: l_request_id number;

Line 938: fnd_profile.value('MSC_HUB_CAL_CODE') cal_code,

934: last_update_date, last_updated_by, last_update_login,
935: program_id, program_login_id,
936: program_application_id, request_id)
937: select
938: fnd_profile.value('MSC_HUB_CAL_CODE') cal_code,
939: fnd_profile.value('MSC_HUB_PERIOD_SET_NAME') period_set_name,
940: fnd_profile.value('MSC_HUB_CUR_CODE_RPT') reporting_currency,
941: fnd_profile.value('MSC_HUB_CAT_SET_ID_1') category_set_id1,
942: fnd_profile.value('MSC_HUB_CAT_SET_ID_2') category_set_id2,

Line 939: fnd_profile.value('MSC_HUB_PERIOD_SET_NAME') period_set_name,

935: program_id, program_login_id,
936: program_application_id, request_id)
937: select
938: fnd_profile.value('MSC_HUB_CAL_CODE') cal_code,
939: fnd_profile.value('MSC_HUB_PERIOD_SET_NAME') period_set_name,
940: fnd_profile.value('MSC_HUB_CUR_CODE_RPT') reporting_currency,
941: fnd_profile.value('MSC_HUB_CAT_SET_ID_1') category_set_id1,
942: fnd_profile.value('MSC_HUB_CAT_SET_ID_2') category_set_id2,
943: fnd_profile.value('MSC_HUB_CAT_SET_ID_3') category_set_id3,

Line 940: fnd_profile.value('MSC_HUB_CUR_CODE_RPT') reporting_currency,

936: program_application_id, request_id)
937: select
938: fnd_profile.value('MSC_HUB_CAL_CODE') cal_code,
939: fnd_profile.value('MSC_HUB_PERIOD_SET_NAME') period_set_name,
940: fnd_profile.value('MSC_HUB_CUR_CODE_RPT') reporting_currency,
941: fnd_profile.value('MSC_HUB_CAT_SET_ID_1') category_set_id1,
942: fnd_profile.value('MSC_HUB_CAT_SET_ID_2') category_set_id2,
943: fnd_profile.value('MSC_HUB_CAT_SET_ID_3') category_set_id3,
944: fnd_profile.value('MSC_APCC_PEGGING_CAT_SET') pg_category_set_id,

Line 941: fnd_profile.value('MSC_HUB_CAT_SET_ID_1') category_set_id1,

937: select
938: fnd_profile.value('MSC_HUB_CAL_CODE') cal_code,
939: fnd_profile.value('MSC_HUB_PERIOD_SET_NAME') period_set_name,
940: fnd_profile.value('MSC_HUB_CUR_CODE_RPT') reporting_currency,
941: fnd_profile.value('MSC_HUB_CAT_SET_ID_1') category_set_id1,
942: fnd_profile.value('MSC_HUB_CAT_SET_ID_2') category_set_id2,
943: fnd_profile.value('MSC_HUB_CAT_SET_ID_3') category_set_id3,
944: fnd_profile.value('MSC_APCC_PEGGING_CAT_SET') pg_category_set_id,
945: fnd_global.user_id, sysdate,

Line 942: fnd_profile.value('MSC_HUB_CAT_SET_ID_2') category_set_id2,

938: fnd_profile.value('MSC_HUB_CAL_CODE') cal_code,
939: fnd_profile.value('MSC_HUB_PERIOD_SET_NAME') period_set_name,
940: fnd_profile.value('MSC_HUB_CUR_CODE_RPT') reporting_currency,
941: fnd_profile.value('MSC_HUB_CAT_SET_ID_1') category_set_id1,
942: fnd_profile.value('MSC_HUB_CAT_SET_ID_2') category_set_id2,
943: fnd_profile.value('MSC_HUB_CAT_SET_ID_3') category_set_id3,
944: fnd_profile.value('MSC_APCC_PEGGING_CAT_SET') pg_category_set_id,
945: fnd_global.user_id, sysdate,
946: sysdate, fnd_global.user_id, fnd_global.login_id,

Line 943: fnd_profile.value('MSC_HUB_CAT_SET_ID_3') category_set_id3,

939: fnd_profile.value('MSC_HUB_PERIOD_SET_NAME') period_set_name,
940: fnd_profile.value('MSC_HUB_CUR_CODE_RPT') reporting_currency,
941: fnd_profile.value('MSC_HUB_CAT_SET_ID_1') category_set_id1,
942: fnd_profile.value('MSC_HUB_CAT_SET_ID_2') category_set_id2,
943: fnd_profile.value('MSC_HUB_CAT_SET_ID_3') category_set_id3,
944: fnd_profile.value('MSC_APCC_PEGGING_CAT_SET') pg_category_set_id,
945: fnd_global.user_id, sysdate,
946: sysdate, fnd_global.user_id, fnd_global.login_id,
947: fnd_global.conc_program_id, fnd_global.conc_login_id,

Line 944: fnd_profile.value('MSC_APCC_PEGGING_CAT_SET') pg_category_set_id,

940: fnd_profile.value('MSC_HUB_CUR_CODE_RPT') reporting_currency,
941: fnd_profile.value('MSC_HUB_CAT_SET_ID_1') category_set_id1,
942: fnd_profile.value('MSC_HUB_CAT_SET_ID_2') category_set_id2,
943: fnd_profile.value('MSC_HUB_CAT_SET_ID_3') category_set_id3,
944: fnd_profile.value('MSC_APCC_PEGGING_CAT_SET') pg_category_set_id,
945: fnd_global.user_id, sysdate,
946: sysdate, fnd_global.user_id, fnd_global.login_id,
947: fnd_global.conc_program_id, fnd_global.conc_login_id,
948: fnd_global.prog_appl_id, fnd_global.conc_request_id

Line 1547: where category_set_id=fnd_profile.value('MSC_HUB_CAT_SET_ID_1')) ic1,

1543: fnd_global.prog_appl_id, fnd_global.conc_request_id
1544: from msc_system_items i,
1545: (select sr_instance_id, organization_id, inventory_item_id, sr_category_id
1546: from msc_phub_item_categories_mv
1547: where category_set_id=fnd_profile.value('MSC_HUB_CAT_SET_ID_1')) ic1,
1548: (select sr_instance_id, organization_id, inventory_item_id, sr_category_id
1549: from msc_phub_item_categories_mv
1550: where category_set_id=fnd_profile.value('MSC_HUB_CAT_SET_ID_2')) ic2,
1551: (select sr_instance_id, organization_id, inventory_item_id, sr_category_id

Line 1550: where category_set_id=fnd_profile.value('MSC_HUB_CAT_SET_ID_2')) ic2,

1546: from msc_phub_item_categories_mv
1547: where category_set_id=fnd_profile.value('MSC_HUB_CAT_SET_ID_1')) ic1,
1548: (select sr_instance_id, organization_id, inventory_item_id, sr_category_id
1549: from msc_phub_item_categories_mv
1550: where category_set_id=fnd_profile.value('MSC_HUB_CAT_SET_ID_2')) ic2,
1551: (select sr_instance_id, organization_id, inventory_item_id, sr_category_id
1552: from msc_phub_item_categories_mv
1553: where category_set_id=fnd_profile.value('MSC_HUB_CAT_SET_ID_3')) ic3,
1554: (select sr_instance_id, organization_id, inventory_item_id, sr_category_id

Line 1553: where category_set_id=fnd_profile.value('MSC_HUB_CAT_SET_ID_3')) ic3,

1549: from msc_phub_item_categories_mv
1550: where category_set_id=fnd_profile.value('MSC_HUB_CAT_SET_ID_2')) ic2,
1551: (select sr_instance_id, organization_id, inventory_item_id, sr_category_id
1552: from msc_phub_item_categories_mv
1553: where category_set_id=fnd_profile.value('MSC_HUB_CAT_SET_ID_3')) ic3,
1554: (select sr_instance_id, organization_id, inventory_item_id, sr_category_id
1555: from msc_phub_item_categories_mv
1556: where nvl(fnd_profile.value('MSC_APCC_END_ITEM_ENABLED'), 2)<2
1557: and category_set_id=fnd_profile.value('MSC_APCC_PEGGING_CAT_SET')) ick,

Line 1556: where nvl(fnd_profile.value('MSC_APCC_END_ITEM_ENABLED'), 2)<2

1552: from msc_phub_item_categories_mv
1553: where category_set_id=fnd_profile.value('MSC_HUB_CAT_SET_ID_3')) ic3,
1554: (select sr_instance_id, organization_id, inventory_item_id, sr_category_id
1555: from msc_phub_item_categories_mv
1556: where nvl(fnd_profile.value('MSC_APCC_END_ITEM_ENABLED'), 2)<2
1557: and category_set_id=fnd_profile.value('MSC_APCC_PEGGING_CAT_SET')) ick,
1558: (select distinct lower_item_id,
1559: first_value(highest_item_id) over(partition by lower_item_id) highest_item_id
1560: from

Line 1557: and category_set_id=fnd_profile.value('MSC_APCC_PEGGING_CAT_SET')) ick,

1553: where category_set_id=fnd_profile.value('MSC_HUB_CAT_SET_ID_3')) ic3,
1554: (select sr_instance_id, organization_id, inventory_item_id, sr_category_id
1555: from msc_phub_item_categories_mv
1556: where nvl(fnd_profile.value('MSC_APCC_END_ITEM_ENABLED'), 2)<2
1557: and category_set_id=fnd_profile.value('MSC_APCC_PEGGING_CAT_SET')) ick,
1558: (select distinct lower_item_id,
1559: first_value(highest_item_id) over(partition by lower_item_id) highest_item_id
1560: from
1561: (select lower_item_id, highest_item_id

Line 1820: l_days_forward number := nvl(fnd_profile.value('MSC_APCC_COLL_HORIZON_DAYS'),30);

1816: con_ods_plan_id constant number := -1;
1817: l_plan_run_id number;
1818: l_lcid number;
1819: l_return_status number := sys_no;
1820: l_days_forward number := nvl(fnd_profile.value('MSC_APCC_COLL_HORIZON_DAYS'),30);
1821: l_days_back number := nvl(fnd_profile.value('MSC_APCC_COLL_HORIZON_DAYS_BACK'),30);
1822: l_instance_code varchar2(3);
1823: l_plan_run_name varchar2(100);
1824: l_pi plan_info;

Line 1821: l_days_back number := nvl(fnd_profile.value('MSC_APCC_COLL_HORIZON_DAYS_BACK'),30);

1817: l_plan_run_id number;
1818: l_lcid number;
1819: l_return_status number := sys_no;
1820: l_days_forward number := nvl(fnd_profile.value('MSC_APCC_COLL_HORIZON_DAYS'),30);
1821: l_days_back number := nvl(fnd_profile.value('MSC_APCC_COLL_HORIZON_DAYS_BACK'),30);
1822: l_instance_code varchar2(3);
1823: l_plan_run_name varchar2(100);
1824: l_pi plan_info;
1825: l_transfer_id number := null;