APPS.PAY_US_GEOCODE_ENGINE_PKG dependencies on PAY_PATCH_STATUS

Line 14: from pay_patch_status

10: cursor c_max_geocode_patch_name is
11: select patch_name,
12: Substr( patch_name,
13: greatest(instr(patch_name,'_1'),instr(patch_name,'_2')) + 1, 4)
14: from pay_patch_status
15: where patch_name like '%GEO%'
16: and Substr( patch_name,
17: greatest(instr(patch_name,'_1'),instr(patch_name,'_2')) + 1, 4) >= '2001'
18: group by patch_name

Line 36: from pay_patch_status

32:
33: cursor c_geocode_patch_status (p_patch_name in varchar)
34: is
35: select status
36: from pay_patch_status
37: where patch_name = p_patch_name
38: order by patch_name asc;
39:
40: cursor c_geo_patch_comp_stat (p_patch_name in varchar)

Line 43: from pay_patch_status

39:
40: cursor c_geo_patch_comp_stat (p_patch_name in varchar)
41: is
42: select status
43: from pay_patch_status
44: where patch_name = p_patch_name;
45:
46: cursor c_geo_check_us_assignments (p_patch_name in varchar)
47: is

Line 90: l_patch_name Pay_Patch_status.patch_name%type;

86: req_id varchar2(80) := null;
87: x boolean;
88: x1 boolean;
89:
90: l_patch_name Pay_Patch_status.patch_name%type;
91: l_patch_status Pay_Patch_status.status%type;
92: l_max_patch_name Pay_Patch_status.patch_name%type;
93: l_completion_patch_status Pay_Patch_status.status%type;
94: l_year varchar2(4);

Line 91: l_patch_status Pay_Patch_status.status%type;

87: x boolean;
88: x1 boolean;
89:
90: l_patch_name Pay_Patch_status.patch_name%type;
91: l_patch_status Pay_Patch_status.status%type;
92: l_max_patch_name Pay_Patch_status.patch_name%type;
93: l_completion_patch_status Pay_Patch_status.status%type;
94: l_year varchar2(4);
95: l_max_year varchar2(4);

Line 92: l_max_patch_name Pay_Patch_status.patch_name%type;

88: x1 boolean;
89:
90: l_patch_name Pay_Patch_status.patch_name%type;
91: l_patch_status Pay_Patch_status.status%type;
92: l_max_patch_name Pay_Patch_status.patch_name%type;
93: l_completion_patch_status Pay_Patch_status.status%type;
94: l_year varchar2(4);
95: l_max_year varchar2(4);
96:

Line 93: l_completion_patch_status Pay_Patch_status.status%type;

89:
90: l_patch_name Pay_Patch_status.patch_name%type;
91: l_patch_status Pay_Patch_status.status%type;
92: l_max_patch_name Pay_Patch_status.patch_name%type;
93: l_completion_patch_status Pay_Patch_status.status%type;
94: l_year varchar2(4);
95: l_max_year varchar2(4);
96:
97: l_phase varchar2(10);

Line 269: insert into pay_patch_status

265:
266:
267: ELSE
268: hr_utility.trace(' in ELSE');
269: insert into pay_patch_status
270: (ID,
271: PATCH_NUMBER,
272: PATCH_NAME,
273: PHASE,

Line 283: (PAY_PATCH_STATUS_S.nextval,

279: LEGISLATION_CODE,
280: APPLICATION_RELEASE,
281: PREREQ_PATCH_NAME)
282: values
283: (PAY_PATCH_STATUS_S.nextval,
284: '1111111',
285: l_patch_name, --p_patch_name,
286: null,
287: null,

Line 319: update pay_patch_status

315: RAISE concurrent_program_failure;
316: END IF;
317:
318: if p_mode = 'DEBUG' then
319: update pay_patch_status
320: set patch_name = 'DEBUG_' || l_patch_name
321: where patch_name = l_patch_name;
322: end if;
323:

Line 340: update pay_patch_status

336: close c_max_geocode_patch_name;
337:
338: /*Modified for bug no 7421642
339: if p_mode = 'DEBUG' then
340: update pay_patch_status
341: set patch_name = 'DEBUG_' || l_patch_name
342: where patch_name = l_patch_name;
343: end if; */
344: