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.PQP_NL_ABP_FUNCTIONS dependencies on BEN_EXT_CHG_EVT_LOG

Line 767: --ben_ext_chg_evt_log table

763: hr_utility.raise_error;
764: END IF; */
765: --hr_utility.trace_off;
766: --call the procedure to fire insert of the change events in the
767: --ben_ext_chg_evt_log table
768: pqp_nl_ext_functions.create_org_pt_ins_chg_evt
769: (p_organization_id => p_organization_id
770: ,p_org_information1 => p_org_information1
771: ,p_org_information2 => p_org_information2

Line 1473: --ben_ext_chg_evt_log table

1469: END IF;
1470: END IF; */
1471: hr_utility.set_location('calling insert process',20);
1472: --call the procedure to fire insert of the change events in the
1473: --ben_ext_chg_evt_log table
1474: pqp_nl_ext_functions.create_org_pt_upd_chg_evt
1475: (p_organization_id => p_organization_id
1476: ,p_org_information1 => p_org_information1
1477: ,p_org_information2 => p_org_information2

Line 2315: --call the procedure to insert rows into the ben_ext_chg_evt_log table

2311: ELSE
2312: l_abp_rep_date := greatest(l_abp_rep_date,fnd_date.canonical_to_date(p_aei_information1));
2313: END IF;
2314:
2315: --call the procedure to insert rows into the ben_ext_chg_evt_log table
2316: pqp_nl_ext_functions.create_asg_info_ins_chg_evt
2317: (p_assignment_id => p_assignment_id
2318: ,p_assignment_extra_info_id => p_assignment_extra_info_id
2319: ,p_aei_information1 => p_aei_information1

Line 2545: --call the procedure to insert rows into the ben_ext_chg_evt_log table

2541: ,p_assignment_id => fnd_number.canonical_to_number(p_assignment_id)
2542: ,p_person_id => l_person_id
2543: ,p_reporting_date => l_abp_rep_date );
2544:
2545: --call the procedure to insert rows into the ben_ext_chg_evt_log table
2546: pqp_nl_ext_functions.create_sal_info_ins_chg_evt
2547: (p_assignment_id => p_assignment_id
2548: ,p_assignment_extra_info_id => p_assignment_extra_info_id
2549: ,p_aei_information1 => p_aei_information1

Line 3380: --Call the procedure to insert the rows in the ben_ext_chg_evt_log table

3376: ELSE
3377: l_abp_rep_date := greatest(l_abp_rep_date,fnd_date.canonical_to_date(p_aei_information1));
3378: END IF;
3379:
3380: --Call the procedure to insert the rows in the ben_ext_chg_evt_log table
3381: pqp_nl_ext_functions.create_asg_info_upd_chg_evt
3382: (p_assignment_id => p_assignment_id
3383: ,p_assignment_extra_info_id => p_assignment_extra_info_id
3384: ,p_aei_information1 => p_aei_information1

Line 3645: --Call the procedure to insert the rows in the ben_ext_chg_evt_log table

3641: ,p_assignment_id => fnd_number.canonical_to_number(p_assignment_id)
3642: ,p_person_id => l_person_id
3643: ,p_reporting_date => l_abp_rep_date );
3644:
3645: --Call the procedure to insert the rows in the ben_ext_chg_evt_log table
3646: pqp_nl_ext_functions.create_sal_info_upd_chg_evt
3647: (p_assignment_id => p_assignment_id
3648: ,p_assignment_extra_info_id => p_assignment_extra_info_id
3649: ,p_aei_information1 => p_aei_information1

Line 5946: --ben_ext_chg_evt_log table

5942: CLOSE c_rows_exist;
5943: END IF;
5944:
5945: --call the procedure to fire insert of the change events in the
5946: --ben_ext_chg_evt_log table
5947: pqp_nl_ext_functions.create_org_pp_ins_chg_evt
5948: (p_organization_id => p_organization_id
5949: ,p_org_information1 => p_org_information1
5950: ,p_org_information2 => p_org_information2

Line 5988: --call the procedure to insert the change in the row into the ben_ext_chg_evt_log table

5984: OPEN c_get_eff_date;
5985: FETCH c_get_eff_date INTO l_eff_date;
5986: CLOSE c_get_eff_date;
5987:
5988: --call the procedure to insert the change in the row into the ben_ext_chg_evt_log table
5989: pqp_nl_ext_functions.create_org_pp_upd_chg_evt
5990: (p_organization_id => p_organization_id
5991: ,p_org_information1 => p_org_information1
5992: ,p_org_information2 => p_org_information2

Line 6674: ,c_st_dt IN ben_ext_chg_evt_log.prmtr_04%TYPE

6670: FROM hr_soft_coding_keyflex
6671: WHERE soft_coding_keyflex_id = c_kff_id;
6672:
6673: CURSOR c_log_xst( c_kff_id IN NUMBER
6674: ,c_st_dt IN ben_ext_chg_evt_log.prmtr_04%TYPE
6675: ,c_ed_dt IN ben_ext_chg_evt_log.prmtr_05%TYPE
6676: ,c_rep_dt IN ben_ext_chg_evt_log.prmtr_09%TYPE
6677: ,c_asg_id IN ben_ext_chg_evt_log.prmtr_01%TYPE ) IS
6678: SELECT *

Line 6675: ,c_ed_dt IN ben_ext_chg_evt_log.prmtr_05%TYPE

6671: WHERE soft_coding_keyflex_id = c_kff_id;
6672:
6673: CURSOR c_log_xst( c_kff_id IN NUMBER
6674: ,c_st_dt IN ben_ext_chg_evt_log.prmtr_04%TYPE
6675: ,c_ed_dt IN ben_ext_chg_evt_log.prmtr_05%TYPE
6676: ,c_rep_dt IN ben_ext_chg_evt_log.prmtr_09%TYPE
6677: ,c_asg_id IN ben_ext_chg_evt_log.prmtr_01%TYPE ) IS
6678: SELECT *
6679: FROM ben_ext_chg_evt_log

Line 6676: ,c_rep_dt IN ben_ext_chg_evt_log.prmtr_09%TYPE

6672:
6673: CURSOR c_log_xst( c_kff_id IN NUMBER
6674: ,c_st_dt IN ben_ext_chg_evt_log.prmtr_04%TYPE
6675: ,c_ed_dt IN ben_ext_chg_evt_log.prmtr_05%TYPE
6676: ,c_rep_dt IN ben_ext_chg_evt_log.prmtr_09%TYPE
6677: ,c_asg_id IN ben_ext_chg_evt_log.prmtr_01%TYPE ) IS
6678: SELECT *
6679: FROM ben_ext_chg_evt_log
6680: WHERE chg_evt_cd = 'COPTP'

Line 6677: ,c_asg_id IN ben_ext_chg_evt_log.prmtr_01%TYPE ) IS

6673: CURSOR c_log_xst( c_kff_id IN NUMBER
6674: ,c_st_dt IN ben_ext_chg_evt_log.prmtr_04%TYPE
6675: ,c_ed_dt IN ben_ext_chg_evt_log.prmtr_05%TYPE
6676: ,c_rep_dt IN ben_ext_chg_evt_log.prmtr_09%TYPE
6677: ,c_asg_id IN ben_ext_chg_evt_log.prmtr_01%TYPE ) IS
6678: SELECT *
6679: FROM ben_ext_chg_evt_log
6680: WHERE chg_evt_cd = 'COPTP'
6681: AND person_id = p_person_id

Line 6679: FROM ben_ext_chg_evt_log

6675: ,c_ed_dt IN ben_ext_chg_evt_log.prmtr_05%TYPE
6676: ,c_rep_dt IN ben_ext_chg_evt_log.prmtr_09%TYPE
6677: ,c_asg_id IN ben_ext_chg_evt_log.prmtr_01%TYPE ) IS
6678: SELECT *
6679: FROM ben_ext_chg_evt_log
6680: WHERE chg_evt_cd = 'COPTP'
6681: AND person_id = p_person_id
6682: AND prmtr_04 = c_st_dt
6683: -- AND prmtr_05 = c_ed_dt

Line 6687: CURSOR c_upd_log_kff_upd(c_asg_id IN ben_ext_chg_evt_log.prmtr_01%TYPE ) IS

6683: -- AND prmtr_05 = c_ed_dt
6684: AND prmtr_01 = c_asg_id
6685: AND prmtr_02 = c_kff_id;
6686:
6687: CURSOR c_upd_log_kff_upd(c_asg_id IN ben_ext_chg_evt_log.prmtr_01%TYPE ) IS
6688: SELECT ext_chg_evt_log_id
6689: ,prmtr_09
6690: FROM ben_ext_chg_evt_log
6691: WHERE chg_evt_cd = 'COPTP'

Line 6690: FROM ben_ext_chg_evt_log

6686:
6687: CURSOR c_upd_log_kff_upd(c_asg_id IN ben_ext_chg_evt_log.prmtr_01%TYPE ) IS
6688: SELECT ext_chg_evt_log_id
6689: ,prmtr_09
6690: FROM ben_ext_chg_evt_log
6691: WHERE chg_evt_cd = 'COPTP'
6692: AND person_id = p_person_id
6693: AND prmtr_01 = c_asg_id
6694: AND prmtr_02 = p_old_val1

Line 6700: CURSOR c_upd_log_kff(c_asg_id IN ben_ext_chg_evt_log.prmtr_01%TYPE ) IS

6696: TRUNC(p_chg_eff_dt) - 1,
6697: TRUNC(fnd_date.canonical_to_date(prmtr_05)))
6698: = TRUNC(p_chg_eff_dt) - 1;
6699:
6700: CURSOR c_upd_log_kff(c_asg_id IN ben_ext_chg_evt_log.prmtr_01%TYPE ) IS
6701: SELECT ext_chg_evt_log_id
6702: ,prmtr_09
6703: FROM ben_ext_chg_evt_log
6704: WHERE chg_evt_cd = 'COPTP'

Line 6703: FROM ben_ext_chg_evt_log

6699:
6700: CURSOR c_upd_log_kff(c_asg_id IN ben_ext_chg_evt_log.prmtr_01%TYPE ) IS
6701: SELECT ext_chg_evt_log_id
6702: ,prmtr_09
6703: FROM ben_ext_chg_evt_log
6704: WHERE chg_evt_cd = 'COPTP'
6705: AND person_id = p_person_id
6706: AND prmtr_01 = c_asg_id
6707: AND prmtr_02 = p_old_val1;

Line 6709: CURSOR c_del_log (c_asg_id IN ben_ext_chg_evt_log.prmtr_01%TYPE ) IS

6705: AND person_id = p_person_id
6706: AND prmtr_01 = c_asg_id
6707: AND prmtr_02 = p_old_val1;
6708:
6709: CURSOR c_del_log (c_asg_id IN ben_ext_chg_evt_log.prmtr_01%TYPE ) IS
6710: SELECT object_version_number
6711: ,ext_chg_evt_log_id
6712: FROM ben_ext_chg_evt_log
6713: WHERE chg_evt_cd = 'COPTP'

Line 6712: FROM ben_ext_chg_evt_log

6708:
6709: CURSOR c_del_log (c_asg_id IN ben_ext_chg_evt_log.prmtr_01%TYPE ) IS
6710: SELECT object_version_number
6711: ,ext_chg_evt_log_id
6712: FROM ben_ext_chg_evt_log
6713: WHERE chg_evt_cd = 'COPTP'
6714: AND person_id = p_person_id
6715: AND prmtr_01 = c_asg_id
6716: AND prmtr_02 = p_old_val1;

Line 6725: l_xst_log_rec ben_ext_chg_evt_log%ROWTYPE;

6721: l_ovn1 NUMBER;
6722: l_upd_ovn NUMBER;
6723: l_id NUMBER;
6724: l_id1 NUMBER;
6725: l_xst_log_rec ben_ext_chg_evt_log%ROWTYPE;
6726: l_asg_st_dt ben_ext_chg_evt_log.prmtr_04%TYPE;
6727: l_asg_ed_dt ben_ext_chg_evt_log.prmtr_05%TYPE;
6728: l_out_rep_dt DATE;
6729: l_reporting_dt ben_ext_chg_evt_log.prmtr_09%TYPE;

Line 6726: l_asg_st_dt ben_ext_chg_evt_log.prmtr_04%TYPE;

6722: l_upd_ovn NUMBER;
6723: l_id NUMBER;
6724: l_id1 NUMBER;
6725: l_xst_log_rec ben_ext_chg_evt_log%ROWTYPE;
6726: l_asg_st_dt ben_ext_chg_evt_log.prmtr_04%TYPE;
6727: l_asg_ed_dt ben_ext_chg_evt_log.prmtr_05%TYPE;
6728: l_out_rep_dt DATE;
6729: l_reporting_dt ben_ext_chg_evt_log.prmtr_09%TYPE;
6730: l_new_log_cre NUMBER;

Line 6727: l_asg_ed_dt ben_ext_chg_evt_log.prmtr_05%TYPE;

6723: l_id NUMBER;
6724: l_id1 NUMBER;
6725: l_xst_log_rec ben_ext_chg_evt_log%ROWTYPE;
6726: l_asg_st_dt ben_ext_chg_evt_log.prmtr_04%TYPE;
6727: l_asg_ed_dt ben_ext_chg_evt_log.prmtr_05%TYPE;
6728: l_out_rep_dt DATE;
6729: l_reporting_dt ben_ext_chg_evt_log.prmtr_09%TYPE;
6730: l_new_log_cre NUMBER;
6731: l_ret_val NUMBER;

Line 6729: l_reporting_dt ben_ext_chg_evt_log.prmtr_09%TYPE;

6725: l_xst_log_rec ben_ext_chg_evt_log%ROWTYPE;
6726: l_asg_st_dt ben_ext_chg_evt_log.prmtr_04%TYPE;
6727: l_asg_ed_dt ben_ext_chg_evt_log.prmtr_05%TYPE;
6728: l_out_rep_dt DATE;
6729: l_reporting_dt ben_ext_chg_evt_log.prmtr_09%TYPE;
6730: l_new_log_cre NUMBER;
6731: l_ret_val NUMBER;
6732:
6733: BEGIN

Line 6850: UPDATE ben_ext_chg_evt_log

6846: --
6847: -- Update the existing log with the changed part time percentages
6848: --
6849: hr_utility.set_location('GAA -- An existing row is found in the logs: ',10 );
6850: UPDATE ben_ext_chg_evt_log
6851: SET new_val1 = fnd_number.number_to_canonical(l_new_ptp)
6852: ,old_val1 = fnd_number.number_to_canonical(l_old_ptp)
6853: ,prmtr_09 = l_reporting_dt
6854: WHERE ext_chg_evt_log_id = l_xst_log_rec.ext_chg_evt_log_id;

Line 6959: UPDATE ben_ext_chg_evt_log

6955: --
6956: FOR upd_rec IN c_upd_log_kff_upd(c_asg_id => p_prmtr_01) LOOP
6957: IF trunc(fnd_date.canonical_to_date(upd_rec.prmtr_09)) =
6958: trunc(fnd_date.canonical_to_date(l_reporting_dt)) THEN
6959: UPDATE ben_ext_chg_evt_log
6960: SET prmtr_05 = fnd_date.date_to_canonical(TRUNC(p_chg_eff_dt)-1)
6961: ,prmtr_09 = l_reporting_dt
6962: WHERE ext_chg_evt_log_id = upd_rec.ext_chg_evt_log_id;
6963: ELSE

Line 6964: UPDATE ben_ext_chg_evt_log

6960: SET prmtr_05 = fnd_date.date_to_canonical(TRUNC(p_chg_eff_dt)-1)
6961: ,prmtr_09 = l_reporting_dt
6962: WHERE ext_chg_evt_log_id = upd_rec.ext_chg_evt_log_id;
6963: ELSE
6964: UPDATE ben_ext_chg_evt_log
6965: SET prmtr_05 = fnd_date.date_to_canonical(TRUNC(p_chg_eff_dt)-1)
6966: WHERE ext_chg_evt_log_id = upd_rec.ext_chg_evt_log_id;
6967: END IF;
6968: END LOOP;

Line 6979: UPDATE ben_ext_chg_evt_log

6975: IF l_new_log_cre = 0 THEN
6976: FOR upd_rec IN c_upd_log_kff(c_asg_id => p_prmtr_01) LOOP
6977: IF trunc(fnd_date.canonical_to_date(upd_rec.prmtr_09)) =
6978: trunc(fnd_date.canonical_to_date(l_reporting_dt)) THEN
6979: UPDATE ben_ext_chg_evt_log
6980: SET prmtr_02 = p_new_val1
6981: ,prmtr_09 = l_reporting_dt
6982: WHERE ext_chg_evt_log_id = upd_rec.ext_chg_evt_log_id;
6983: ELSE

Line 6984: UPDATE ben_ext_chg_evt_log

6980: SET prmtr_02 = p_new_val1
6981: ,prmtr_09 = l_reporting_dt
6982: WHERE ext_chg_evt_log_id = upd_rec.ext_chg_evt_log_id;
6983: ELSE
6984: UPDATE ben_ext_chg_evt_log
6985: SET prmtr_02 = p_new_val1
6986: WHERE ext_chg_evt_log_id = upd_rec.ext_chg_evt_log_id;
6987: END IF;
6988: END LOOP;

Line 6993: UPDATE ben_ext_chg_evt_log

6989: ELSIF l_new_log_cre = 1 THEN
6990: FOR upd_rec IN c_upd_log_kff_upd(c_asg_id => p_prmtr_01) LOOP
6991: IF trunc(fnd_date.canonical_to_date(upd_rec.prmtr_09)) =
6992: trunc(fnd_date.canonical_to_date(l_reporting_dt)) THEN
6993: UPDATE ben_ext_chg_evt_log
6994: SET prmtr_05 = fnd_date.date_to_canonical(TRUNC(p_chg_eff_dt)-1)
6995: ,prmtr_09 = l_reporting_dt
6996: WHERE ext_chg_evt_log_id = upd_rec.ext_chg_evt_log_id;
6997: ELSE

Line 6998: UPDATE ben_ext_chg_evt_log

6994: SET prmtr_05 = fnd_date.date_to_canonical(TRUNC(p_chg_eff_dt)-1)
6995: ,prmtr_09 = l_reporting_dt
6996: WHERE ext_chg_evt_log_id = upd_rec.ext_chg_evt_log_id;
6997: ELSE
6998: UPDATE ben_ext_chg_evt_log
6999: SET prmtr_05 = fnd_date.date_to_canonical(TRUNC(p_chg_eff_dt)-1)
7000: WHERE ext_chg_evt_log_id = upd_rec.ext_chg_evt_log_id;
7001: END IF;
7002: END LOOP;