eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_ENTRY_API dependencies on PAY_ELEMENT_ENTRIES_F

Line 127: -- the PAY_ELEMENT_ENTRIES_F or PAY_ELEMENT_ENTRY_VALUES_F tables. --

123: -- hr_entry_api.element_entry_changed PRIVATE FUNCTION --
124: -- --
125: -- DESCRIPTION --
126: -- Determines if the entry to be updated will cause a change on either --
127: -- the PAY_ELEMENT_ENTRIES_F or PAY_ELEMENT_ENTRY_VALUES_F tables. --
128: -- If the entry is going to cause an update against either the --
129: -- PAY_ELEMENT_ENTRIES_F or PAY_ELEMENT_ENTRY_VALUES_F attributes then the --
130: -- return code will be true. --
131: ------------------------------------------------------------------------------

Line 129: -- PAY_ELEMENT_ENTRIES_F or PAY_ELEMENT_ENTRY_VALUES_F attributes then the --

125: -- DESCRIPTION --
126: -- Determines if the entry to be updated will cause a change on either --
127: -- the PAY_ELEMENT_ENTRIES_F or PAY_ELEMENT_ENTRY_VALUES_F tables. --
128: -- If the entry is going to cause an update against either the --
129: -- PAY_ELEMENT_ENTRIES_F or PAY_ELEMENT_ENTRY_VALUES_F attributes then the --
130: -- return code will be true. --
131: ------------------------------------------------------------------------------
132: --
133: function element_entry_changed

Line 234: -- Need to determine if the PAY_ELEMENT_ENTRIES_F table is being

230: l_proc_func_error varchar2(30) := 'HR_6153_ALL_PROCEDURE_FAIL';
231: --
232: begin
233: --
234: -- Need to determine if the PAY_ELEMENT_ENTRIES_F table is being
235: -- updated with any new values.
236: -- If No change is being made against PAY_ELEMENT_ENTRIES_F we
237: -- then need to determine if any PAY_ELEMENT_ENTRY_VALUES_F are
238: -- being updated.

Line 236: -- If No change is being made against PAY_ELEMENT_ENTRIES_F we

232: begin
233: --
234: -- Need to determine if the PAY_ELEMENT_ENTRIES_F table is being
235: -- updated with any new values.
236: -- If No change is being made against PAY_ELEMENT_ENTRIES_F we
237: -- then need to determine if any PAY_ELEMENT_ENTRY_VALUES_F are
238: -- being updated.
239: -- However, if a change is going to place against the PAY_ELEMENT_ENTRIES_F
240: -- table then we don't need to check against a change to the

Line 239: -- However, if a change is going to place against the PAY_ELEMENT_ENTRIES_F

235: -- updated with any new values.
236: -- If No change is being made against PAY_ELEMENT_ENTRIES_F we
237: -- then need to determine if any PAY_ELEMENT_ENTRY_VALUES_F are
238: -- being updated.
239: -- However, if a change is going to place against the PAY_ELEMENT_ENTRIES_F
240: -- table then we don't need to check against a change to the
241: -- PAY_ELEMENT_ENTRY_VALUES_F table.
242: --
243: if g_debug then

Line 252: from pay_element_entries_f pee

248: into l_check_entry_values
249: from sys.dual
250: where exists
251: (select 1
252: from pay_element_entries_f pee
253: where pee.element_entry_id = p_element_entry_id
254: and p_driving_date
255: between pee.effective_start_date
256: and pee.effective_end_date

Line 453: -- the PAY_ELEMENT_ENTRIES_F attributes then we must check to

449: null;
450: end;
451: --
452: -- If the entry record to be updated is not updating any of
453: -- the PAY_ELEMENT_ENTRIES_F attributes then we must check to
454: -- see if any of the PAY_ELEMENT_ENTRY_VALUES_F are to be
455: -- updated.
456: --
457: if (l_check_entry_values = 'Y') then

Line 506: -- The entry is being updated on the PAY_ELEMENT_ENTRIES_F table

502: end loop;
503: close select_entry_value;
504: else
505: --
506: -- The entry is being updated on the PAY_ELEMENT_ENTRIES_F table
507: -- therefore set the returning function code to true.
508: --
509: l_entry_changed := true;
510: end if;

Line 1384: pay_element_entries_f ee,

1380: p_input_value_id14,'SET',
1381: p_input_value_id15,'SET',
1382: 'NOT_SET') entry_specified
1383: from pay_element_entry_values_f eev,
1384: pay_element_entries_f ee,
1385: pay_input_values_f piv,
1386: pay_element_types_f et
1387: where ee.element_entry_id = p_element_entry_id
1388: and eev.element_entry_id = ee.element_entry_id

Line 1407: from pay_element_entries_f ee

1403: l_element_entry_id number,
1404: l_session_date date
1405: ) is
1406: select ee.creator_type
1407: from pay_element_entries_f ee
1408: where ee.element_entry_id = l_element_entry_id
1409: and l_session_date between ee.effective_start_date and ee.effective_end_date;
1410: --
1411: v_creator_type varchar2(30);

Line 1779: pay_element_entries_f ee,

1775: piv.mandatory_flag,
1776: eev.screen_entry_value peev_default_value,
1777: eev.screen_entry_value
1778: from pay_element_entry_values_f eev,
1779: pay_element_entries_f ee,
1780: pay_input_values_f piv,
1781: pay_element_types_f et
1782: where ee.element_entry_id = p_element_entry_id
1783: and eev.element_entry_id = ee.element_entry_id

Line 1802: from pay_element_entries_f ee

1798: l_element_entry_id number,
1799: l_session_date date
1800: ) is
1801: select ee.creator_type
1802: from pay_element_entries_f ee
1803: where ee.element_entry_id = l_element_entry_id
1804: and l_session_date between ee.effective_start_date and ee.effective_end_date;
1805: --
1806: -- Local Variables

Line 2592: from pay_element_entries_f ee

2588: begin
2589: --
2590: select ee.element_entry_id
2591: into v_number_variable
2592: from pay_element_entries_f ee
2593: where p_entry_type in ('R','A')
2594: and ee.element_entry_id = p_target_entry_id
2595: and ee.assignment_id = p_assignment_id
2596: and ee.element_link_id = p_element_link_id

Line 2655: from pay_element_entries_f ee

2651: --
2652: cursor csr_adj_orig_entry
2653: is
2654: select 1
2655: from pay_element_entries_f ee
2656: ,pay_element_links_f el
2657: ,pay_element_types_f et
2658: where ee.assignment_id = p_assignment_id
2659: and nvl(ee.original_entry_id, ee.element_entry_id)

Line 2701: from pay_element_entries_f ee

2697: into v_number_variable
2698: from sys.dual
2699: where exists
2700: (select null
2701: from pay_element_entries_f ee
2702: ,pay_element_links_f el
2703: ,pay_element_types_f et
2704: where ee.assignment_id = p_assignment_id
2705: and ee.element_link_id = p_element_link_id

Line 2796: -- element_type_id on pay_element_entries_f. --

2792: -- --
2793: -- DESCRIPTION --
2794: -- Derives the element_type_id from the previously validated element_link_id --
2795: -- The resulting element_type_id will populate the denormalised column, --
2796: -- element_type_id on pay_element_entries_f. --
2797: -- --
2798: -------------------------------------------------------------------------------
2799: FUNCTION derive_element_type_id (p_element_link_id in number
2800: ,p_effective_date in date)

Line 3701: from pay_element_entries_f

3697: -- bug 666197
3698: cursor csr_object_version_number
3699: (p_element_entry_id number, p_effective_date date) is
3700: select object_version_number
3701: from pay_element_entries_f
3702: where element_entry_id = p_element_entry_id
3703: and p_effective_date between effective_start_date
3704: and effective_end_date;
3705: --

Line 3870: ('PAY_ELEMENT_ENTRIES_F'

3866: -- Derive the OVN here instead of in the database trigger in order to
3867: -- avoid the ORA-04091 error
3868: --
3869: l_object_version_number := dt_api.get_object_version_number
3870: ('PAY_ELEMENT_ENTRIES_F'
3871: ,'ELEMENT_ENTRY_ID'
3872: ,v_element_entry_id);
3873: --
3874: -- Enhancement 3478848

Line 3881: insert into pay_element_entries_f

3877: l_all_entry_values_null := derive_all_entry_values_null(p_entry_value_tbl);
3878: --
3879: -- Create element entry
3880: --
3881: insert into pay_element_entries_f
3882: (effective_start_date,
3883: effective_end_date,
3884: element_entry_id,
3885: original_entry_id,

Line 4008: -- Bug 570156 changed to null so the PAY_ELEMENT_ENTRIES_F_WHO trigger

4004: p_attribute20,
4005: trunc(sysdate),
4006: 0,
4007: 0,
4008: -- Bug 570156 changed to null so the PAY_ELEMENT_ENTRIES_F_WHO trigger
4009: -- can set it. These parameters are not needed here at all, as the form
4010: -- is not passing them and api should not set them. It's always done via
4011: -- the database trigger.
4012: null,

Line 4165: (p_module_name => 'PAY_ELEMENT_ENTRIES_F'

4161: );
4162: exception
4163: when hr_api.cannot_find_prog_unit then
4164: hr_api.cannot_find_prog_unit_error
4165: (p_module_name => 'PAY_ELEMENT_ENTRIES_F'
4166: ,p_hook_type => 'AI'
4167: );
4168: end;
4169: --

Line 5183: from pay_element_entries_f

5179: -- Get the old values of the entry for comparison with the updated
5180: -- values
5181: --
5182: select *
5183: from pay_element_entries_f
5184: where element_entry_id = p_element_entry_id
5185: and p_effective_date between effective_start_date
5186: and effective_end_date;
5187: --

Line 5189: old_entry pay_element_entries_f%rowtype;

5185: and p_effective_date between effective_start_date
5186: and effective_end_date;
5187: --
5188: l_proc varchar2 (72);
5189: old_entry pay_element_entries_f%rowtype;
5190: invalid_element_entry_id exception;
5191: invalid_dt_update_mode exception;
5192: --
5193: procedure check_parameters is

Line 5502: from pay_element_entries_f ee,

5498: decode(p_entry_information28,hr_api.g_varchar2,ee.entry_information28,p_entry_information28),
5499: decode(p_entry_information29,hr_api.g_varchar2,ee.entry_information29,p_entry_information29),
5500: decode(p_entry_information30,hr_api.g_varchar2,ee.entry_information30,p_entry_information30)
5501: into v_entry_rec
5502: from pay_element_entries_f ee,
5503: pay_element_links_f el,
5504: pay_element_types_f et
5505: where ee.element_entry_id = p_element_entry_id
5506: and el.element_link_id = ee.element_link_id

Line 5717: from pay_element_entries_f ee

5713: from per_pay_proposals pp
5714: where pp.assignment_id = p_assignment_id
5715: and exists
5716: (select null
5717: from pay_element_entries_f ee
5718: where ee.element_entry_id = p_element_entry_id
5719: and ee.creator_type = 'SP'
5720: and ee.creator_id = pp.pay_proposal_id
5721: and ee.effective_start_date = pp.change_date);

Line 5729: from pay_element_entries_f

5725: -- OVN of the dml record
5726: cursor csr_object_version_number
5727: (p_element_entry_id number, p_effective_date date) is
5728: select object_version_number, effective_start_date, effective_end_date
5729: from pay_element_entries_f
5730: where element_entry_id = p_element_entry_id
5731: and p_effective_date between effective_start_date
5732: and effective_end_date;
5733:

Line 5815: from pay_element_entries_f

5811: ,entry_information29
5812: ,entry_information30
5813: ,element_type_id
5814: ,all_entry_values_null
5815: from pay_element_entries_f
5816: where element_entry_id = p_element_entry_id
5817: and p_session_date between effective_start_date
5818: and effective_end_date;
5819: --

Line 6166: from pay_element_entries_f ee

6162: --
6163: begin
6164: select max(ee.effective_end_date)
6165: into v_max_effective_end_date
6166: from pay_element_entries_f ee
6167: where ee.element_entry_id = p_element_entry_id;
6168: exception
6169: when no_data_found then null;
6170: end;

Line 6339: delete from pay_element_entries_f ee

6335: --
6336: -- Clear out future records (if any).
6337: if v_dt_update_mode = 'UPDATE_OVERRIDE' then
6338: --
6339: delete from pay_element_entries_f ee
6340: where ee.element_entry_id = p_element_entry_id
6341: and ee.effective_start_date > v_entry_rec.effective_start_date;
6342: --
6343: end if;

Line 6352: update pay_element_entries_f ee

6348: -- null on first half for Stop
6349: -- null on second half for Update Recurring
6350: --
6351:
6352: update pay_element_entries_f ee
6353: set ee.effective_end_date = p_session_date - 1,
6354: ee.updating_action_id = decode(ee.updating_action_type, 'U', ee.updating_action_id,
6355: null),
6356: ee.updating_action_type = decode(ee.updating_action_type, 'U', 'U', null)

Line 6366: ('PAY_ELEMENT_ENTRIES_F'

6362: -- Derive the OVN here instead of in the database trigger in order to
6363: -- avoid the ORA-04091 error
6364: --
6365: l_object_version_number := dt_api.get_object_version_number
6366: ('PAY_ELEMENT_ENTRIES_F'
6367: ,'ELEMENT_ENTRY_ID'
6368: ,p_element_entry_id);
6369:
6370: insert into pay_element_entries_f

Line 6370: insert into pay_element_entries_f

6366: ('PAY_ELEMENT_ENTRIES_F'
6367: ,'ELEMENT_ENTRY_ID'
6368: ,p_element_entry_id);
6369:
6370: insert into pay_element_entries_f
6371: (element_entry_id,
6372: effective_start_date,
6373: effective_end_date,
6374: cost_allocation_keyflex_id,

Line 6534: from pay_element_entries_f ee

6530: 0,
6531: 0,
6532: ee.created_by,
6533: ee.creation_date
6534: from pay_element_entries_f ee
6535: where ee.element_entry_id = p_element_entry_id
6536: and ee.effective_start_date = v_entry_rec.effective_start_date;
6537: --
6538: elsif v_dt_update_mode = 'CORRECTION' then

Line 6539: update pay_element_entries_f ee

6535: where ee.element_entry_id = p_element_entry_id
6536: and ee.effective_start_date = v_entry_rec.effective_start_date;
6537: --
6538: elsif v_dt_update_mode = 'CORRECTION' then
6539: update pay_element_entries_f ee
6540: set ee.cost_allocation_keyflex_id =
6541: v_entry_rec.cost_allocation_keyflex_id,
6542: ee.updating_action_id = v_entry_rec.updating_action_id,
6543: ee.updating_action_type = v_entry_rec.updating_action_type,

Line 6672: from pay_element_entries_f ee

6668: delete from per_pay_proposals pp
6669: where pp.pay_proposal_id = v_pay_proposal_id
6670: and not exists
6671: (select null
6672: from pay_element_entries_f ee
6673: where ee.element_entry_id = p_element_entry_id
6674: and ee.creator_type = 'SP'
6675: and ee.creator_id = pp.pay_proposal_id
6676: and ee.effective_start_date = pp.change_date);

Line 6860: (p_module_name => 'PAY_ELEMENT_ENTRIES_F'

6856: );
6857: exception
6858: when hr_api.cannot_find_prog_unit then
6859: hr_api.cannot_find_prog_unit_error
6860: (p_module_name => 'PAY_ELEMENT_ENTRIES_F'
6861: ,p_hook_type => 'AU'
6862: );
6863: end;
6864: --

Line 7019: FROM PAY_ELEMENT_ENTRIES_F pee

7015: p_effective_date DATE)
7016: IS
7017: SELECT pee.entry_type,
7018: pee.assignment_id
7019: FROM PAY_ELEMENT_ENTRIES_F pee
7020: WHERE pee.element_entry_id = p_element_entry_id
7021: and p_effective_date BETWEEN
7022: pee.effective_start_date and pee.effective_end_date
7023: ;

Line 7247: FROM PAY_ELEMENT_ENTRIES_F pee

7243: p_effective_date DATE)
7244: IS
7245: SELECT pee.entry_type,
7246: pee.assignment_id
7247: FROM PAY_ELEMENT_ENTRIES_F pee
7248: WHERE pee.element_entry_id = p_element_entry_id
7249: and p_effective_date BETWEEN
7250: pee.effective_start_date and pee.effective_end_date
7251: ;

Line 7511: FROM PAY_ELEMENT_ENTRIES_F pee

7507: p_effective_date DATE)
7508: IS
7509: SELECT pee.entry_type,
7510: pee.assignment_id
7511: FROM PAY_ELEMENT_ENTRIES_F pee
7512: WHERE pee.element_entry_id = p_element_entry_id
7513: and p_effective_date BETWEEN
7514: pee.effective_start_date and pee.effective_end_date
7515: ;

Line 7771: FROM PAY_ELEMENT_ENTRIES_F pee

7767: p_effective_date DATE)
7768: IS
7769: SELECT pee.entry_type,
7770: pee.assignment_id
7771: FROM PAY_ELEMENT_ENTRIES_F pee
7772: WHERE pee.element_entry_id = p_element_entry_id
7773: and p_effective_date BETWEEN
7774: pee.effective_start_date and pee.effective_end_date
7775: ;

Line 7990: from pay_element_entries_f ee,

7986: et.processing_type,
7987: nvl(ec.non_payments_flag, 'N'),
7988: ee.personal_payment_method_id
7989: into v_entry_rec
7990: from pay_element_entries_f ee,
7991: pay_element_links_f el,
7992: pay_element_types_f et,
7993: pay_element_classifications ec
7994: where ee.element_entry_id = p_element_entry_id

Line 8198: from pay_element_entries_f ee

8194: from per_pay_proposals pp
8195: where pp.assignment_id = p_assignment_id
8196: and exists
8197: (select null
8198: from pay_element_entries_f ee
8199: where ee.element_entry_id = p_element_entry_id
8200: and ee.creator_type = 'SP'
8201: and ee.creator_id = pp.pay_proposal_id
8202: and ee.effective_start_date = pp.change_date);

Line 8208: from pay_element_entries_f

8204: -- bug 666197
8205: cursor csr_ovn_and_dates
8206: (p_element_entry_id number, p_effective_date date) is
8207: select object_version_number, effective_start_date, effective_end_date
8208: from pay_element_entries_f
8209: where element_entry_id = p_element_entry_id
8210: and p_effective_date between effective_start_date
8211: and effective_end_date;
8212: --

Line 8259: from pay_element_entries_f

8255: ,object_version_number
8256: ,balance_adj_cost_flag
8257: ,element_type_id
8258: ,all_entry_values_null
8259: from pay_element_entries_f
8260: where element_entry_id = p_element_entry_id
8261: and p_session_date between effective_start_date
8262: and effective_end_date;
8263: --

Line 8377: pay_element_entries_f pee

8373: --
8374: cursor nonrecurring_entries (adjust_ee_source in varchar2) is
8375: select 'Y'
8376: from pay_run_results prr,
8377: pay_element_entries_f pee
8378: where pee.element_entry_id = p_element_entry_id
8379: /* Added the following condition for bug: 7344563 */
8380: and pee.element_entry_id = prr.element_entry_id
8381: and p_validation_start_date between pee.effective_start_date

Line 8527: from pay_element_entries_f ee

8523: --
8524: begin
8525: select min(ee.effective_end_date)
8526: into v_next_effective_end_date
8527: from pay_element_entries_f ee
8528: where ee.element_entry_id = p_element_entry_id
8529: and ee.effective_start_date > v_entry_rec.effective_end_date;
8530: exception
8531: when no_data_found then null;

Line 8585: from pay_element_entries_f pee

8581: select min(pee.effective_start_date),
8582: max(pee.effective_end_date)
8583: into v_validation_start_date,
8584: v_validation_end_date
8585: from pay_element_entries_f pee
8586: where pee.element_entry_id = p_element_entry_id;
8587: --
8588: end if;
8589: --

Line 8702: delete from pay_element_entries_f ee

8698: if g_debug then
8699: hr_utility.set_location('hr_entry_api.delete_element_entry', 40);
8700: end if;
8701: --
8702: delete from pay_element_entries_f ee
8703: where ee.element_entry_id = p_element_entry_id
8704: and ee.effective_start_date = v_validation_start_date;
8705: --
8706: update pay_element_entries_f ee

Line 8706: update pay_element_entries_f ee

8702: delete from pay_element_entries_f ee
8703: where ee.element_entry_id = p_element_entry_id
8704: and ee.effective_start_date = v_validation_start_date;
8705: --
8706: update pay_element_entries_f ee
8707: set ee.effective_end_date = decode(v_validation_end_date,
8708: hr_general.end_of_time,
8709: v_entry_rec.effective_end_date,
8710: v_validation_end_date),

Line 8723: delete from pay_element_entries_f ee

8719: if g_debug then
8720: hr_utility.set_location('hr_entry_api.delete_element_entry', 45);
8721: end if;
8722: --
8723: delete from pay_element_entries_f ee
8724: where ee.element_entry_id = p_element_entry_id
8725: and ee.effective_start_date > v_entry_rec.effective_start_date;
8726: --
8727: update pay_element_entries_f ee

Line 8727: update pay_element_entries_f ee

8723: delete from pay_element_entries_f ee
8724: where ee.element_entry_id = p_element_entry_id
8725: and ee.effective_start_date > v_entry_rec.effective_start_date;
8726: --
8727: update pay_element_entries_f ee
8728: set ee.effective_end_date = v_entry_rec.effective_end_date,
8729: ee.updating_action_id = decode(ee.updating_action_type, 'U', ee.updating_action_id,
8730: null),
8731: ee.updating_action_type = decode(ee.updating_action_type, 'U', 'U', null)

Line 8741: delete from pay_element_entries_f ee

8737: if g_debug then
8738: hr_utility.set_location('hr_entry_api.delete_element_entry', 50);
8739: end if;
8740: --
8741: delete from pay_element_entries_f ee
8742: where ee.element_entry_id = p_element_entry_id
8743: and ee.effective_start_date > p_session_date;
8744: --
8745: update pay_element_entries_f ee

Line 8745: update pay_element_entries_f ee

8741: delete from pay_element_entries_f ee
8742: where ee.element_entry_id = p_element_entry_id
8743: and ee.effective_start_date > p_session_date;
8744: --
8745: update pay_element_entries_f ee
8746: set ee.effective_end_date = p_session_date,
8747: ee.updating_action_id = decode(ee.updating_action_type, 'U', ee.updating_action_id,
8748: null),
8749: ee.updating_action_type = decode(ee.updating_action_type, 'U', 'U', null)

Line 8765: delete from pay_element_entries_f ee

8761: delete from pay_grossup_bal_exclusions excl
8762: where excl.source_id = p_element_entry_id
8763: and excl.source_type = 'EE';
8764: --
8765: delete from pay_element_entries_f ee
8766: where ee.element_entry_id = p_element_entry_id;
8767: --
8768: end if;
8769: --

Line 8809: from pay_element_entries_f ee

8805: delete from per_pay_proposals pp
8806: where pp.pay_proposal_id = v_pay_proposal_id
8807: and not exists
8808: (select null
8809: from pay_element_entries_f ee
8810: where ee.element_entry_id = p_element_entry_id
8811: and ee.creator_type = 'SP'
8812: and ee.creator_id = pp.pay_proposal_id
8813: and ee.effective_start_date = pp.change_date);

Line 8945: (p_module_name => 'PAY_ELEMENT_ENTRIES_F'

8941: --
8942: exception
8943: when hr_api.cannot_find_prog_unit then
8944: hr_api.cannot_find_prog_unit_error
8945: (p_module_name => 'PAY_ELEMENT_ENTRIES_F'
8946: ,p_hook_type => 'AD'
8947: );
8948: end;
8949: --