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_BUDGET_PUB dependencies on PA_TASKS

Line 2683: FROM pa_fp_txn_currencies cu, pa_tasks pa

2679: --commented the below query since no data populated in the table pa_fp_txn_currencies if multi currency not enabled
2680: /*
2681: SELECT DISTINCT Nvl(cu.TXN_CURRENCY_CODE,'USD')
2682: INTO l_txn_currency_code
2683: FROM pa_fp_txn_currencies cu, pa_tasks pa
2684: WHERE pa.task_id = p_pa_task_id
2685: AND cu.PROJECT_ID= pa.project_id
2686: AND cu.PROJFUNC_CURRENCY_FLAG = 'Y'; */
2687: --added the below query

Line 2690: FROM pa_projects_all p, pa_tasks pa

2686: AND cu.PROJFUNC_CURRENCY_FLAG = 'Y'; */
2687: --added the below query
2688: SELECT Nvl(p.PROJFUNC_CURRENCY_CODE,'USD')
2689: INTO l_txn_currency_code
2690: FROM pa_projects_all p, pa_tasks pa
2691: WHERE pa.task_id = p_pa_task_id
2692: AND p.project_id= pa.project_id;
2693: --bug fix 14114695 end
2694: END IF;

Line 9407: (p_pa_task_id pa_tasks.task_id%type)

9403: FROM pa_projects p
9404: WHERE p.project_id = p_pa_project_id;
9405:
9406: CURSOR l_amg_task_csr
9407: (p_pa_task_id pa_tasks.task_id%type)
9408: IS
9409: SELECT task_number
9410: FROM pa_tasks p
9411: WHERE p.task_id = p_pa_task_id;

Line 9410: FROM pa_tasks p

9406: CURSOR l_amg_task_csr
9407: (p_pa_task_id pa_tasks.task_id%type)
9408: IS
9409: SELECT task_number
9410: FROM pa_tasks p
9411: WHERE p.task_id = p_pa_task_id;
9412:
9413: p_multiple_task_msg VARCHAR2(1) := 'T';
9414:

Line 14343: FROM pa_tasks

14339:
14340: CURSOR l_task_csr (p_task_id IN NUMBER ) IS
14341: SELECT pm_task_reference,
14342: task_name -- Bug 2863564
14343: FROM pa_tasks
14344: WHERE task_id = p_task_id;
14345:
14346: -- Bug 2863564 new variables defined for Financial Planning chnages
14347:

Line 14348: l_task_name pa_tasks.task_name%TYPE;

14344: WHERE task_id = p_task_id;
14345:
14346: -- Bug 2863564 new variables defined for Financial Planning chnages
14347:
14348: l_task_name pa_tasks.task_name%TYPE;
14349: l_context VARCHAR2(30);
14350: l_context_finplan CONSTANT VARCHAR2(30) := PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_FIN_PLAN;
14351: l_context_budget CONSTANT VARCHAR2(30) := PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_BUDGET;
14352:

Line 15890: -- But records for tasks with task_id = 0 will not be present in pa_tasks table

15886: l_task_name := NULL;
15887: l_pm_task_reference := NULL;
15888: -- Get the pm_task_reference for the task_id
15889: -- Bug # 14794301 - added 'AND l_task_id_tbl(i) <> 0' .Task_id = 0 for a project level task.
15890: -- But records for tasks with task_id = 0 will not be present in pa_tasks table
15891: IF l_entry_level <> 'P' AND l_task_id_tbl(i) <> 0 THEN /* 2207733 do this check only if budget is not at project level other valid
15892: values are 'L', 'M', and 'P' */
15893: --OPEN l_task_csr (l_resource_assignment_rec.task_id);
15894: OPEN l_task_csr (l_task_id_tbl(i));

Line 17416: l_task_number pa_tasks.task_number%TYPE;

17412: IS
17413:
17414:
17415: /* SCALAR VARIABLES */
17416: l_task_number pa_tasks.task_number%TYPE;
17417: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
17418: l_baselined_version_id pa_budget_versions.budget_version_id%TYPE;
17419: l_curr_work_version_id pa_budget_versions.budget_version_id%TYPE;
17420: l_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;

Line 18389: FROM pa_tasks t

18385: ELSE
18386: BEGIN
18387: SELECT t.task_number
18388: INTO l_task_number
18389: FROM pa_tasks t
18390: WHERE t.task_id = P_finplan_trans_tab(i).task_id;
18391: l_task_number_tbl(i) := l_task_number;
18392:
18393: EXCEPTION

Line 18978: ,P_TASK_ID PA_TASKS.TASK_ID%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

18974: END CREATE_DRAFT_FINPLAN;
18975:
18976: PROCEDURE load_resource_info(
18977: P_PM_PRODUCT_CODE PA_BUDGET_VERSIONS.PM_PRODUCT_CODE%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18978: ,P_TASK_ID PA_TASKS.TASK_ID%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18979: ,P_PM_TASK_REFERENCE PA_TASKS.PM_TASK_REFERENCE%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18980: ,P_PM_RES_ASGMT_REFERENCE VARCHAR2 DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18981: ,P_RESOURCE_ALIAS VARCHAR2 DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18982: ,P_CURRENCY_CODE PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 18979: ,P_PM_TASK_REFERENCE PA_TASKS.PM_TASK_REFERENCE%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

18975:
18976: PROCEDURE load_resource_info(
18977: P_PM_PRODUCT_CODE PA_BUDGET_VERSIONS.PM_PRODUCT_CODE%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18978: ,P_TASK_ID PA_TASKS.TASK_ID%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18979: ,P_PM_TASK_REFERENCE PA_TASKS.PM_TASK_REFERENCE%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18980: ,P_PM_RES_ASGMT_REFERENCE VARCHAR2 DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18981: ,P_RESOURCE_ALIAS VARCHAR2 DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18982: ,P_CURRENCY_CODE PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18983: ,P_UNIT_OF_MEASURE_CODE PA_RESOURCE_ASSIGNMENTS.UNIT_OF_MEASURE%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR