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_FP_WEBADI_UPLOAD_INF

Line 43: (c_run_id pa_fp_webadi_upload_inf.run_id%TYPE,

39: made changes in change_reason derivation. This is done as part of merging the MRUP3 changes
40: done in 11i into R12.
41: */
42: CURSOR inf_tbl_data_csr
43: (c_run_id pa_fp_webadi_upload_inf.run_id%TYPE,
44: c_allow_qty_flag VARCHAR2,
45: c_allow_raw_cost_flag VARCHAR2,
46: c_allow_burd_cost_flag VARCHAR2,
47: c_allow_revenue_flag VARCHAR2,

Line 194: FROM pa_fp_webadi_upload_inf inf

190: DECODE (inf.prd50, g_hidden_col_num, NULL, DECODE(inf.prd50, NULL, l_fnd_miss_num, inf.prd50)) prd50,
191: DECODE (inf.prd51, g_hidden_col_num, NULL, DECODE(inf.prd51, NULL, l_fnd_miss_num, inf.prd51)) prd51,
192: DECODE (inf.prd52, g_hidden_col_num, NULL, DECODE(inf.prd52, NULL, l_fnd_miss_num, inf.prd52)) prd52,
193: DECODE (inf.sd_prd, g_hidden_col_num, NULL, DECODE(inf.sd_prd, NULL, l_fnd_miss_num, inf.sd_prd)) sd_prd
194: FROM pa_fp_webadi_upload_inf inf
195: WHERE inf.run_id=c_run_id
196: AND Nvl(inf.val_error_flag, 'N') <> 'Y'
197: AND inf.val_error_code IS NULL
198: AND (inf.amount_type_name IS NULL OR

Line 309: ( p_run_id IN pa_fp_webadi_upload_inf.run_id%TYPE

305: END log1;
306: */
307:
308: PROCEDURE delete_xface
309: ( p_run_id IN pa_fp_webadi_upload_inf.run_id%TYPE
310: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
311: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
312: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
313: ,p_calling_module IN VARCHAR2 DEFAULT NULL

Line 364: FROM pa_fp_webadi_upload_inf inf,

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
367: AND inf.budget_version_id = bv.budget_version_id
368: AND Nvl(inf.request_id, -99) = Nvl(bv.request_id, -99)

Line 389: DELETE FROM PA_FP_WEBADI_UPLOAD_INF

385: END;
386: END IF;
387:
388: IF l_preserve_rows_flag <> 'Y' THEN
389: DELETE FROM PA_FP_WEBADI_UPLOAD_INF
390: WHERE run_id = p_run_id;
391:
392: IF l_debug_mode = 'Y' THEN
393: l_del_record_count := SQL%ROWCOUNT;

Line 394: pa_debug.g_err_stage := ':Deleted '||l_del_record_count||' records from PA_FP_WEBADI_UPLOAD_INF';

390: WHERE run_id = p_run_id;
391:
392: IF l_debug_mode = 'Y' THEN
393: l_del_record_count := SQL%ROWCOUNT;
394: pa_debug.g_err_stage := ':Deleted '||l_del_record_count||' records from PA_FP_WEBADI_UPLOAD_INF';
395: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
396: pa_debug.reset_curr_function;
397: END IF;
398: END IF;

Line 443: p_run_id IN pa_fp_webadi_upload_inf.run_id%TYPE,

439: -- Bug 3986129: FP.M Web ADI Dev changes. Added the followings:
440:
441: PROCEDURE validate_header_info
442: ( p_calling_mode IN VARCHAR2,
443: p_run_id IN pa_fp_webadi_upload_inf.run_id%TYPE,
444: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
445: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
446: p_pm_rec_version_number IN pa_period_masks_b.record_version_number%TYPE,
447: p_submit_flag IN VARCHAR2,

Line 590: FROM pa_fp_webadi_upload_inf

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
593: AND Nvl(p_request_id, -99) = Nvl(request_id, -99));
594: EXCEPTION

Line 806: UPDATE pa_fp_webadi_upload_inf

802: pa_debug.g_err_stage := 'Updating tmp table with error code: PA_FP_WEBADI_VER_MODIFIED';
803: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
804: END IF;
805:
806: UPDATE pa_fp_webadi_upload_inf
807: SET val_error_flag = 'Y',
808: val_error_code = 'PA_FP_WEBADI_VER_MODIFIED',
809: err_task_name = nvl(task_name,'-98'),
810: err_task_number = nvl(task_number,'-98'),

Line 828: UPDATE pa_fp_webadi_upload_inf

824: pa_debug.g_err_stage := 'Updating tmp table with error code: PA_FP_WEBADI_TP_MODIFIED';
825: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
826: END IF;
827:
828: UPDATE pa_fp_webadi_upload_inf
829: SET val_error_flag = 'Y',
830: val_error_code = 'PA_FP_WEBADI_TP_MODIFIED',
831: err_task_name = nvl(task_name,'-98'),
832: err_task_number = nvl(task_number,'-98'),

Line 850: UPDATE pa_fp_webadi_upload_inf

846: pa_debug.g_err_stage := 'Updating tmp table with error code: PA_FP_WEBADI_NO_BV_MAINT_PVLG';
847: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
848: END IF;
849:
850: UPDATE pa_fp_webadi_upload_inf
851: SET val_error_flag = 'Y',
852: val_error_code = 'PA_FP_WEBADI_NO_BV_MAINT_PVLG',
853: err_task_name = nvl(task_name,'-98'),
854: err_task_number = nvl(task_number,'-98'),

Line 872: UPDATE pa_fp_webadi_upload_inf

868: pa_debug.g_err_stage := 'Updating tmp table with error code: ' || l_val_err_code;
869: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
870: END IF;
871:
872: UPDATE pa_fp_webadi_upload_inf
873: SET val_error_flag = 'Y',
874: val_error_code = l_val_err_code,
875: err_task_name = nvl(task_name,'-98'),
876: err_task_number = nvl(task_number,'-98'),

Line 894: UPDATE pa_fp_webadi_upload_inf

890: pa_debug.g_err_stage := 'Updating tmp table with error code: FP_WEBADI_CI_VER_NON_EDITABLE';
891: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
892: END IF;
893:
894: UPDATE pa_fp_webadi_upload_inf
895: SET val_error_flag = 'Y',
896: val_error_code = 'PA_FP_WA_CI_VER_NON_EDITABLE',
897: err_task_name = nvl(task_name,'-98'),
898: err_task_number = nvl(task_number,'-98'),

Line 916: UPDATE pa_fp_webadi_upload_inf

912: pa_debug.g_err_stage := 'Updating tmp table with error code: FP_WEBADI_BV_NOT_CURR_WORKING';
913: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
914: END IF;
915:
916: UPDATE pa_fp_webadi_upload_inf
917: SET val_error_flag = 'Y',
918: val_error_code = 'PA_FP_WA_BV_NOT_CURR_WORKING',
919: err_task_name = nvl(task_name,'-98'),
920: err_task_number = nvl(task_number,'-98'),

Line 938: UPDATE pa_fp_webadi_upload_inf

934: pa_debug.g_err_stage := 'Updating tmp table with error code: FP_WEBADI_CI_VER_SUBMIT_FLAG';
935: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
936: END IF;
937:
938: UPDATE pa_fp_webadi_upload_inf
939: SET val_error_flag = 'Y',
940: val_error_code = 'PA_FP_WA_CI_VER_SUBMIT_FLAG',
941: err_task_name = nvl(task_name,'-98'),
942: err_task_number = nvl(task_number,'-98'),

Line 1010: ( p_run_id IN pa_fp_webadi_upload_inf.run_id%TYPE,

1006: -- other DML performed in the course of validation processing till the point
1007: -- a validation failure occurs.
1008:
1009: PROCEDURE process_errors
1010: ( p_run_id IN pa_fp_webadi_upload_inf.run_id%TYPE,
1011: p_context IN VARCHAR2,
1012: p_periodic_flag IN VARCHAR2,
1013: p_error_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
1014: p_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,

Line 1082: FROM pa_fp_webadi_upload_inf

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
1085: AND Nvl(p_request_id, -99) = Nvl(request_id, -99));
1086:

Line 1100: UPDATE pa_fp_webadi_upload_inf

1096:
1097:
1098: IF p_context IS NOT NULL THEN
1099: IF p_context = 'INV_TASK' THEN
1100: UPDATE pa_fp_webadi_upload_inf
1101: SET val_error_flag = 'Y',
1102: val_error_code = 'INVALID_TASK_INFO',
1103: err_task_name = nvl(task_name,'-98'),
1104: err_task_number = nvl(task_number,'-98'),

Line 1112: UPDATE pa_fp_webadi_upload_inf

1108: AND task_id IS NULL
1109: AND val_error_flag IS NULL
1110: AND Nvl(p_request_id, -99) = Nvl(request_id, -99);
1111: ELSIF p_context = 'INV_RESOURCE' THEN
1112: UPDATE pa_fp_webadi_upload_inf
1113: SET val_error_flag = 'Y',
1114: val_error_code = 'INVALID_RESOURCE_INFO',
1115: err_task_name = nvl(task_name,'-98'),
1116: err_task_number = nvl(task_number,'-98'),

Line 1141: UPDATE pa_fp_webadi_upload_inf

1137: p_error_code_tbl.COUNT = p_rlm_id_tbl.COUNT AND
1138: p_error_code_tbl.COUNT = p_amount_type_tbl.COUNT AND
1139: p_error_code_tbl.COUNT = p_txn_curr_tbl.COUNT THEN
1140: FORALL i IN p_task_id_tbl.FIRST .. p_task_id_tbl.LAST
1141: UPDATE pa_fp_webadi_upload_inf
1142: SET val_error_flag = 'Y',
1143: val_error_code = p_error_code_tbl(i),
1144: err_task_name = nvl(task_name,'-98'),
1145: err_task_number = nvl(task_number,'-98'),

Line 1170: UPDATE pa_fp_webadi_upload_inf inf

1166: IF p_error_code_tbl.COUNT = p_task_id_tbl.COUNT AND
1167: p_error_code_tbl.COUNT = p_rlm_id_tbl.COUNT AND
1168: p_error_code_tbl.COUNT = p_txn_curr_tbl.COUNT THEN
1169: FORALL i IN p_task_id_tbl.FIRST .. p_task_id_tbl.LAST
1170: UPDATE pa_fp_webadi_upload_inf inf
1171: SET inf.val_error_flag = 'Y',
1172: inf.val_error_code = p_error_code_tbl(i),
1173: inf.err_task_name = nvl(inf.task_name,'-98'),
1174: inf.err_task_number = nvl(inf.task_number,'-98'),

Line 1268: ( p_run_id IN pa_fp_webadi_upload_inf.run_id%TYPE,

1264: * rec type returned from calculate api and then to call process_errors api
1265: * to report the errors in interface table.
1266: */
1267: PROCEDURE read_global_var_to_report_err
1268: ( p_run_id IN pa_fp_webadi_upload_inf.run_id%TYPE,
1269: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1270: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
1271: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1272: )

Line 1539: (p_run_id IN pa_fp_webadi_upload_inf.run_id%TYPE)

1535: -- these attribute can be defaulted to null values or version
1536: -- level attributes accordingly.
1537:
1538: FUNCTION conv_attributes_displayed
1539: (p_run_id IN pa_fp_webadi_upload_inf.run_id%TYPE)
1540: RETURN VARCHAR2
1541: IS
1542:
1543: l_debug_mode VARCHAR2(1);

Line 1550: l_projfunc_rate_type pa_fp_webadi_upload_inf.projfunc_rate_type%TYPE;

1546: l_debug_level5 CONSTANT NUMBER := PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5;
1547:
1548: conv_attrb_displayed VARCHAR2(1);
1549:
1550: l_projfunc_rate_type pa_fp_webadi_upload_inf.projfunc_rate_type%TYPE;
1551: l_projfunc_rate_date_type pa_fp_webadi_upload_inf.projfunc_rate_date_type%TYPE;
1552: l_projfunc_rate_date pa_fp_webadi_upload_inf.projfunc_rate_date%TYPE;
1553: l_project_rate_type pa_fp_webadi_upload_inf.project_rate_type%TYPE;
1554: l_project_rate_date_type pa_fp_webadi_upload_inf.project_rate_date_type%TYPE;

Line 1551: l_projfunc_rate_date_type pa_fp_webadi_upload_inf.projfunc_rate_date_type%TYPE;

1547:
1548: conv_attrb_displayed VARCHAR2(1);
1549:
1550: l_projfunc_rate_type pa_fp_webadi_upload_inf.projfunc_rate_type%TYPE;
1551: l_projfunc_rate_date_type pa_fp_webadi_upload_inf.projfunc_rate_date_type%TYPE;
1552: l_projfunc_rate_date pa_fp_webadi_upload_inf.projfunc_rate_date%TYPE;
1553: l_project_rate_type pa_fp_webadi_upload_inf.project_rate_type%TYPE;
1554: l_project_rate_date_type pa_fp_webadi_upload_inf.project_rate_date_type%TYPE;
1555: l_project_rate_date pa_fp_webadi_upload_inf.project_rate_date%TYPE;

Line 1552: l_projfunc_rate_date pa_fp_webadi_upload_inf.projfunc_rate_date%TYPE;

1548: conv_attrb_displayed VARCHAR2(1);
1549:
1550: l_projfunc_rate_type pa_fp_webadi_upload_inf.projfunc_rate_type%TYPE;
1551: l_projfunc_rate_date_type pa_fp_webadi_upload_inf.projfunc_rate_date_type%TYPE;
1552: l_projfunc_rate_date pa_fp_webadi_upload_inf.projfunc_rate_date%TYPE;
1553: l_project_rate_type pa_fp_webadi_upload_inf.project_rate_type%TYPE;
1554: l_project_rate_date_type pa_fp_webadi_upload_inf.project_rate_date_type%TYPE;
1555: l_project_rate_date pa_fp_webadi_upload_inf.project_rate_date%TYPE;
1556:

Line 1553: l_project_rate_type pa_fp_webadi_upload_inf.project_rate_type%TYPE;

1549:
1550: l_projfunc_rate_type pa_fp_webadi_upload_inf.projfunc_rate_type%TYPE;
1551: l_projfunc_rate_date_type pa_fp_webadi_upload_inf.projfunc_rate_date_type%TYPE;
1552: l_projfunc_rate_date pa_fp_webadi_upload_inf.projfunc_rate_date%TYPE;
1553: l_project_rate_type pa_fp_webadi_upload_inf.project_rate_type%TYPE;
1554: l_project_rate_date_type pa_fp_webadi_upload_inf.project_rate_date_type%TYPE;
1555: l_project_rate_date pa_fp_webadi_upload_inf.project_rate_date%TYPE;
1556:
1557:

Line 1554: l_project_rate_date_type pa_fp_webadi_upload_inf.project_rate_date_type%TYPE;

1550: l_projfunc_rate_type pa_fp_webadi_upload_inf.projfunc_rate_type%TYPE;
1551: l_projfunc_rate_date_type pa_fp_webadi_upload_inf.projfunc_rate_date_type%TYPE;
1552: l_projfunc_rate_date pa_fp_webadi_upload_inf.projfunc_rate_date%TYPE;
1553: l_project_rate_type pa_fp_webadi_upload_inf.project_rate_type%TYPE;
1554: l_project_rate_date_type pa_fp_webadi_upload_inf.project_rate_date_type%TYPE;
1555: l_project_rate_date pa_fp_webadi_upload_inf.project_rate_date%TYPE;
1556:
1557:
1558: BEGIN

Line 1555: l_project_rate_date pa_fp_webadi_upload_inf.project_rate_date%TYPE;

1551: l_projfunc_rate_date_type pa_fp_webadi_upload_inf.projfunc_rate_date_type%TYPE;
1552: l_projfunc_rate_date pa_fp_webadi_upload_inf.projfunc_rate_date%TYPE;
1553: l_project_rate_type pa_fp_webadi_upload_inf.project_rate_type%TYPE;
1554: l_project_rate_date_type pa_fp_webadi_upload_inf.project_rate_date_type%TYPE;
1555: l_project_rate_date pa_fp_webadi_upload_inf.project_rate_date%TYPE;
1556:
1557:
1558: BEGIN
1559: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

Line 1598: FROM pa_fp_webadi_upload_inf

1594: l_projfunc_rate_date,
1595: l_project_rate_type,
1596: l_project_rate_date_type,
1597: l_project_rate_date
1598: FROM pa_fp_webadi_upload_inf
1599: WHERE run_id = p_run_id
1600: AND ROWNUM = 1;
1601:
1602: IF l_projfunc_rate_type <> g_hidden_col_char OR

Line 1663: ( p_run_id IN pa_fp_webadi_upload_inf.run_id%TYPE,

1659: RAISE;
1660: END conv_attributes_displayed;
1661:
1662: PROCEDURE prepare_val_input
1663: ( p_run_id IN pa_fp_webadi_upload_inf.run_id%TYPE,
1664: p_request_id IN pa_budget_versions.request_id%TYPE DEFAULT NULL,
1665: p_version_info_rec IN pa_fp_gen_amount_utils.fp_cols,
1666: p_prd_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE,
1667: p_prd_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE,

Line 2088: UPDATE pa_fp_webadi_upload_inf inf

2084:
2085: IF l_uncategorized_flag = 'N' THEN
2086: IF l_rl_control_flag = 'N' THEN
2087: -- updating the rlm ids for categorized resource lists with control_fl as N
2088: UPDATE pa_fp_webadi_upload_inf inf
2089: SET inf.task_id = (SELECT pt.task_id
2090: FROM (SELECT pt.name task_name, /* Bug 4929163. Modified the select statement to refer to pa_proj_elements instead of pa_tasks*/
2091: pt.element_number task_number,
2092: pt.proj_element_id task_id

Line 2214: --DEBUG_NS('updated pa_fp_webadi_upload_inf :: ');

2210:
2211: WHERE inf.run_id= p_run_id
2212: AND Nvl(p_request_id, -99) = Nvl(inf.request_id, -99);
2213:
2214: --DEBUG_NS('updated pa_fp_webadi_upload_inf :: ');
2215:
2216: ELSE -- control_flag = Y
2217: -- updating the rlm ids for categorized resource lists with control_fl as Y
2218: UPDATE pa_fp_webadi_upload_inf inf

Line 2218: UPDATE pa_fp_webadi_upload_inf inf

2214: --DEBUG_NS('updated pa_fp_webadi_upload_inf :: ');
2215:
2216: ELSE -- control_flag = Y
2217: -- updating the rlm ids for categorized resource lists with control_fl as Y
2218: UPDATE pa_fp_webadi_upload_inf inf
2219: SET inf.task_id = (SELECT pt.task_id
2220: FROM (SELECT pt.name task_name, /* Bug 4929163. Modified the select statement to refer to pa_proj_elements instead of pa_tasks*/
2221: pt.element_number task_number,
2222: pt.proj_element_id task_id

Line 2362: UPDATE pa_fp_webadi_upload_inf inf

2358:
2359: --log1('----- STAGE 3.4------- '||l_unct_rlm_id);
2360: --DEBUG_NS('l_unct_rlm_id :: ' ||l_unct_rlm_id);
2361:
2362: UPDATE pa_fp_webadi_upload_inf inf
2363: SET inf.task_id = (SELECT pt.task_id
2364: FROM (SELECT pt.name task_name, /* Bug 4929163. Modidfied the select statement to refer to pa_proj_elements instead of pa_tasks*/
2365: pt.element_number task_number,
2366: pt.proj_element_id task_id

Line 2509: FROM pa_fp_webadi_upload_inf

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
2512: AND Nvl(p_request_id, -99) = Nvl(request_id, -99));
2513: EXCEPTION

Line 2543: UPDATE pa_fp_webadi_upload_inf inf

2539:
2540: END IF;
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

Line 2577: UPDATE pa_fp_webadi_upload_inf inf

2573: AND Nvl(p_request_id, -99) = Nvl(request_id, -99);
2574:
2575: ELSE --Non Periodic layout
2576:
2577: UPDATE pa_fp_webadi_upload_inf inf
2578: SET val_error_flag = NVL(val_error_flag,
2579: DECODE(task_id,
2580: NULL,'Y',
2581: DECODE(resource_list_member_id,

Line 5976: --This is a private function used by prepare_pbl_input. This function expects p_rec, record in pa_fp_webadi_upload_inf

5972: RAISE;
5973:
5974: END prepare_val_input;
5975:
5976: --This is a private function used by prepare_pbl_input. This function expects p_rec, record in pa_fp_webadi_upload_inf
5977: --and p_prd that indicates the period in p_rec from which the amount should be returned.
5978: --valid values for prd are ('SD,'PD', '1'..'52')
5979:
5980: FUNCTION get_amount_in_prd_x

Line 6763: --in pa_fp_webadi_upload_inf table and this data has been already validated.

6759:
6760: END get_total_fcst_amounts;
6761:
6762: --This is a private API called from Switcher API. This API assumes that the data exists
6763: --in pa_fp_webadi_upload_inf table and this data has been already validated.
6764:
6765: --Note: p_budget_lines_tbl contains records ordered by task id, resource alias and curr. This
6766: --API assumes that there exists only one record for an RA/TXN Currency Code in p_budget_lines_tbl
6767:

Line 6777: p_run_id IN pa_fp_webadi_upload_inf.run_id%TYPE,

6773: --and it will be used as the start date if the amounts are entered in preceeding bucket
6774:
6775: PROCEDURE prepare_pbl_input
6776: (p_context IN VARCHAR2,
6777: p_run_id IN pa_fp_webadi_upload_inf.run_id%TYPE,
6778: p_request_id IN pa_budget_versions.request_id%TYPE DEFAULT NULL,
6779: p_inf_tbl_rec_tbl IN inf_cur_tbl_typ,
6780: p_version_info_rec IN pa_fp_gen_amount_utils.fp_cols,
6781: p_project_id IN pa_projects_all.project_id%TYPE,

Line 10253: p_run_id IN pa_fp_webadi_upload_inf.run_id%TYPE,

10249: --This procedure will update the budget version and its corresponding data in the interface table with
10250: --the latest request id and plan processing code(XLUP/XLUE).
10251: PROCEDURE update_xl_data_for_new_req
10252: (p_request_id IN pa_budget_versions.request_id%TYPE,
10253: p_run_id IN pa_fp_webadi_upload_inf.run_id%TYPE,
10254: p_plan_processing_code IN pa_budget_versions.plan_processing_code%TYPE,
10255: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
10256: p_null_out_cols IN VARCHAR2)
10257: IS

Line 10269: UPDATE pa_fp_webadi_upload_inf

10265: WHERE budget_version_id = p_budget_version_id;
10266:
10267: --NULL out the IDS and values derived in the previous call to Switcher API do that all the validations
10268: --are done again
10269: UPDATE pa_fp_webadi_upload_inf
10270: SET task_id =DECODE(p_null_out_cols,'Y',NULL,task_id),
10271: resource_list_member_id=DECODE(p_null_out_cols,'Y',NULL,resource_list_member_id),
10272: val_error_flag =DECODE(p_null_out_cols,'Y',NULL,val_error_flag),
10273: val_error_code =DECODE(p_null_out_cols,'Y',NULL,val_error_code),

Line 10289: p_run_id IN pa_fp_webadi_upload_inf.run_id%TYPE,

10285: (x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
10286: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
10287: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
10288: p_submit_budget_flag IN VARCHAR2,
10289: p_run_id IN pa_fp_webadi_upload_inf.run_id%TYPE,
10290: x_success_msg OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
10291: p_submit_forecast_flag IN VARCHAR2,
10292: p_request_id IN pa_budget_versions.request_id%TYPE,
10293: p_calling_mode IN VARCHAR2)

Line 10483: we need to stamp the val_error_code and val_error_flag of PA_FP_WEBADI_UPLOAD_INF table

10479: l_rollback_flag := 'N';
10480: COMMIT; /* Added this for bug 3736220
10481:
10482: Reason: To display budget client extension error messages customized by the Customers
10483: we need to stamp the val_error_code and val_error_flag of PA_FP_WEBADI_UPLOAD_INF table
10484: Only then these error messages will appear in Excel Sheet itself when any failure happens
10485: during upload.
10486:
10487: Code flow is designed as follows:

Line 10489: the WEB ADI related procedures will populate PA_FP_WEBADI_UPLOAD_INF table and does not commit

10485: during upload.
10486:
10487: Code flow is designed as follows:
10488: 1. When user clicks on Oracle Upload Toolbar Menu item in Excel
10489: the WEB ADI related procedures will populate PA_FP_WEBADI_UPLOAD_INF table and does not commit
10490:
10491: 2. Switcher API will be invoked after WEB ADI related code flow is completed.
10492:
10493: 3. Swicher API internally invokes PA_FP_CALC_PLAN_PKG.CALCULATE which inturn

Line 10498: PA_FP_WEBADI_UPLOAD_INF table)

10494: invokes the actual budget client extension
10495:
10496: 4. In client extension, as part of bug fix 3736220 added code to Stamp client extension errors
10497: in xface table (we stamp the val_error_code and val_error_flag of
10498: PA_FP_WEBADI_UPLOAD_INF table)
10499:
10500: 5. But the client extension is designed in such a way that when any error occurs in
10501: client extension we roll back to the calling API PA_FP_CALC_PLAN_PKG. So the stamped data
10502: gets rolled back. Ulimately the customers customized errors cannot be displayed in excel

Line 10506: of PA_FP_WEBADI_UPLOAD_INF table,introduced an autonomous procedure Stamp_Client_Extn_Errors

10502: gets rolled back. Ulimately the customers customized errors cannot be displayed in excel
10503: due to this rollback.
10504:
10505: 6. Hence in order to preserve the stamped val_error_code and val_error_flag
10506: of PA_FP_WEBADI_UPLOAD_INF table,introduced an autonomous procedure Stamp_Client_Extn_Errors
10507:
10508: 7. As a result if we dont commit in the beginning when SWITCHER API is called, then when
10509: Stamp_Client_Extn_Errors APi is invoked there will be no records in PA_FP_WEBADI_UPLOAD_INF.
10510: */

Line 10509: Stamp_Client_Extn_Errors APi is invoked there will be no records in PA_FP_WEBADI_UPLOAD_INF.

10505: 6. Hence in order to preserve the stamped val_error_code and val_error_flag
10506: of PA_FP_WEBADI_UPLOAD_INF table,introduced an autonomous procedure Stamp_Client_Extn_Errors
10507:
10508: 7. As a result if we dont commit in the beginning when SWITCHER API is called, then when
10509: Stamp_Client_Extn_Errors APi is invoked there will be no records in PA_FP_WEBADI_UPLOAD_INF.
10510: */
10511:
10512: fnd_profile.get('PA_DEBUG_MODE', l_debug_mode);
10513:

Line 10568: FROM pa_fp_webadi_upload_inf

10564: prd_mask_rec_ver_number
10565: INTO l_budget_version_id,
10566: l_rec_version_number,
10567: l_pm_rec_version_number
10568: FROM pa_fp_webadi_upload_inf
10569: WHERE run_id = p_run_id
10570: AND Nvl(p_request_id, -99) = Nvl(request_id, -99)
10571: AND rownum = 1;
10572: EXCEPTION

Line 10589: FROM pa_fp_webadi_upload_inf

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
10592: AND Nvl(p_request_id, -99) = Nvl(request_id, -99));
10593: EXCEPTION

Line 10643: UPDATE pa_fp_webadi_upload_inf

10639: IF l_debug_mode = 'Y' THEN
10640: pa_debug.g_err_stage := 'No data found while reading project id ..';
10641: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
10642: END IF;
10643: UPDATE pa_fp_webadi_upload_inf
10644: SET val_error_flag = 'Y',
10645: val_error_code = 'PA_FP_WEBADI_VER_MODIFIED',
10646: err_task_name = nvl(task_name,'-98'),
10647: err_task_number = nvl(task_number,'-98'),

Line 10982: FROM pa_fp_webadi_upload_inf inf--pa_fp_webadi_upload_inf inf

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)
10985: AND (inf.val_error_flag = 'Y'
10986: OR inf.val_error_code IS NOT NULL));

Line 11112: UPDATE pa_fp_webadi_upload_inf

11108: SET plan_processing_code = 'XLUP',
11109: request_id = l_request_id
11110: WHERE budget_version_id = l_budget_version_id;
11111:
11112: UPDATE pa_fp_webadi_upload_inf
11113: SET request_id = l_request_id
11114: WHERE run_id = p_run_id
11115: AND request_id IS NULL;
11116:

Line 11272: --Till this point all the DMLs would have been executed on PA_FP_WEBADI_UPLOAD_INF. In case of any error

11268: pa_debug.g_err_stage := 'Calling process_budget_lines';
11269: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
11270: END IF;
11271:
11272: --Till this point all the DMLs would have been executed on PA_FP_WEBADI_UPLOAD_INF. In case of any error
11273: --those changes need not be rolled back. process_budget_lines API will update the core B/F tables and hence
11274: --those updates should be reverted in case of any error. Hence establishing a savepoint now.
11275: SAVEPOINT SWITCHER;
11276: l_rollback_flag := 'Y';

Line 11530: p_run_id IN pa_fp_webadi_upload_inf.run_id%TYPE)

11526: PROCEDURE process_MSExcel_data
11527: (errbuf OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
11528: retcode OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
11529: p_submit_ver_flag IN VARCHAR2,
11530: p_run_id IN pa_fp_webadi_upload_inf.run_id%TYPE)
11531: IS
11532: --Start of variables used for debugging
11533: l_return_status VARCHAR2(1);
11534: l_msg_count NUMBER := 0;

Line 11554: CURSOR l_get_error_msg_to_report_csr (c_run_id pa_fp_webadi_upload_inf.run_id%TYPE,

11550: -- the following cursor would query the interface table for any validation failure
11551: -- error messages present in the interface table corresponding to a set of run_id
11552: -- for the upload session.
11553:
11554: CURSOR l_get_error_msg_to_report_csr (c_run_id pa_fp_webadi_upload_inf.run_id%TYPE,
11555: c_plan_class pa_fin_plan_types_b.plan_class_code%TYPE,
11556: c_version_type pa_budget_versions.version_type%TYPE,
11557: c_request_id pa_budget_versions.request_id%TYPE)
11558: IS

Line 11565: FROM pa_fp_webadi_upload_inf inf,

11561: inf.resource_alias resource_info,
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'

Line 11610: FROM pa_fp_webadi_upload_inf inf

11606:
11607: -- 4497323.Perf Fix:The SELECT query is splitted into two queries in order to improve performance.
11608: SELECT budget_version_id
11609: INTO l_budget_version_id
11610: FROM pa_fp_webadi_upload_inf inf
11611: WHERE inf.run_id = p_run_id
11612: AND Nvl(l_request_id,-99) = Nvl(request_id,-99)
11613: AND rownum=1;
11614: