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.PA_FP_WEBADI_PKG dependencies on PA_LOOKUPS

Line 1779: l_pfunc_cost_rate_dt_typ_mning pa_lookups.meaning%TYPE;

1775: l_allow_qty_flag VARCHAR2(1);
1776:
1777: l_bdgt_ln_tbl_description VARCHAR2(255);
1778: l_pfunc_cost_rate_type_mning pa_conversion_types_v.user_conversion_type%TYPE;
1779: l_pfunc_cost_rate_dt_typ_mning pa_lookups.meaning%TYPE;
1780: l_pfunc_rev_rate_type_mning pa_conversion_types_v.user_conversion_type%TYPE;
1781: l_pfunc_rev_rate_dt_typ_mning pa_lookups.meaning%TYPE;
1782: l_prj_cost_rate_type_mning pa_conversion_types_v.user_conversion_type%TYPE;
1783: l_prj_cost_rate_dt_typ_mning pa_lookups.meaning%TYPE;

Line 1781: l_pfunc_rev_rate_dt_typ_mning pa_lookups.meaning%TYPE;

1777: l_bdgt_ln_tbl_description VARCHAR2(255);
1778: l_pfunc_cost_rate_type_mning pa_conversion_types_v.user_conversion_type%TYPE;
1779: l_pfunc_cost_rate_dt_typ_mning pa_lookups.meaning%TYPE;
1780: l_pfunc_rev_rate_type_mning pa_conversion_types_v.user_conversion_type%TYPE;
1781: l_pfunc_rev_rate_dt_typ_mning pa_lookups.meaning%TYPE;
1782: l_prj_cost_rate_type_mning pa_conversion_types_v.user_conversion_type%TYPE;
1783: l_prj_cost_rate_dt_typ_mning pa_lookups.meaning%TYPE;
1784: l_prj_rev_rate_type_mning pa_conversion_types_v.user_conversion_type%TYPE;
1785: l_prj_rev_rate_date_type_mning pa_lookups.meaning%TYPE;

Line 1783: l_prj_cost_rate_dt_typ_mning pa_lookups.meaning%TYPE;

1779: l_pfunc_cost_rate_dt_typ_mning pa_lookups.meaning%TYPE;
1780: l_pfunc_rev_rate_type_mning pa_conversion_types_v.user_conversion_type%TYPE;
1781: l_pfunc_rev_rate_dt_typ_mning pa_lookups.meaning%TYPE;
1782: l_prj_cost_rate_type_mning pa_conversion_types_v.user_conversion_type%TYPE;
1783: l_prj_cost_rate_dt_typ_mning pa_lookups.meaning%TYPE;
1784: l_prj_rev_rate_type_mning pa_conversion_types_v.user_conversion_type%TYPE;
1785: l_prj_rev_rate_date_type_mning pa_lookups.meaning%TYPE;
1786:
1787: d_projfunc_cost_rate_type pa_proj_fp_options.projfunc_cost_rate_type%TYPE ;

Line 1785: l_prj_rev_rate_date_type_mning pa_lookups.meaning%TYPE;

1781: l_pfunc_rev_rate_dt_typ_mning pa_lookups.meaning%TYPE;
1782: l_prj_cost_rate_type_mning pa_conversion_types_v.user_conversion_type%TYPE;
1783: l_prj_cost_rate_dt_typ_mning pa_lookups.meaning%TYPE;
1784: l_prj_rev_rate_type_mning pa_conversion_types_v.user_conversion_type%TYPE;
1785: l_prj_rev_rate_date_type_mning pa_lookups.meaning%TYPE;
1786:
1787: d_projfunc_cost_rate_type pa_proj_fp_options.projfunc_cost_rate_type%TYPE ;
1788: d_projfunc_cost_rate_date_type pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE;
1789: d_projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE ;

Line 1973: l_lookup_type pa_lookups.lookup_type%TYPE;

1969: l_min_ra_plan_start_date DATE;
1970: l_max_ra_plan_end_date DATE;
1971:
1972: l_amount_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
1973: l_lookup_type pa_lookups.lookup_type%TYPE;
1974: l_amount NUMBER;
1975: --l_temp DATE;
1976:
1977: -- Added for the bug 4414062

Line 2508: FROM pa_lookups pl,pa_fp_proj_xl_amt_types xlt

2504:
2505:
2506: UPDATE pa_fp_webadi_upload_inf inf
2507: SET amount_type_code = (SELECT pl.lookup_code
2508: FROM pa_lookups pl,pa_fp_proj_xl_amt_types xlt
2509: WHERE lookup_type=l_lookup_type
2510: AND meaning=inf.amount_type_name
2511: AND xlt.project_id=p_version_info_rec.x_project_id
2512: AND xlt.fin_plan_type_id=p_version_info_rec.x_fin_plan_type_id

Line 11336: pa_lookups plu1,

11332: inf.txn_currency_code currency,
11333: plu1.meaning amount_type,
11334: plu2.meaning error
11335: FROM pa_fp_webadi_upload_inf inf,
11336: pa_lookups plu1,
11337: pa_lookups plu2
11338: WHERE inf.run_id = c_run_id
11339: AND Nvl(inf.val_error_flag, 'N') = 'Y'
11340: AND inf.val_error_code IS NOT NULL

Line 11337: pa_lookups plu2

11333: plu1.meaning amount_type,
11334: plu2.meaning error
11335: FROM pa_fp_webadi_upload_inf inf,
11336: pa_lookups plu1,
11337: pa_lookups plu2
11338: WHERE inf.run_id = c_run_id
11339: AND Nvl(inf.val_error_flag, 'N') = 'Y'
11340: AND inf.val_error_code IS NOT NULL
11341: AND plu1.lookup_type = DECODE (c_plan_class, 'BUDGET',

Line 11864: FROM PA_LOOKUPS

11860: etc.meaning etc_method,
11861: pev.proj_element_id project_element_id,
11862: decode(pra.transaction_source_code,NULL,NULL,
11863: (SELECT meaning
11864: FROM PA_LOOKUPS
11865: WHERE LOOKUP_TYPE='PA_FP_FCST_GEN_SRC_ALL'
11866: AND LOOKUP_CODE= nvl(pra.transaction_source_code, (
11867: SELECT lookup_code
11868: FROM pa_lookups

Line 11868: FROM pa_lookups

11864: FROM PA_LOOKUPS
11865: WHERE LOOKUP_TYPE='PA_FP_FCST_GEN_SRC_ALL'
11866: AND LOOKUP_CODE= nvl(pra.transaction_source_code, (
11867: SELECT lookup_code
11868: FROM pa_lookups
11869: WHERE lookup_type='PA_FP_FCST_GEN_SRC_ALL'
11870: AND rownum=1)))) etc_source,
11871: pftc.txn_currency_code txn_currency_code,
11872: pftc.project_cost_exchange_rate project_cost_exchange_rate,

Line 11882: pa_lookups uom,

11878: pa_fp_txn_currencies pftc,
11879: pa_proj_elements pe,
11880: pa_proj_element_versions pev,
11881: pa_resource_list_members prlm,
11882: pa_lookups uom,
11883: pa_spread_curves_tl psc,
11884: cst_cost_types cct,
11885: pa_lookups etc,
11886: pa_projects_all ppa

Line 11885: pa_lookups etc,

11881: pa_resource_list_members prlm,
11882: pa_lookups uom,
11883: pa_spread_curves_tl psc,
11884: cst_cost_types cct,
11885: pa_lookups etc,
11886: pa_projects_all ppa
11887: WHERE pra.budget_version_id = c_budget_version_id
11888: AND prac.budget_version_id = pra.budget_version_id
11889: AND prac.resource_assignment_id = pra.resource_assignment_id

Line 11944: FROM pa_lookups plk_d1

11940:
11941: decode(decode(amt.amount_type_code,'TOTAL_REV',decode(l_proj_fp_options_rec.projfunc_rev_rate_type,'User',null,l_proj_fp_options_rec.projfunc_rev_rate_date_type),
11942: decode(l_proj_fp_options_rec.projfunc_cost_rate_type,'User',null,l_proj_fp_options_rec.projfunc_cost_rate_date_type)),null,null,
11943: (SELECT plk_d1.meaning
11944: FROM pa_lookups plk_d1
11945: WHERE plk_d1.lookup_type='PA_FP_RATE_DATE_TYPE'
11946: AND plk_d1.lookup_code=NVL(decode(amt.amount_type_code,'TOTAL_REV',
11947: decode(l_proj_fp_options_rec.projfunc_rev_rate_type,'User',null,l_proj_fp_options_rec.projfunc_rev_rate_date_type),
11948: decode(l_proj_fp_options_rec.projfunc_cost_rate_type,'User',null,l_proj_fp_options_rec.projfunc_cost_rate_date_type)),'FIXED_DATE'))) projfunc_rate_date_type,

Line 11961: FROM pa_lookups plk_d2

11957:
11958: decode(decode(amt.amount_type_code,'TOTAL_REV',decode(l_proj_fp_options_rec.project_rev_rate_type,'User',null,l_proj_fp_options_rec.PROJECT_REV_RATE_DATE_TYPE),
11959: decode(l_proj_fp_options_rec.project_cost_rate_type,'User',null,l_proj_fp_options_rec.project_cost_rate_date_type)),null,null,
11960: (SELECT plk_d2.meaning
11961: FROM pa_lookups plk_d2
11962: WHERE plk_d2.lookup_type='PA_FP_RATE_DATE_TYPE'
11963: AND plk_d2.lookup_code=NVL(decode(amt.amount_type_code,'TOTAL_REV',
11964: decode(l_proj_fp_options_rec.project_rev_rate_type,'User',null,l_proj_fp_options_rec.project_rev_rate_date_type),
11965: decode(l_proj_fp_options_rec.project_cost_rate_type,'User',null,l_proj_fp_options_rec.project_cost_rate_date_type)),'FIXED_DATE'))) project_rate_date_type,

Line 11970: pa_lookups amt_lu

11966:
11967: decode(amt.amount_type_code,'TOTAL_REV',decode(l_proj_fp_options_rec.project_rev_rate_date_type,'FIXED_DATE',l_proj_fp_options_rec.project_rev_rate_date,TO_DATE(null)),
11968: decode(l_proj_fp_options_rec.project_cost_rate_date_type,'FIXED_DATE',l_proj_fp_options_rec.project_cost_rate_date,TO_DATE(null))) project_rate_date
11969: FROM pa_fp_proj_xl_amt_types amt,
11970: pa_lookups amt_lu
11971: WHERE amt.project_id = c_project_id
11972: AND amt.fin_plan_type_id = c_fin_plan_type_id
11973: AND amt.option_type = c_option_type
11974: AND amt_lu.lookup_type = decode(c_plan_class_code,'BUDGET', decode(c_option_type,'COST','PA_FP_XL_COST_BDGT_AMT_TYPES','REVENUE','PA_FP_XL_REV_BDGT_AMT_TYPES','ALL','PA_FP_XL_ALL_BDGT_AMT_TYPES'),