[Home] [Help]
358: IF p_calling_module = 'XL_UPLOAD' THEN
359: BEGIN
360: SELECT 'Y'
361: INTO l_preserve_rows_flag
362: FROM DUAL
363: WHERE EXISTS (SELECT 'X'
364: FROM pa_fp_webadi_upload_inf inf,
365: pa_budget_versions bv
366: WHERE inf.run_id = p_run_id
584:
585: BEGIN
586: SELECT 'Y'
587: INTO is_periodic_layout
588: FROM DUAL
589: WHERE EXISTS(SELECT 'X'
590: FROM pa_fp_webadi_upload_inf
591: WHERE run_id = p_run_id
592: AND amount_type_name IS NOT NULL
1076:
1077: BEGIN
1078: SELECT 'Y'
1079: INTO l_periodic_flag
1080: FROM DUAL
1081: WHERE EXISTS (SELECT 1
1082: FROM pa_fp_webadi_upload_inf
1083: WHERE run_id=p_run_id
1084: AND amount_type_name IS NOT NULL
1708: l_debug_level5 CONSTANT NUMBER := PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5;
1709: l_msg_index_out NUMBER;
1710: l_data VARCHAR2(2000);
1711:
1712: -- variable to held the start_date and end_date of individual periods
1713: l_prd_start_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
1714: l_prd_end_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
1715:
1716: l_inf_tbl_data_prev_rec inf_tbl_data_csr%ROWTYPE;
2503:
2504: BEGIN
2505: SELECT 'Y'
2506: INTO is_periodic_setup
2507: FROM DUAL
2508: WHERE EXISTS(SELECT 'X'
2509: FROM pa_fp_webadi_upload_inf
2510: WHERE amount_type_name IS NOT NULL
2511: AND run_id = p_run_id
8907: BEGIN
8908: --log1('----- STAGE PBL15-------');
8909: SELECT pa_resource_assignments_s.nextval
8910: INTO l_curr_ra_id_seq
8911: FROM DUAL
8912: WHERE 1 = 1;
8913: --log1('----- STAGE PBL16-------');
8914: EXCEPTION
8915: WHEN OTHERS THEN
9272: --Bug 4424457. Find out if there are budget lines that are processed by calculate API
9273: BEGIN
9274: SELECT 'Y'
9275: INTO l_bls_proccessed_flag
9276: FROM DUAL
9277: WHERE EXISTS (SELECT 1
9278: FROM pa_fp_rollup_tmp);
9279: EXCEPTION
9280: WHEN NO_DATA_FOUND THEN
10310: l_project_id pa_projects_all.project_id%TYPE;
10311: l_org_id pa_projects_all.org_id%TYPE;
10312: l_version_info_rec pa_fp_gen_amount_utils.fp_cols;
10313:
10314: -- variable to held the start_date and end_date of individual periods
10315: l_prd_start_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
10316: l_prd_end_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
10317:
10318: l_budget_line_in_tbl PA_BUDGET_PUB.G_budget_lines_in_tbl%TYPE;
10583: --in the table since it will be populated only for periodic layouts.
10584: BEGIN
10585: SELECT 'Y'
10586: INTO is_periodic_setup
10587: FROM DUAL
10588: WHERE EXISTS(SELECT 'X'
10589: FROM pa_fp_webadi_upload_inf
10590: WHERE amount_type_name IS NOT NULL
10591: AND run_id = p_run_id
10976: BEGIN
10977:
10978: SELECT 'X'
10979: INTO l_error_indicator_flag
10980: FROM DUAL
10981: WHERE EXISTS (SELECT 'Y'
10982: FROM pa_fp_webadi_upload_inf inf--pa_fp_webadi_upload_inf inf
10983: WHERE run_id = p_run_id
10984: AND Nvl(p_request_id, -99) = Nvl(request_id, -99)
11072: BEGIN
11073:
11074: SELECT to_number(l_profile_thsld_val)
11075: INTO l_profile_thsld_num
11076: FROM dual;
11077: --log1('----- STAGE 10.9-------');
11078: EXCEPTION
11079: WHEN INVALID_NUMBER THEN
11080: --log1('----- STAGE 10.10-------');
12768: 'ALL', l_agr_curr_code,
12769: 'REVENUE', l_agr_curr_code,
12770: l_project_currency_code)))
12771: INTO l_txn_curr_tbl(1).txn_currency_code
12772: FROM dual;
12773: END IF;
12774: END;
12775: */ --Bug 5144013.
12776: /* End of code changes for bug 5330532 */
12796: 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)),
12797: decode(l_proj_fp_options_rec.project_cost_rate_type,'User',null,l_res_ass_tbl(res).project_cost_exchange_rate,TO_NUMBER(null)))
12798: INTO projfunc_exchange_rate,
12799: project_exchange_rate
12800: FROM dual;
12801: l_global_tmp_rec.projfunc_exchange_rate := projfunc_exchange_rate;
12802: l_global_tmp_rec.project_exchange_rate := project_exchange_rate;
12803: FOR prd in l_periods_tbl.first-1..l_periods_tbl.last+1 LOOP
12804: IF prd <> l_periods_tbl.first-1 and prd <> l_periods_tbl.last+1 THEN