DBA Data[Home] [Help]

APPS.PATC dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 161: G_OVERIDE_ASSIGNMENT_ID pa_expenditure_items_all.assignment_id%type := NULL;

157: * a global variable is declared in PATC and is accessed from all the
158: * above the places to copy the overide value of the assignment id
159: **/
160:
161: G_OVERIDE_ASSIGNMENT_ID pa_expenditure_items_all.assignment_id%type := NULL;
162: /* Added for bug 2648550 */
163: /* When the assignment_id is overwritten work_type_id,TP_AMT_TYPE_CODE,assignment_name
164: * and WORK_TYPE_NAME too needs to be modified.So instead of using IN OUT parameters
165: * global variables are declared to hold these parameters and can be referenced from

Line 169: G_OVERIDE_TP_AMT_TYPE_CODE pa_expenditure_items_all.TP_AMT_TYPE_CODE%type :=NULL;

165: * global variables are declared to hold these parameters and can be referenced from
166: * anywhere
167: **/
168: G_OVERIDE_WORK_TYPE_ID pa_tasks.work_type_id%type :=NULL;
169: G_OVERIDE_TP_AMT_TYPE_CODE pa_expenditure_items_all.TP_AMT_TYPE_CODE%type :=NULL;
170: G_OVERIDE_ASSIGNMENT_NAME pa_project_assignments.assignment_name%type :=NULL;
171: G_OVERIDE_WORK_TYPE_NAME pa_work_types_tl.name%type :=NULL;
172: /* End of bug 2648550 */
173:

Line 273: p_ei_date in pa_expenditure_items_all.expenditure_item_date%type,

269: G_EXP_TYPE_END_DATE DATE;
270:
271: /* Added Procedure check_termination for Bug#4604614 (BaseBug#4118885) */
272: procedure check_termination (p_person_id in per_all_people_f.person_id%type,
273: p_ei_date in pa_expenditure_items_all.expenditure_item_date%type,
274: x_actual_termination_date out nocopy per_periods_of_service.actual_termination_date%type);
275:
276: /* Bug 6156072: Base Bug 6045051: procedure check_termination_for_cwk added */
277: procedure check_termination_for_cwk (p_person_id in per_all_people_f.person_id%type,

Line 278: p_ei_date in pa_expenditure_items_all.expenditure_item_date%type,

274: x_actual_termination_date out nocopy per_periods_of_service.actual_termination_date%type);
275:
276: /* Bug 6156072: Base Bug 6045051: procedure check_termination_for_cwk added */
277: procedure check_termination_for_cwk (p_person_id in per_all_people_f.person_id%type,
278: p_ei_date in pa_expenditure_items_all.expenditure_item_date%type,
279: x_actual_termination_date out nocopy per_periods_of_placement.actual_termination_date%type);
280:
281: END PATC;