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);
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);
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,