APPS.PAY_KR_YEA_SSHR_UTILS_PKG dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 207: -- to the EIT table (PER_ASSIGNMENT_EXTRA_INFO)

203: return(l_ovs_bal);
204: end;
205: -----------------------------------------------------------------------------------
206: -- This procedure will be used to transfer the data from intermediate table
207: -- to the EIT table (PER_ASSIGNMENT_EXTRA_INFO)
208: -----------------------------------------------------------------------------------
209: procedure submit_yea_info(p_assignment_id in varchar2,
210: p_target_year in varchar2,
211: p_effective_date in varchar2, -- expects canonical

Line 221: l_aei_id per_assignment_extra_info.assignment_extra_infO_id%type;

217: l_proc_name varchar2(50);
218: l_effective_date date;
219: l_yea_data_exists varchar2(1);
220: l_yea_fwtb_data_exists varchar2(1);
221: l_aei_id per_assignment_extra_info.assignment_extra_infO_id%type;
222: l_ovn per_assignment_extra_info.object_version_number%type;
223: l_record_name varchar2(50);
224: l_person_id number ;
225: l_session_id number ;

Line 222: l_ovn per_assignment_extra_info.object_version_number%type;

218: l_effective_date date;
219: l_yea_data_exists varchar2(1);
220: l_yea_fwtb_data_exists varchar2(1);
221: l_aei_id per_assignment_extra_info.assignment_extra_infO_id%type;
222: l_ovn per_assignment_extra_info.object_version_number%type;
223: l_record_name varchar2(50);
224: l_person_id number ;
225: l_session_id number ;
226: --

Line 230: From per_assignment_extra_info

226: --
227: Cursor csr_yea_data_exists
228: Is
229: Select 'Y'
230: From per_assignment_extra_info
231: Where assignment_id = p_assignment_id
232: And to_number(to_char(fnd_date.canonical_to_date(aei_information1), 'YYYY')) = p_target_year
233: And information_type in ('KR_YEA_SP_TAX_EXEM_INFO'
234: ,'KR_YEA_SP_TAX_EXEM_INFO2'

Line 248: From per_assignment_extra_info

244:
245: Cursor csr_yea_fwtb_data_exists
246: Is
247: Select 'Y'
248: From per_assignment_extra_info
249: Where assignment_id = p_assignment_id
250: And information_type ='KR_YEA_FW_TAX_BREAK_INFO';
251:
252: --

Line 405: delete from per_assignment_extra_info

401: end if;
402: close csr_yea_fwtb_data_exists;
403:
404:
405: delete from per_assignment_extra_info
406: where assignment_id = p_assignment_id
407: and to_number(to_char(fnd_date.canonical_to_date(aei_information1), 'YYYY')) = p_target_year
408: And information_type in ('KR_YEA_SP_TAX_EXEM_INFO'
409: ,'KR_YEA_SP_TAX_EXEM_INFO2'

Line 420: delete from per_assignment_extra_info

416: ,'KR_YEA_OVS_TAX_BREAK_INFO'
417: ,'KR_YEA_DETAIL_DONATION_INFO' --3506170
418: ,'KR_YEA_EMP_EXPENSE_DETAILS') ; -- Bug 5372366
419:
420: delete from per_assignment_extra_info
421: where assignment_id = p_assignment_id
422: And information_type = 'KR_YEA_FW_TAX_BREAK_INFO';
423:
424: --

Line 527: from per_assignment_extra_info

523:
524: -- cursor to get the Update Allowed Flag of the assignment
525: cursor csr_update_allowed_flag is
526: select nvl(aei_information2, 'Y')
527: from per_assignment_extra_info
528: where information_type = 'KR_YEA_ENTRY_UPDATE'
529: and aei_information1 = p_target_year
530: and assignment_id = p_assignment_id;
531:

Line 1133: from per_assignment_extra_info

1129: is
1130: cursor csr_access is
1131: select nvl(aei_information2,'Y') update_allowed,
1132: assignment_extra_info_id info_id
1133: from per_assignment_extra_info
1134: where assignment_id = P_ASSIGNMENT_ID
1135: and information_type = 'KR_YEA_ENTRY_UPDATE'
1136: and aei_information1 = P_TARGET_YEAR
1137: for update nowait;

Line 1156: insert into per_assignment_extra_info(

1152: end if;
1153: close csr_access;
1154:
1155: if l_record_present = 'N' then -- create a record
1156: insert into per_assignment_extra_info(
1157: assignment_extra_info_id,
1158: assignment_id,
1159: aei_information1,
1160: aei_information2,

Line 1164: per_assignment_extra_info_s.nextval,

1160: aei_information2,
1161: information_type,
1162: aei_information_category)
1163: values(
1164: per_assignment_extra_info_s.nextval,
1165: P_ASSIGNMENT_ID,
1166: P_TARGET_YEAR,
1167: 'Y',
1168: 'KR_YEA_ENTRY_UPDATE',

Line 1178: update per_assignment_extra_info

1174: else
1175: l_future_access := 'N';
1176: end if;
1177:
1178: update per_assignment_extra_info
1179: set aei_information2 = l_future_access
1180: where assignment_extra_info_id = l_info_id;
1181:
1182: P_RESULT := l_future_access;

Line 1274: delete from per_assignment_extra_info

1270: P_ASSIGNMENT_ID in varchar2,
1271: P_TARGET_YEAR in varchar2)
1272: is
1273: begin
1274: delete from per_assignment_extra_info
1275: where assignment_id = p_assignment_id
1276: and to_number(to_char(fnd_date.canonical_to_date(aei_information1), 'YYYY')) = p_target_year
1277: And information_type in ('KR_YEA_SP_TAX_EXEM_INFO'
1278: ,'KR_YEA_SP_TAX_EXEM_INFO2'