[Home] [Help]
357: IF p_calling_module = 'XL_UPLOAD' THEN
358: BEGIN
359: SELECT 'Y'
360: INTO l_preserve_rows_flag
361: FROM DUAL
362: WHERE EXISTS (SELECT 'X'
363: FROM pa_fp_webadi_upload_inf inf,
364: pa_budget_versions bv
365: WHERE inf.run_id = p_run_id
583:
584: BEGIN
585: SELECT 'Y'
586: INTO is_periodic_layout
587: FROM DUAL
588: WHERE EXISTS(SELECT 'X'
589: FROM pa_fp_webadi_upload_inf
590: WHERE run_id = p_run_id
591: AND amount_type_name IS NOT NULL
1075:
1076: BEGIN
1077: SELECT 'Y'
1078: INTO l_periodic_flag
1079: FROM DUAL
1080: WHERE EXISTS (SELECT 1
1081: FROM pa_fp_webadi_upload_inf
1082: WHERE run_id=p_run_id
1083: AND amount_type_name IS NOT NULL
1706: l_debug_level5 CONSTANT NUMBER := PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5;
1707: l_msg_index_out NUMBER;
1708: l_data VARCHAR2(2000);
1709:
1710: -- variable to held the start_date and end_date of individual periods
1711: l_prd_start_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
1712: l_prd_end_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
1713:
1714: l_inf_tbl_data_prev_rec inf_tbl_data_csr%ROWTYPE;
2469:
2470: BEGIN
2471: SELECT 'Y'
2472: INTO is_periodic_setup
2473: FROM DUAL
2474: WHERE EXISTS(SELECT 'X'
2475: FROM pa_fp_webadi_upload_inf
2476: WHERE amount_type_name IS NOT NULL
2477: AND run_id = p_run_id
8743: BEGIN
8744: --log1('----- STAGE PBL15-------');
8745: SELECT pa_resource_assignments_s.nextval
8746: INTO l_curr_ra_id_seq
8747: FROM DUAL
8748: WHERE 1 = 1;
8749: --log1('----- STAGE PBL16-------');
8750: EXCEPTION
8751: WHEN OTHERS THEN
9104: --Bug 4424457. Find out if there are budget lines that are processed by calculate API
9105: BEGIN
9106: SELECT 'Y'
9107: INTO l_bls_proccessed_flag
9108: FROM DUAL
9109: WHERE EXISTS (SELECT 1
9110: FROM pa_fp_rollup_tmp);
9111: EXCEPTION
9112: WHEN NO_DATA_FOUND THEN
10132: l_project_id pa_projects_all.project_id%TYPE;
10133: l_org_id pa_projects_all.org_id%TYPE;
10134: l_version_info_rec pa_fp_gen_amount_utils.fp_cols;
10135:
10136: -- variable to held the start_date and end_date of individual periods
10137: l_prd_start_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
10138: l_prd_end_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
10139:
10140: l_budget_line_in_tbl PA_BUDGET_PUB.G_budget_lines_in_tbl%TYPE;
10399: --in the table since it will be populated only for periodic layouts.
10400: BEGIN
10401: SELECT 'Y'
10402: INTO is_periodic_setup
10403: FROM DUAL
10404: WHERE EXISTS(SELECT 'X'
10405: FROM pa_fp_webadi_upload_inf
10406: WHERE amount_type_name IS NOT NULL
10407: AND run_id = p_run_id
10765:
10766: BEGIN
10767: SELECT 'X'
10768: INTO l_error_indicator_flag
10769: FROM DUAL
10770: WHERE EXISTS (SELECT 'Y'
10771: FROM pa_fp_webadi_upload_inf inf
10772: WHERE run_id = p_run_id
10773: AND Nvl(p_request_id, -99) = Nvl(request_id, -99)
10851: BEGIN
10852:
10853: SELECT to_number(l_profile_thsld_val)
10854: INTO l_profile_thsld_num
10855: FROM dual;
10856: --log1('----- STAGE 10.9-------');
10857: EXCEPTION
10858: WHEN INVALID_NUMBER THEN
10859: --log1('----- STAGE 10.10-------');
12523: 'ALL', l_agr_curr_code,
12524: 'REVENUE', l_agr_curr_code,
12525: l_project_currency_code)))
12526: INTO l_txn_curr_tbl(1).txn_currency_code
12527: FROM dual;
12528: END IF;
12529: END;
12530: */ --Bug 5144013.
12531: /* End of code changes for bug 5330532 */
12551: decode(l_amt_type_tbl(amt).amount_type_code,'TOTAL_REV',decode(l_proj_fp_options_rec.project_rev_rate_type,'User',l_res_ass_tbl(res).project_rev_exchange_rate,TO_NUMBER(null)),
12552: decode(l_proj_fp_options_rec.project_cost_rate_type,'User',null,l_res_ass_tbl(res).project_cost_exchange_rate,TO_NUMBER(null)))
12553: INTO projfunc_exchange_rate,
12554: project_exchange_rate
12555: FROM dual;
12556: l_global_tmp_rec.projfunc_exchange_rate := projfunc_exchange_rate;
12557: l_global_tmp_rec.project_exchange_rate := project_exchange_rate;
12558: FOR prd in l_periods_tbl.first-1..l_periods_tbl.last+1 LOOP
12559: IF prd <> l_periods_tbl.first-1 and prd <> l_periods_tbl.last+1 THEN