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.BEN_PD_COPY_TO_BEN_FOUR dependencies on BEN_PD_COPY_TO_BEN_THREE

Line 452: BEN_PD_COPY_TO_BEN_three.log_nomapping_data(p_parent_table_alias =>'ELP'

448:
449: if l_ASSIGNMENT_SET_ID is null then
450: close c_EAN_min_max_dates;
451: --
452: BEN_PD_COPY_TO_BEN_three.log_nomapping_data(p_parent_table_alias =>'ELP'
453: ,p_parent_pk_id => r_EAN.information263
454: ,p_copy_entity_txn_id => p_copy_entity_txn_id
455: ,p_child_table_alias => 'EAN'
456: ,p_child_data => r_EAN.information173 );

Line 4473: BEN_PD_COPY_TO_BEN_three.log_nomapping_data(p_parent_table_alias =>'ELP'

4469:
4470: if l_COMPETENCE_ID is null or l_RATING_LEVEL_ID is null then
4471: close c_ECY_min_max_dates;
4472: --
4473: BEN_PD_COPY_TO_BEN_three.log_nomapping_data(p_parent_table_alias =>'ELP'
4474: ,p_parent_pk_id => r_ECY.information263
4475: ,p_copy_entity_txn_id => p_copy_entity_txn_id
4476: ,p_child_table_alias => 'ECY'
4477: ,p_child_data => r_ECY.information173 );

Line 4750: -- Print the Not Copied data to Log File BEN_PD_COPY_TO_BEN_THREE.G_NOT_COPIED_TBL

4746: end loop;
4747:
4748: /*
4749: ----------------------< DISPLAY START >---------------------------
4750: -- Print the Not Copied data to Log File BEN_PD_COPY_TO_BEN_THREE.G_NOT_COPIED_TBL
4751: --
4752: if l_not_copied_ecy_table_count > 0
4753: then
4754: --

Line 4771: ben_pd_copy_to_ben_three.g_not_copied_tbl(ben_pd_copy_to_ben_three.g_not_copied_tbl_count).text

4767: --
4768: close c_display_name;
4769: --
4770: --
4771: ben_pd_copy_to_ben_three.g_not_copied_tbl(ben_pd_copy_to_ben_three.g_not_copied_tbl_count).text
4772: := l_label_start_tag ||
4773: l_elp_display_name ||
4774: l_label_end_tag;
4775: --

Line 4776: ben_pd_copy_to_ben_three.g_not_copied_tbl_count := ben_pd_copy_to_ben_three.g_not_copied_tbl_count + 1;

4772: := l_label_start_tag ||
4773: l_elp_display_name ||
4774: l_label_end_tag;
4775: --
4776: ben_pd_copy_to_ben_three.g_not_copied_tbl_count := ben_pd_copy_to_ben_three.g_not_copied_tbl_count + 1;
4777: --
4778: FOR i IN l_not_copied_egl_tbl.FIRST .. l_not_copied_egl_tbl.LAST
4779: LOOP
4780: --

Line 4790: ben_pd_copy_to_ben_three.g_not_copied_tbl(ben_pd_copy_to_ben_three.g_not_copied_tbl_count).text

4786: fetch c_parent_data into l_elpro_name;
4787: --
4788: close c_parent_data;
4789: --
4790: ben_pd_copy_to_ben_three.g_not_copied_tbl(ben_pd_copy_to_ben_three.g_not_copied_tbl_count).text
4791: := l_para_spacer || l_elpro_name;
4792: --
4793: ben_pd_copy_to_ben_three.g_not_copied_tbl_count := ben_pd_copy_to_ben_three.g_not_copied_tbl_count + 1;
4794: --

Line 4793: ben_pd_copy_to_ben_three.g_not_copied_tbl_count := ben_pd_copy_to_ben_three.g_not_copied_tbl_count + 1;

4789: --
4790: ben_pd_copy_to_ben_three.g_not_copied_tbl(ben_pd_copy_to_ben_three.g_not_copied_tbl_count).text
4791: := l_para_spacer || l_elpro_name;
4792: --
4793: ben_pd_copy_to_ben_three.g_not_copied_tbl_count := ben_pd_copy_to_ben_three.g_not_copied_tbl_count + 1;
4794: --
4795: ben_pd_copy_to_ben_three.g_not_copied_tbl(ben_pd_copy_to_ben_three.g_not_copied_tbl_count).text
4796: := l_label_start_tag || l_para_spacer || l_para_spacer ||
4797: l_ecv_display_name ||

Line 4795: ben_pd_copy_to_ben_three.g_not_copied_tbl(ben_pd_copy_to_ben_three.g_not_copied_tbl_count).text

4791: := l_para_spacer || l_elpro_name;
4792: --
4793: ben_pd_copy_to_ben_three.g_not_copied_tbl_count := ben_pd_copy_to_ben_three.g_not_copied_tbl_count + 1;
4794: --
4795: ben_pd_copy_to_ben_three.g_not_copied_tbl(ben_pd_copy_to_ben_three.g_not_copied_tbl_count).text
4796: := l_label_start_tag || l_para_spacer || l_para_spacer ||
4797: l_ecv_display_name ||
4798: l_label_end_tag;
4799: --

Line 4800: ben_pd_copy_to_ben_three.g_not_copied_tbl_count := ben_pd_copy_to_ben_three.g_not_copied_tbl_count + 1;

4796: := l_label_start_tag || l_para_spacer || l_para_spacer ||
4797: l_ecv_display_name ||
4798: l_label_end_tag;
4799: --
4800: ben_pd_copy_to_ben_three.g_not_copied_tbl_count := ben_pd_copy_to_ben_three.g_not_copied_tbl_count + 1;
4801: --
4802: l_prev_parent_pk_id := l_not_copied_egl_tbl(i).eligy_prfl_id;
4803: --
4804: end if;

Line 4809: ben_pd_copy_to_ben_three.g_not_copied_tbl(ben_pd_copy_to_ben_three.g_not_copied_tbl_count).text

4805: --
4806: IF nvl(l_prev_ecy_id, -1) <> l_not_copied_egl_tbl(i).elig_comptncy_prte_id
4807: THEN
4808: --
4809: ben_pd_copy_to_ben_three.g_not_copied_tbl(ben_pd_copy_to_ben_three.g_not_copied_tbl_count).text
4810: := l_para_spacer ||
4811: l_para_spacer || l_para_spacer ||
4812: l_not_copied_egl_tbl(i).text;
4813: --

Line 4814: ben_pd_copy_to_ben_three.g_not_copied_tbl_count := ben_pd_copy_to_ben_three.g_not_copied_tbl_count + 1;

4810: := l_para_spacer ||
4811: l_para_spacer || l_para_spacer ||
4812: l_not_copied_egl_tbl(i).text;
4813: --
4814: ben_pd_copy_to_ben_three.g_not_copied_tbl_count := ben_pd_copy_to_ben_three.g_not_copied_tbl_count + 1;
4815: --
4816: l_prev_ecy_id := l_not_copied_egl_tbl(i).elig_comptncy_prte_id;
4817: --
4818: END IF;

Line 8075: BEN_PD_COPY_TO_BEN_three.log_nomapping_data(p_parent_table_alias =>'ELP'

8071:
8072: if l_JOB_ID is null then
8073: close c_EJP_min_max_dates;
8074: --
8075: BEN_PD_COPY_TO_BEN_three.log_nomapping_data(p_parent_table_alias =>'ELP'
8076: ,p_parent_pk_id => r_EJP.information263
8077: ,p_copy_entity_txn_id => p_copy_entity_txn_id
8078: ,p_child_table_alias => 'EJP'
8079: ,p_child_data => r_EJP.information173 );

Line 9081: BEN_PD_COPY_TO_BEN_three.log_nomapping_data(p_parent_table_alias =>'ELP'

9077: --
9078: if l_ORGANIZATION_ID is null then
9079: close c_ELN_min_max_dates;
9080: --
9081: BEN_PD_COPY_TO_BEN_three.log_nomapping_data(p_parent_table_alias =>'ELP'
9082: ,p_parent_pk_id => r_ELN.information263
9083: ,p_copy_entity_txn_id => p_copy_entity_txn_id
9084: ,p_child_table_alias => 'ELN'
9085: ,p_child_data => r_ELN.information173 );

Line 9630: BEN_PD_COPY_TO_BEN_three.log_nomapping_data(p_parent_table_alias =>'ELP'

9626:
9627: if l_ABSENCE_ATTENDANCE_TYPE_ID is null then
9628: close c_ELR_min_max_dates;
9629: --
9630: BEN_PD_COPY_TO_BEN_three.log_nomapping_data(p_parent_table_alias =>'ELP'
9631: ,p_parent_pk_id => r_ELR.information263
9632: ,p_copy_entity_txn_id => p_copy_entity_txn_id
9633: ,p_child_table_alias => 'ELR'
9634: ,p_child_data => r_ELR.information173 );

Line 12606: BEN_PD_COPY_TO_BEN_three.log_nomapping_data(p_parent_table_alias =>'ELP'

12602: --
12603: if l_ORGANIZATION_ID is null then
12604: close c_EOU_min_max_dates;
12605: --
12606: BEN_PD_COPY_TO_BEN_three.log_nomapping_data(p_parent_table_alias =>'ELP'
12607: ,p_parent_pk_id => r_EOU.information263
12608: ,p_copy_entity_txn_id => p_copy_entity_txn_id
12609: ,p_child_table_alias => 'EOU'
12610: ,p_child_data => r_EOU.information173 );

Line 14128: BEN_PD_COPY_TO_BEN_three.log_nomapping_data(p_parent_table_alias =>'ELP'

14124:
14125: if l_PERSON_TYPE_ID is null then
14126: close c_EPT_min_max_dates;
14127: --
14128: BEN_PD_COPY_TO_BEN_three.log_nomapping_data(p_parent_table_alias =>'ELP'
14129: ,p_parent_pk_id => r_EPT.information263
14130: ,p_copy_entity_txn_id => p_copy_entity_txn_id
14131: ,p_child_table_alias => 'EPT'
14132: ,p_child_data => r_EPT.information173 );

Line 15149: BEN_PD_COPY_TO_BEN_three.log_nomapping_data(p_parent_table_alias =>'ELP'

15145: --
15146: if l_PAY_BASIS_ID is null then
15147: close c_EPB_min_max_dates;
15148: --
15149: BEN_PD_COPY_TO_BEN_three.log_nomapping_data(p_parent_table_alias =>'ELP'
15150: ,p_parent_pk_id => r_EPB.information263
15151: ,p_copy_entity_txn_id => p_copy_entity_txn_id
15152: ,p_child_table_alias => 'EPB'
15153: ,p_child_data => r_EPB.information173 );

Line 16663: BEN_PD_COPY_TO_BEN_three.log_nomapping_data(p_parent_table_alias =>'ELP'

16659: --
16660: if l_POSITION_ID is null then
16661: close c_EPS_min_max_dates;
16662: --
16663: BEN_PD_COPY_TO_BEN_three.log_nomapping_data(p_parent_table_alias =>'ELP'
16664: ,p_parent_pk_id => r_EPS.information263
16665: ,p_copy_entity_txn_id => p_copy_entity_txn_id
16666: ,p_child_table_alias => 'EPS'
16667: ,p_child_data => r_EPS.information173 );

Line 17179: BEN_PD_COPY_TO_BEN_three.log_nomapping_data(p_parent_table_alias =>'ELP'

17175: --
17176: if l_PAYROLL_ID is null then
17177: close c_EPY_min_max_dates;
17178: --
17179: BEN_PD_COPY_TO_BEN_three.log_nomapping_data(p_parent_table_alias =>'ELP'
17180: ,p_parent_pk_id => r_EPY.information263
17181: ,p_copy_entity_txn_id => p_copy_entity_txn_id
17182: ,p_child_table_alias => 'EPY'
17183: ,p_child_data => r_EPY.information173 );

Line 18176: BEN_PD_COPY_TO_BEN_three.log_nomapping_data(p_parent_table_alias =>'ELP'

18172: --
18173: if l_QUALIFICATION_TYPE_ID is null then
18174: close c_EQT_min_max_dates;
18175: --
18176: BEN_PD_COPY_TO_BEN_three.log_nomapping_data(p_parent_table_alias =>'ELP'
18177: ,p_parent_pk_id => r_EQT.information263
18178: ,p_copy_entity_txn_id => p_copy_entity_txn_id
18179: ,p_child_table_alias => 'EQT'
18180: ,p_child_data => r_EQT.information173 );

Line 19759: BEN_PD_COPY_TO_BEN_three.log_nomapping_data(p_parent_table_alias =>'ELP'

19755:
19756: if l_SPECIAL_CEILING_STEP_ID is null then
19757: close c_ESP_min_max_dates;
19758: --
19759: BEN_PD_COPY_TO_BEN_three.log_nomapping_data(p_parent_table_alias =>'ELP'
19760: ,p_parent_pk_id => r_ESP.information263
19761: ,p_copy_entity_txn_id => p_copy_entity_txn_id
19762: ,p_child_table_alias => 'ESP'
19763: ,p_child_data => r_ESP.information173 );

Line 20283: BEN_PD_COPY_TO_BEN_three.log_nomapping_data(p_parent_table_alias =>'ELP'

20279:
20280: if l_JOB_GROUP_ID is null or l_JOB_ID is null then
20281: close c_EST_min_max_dates;
20282: --
20283: BEN_PD_COPY_TO_BEN_three.log_nomapping_data(p_parent_table_alias =>'ELP'
20284: ,p_parent_pk_id => r_EST.information263
20285: ,p_copy_entity_txn_id => p_copy_entity_txn_id
20286: ,p_child_table_alias => 'EST'
20287: ,p_child_data => r_EST.information173 );

Line 20797: BEN_PD_COPY_TO_BEN_three.log_nomapping_data(p_parent_table_alias =>'ELP'

20793:
20794: if l_LOCATION_ID is null then
20795: close c_EWL_min_max_dates;
20796: --
20797: BEN_PD_COPY_TO_BEN_three.log_nomapping_data(p_parent_table_alias =>'ELP'
20798: ,p_parent_pk_id => r_EWL.information263
20799: ,p_copy_entity_txn_id => p_copy_entity_txn_id
20800: ,p_child_table_alias => 'EWL'
20801: ,p_child_data => r_EWL.information173 );

Line 23359: BEN_PD_COPY_TO_BEN_three.log_nomapping_data(p_parent_table_alias =>'ELP'

23355: --
23356: if l_ASSIGNMENT_STATUS_TYPE_ID is null then
23357: close c_EES_min_max_dates;
23358: --
23359: BEN_PD_COPY_TO_BEN_three.log_nomapping_data(p_parent_table_alias =>'ELP'
23360: ,p_parent_pk_id => r_EES.information263
23361: ,p_copy_entity_txn_id => p_copy_entity_txn_id
23362: ,p_child_table_alias => 'EES'
23363: ,p_child_data => r_EES.information173 );

Line 26862: BEN_PD_COPY_TO_BEN_three.log_nomapping_data(p_parent_table_alias =>'ELP'

26858:
26859: if l_GRADE_ID is null then
26860: close c_EGR_min_max_dates;
26861: --
26862: BEN_PD_COPY_TO_BEN_three.log_nomapping_data(p_parent_table_alias =>'ELP'
26863: ,p_parent_pk_id => r_EGR.information263
26864: ,p_copy_entity_txn_id => p_copy_entity_txn_id
26865: ,p_child_table_alias => 'EGR'
26866: ,p_child_data => r_EGR.information173 );

Line 33027: -- Print the Not Copied data to Log File BEN_PD_COPY_TO_BEN_THREE.G_NOT_COPIED_TBL

33023: END LOOP;
33024: --
33025: --
33026: ----------------------< DISPLAY START >---------------------------
33027: -- Print the Not Copied data to Log File BEN_PD_COPY_TO_BEN_THREE.G_NOT_COPIED_TBL
33028: --
33029: if l_not_copied_egl_table_count > 0
33030: then
33031: --

Line 33048: ben_pd_copy_to_ben_three.g_not_copied_tbl(ben_pd_copy_to_ben_three.g_not_copied_tbl_count).text

33044: --
33045: close c_display_name;
33046: --
33047: --
33048: ben_pd_copy_to_ben_three.g_not_copied_tbl(ben_pd_copy_to_ben_three.g_not_copied_tbl_count).text
33049: := l_label_start_tag ||
33050: l_elp_display_name ||
33051: l_label_end_tag;
33052: --

Line 33053: ben_pd_copy_to_ben_three.g_not_copied_tbl_count := ben_pd_copy_to_ben_three.g_not_copied_tbl_count + 1;

33049: := l_label_start_tag ||
33050: l_elp_display_name ||
33051: l_label_end_tag;
33052: --
33053: ben_pd_copy_to_ben_three.g_not_copied_tbl_count := ben_pd_copy_to_ben_three.g_not_copied_tbl_count + 1;
33054: --
33055: FOR i IN l_not_copied_egl_tbl.FIRST .. l_not_copied_egl_tbl.LAST
33056: LOOP
33057: --

Line 33067: ben_pd_copy_to_ben_three.g_not_copied_tbl(ben_pd_copy_to_ben_three.g_not_copied_tbl_count).text

33063: fetch c_parent_data into l_elpro_name;
33064: --
33065: close c_parent_data;
33066: --
33067: ben_pd_copy_to_ben_three.g_not_copied_tbl(ben_pd_copy_to_ben_three.g_not_copied_tbl_count).text
33068: := l_para_spacer || l_elpro_name;
33069: --
33070: ben_pd_copy_to_ben_three.g_not_copied_tbl_count := ben_pd_copy_to_ben_three.g_not_copied_tbl_count + 1;
33071: --

Line 33070: ben_pd_copy_to_ben_three.g_not_copied_tbl_count := ben_pd_copy_to_ben_three.g_not_copied_tbl_count + 1;

33066: --
33067: ben_pd_copy_to_ben_three.g_not_copied_tbl(ben_pd_copy_to_ben_three.g_not_copied_tbl_count).text
33068: := l_para_spacer || l_elpro_name;
33069: --
33070: ben_pd_copy_to_ben_three.g_not_copied_tbl_count := ben_pd_copy_to_ben_three.g_not_copied_tbl_count + 1;
33071: --
33072: ben_pd_copy_to_ben_three.g_not_copied_tbl(ben_pd_copy_to_ben_three.g_not_copied_tbl_count).text
33073: := l_label_start_tag || l_para_spacer || l_para_spacer ||
33074: l_ecv_display_name ||

Line 33072: ben_pd_copy_to_ben_three.g_not_copied_tbl(ben_pd_copy_to_ben_three.g_not_copied_tbl_count).text

33068: := l_para_spacer || l_elpro_name;
33069: --
33070: ben_pd_copy_to_ben_three.g_not_copied_tbl_count := ben_pd_copy_to_ben_three.g_not_copied_tbl_count + 1;
33071: --
33072: ben_pd_copy_to_ben_three.g_not_copied_tbl(ben_pd_copy_to_ben_three.g_not_copied_tbl_count).text
33073: := l_label_start_tag || l_para_spacer || l_para_spacer ||
33074: l_ecv_display_name ||
33075: l_label_end_tag;
33076: --

Line 33077: ben_pd_copy_to_ben_three.g_not_copied_tbl_count := ben_pd_copy_to_ben_three.g_not_copied_tbl_count + 1;

33073: := l_label_start_tag || l_para_spacer || l_para_spacer ||
33074: l_ecv_display_name ||
33075: l_label_end_tag;
33076: --
33077: ben_pd_copy_to_ben_three.g_not_copied_tbl_count := ben_pd_copy_to_ben_three.g_not_copied_tbl_count + 1;
33078: --
33079: l_prev_parent_pk_id := l_not_copied_egl_tbl(i).eligy_prfl_id;
33080: --
33081: end if;

Line 33086: ben_pd_copy_to_ben_three.g_not_copied_tbl(ben_pd_copy_to_ben_three.g_not_copied_tbl_count).text

33082: --
33083: IF nvl(l_prev_ecv_id, -1) <> l_not_copied_egl_tbl(i).eligy_crit_values_id
33084: THEN
33085: --
33086: ben_pd_copy_to_ben_three.g_not_copied_tbl(ben_pd_copy_to_ben_three.g_not_copied_tbl_count).text
33087: := l_para_spacer ||
33088: l_para_spacer || l_para_spacer ||
33089: l_not_copied_egl_tbl(i).text;
33090: --

Line 33091: ben_pd_copy_to_ben_three.g_not_copied_tbl_count := ben_pd_copy_to_ben_three.g_not_copied_tbl_count + 1;

33087: := l_para_spacer ||
33088: l_para_spacer || l_para_spacer ||
33089: l_not_copied_egl_tbl(i).text;
33090: --
33091: ben_pd_copy_to_ben_three.g_not_copied_tbl_count := ben_pd_copy_to_ben_three.g_not_copied_tbl_count + 1;
33092: --
33093: l_prev_ecv_id := l_not_copied_egl_tbl(i).eligy_crit_values_id;
33094: --
33095: END IF;