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.

[Home] [Help]

APPS.PA_FP_WEBADI_PKG dependencies on PA_LOOKUPS

Line 1781: l_pfunc_cost_rate_dt_typ_mning pa_lookups.meaning%TYPE;

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

Line 1783: l_pfunc_rev_rate_dt_typ_mning pa_lookups.meaning%TYPE;

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

Line 1785: l_prj_cost_rate_dt_typ_mning pa_lookups.meaning%TYPE;

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

Line 1787: l_prj_rev_rate_date_type_mning pa_lookups.meaning%TYPE;

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

Line 1982: l_lookup_type pa_lookups.lookup_type%TYPE;

1978: l_min_ra_plan_start_date DATE;
1979: l_max_ra_plan_end_date DATE;
1980:
1981: l_amount_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
1982: l_lookup_type pa_lookups.lookup_type%TYPE;
1983: l_amount NUMBER;
1984: --l_temp DATE;
1985:
1986: -- Added for the bug 4414062

Line 2545: FROM pa_lookups pl,pa_fp_proj_xl_amt_types xlt

2541:
2542:
2543: UPDATE pa_fp_webadi_upload_inf inf
2544: SET amount_type_code = (SELECT pl.lookup_code
2545: FROM pa_lookups pl,pa_fp_proj_xl_amt_types xlt
2546: WHERE lookup_type=l_lookup_type
2547: AND meaning=inf.amount_type_name
2548: AND xlt.project_id=p_version_info_rec.x_project_id
2549: AND xlt.fin_plan_type_id=p_version_info_rec.x_fin_plan_type_id

Line 11566: pa_lookups plu1,

11562: inf.txn_currency_code currency,
11563: plu1.meaning amount_type,
11564: plu2.meaning error
11565: FROM pa_fp_webadi_upload_inf inf,
11566: pa_lookups plu1,
11567: pa_lookups plu2
11568: WHERE inf.run_id = c_run_id
11569: AND Nvl(inf.val_error_flag, 'N') = 'Y'
11570: AND inf.val_error_code IS NOT NULL

Line 11567: pa_lookups plu2

11563: plu1.meaning amount_type,
11564: plu2.meaning error
11565: FROM pa_fp_webadi_upload_inf inf,
11566: pa_lookups plu1,
11567: pa_lookups plu2
11568: WHERE inf.run_id = c_run_id
11569: AND Nvl(inf.val_error_flag, 'N') = 'Y'
11570: AND inf.val_error_code IS NOT NULL
11571: AND plu1.lookup_type = DECODE (c_plan_class, 'BUDGET',

Line 12095: FROM PA_LOOKUPS

12091: etc.meaning etc_method,
12092: pev.proj_element_id project_element_id,
12093: decode(pra.transaction_source_code,NULL,NULL,
12094: (SELECT meaning
12095: FROM PA_LOOKUPS
12096: WHERE LOOKUP_TYPE='PA_FP_FCST_GEN_SRC_ALL'
12097: AND LOOKUP_CODE= nvl(pra.transaction_source_code, (
12098: SELECT lookup_code
12099: FROM pa_lookups

Line 12099: FROM pa_lookups

12095: FROM PA_LOOKUPS
12096: WHERE LOOKUP_TYPE='PA_FP_FCST_GEN_SRC_ALL'
12097: AND LOOKUP_CODE= nvl(pra.transaction_source_code, (
12098: SELECT lookup_code
12099: FROM pa_lookups
12100: WHERE lookup_type='PA_FP_FCST_GEN_SRC_ALL'
12101: AND rownum=1)))) etc_source,
12102: pftc.txn_currency_code txn_currency_code,
12103: pftc.project_cost_exchange_rate project_cost_exchange_rate,

Line 12115: pa_lookups uom,

12111: pa_fp_txn_currencies pftc,
12112: pa_proj_elements pe,
12113: pa_proj_element_versions pev,
12114: pa_resource_list_members prlm,
12115: pa_lookups uom,
12116: pa_spread_curves_tl psc,
12117: cst_cost_types cct,
12118: pa_lookups etc,
12119: pa_projects_all ppa

Line 12118: pa_lookups etc,

12114: pa_resource_list_members prlm,
12115: pa_lookups uom,
12116: pa_spread_curves_tl psc,
12117: cst_cost_types cct,
12118: pa_lookups etc,
12119: pa_projects_all ppa
12120: WHERE pra.budget_version_id = c_budget_version_id
12121: AND prac.budget_version_id = pra.budget_version_id
12122: AND prac.resource_assignment_id = pra.resource_assignment_id

Line 12177: FROM pa_lookups plk_d1

12173:
12174: 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),
12175: decode(l_proj_fp_options_rec.projfunc_cost_rate_type,'User',null,l_proj_fp_options_rec.projfunc_cost_rate_date_type)),null,null,
12176: (SELECT plk_d1.meaning
12177: FROM pa_lookups plk_d1
12178: WHERE plk_d1.lookup_type='PA_FP_RATE_DATE_TYPE'
12179: AND plk_d1.lookup_code=NVL(decode(amt.amount_type_code,'TOTAL_REV',
12180: decode(l_proj_fp_options_rec.projfunc_rev_rate_type,'User',null,l_proj_fp_options_rec.projfunc_rev_rate_date_type),
12181: 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 12194: FROM pa_lookups plk_d2

12190:
12191: 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),
12192: decode(l_proj_fp_options_rec.project_cost_rate_type,'User',null,l_proj_fp_options_rec.project_cost_rate_date_type)),null,null,
12193: (SELECT plk_d2.meaning
12194: FROM pa_lookups plk_d2
12195: WHERE plk_d2.lookup_type='PA_FP_RATE_DATE_TYPE'
12196: AND plk_d2.lookup_code=NVL(decode(amt.amount_type_code,'TOTAL_REV',
12197: decode(l_proj_fp_options_rec.project_rev_rate_type,'User',null,l_proj_fp_options_rec.project_rev_rate_date_type),
12198: 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 12203: pa_lookups amt_lu

12199:
12200: 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)),
12201: 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
12202: FROM pa_fp_proj_xl_amt_types amt,
12203: pa_lookups amt_lu
12204: WHERE amt.project_id = c_project_id
12205: AND amt.fin_plan_type_id = c_fin_plan_type_id
12206: AND amt.option_type = c_option_type
12207: 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'),