APPS.PAY_US_GEOCODE_ENGINE_PKG dependencies on PAY_PATCH_STATUS_S

Line 139: l_patch_status Pay_Patch_status.status%type;

135: x boolean;
136: x1 boolean;
137:
138: l_patch_name Pay_Patch_status.patch_name%type;
139: l_patch_status Pay_Patch_status.status%type;
140: l_max_patch_name Pay_Patch_status.patch_name%type;
141: l_completion_patch_status Pay_Patch_status.status%type;
142: l_year varchar2(4);
143: l_max_year varchar2(4);

Line 141: l_completion_patch_status Pay_Patch_status.status%type;

137:
138: l_patch_name Pay_Patch_status.patch_name%type;
139: l_patch_status Pay_Patch_status.status%type;
140: l_max_patch_name Pay_Patch_status.patch_name%type;
141: l_completion_patch_status Pay_Patch_status.status%type;
142: l_year varchar2(4);
143: l_max_year varchar2(4);
144:
145: l_phase varchar2(10);

Line 404: select PAY_PATCH_STATUS_S.nextval into l_id

400:
401: ELSE
402: hr_utility.trace(' in ELSE');
403:
404: select PAY_PATCH_STATUS_S.nextval into l_id
405: from dual;
406:
407: insert into pay_patch_status
408: (ID,