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_PLANNING_TRANSACTION_PUB dependencies on PA_RESOURCE_LISTS_ALL_BG

Line 1584: l_res_class_flag pa_resource_lists_all_bg.resource_class_flag%TYPE := 'Y';

1580: l_curr_code_rollup_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
1581: l_rollup_index NUMBER;
1582: l_add_flag BOOLEAN;
1583: --CBS related Chnages
1584: l_res_class_flag pa_resource_lists_all_bg.resource_class_flag%TYPE := 'Y';
1585:
1586: CURSOR get_pc_code IS
1587: SELECT project_currency_code, projfunc_currency_code
1588: FROM pa_projects_all

Line 6262: l_res_class_flag pa_resource_lists_all_bg.resource_class_flag%TYPE := 'Y';

6258: l_txn_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6259: l_txn_burdened_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6260: l_cal_api_called_flg VARCHAR2(1) := 'N';
6261: --CBS related Chnages
6262: l_res_class_flag pa_resource_lists_all_bg.resource_class_flag%TYPE := 'Y';
6263: BEGIN
6264:
6265: l_trace_stage := 10;
6266: --hr_utility.trace('PA_FP_PLAN_TXN_PUB.update_planning_transactions: '||to_char(l_trace_stage));

Line 11629: l_res_list_uncategorized_flag pa_resource_lists_all_bg.uncategorized_flag%TYPE;

11625:
11626: budget_version_info_rec budget_version_info_cur%ROWTYPE;
11627:
11628: -- added for bug 4724017:
11629: l_res_list_uncategorized_flag pa_resource_lists_all_bg.uncategorized_flag%TYPE;
11630: --Bug 13701718 CBS related Chnages
11631: l_res_class_flag pa_resource_lists_all_bg.resource_class_flag%TYPE := 'Y';
11632: BEGIN
11633:

Line 11631: l_res_class_flag pa_resource_lists_all_bg.resource_class_flag%TYPE := 'Y';

11627:
11628: -- added for bug 4724017:
11629: l_res_list_uncategorized_flag pa_resource_lists_all_bg.uncategorized_flag%TYPE;
11630: --Bug 13701718 CBS related Chnages
11631: l_res_class_flag pa_resource_lists_all_bg.resource_class_flag%TYPE := 'Y';
11632: BEGIN
11633:
11634: x_msg_count := 0;
11635: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 11851: FROM pa_resource_lists_all_bg

11847: END IF;
11848: BEGIN
11849: SELECT nvl(uncategorized_flag,'N')
11850: INTO l_res_list_uncategorized_flag
11851: FROM pa_resource_lists_all_bg
11852: WHERE resource_list_id = budget_version_info_rec.resource_list_id;
11853:
11854: IF l_debug_mode = 'Y' THEN
11855: pa_debug.g_err_stage:='l_res_list_uncategorized_flag: ' || l_res_list_uncategorized_flag;

Line 12389: FROM pa_resource_lists_all_bg

12385: INTO l_resource_list_member_id_tbl
12386: FROM pa_resource_list_members prl,
12387: PA_PLAN_RES_DEFAULTS pr, /*7291493*/
12388: (SELECT control_flag
12389: FROM pa_resource_lists_all_bg
12390: WHERE resource_list_id = version_info_rec.resource_list_id) rl_control_flag
12391: WHERE resource_list_id = version_info_rec.resource_list_id
12392: AND ((rl_control_flag.control_flag = 'N' AND
12393: prl.object_type = 'PROJECT' AND