APPS.PA_FP_VIEW_PLANS_TXN_PUB dependencies on PA_TASKS

Line 137: (p_task_id IN pa_tasks.task_id%TYPE) return VARCHAR2 is

133:
134: /* ------------------------------------------------------------- */
135:
136: function get_task_name
137: (p_task_id IN pa_tasks.task_id%TYPE) return VARCHAR2 is
138: l_task_name pa_tasks.task_name%TYPE;
139: BEGIN
140: select task_name
141: into l_task_name

Line 138: l_task_name pa_tasks.task_name%TYPE;

134: /* ------------------------------------------------------------- */
135:
136: function get_task_name
137: (p_task_id IN pa_tasks.task_id%TYPE) return VARCHAR2 is
138: l_task_name pa_tasks.task_name%TYPE;
139: BEGIN
140: select task_name
141: into l_task_name
142: from pa_tasks

Line 142: from pa_tasks

138: l_task_name pa_tasks.task_name%TYPE;
139: BEGIN
140: select task_name
141: into l_task_name
142: from pa_tasks
143: where task_id = p_task_id;
144: return l_task_name;
145: EXCEPTION
146: WHEN NO_DATA_FOUND THEN

Line 156: (p_task_id IN pa_tasks.task_id%TYPE) return VARCHAR2 is

152: END;
153: /* ------------------------------------------------------------- */
154:
155: function get_task_number
156: (p_task_id IN pa_tasks.task_id%TYPE) return VARCHAR2 is
157: l_task_number pa_tasks.task_number%TYPE;
158: BEGIN
159: select task_number
160: into l_task_number

Line 157: l_task_number pa_tasks.task_number%TYPE;

153: /* ------------------------------------------------------------- */
154:
155: function get_task_number
156: (p_task_id IN pa_tasks.task_id%TYPE) return VARCHAR2 is
157: l_task_number pa_tasks.task_number%TYPE;
158: BEGIN
159: select task_number
160: into l_task_number
161: from pa_tasks

Line 161: from pa_tasks

157: l_task_number pa_tasks.task_number%TYPE;
158: BEGIN
159: select task_number
160: into l_task_number
161: from pa_tasks
162: where task_id = p_task_id;
163: return l_task_number;
164: EXCEPTION
165: WHEN NO_DATA_FOUND THEN

Line 3241: l_task_id pa_tasks.task_id%TYPE;

3237: l_txn_revenue_tbl SYSTEM.pa_num_tbl_type ;
3238:
3239: l_budget_line_id_tbl SYSTEM.pa_num_tbl_type ;
3240: l_ra_id_tbl SYSTEM.pa_num_tbl_type ;
3241: l_task_id pa_tasks.task_id%TYPE;
3242: l_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
3243: l_resource_id pa_resource_list_members.resource_id%TYPE;
3244: l_prev_res_assignment_id pa_resource_assignments.resource_assignment_id%TYPE := -99;
3245: