DBA Data[Home] [Help]

APPS.PA_BUDGET_PUB dependencies on PA_TASKS

Line 9224: (p_pa_task_id pa_tasks.task_id%type)

9220: FROM pa_projects p
9221: WHERE p.project_id = p_pa_project_id;
9222:
9223: CURSOR l_amg_task_csr
9224: (p_pa_task_id pa_tasks.task_id%type)
9225: IS
9226: SELECT task_number
9227: FROM pa_tasks p
9228: WHERE p.task_id = p_pa_task_id;

Line 9227: FROM pa_tasks p

9223: CURSOR l_amg_task_csr
9224: (p_pa_task_id pa_tasks.task_id%type)
9225: IS
9226: SELECT task_number
9227: FROM pa_tasks p
9228: WHERE p.task_id = p_pa_task_id;
9229:
9230: p_multiple_task_msg VARCHAR2(1) := 'T';
9231:

Line 14097: FROM pa_tasks

14093:
14094: CURSOR l_task_csr (p_task_id IN NUMBER ) IS
14095: SELECT pm_task_reference,
14096: task_name -- Bug 2863564
14097: FROM pa_tasks
14098: WHERE task_id = p_task_id;
14099:
14100: -- Bug 2863564 new variables defined for Financial Planning chnages
14101:

Line 14102: l_task_name pa_tasks.task_name%TYPE;

14098: WHERE task_id = p_task_id;
14099:
14100: -- Bug 2863564 new variables defined for Financial Planning chnages
14101:
14102: l_task_name pa_tasks.task_name%TYPE;
14103: l_context VARCHAR2(30);
14104: l_context_finplan CONSTANT VARCHAR2(30) := PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_FIN_PLAN;
14105: l_context_budget CONSTANT VARCHAR2(30) := PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_BUDGET;
14106:

Line 17157: l_task_number pa_tasks.task_number%TYPE;

17153: IS
17154:
17155:
17156: /* SCALAR VARIABLES */
17157: l_task_number pa_tasks.task_number%TYPE;
17158: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
17159: l_baselined_version_id pa_budget_versions.budget_version_id%TYPE;
17160: l_curr_work_version_id pa_budget_versions.budget_version_id%TYPE;
17161: l_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;

Line 18121: FROM pa_tasks t

18117: ELSE
18118: BEGIN
18119: SELECT t.task_number
18120: INTO l_task_number
18121: FROM pa_tasks t
18122: WHERE t.task_id = P_finplan_trans_tab(i).task_id;
18123: l_task_number_tbl(i) := l_task_number;
18124:
18125: EXCEPTION

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

18702: END CREATE_DRAFT_FINPLAN;
18703:
18704: PROCEDURE load_resource_info(
18705: P_PM_PRODUCT_CODE PA_BUDGET_VERSIONS.PM_PRODUCT_CODE%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18706: ,P_TASK_ID PA_TASKS.TASK_ID%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18707: ,P_PM_TASK_REFERENCE PA_TASKS.PM_TASK_REFERENCE%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18708: ,P_PM_RES_ASGMT_REFERENCE VARCHAR2 DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18709: ,P_RESOURCE_ALIAS VARCHAR2 DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18710: ,P_CURRENCY_CODE PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

18703:
18704: PROCEDURE load_resource_info(
18705: P_PM_PRODUCT_CODE PA_BUDGET_VERSIONS.PM_PRODUCT_CODE%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18706: ,P_TASK_ID PA_TASKS.TASK_ID%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18707: ,P_PM_TASK_REFERENCE PA_TASKS.PM_TASK_REFERENCE%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18708: ,P_PM_RES_ASGMT_REFERENCE VARCHAR2 DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18709: ,P_RESOURCE_ALIAS VARCHAR2 DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18710: ,P_CURRENCY_CODE PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18711: ,P_UNIT_OF_MEASURE_CODE PA_RESOURCE_ASSIGNMENTS.UNIT_OF_MEASURE%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR