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: /* Modified below cursor to make sure that the City and County Name changes
47: are not considering while checking for the Geocode Changes to be processed.

Line 138: l_patch_name Pay_Patch_status.patch_name%type;

134: req_id varchar2(80) := null;
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);

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 140: l_max_patch_name Pay_Patch_status.patch_name%type;

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);
144:

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,

Line 407: insert into pay_patch_status

403:
404: select PAY_PATCH_STATUS_S.nextval into l_id
405: from dual;
406:
407: insert into pay_patch_status
408: (ID,
409: PATCH_NUMBER,
410: PATCH_NAME,
411: PHASE,

Line 490: update pay_patch_status

486: RAISE concurrent_program_failure;
487: END IF;
488:
489: if p_mode = 'DEBUG' then
490: update pay_patch_status
491: set patch_name = 'DEBUG_' || l_patch_name
492: where patch_name = l_patch_name;
493: end if;
494:

Line 510: update pay_patch_status

506:
507: close c_max_geocode_patch_name;
508: --Modified for bug no 7419559
509: /*if p_mode = 'DEBUG' then
510: update pay_patch_status
511: set patch_name = 'DEBUG_' || l_patch_name
512: where patch_name = l_patch_name;
513: end if;*/
514: