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_ONE dependencies on PQH_COPY_ENTITY_ATTRIBS

Line 1248: l_prefix pqh_copy_entity_attribs.information1%TYPE

1244: l_formula_id NUMBER;
1245: l_object_version_number NUMBER;
1246: l_effective_start_date DATE;
1247: l_effective_end_date DATE;
1248: l_prefix pqh_copy_entity_attribs.information1%TYPE
1249: := NULL;
1250: l_suffix pqh_copy_entity_attribs.information1%TYPE
1251: := NULL;
1252: l_new_value NUMBER (15);

Line 1250: l_suffix pqh_copy_entity_attribs.information1%TYPE

1246: l_effective_start_date DATE;
1247: l_effective_end_date DATE;
1248: l_prefix pqh_copy_entity_attribs.information1%TYPE
1249: := NULL;
1250: l_suffix pqh_copy_entity_attribs.information1%TYPE
1251: := NULL;
1252: l_new_value NUMBER (15);
1253: l_object_found_in_target BOOLEAN := FALSE;
1254: l_min_esd DATE;

Line 1749: l_prefix pqh_copy_entity_attribs.information1%type := null;

1745: l_actn_typ_id number ;
1746: l_object_version_number number ;
1747: l_effective_start_date date ;
1748: l_effective_end_date date ;
1749: l_prefix pqh_copy_entity_attribs.information1%type := null;
1750: l_suffix pqh_copy_entity_attribs.information1%type := null;
1751: l_new_value number(15);
1752: l_object_found_in_target boolean := false ;
1753: l_min_esd date;

Line 1750: l_suffix pqh_copy_entity_attribs.information1%type := null;

1746: l_object_version_number number ;
1747: l_effective_start_date date ;
1748: l_effective_end_date date ;
1749: l_prefix pqh_copy_entity_attribs.information1%type := null;
1750: l_suffix pqh_copy_entity_attribs.information1%type := null;
1751: l_new_value number(15);
1752: l_object_found_in_target boolean := false ;
1753: l_min_esd date;
1754: l_max_eed date;

Line 2052: l_prefix pqh_copy_entity_attribs.information1%type := null;

2048: l_cmbn_plip_id number ;
2049: l_object_version_number number ;
2050: l_effective_start_date date ;
2051: l_effective_end_date date ;
2052: l_prefix pqh_copy_entity_attribs.information1%type := null;
2053: l_suffix pqh_copy_entity_attribs.information1%type := null;
2054: l_new_value number(15);
2055: l_object_found_in_target boolean := false ;
2056: l_min_esd date;

Line 2053: l_suffix pqh_copy_entity_attribs.information1%type := null;

2049: l_object_version_number number ;
2050: l_effective_start_date date ;
2051: l_effective_end_date date ;
2052: l_prefix pqh_copy_entity_attribs.information1%type := null;
2053: l_suffix pqh_copy_entity_attribs.information1%type := null;
2054: l_new_value number(15);
2055: l_object_found_in_target boolean := false ;
2056: l_min_esd date;
2057: l_max_eed date;

Line 2569: l_prefix pqh_copy_entity_attribs.information1%type := null;

2565: l_cmbn_ptip_id number ;
2566: l_object_version_number number ;
2567: l_effective_start_date date ;
2568: l_effective_end_date date ;
2569: l_prefix pqh_copy_entity_attribs.information1%type := null;
2570: l_suffix pqh_copy_entity_attribs.information1%type := null;
2571: l_new_value number(15);
2572: l_object_found_in_target boolean := false ;
2573: l_min_esd date;

Line 2570: l_suffix pqh_copy_entity_attribs.information1%type := null;

2566: l_object_version_number number ;
2567: l_effective_start_date date ;
2568: l_effective_end_date date ;
2569: l_prefix pqh_copy_entity_attribs.information1%type := null;
2570: l_suffix pqh_copy_entity_attribs.information1%type := null;
2571: l_new_value number(15);
2572: l_object_found_in_target boolean := false ;
2573: l_min_esd date;
2574: l_max_eed date;

Line 3050: l_prefix pqh_copy_entity_attribs.information1%type := null;

3046: l_cmbn_ptip_opt_id number ;
3047: l_object_version_number number ;
3048: l_effective_start_date date ;
3049: l_effective_end_date date ;
3050: l_prefix pqh_copy_entity_attribs.information1%type := null;
3051: l_suffix pqh_copy_entity_attribs.information1%type := null;
3052: l_new_value number(15);
3053: l_object_found_in_target boolean := false ;
3054: l_min_esd date;

Line 3051: l_suffix pqh_copy_entity_attribs.information1%type := null;

3047: l_object_version_number number ;
3048: l_effective_start_date date ;
3049: l_effective_end_date date ;
3050: l_prefix pqh_copy_entity_attribs.information1%type := null;
3051: l_suffix pqh_copy_entity_attribs.information1%type := null;
3052: l_new_value number(15);
3053: l_object_found_in_target boolean := false ;
3054: l_min_esd date;
3055: l_max_eed date;

Line 3552: l_prefix pqh_copy_entity_attribs.information1%type := null;

3548: l_bnfts_bal_id number ;
3549: l_object_version_number number ;
3550: l_effective_start_date date ;
3551: l_effective_end_date date ;
3552: l_prefix pqh_copy_entity_attribs.information1%type := null;
3553: l_suffix pqh_copy_entity_attribs.information1%type := null;
3554: l_new_value number(15);
3555: l_object_found_in_target boolean := false ;
3556: l_min_esd date;

Line 3553: l_suffix pqh_copy_entity_attribs.information1%type := null;

3549: l_object_version_number number ;
3550: l_effective_start_date date ;
3551: l_effective_end_date date ;
3552: l_prefix pqh_copy_entity_attribs.information1%type := null;
3553: l_suffix pqh_copy_entity_attribs.information1%type := null;
3554: l_new_value number(15);
3555: l_object_found_in_target boolean := false ;
3556: l_min_esd date;
3557: l_max_eed date;

Line 4002: l_prefix pqh_copy_entity_attribs.information1%type := null;

3998: l_comp_lvl_fctr_id number ;
3999: l_object_version_number number ;
4000: l_effective_start_date date ;
4001: l_effective_end_date date ;
4002: l_prefix pqh_copy_entity_attribs.information1%type := null;
4003: l_suffix pqh_copy_entity_attribs.information1%type := null;
4004: l_new_value number(15);
4005: l_object_found_in_target boolean := false ;
4006: l_min_esd date;

Line 4003: l_suffix pqh_copy_entity_attribs.information1%type := null;

3999: l_object_version_number number ;
4000: l_effective_start_date date ;
4001: l_effective_end_date date ;
4002: l_prefix pqh_copy_entity_attribs.information1%type := null;
4003: l_suffix pqh_copy_entity_attribs.information1%type := null;
4004: l_new_value number(15);
4005: l_object_found_in_target boolean := false ;
4006: l_min_esd date;
4007: l_max_eed date;

Line 4438: l_prefix pqh_copy_entity_attribs.information1%type := null;

4434: l_hrs_wkd_in_perd_fctr_id number ;
4435: l_object_version_number number ;
4436: l_effective_start_date date ;
4437: l_effective_end_date date ;
4438: l_prefix pqh_copy_entity_attribs.information1%type := null;
4439: l_suffix pqh_copy_entity_attribs.information1%type := null;
4440: l_new_value number(15);
4441: l_object_found_in_target boolean := false ;
4442: l_min_esd date;

Line 4439: l_suffix pqh_copy_entity_attribs.information1%type := null;

4435: l_object_version_number number ;
4436: l_effective_start_date date ;
4437: l_effective_end_date date ;
4438: l_prefix pqh_copy_entity_attribs.information1%type := null;
4439: l_suffix pqh_copy_entity_attribs.information1%type := null;
4440: l_new_value number(15);
4441: l_object_found_in_target boolean := false ;
4442: l_min_esd date;
4443: l_max_eed date;

Line 4855: l_prefix pqh_copy_entity_attribs.information1%type := null;

4851: l_age_fctr_id number ;
4852: l_object_version_number number ;
4853: l_effective_start_date date ;
4854: l_effective_end_date date ;
4855: l_prefix pqh_copy_entity_attribs.information1%type := null;
4856: l_suffix pqh_copy_entity_attribs.information1%type := null;
4857: l_new_value number(15);
4858: l_object_found_in_target boolean := false ;
4859: l_min_esd date;

Line 4856: l_suffix pqh_copy_entity_attribs.information1%type := null;

4852: l_object_version_number number ;
4853: l_effective_start_date date ;
4854: l_effective_end_date date ;
4855: l_prefix pqh_copy_entity_attribs.information1%type := null;
4856: l_suffix pqh_copy_entity_attribs.information1%type := null;
4857: l_new_value number(15);
4858: l_object_found_in_target boolean := false ;
4859: l_min_esd date;
4860: l_max_eed date;

Line 5221: l_prefix pqh_copy_entity_attribs.information1%type := null;

5217: l_los_fctr_id number ;
5218: l_object_version_number number ;
5219: l_effective_start_date date ;
5220: l_effective_end_date date ;
5221: l_prefix pqh_copy_entity_attribs.information1%type := null;
5222: l_suffix pqh_copy_entity_attribs.information1%type := null;
5223: l_new_value number(15);
5224: l_object_found_in_target boolean := false ;
5225: l_min_esd date;

Line 5222: l_suffix pqh_copy_entity_attribs.information1%type := null;

5218: l_object_version_number number ;
5219: l_effective_start_date date ;
5220: l_effective_end_date date ;
5221: l_prefix pqh_copy_entity_attribs.information1%type := null;
5222: l_suffix pqh_copy_entity_attribs.information1%type := null;
5223: l_new_value number(15);
5224: l_object_found_in_target boolean := false ;
5225: l_min_esd date;
5226: l_max_eed date;

Line 5585: l_prefix pqh_copy_entity_attribs.information1%type := null;

5581: l_pct_fl_tm_fctr_id number ;
5582: l_object_version_number number ;
5583: l_effective_start_date date ;
5584: l_effective_end_date date ;
5585: l_prefix pqh_copy_entity_attribs.information1%type := null;
5586: l_suffix pqh_copy_entity_attribs.information1%type := null;
5587: l_new_value number(15);
5588: l_object_found_in_target boolean := false ;
5589: l_min_esd date;

Line 5586: l_suffix pqh_copy_entity_attribs.information1%type := null;

5582: l_object_version_number number ;
5583: l_effective_start_date date ;
5584: l_effective_end_date date ;
5585: l_prefix pqh_copy_entity_attribs.information1%type := null;
5586: l_suffix pqh_copy_entity_attribs.information1%type := null;
5587: l_new_value number(15);
5588: l_object_found_in_target boolean := false ;
5589: l_min_esd date;
5590: l_max_eed date;

Line 5929: l_prefix pqh_copy_entity_attribs.information1%type := null;

5925: l_cmbn_age_los_fctr_id number ;
5926: l_object_version_number number ;
5927: l_effective_start_date date ;
5928: l_effective_end_date date ;
5929: l_prefix pqh_copy_entity_attribs.information1%type := null;
5930: l_suffix pqh_copy_entity_attribs.information1%type := null;
5931: l_new_value number(15);
5932: l_object_found_in_target boolean := false ;
5933: l_min_esd date;

Line 5930: l_suffix pqh_copy_entity_attribs.information1%type := null;

5926: l_object_version_number number ;
5927: l_effective_start_date date ;
5928: l_effective_end_date date ;
5929: l_prefix pqh_copy_entity_attribs.information1%type := null;
5930: l_suffix pqh_copy_entity_attribs.information1%type := null;
5931: l_new_value number(15);
5932: l_object_found_in_target boolean := false ;
5933: l_min_esd date;
5934: l_max_eed date;

Line 6296: l_prefix pqh_copy_entity_attribs.information1%type := null;

6292: l_pl_typ_id number ;
6293: l_object_version_number number ;
6294: l_effective_start_date date ;
6295: l_effective_end_date date ;
6296: l_prefix pqh_copy_entity_attribs.information1%type := null;
6297: l_suffix pqh_copy_entity_attribs.information1%type := null;
6298: l_new_value number(15);
6299: l_object_found_in_target boolean := false ;
6300: l_min_esd date;

Line 6297: l_suffix pqh_copy_entity_attribs.information1%type := null;

6293: l_object_version_number number ;
6294: l_effective_start_date date ;
6295: l_effective_end_date date ;
6296: l_prefix pqh_copy_entity_attribs.information1%type := null;
6297: l_suffix pqh_copy_entity_attribs.information1%type := null;
6298: l_new_value number(15);
6299: l_object_found_in_target boolean := false ;
6300: l_min_esd date;
6301: l_max_eed date;

Line 6772: l_prefix pqh_copy_entity_attribs.information1%type := null;

6768: l_pgm_id number ;
6769: l_object_version_number number ;
6770: l_effective_start_date date ;
6771: l_effective_end_date date ;
6772: l_prefix pqh_copy_entity_attribs.information1%type := null;
6773: l_suffix pqh_copy_entity_attribs.information1%type := null;
6774: l_new_value number(15);
6775: l_object_found_in_target boolean := false ;
6776: l_min_esd date;

Line 6773: l_suffix pqh_copy_entity_attribs.information1%type := null;

6769: l_object_version_number number ;
6770: l_effective_start_date date ;
6771: l_effective_end_date date ;
6772: l_prefix pqh_copy_entity_attribs.information1%type := null;
6773: l_suffix pqh_copy_entity_attribs.information1%type := null;
6774: l_new_value number(15);
6775: l_object_found_in_target boolean := false ;
6776: l_min_esd date;
6777: l_max_eed date;

Line 7435: l_prefix pqh_copy_entity_attribs.information1%type := null;

7431: l_regn_id number ;
7432: l_object_version_number number ;
7433: l_effective_start_date date ;
7434: l_effective_end_date date ;
7435: l_prefix pqh_copy_entity_attribs.information1%type := null;
7436: l_suffix pqh_copy_entity_attribs.information1%type := null;
7437: l_new_value number(15);
7438: l_object_found_in_target boolean := false ;
7439: l_min_esd date;

Line 7436: l_suffix pqh_copy_entity_attribs.information1%type := null;

7432: l_object_version_number number ;
7433: l_effective_start_date date ;
7434: l_effective_end_date date ;
7435: l_prefix pqh_copy_entity_attribs.information1%type := null;
7436: l_suffix pqh_copy_entity_attribs.information1%type := null;
7437: l_new_value number(15);
7438: l_object_found_in_target boolean := false ;
7439: l_min_esd date;
7440: l_max_eed date;

Line 7832: l_prefix pqh_copy_entity_attribs.information1%type := null;

7828: l_pstl_zip_rng_id number ;
7829: l_object_version_number number ;
7830: l_effective_start_date date ;
7831: l_effective_end_date date ;
7832: l_prefix pqh_copy_entity_attribs.information1%type := null;
7833: l_suffix pqh_copy_entity_attribs.information1%type := null;
7834: l_new_value number(15);
7835: l_object_found_in_target boolean := false ;
7836: l_min_esd date;

Line 7833: l_suffix pqh_copy_entity_attribs.information1%type := null;

7829: l_object_version_number number ;
7830: l_effective_start_date date ;
7831: l_effective_end_date date ;
7832: l_prefix pqh_copy_entity_attribs.information1%type := null;
7833: l_suffix pqh_copy_entity_attribs.information1%type := null;
7834: l_new_value number(15);
7835: l_object_found_in_target boolean := false ;
7836: l_min_esd date;
7837: l_max_eed date;

Line 8268: l_prefix pqh_copy_entity_attribs.information1%type := null;

8264: l_object_version_number number ;
8265: l_business_group_id number ;
8266: l_effective_start_date date ;
8267: l_effective_end_date date ;
8268: l_prefix pqh_copy_entity_attribs.information1%type := null;
8269: l_suffix pqh_copy_entity_attribs.information1%type := null;
8270: l_new_value number(15);
8271: l_object_found_in_target boolean := false ;
8272: l_min_esd date;

Line 8269: l_suffix pqh_copy_entity_attribs.information1%type := null;

8265: l_business_group_id number ;
8266: l_effective_start_date date ;
8267: l_effective_end_date date ;
8268: l_prefix pqh_copy_entity_attribs.information1%type := null;
8269: l_suffix pqh_copy_entity_attribs.information1%type := null;
8270: l_new_value number(15);
8271: l_object_found_in_target boolean := false ;
8272: l_min_esd date;
8273: l_max_eed date;

Line 8628: l_prefix pqh_copy_entity_attribs.information1%type := null;

8624: l_rltd_per_chg_cs_ler_id number ;
8625: l_object_version_number number ;
8626: l_effective_start_date date ;
8627: l_effective_end_date date ;
8628: l_prefix pqh_copy_entity_attribs.information1%type := null;
8629: l_suffix pqh_copy_entity_attribs.information1%type := null;
8630: l_new_value number(15);
8631: l_object_found_in_target boolean := false ;
8632: l_min_esd date;

Line 8629: l_suffix pqh_copy_entity_attribs.information1%type := null;

8625: l_object_version_number number ;
8626: l_effective_start_date date ;
8627: l_effective_end_date date ;
8628: l_prefix pqh_copy_entity_attribs.information1%type := null;
8629: l_suffix pqh_copy_entity_attribs.information1%type := null;
8630: l_new_value number(15);
8631: l_object_found_in_target boolean := false ;
8632: l_min_esd date;
8633: l_max_eed date;

Line 9106: l_prefix pqh_copy_entity_attribs.information1%type := null;

9102: l_opt_id number ;
9103: l_object_version_number number ;
9104: l_effective_start_date date ;
9105: l_effective_end_date date ;
9106: l_prefix pqh_copy_entity_attribs.information1%type := null;
9107: l_suffix pqh_copy_entity_attribs.information1%type := null;
9108: l_new_value number(15);
9109: l_object_found_in_target boolean := false ;
9110: l_min_esd date;

Line 9107: l_suffix pqh_copy_entity_attribs.information1%type := null;

9103: l_object_version_number number ;
9104: l_effective_start_date date ;
9105: l_effective_end_date date ;
9106: l_prefix pqh_copy_entity_attribs.information1%type := null;
9107: l_suffix pqh_copy_entity_attribs.information1%type := null;
9108: l_new_value number(15);
9109: l_object_found_in_target boolean := false ;
9110: l_min_esd date;
9111: l_max_eed date;

Line 9693: l_prefix pqh_copy_entity_attribs.information1%type := null;

9689: l_ler_id number ;
9690: l_object_version_number number ;
9691: l_effective_start_date date ;
9692: l_effective_end_date date ;
9693: l_prefix pqh_copy_entity_attribs.information1%type := null;
9694: l_suffix pqh_copy_entity_attribs.information1%type := null;
9695: l_new_value number(15);
9696: l_object_found_in_target boolean := false ;
9697: l_min_esd date;

Line 9694: l_suffix pqh_copy_entity_attribs.information1%type := null;

9690: l_object_version_number number ;
9691: l_effective_start_date date ;
9692: l_effective_end_date date ;
9693: l_prefix pqh_copy_entity_attribs.information1%type := null;
9694: l_suffix pqh_copy_entity_attribs.information1%type := null;
9695: l_new_value number(15);
9696: l_object_found_in_target boolean := false ;
9697: l_min_esd date;
9698: l_max_eed date;

Line 10279: l_prefix pqh_copy_entity_attribs.information1%type := null;

10275: l_ler_per_info_cs_ler_id number ;
10276: l_object_version_number number ;
10277: l_effective_start_date date ;
10278: l_effective_end_date date ;
10279: l_prefix pqh_copy_entity_attribs.information1%type := null;
10280: l_suffix pqh_copy_entity_attribs.information1%type := null;
10281: l_new_value number(15);
10282: l_object_found_in_target boolean := false ;
10283: l_min_esd date;

Line 10280: l_suffix pqh_copy_entity_attribs.information1%type := null;

10276: l_object_version_number number ;
10277: l_effective_start_date date ;
10278: l_effective_end_date date ;
10279: l_prefix pqh_copy_entity_attribs.information1%type := null;
10280: l_suffix pqh_copy_entity_attribs.information1%type := null;
10281: l_new_value number(15);
10282: l_object_found_in_target boolean := false ;
10283: l_min_esd date;
10284: l_max_eed date;

Line 10741: l_prefix pqh_copy_entity_attribs.information1%type := null;

10737: l_eligy_prfl_id number ;
10738: l_object_version_number number ;
10739: l_effective_start_date date ;
10740: l_effective_end_date date ;
10741: l_prefix pqh_copy_entity_attribs.information1%type := null;
10742: l_suffix pqh_copy_entity_attribs.information1%type := null;
10743: l_new_value number(15);
10744: l_object_found_in_target boolean := false ;
10745: l_min_esd date;

Line 10742: l_suffix pqh_copy_entity_attribs.information1%type := null;

10738: l_object_version_number number ;
10739: l_effective_start_date date ;
10740: l_effective_end_date date ;
10741: l_prefix pqh_copy_entity_attribs.information1%type := null;
10742: l_suffix pqh_copy_entity_attribs.information1%type := null;
10743: l_new_value number(15);
10744: l_object_found_in_target boolean := false ;
10745: l_min_esd date;
10746: l_max_eed date;

Line 11327: l_prefix pqh_copy_entity_attribs.information1%type := null;

11323: l_dpnt_cvg_eligy_prfl_id number ;
11324: l_object_version_number number ;
11325: l_effective_start_date date ;
11326: l_effective_end_date date ;
11327: l_prefix pqh_copy_entity_attribs.information1%type := null;
11328: l_suffix pqh_copy_entity_attribs.information1%type := null;
11329: l_new_value number(15);
11330: l_object_found_in_target boolean := false ;
11331: l_min_esd date;

Line 11328: l_suffix pqh_copy_entity_attribs.information1%type := null;

11324: l_object_version_number number ;
11325: l_effective_start_date date ;
11326: l_effective_end_date date ;
11327: l_prefix pqh_copy_entity_attribs.information1%type := null;
11328: l_suffix pqh_copy_entity_attribs.information1%type := null;
11329: l_new_value number(15);
11330: l_object_found_in_target boolean := false ;
11331: l_min_esd date;
11332: l_max_eed date;

Line 11786: l_prefix pqh_copy_entity_attribs.information1%type := null;

11782: l_gd_or_svc_typ_id number ;
11783: l_object_version_number number ;
11784: l_effective_start_date date ;
11785: l_effective_end_date date ;
11786: l_prefix pqh_copy_entity_attribs.information1%type := null;
11787: l_suffix pqh_copy_entity_attribs.information1%type := null;
11788: l_new_value number(15);
11789: l_object_found_in_target boolean := false ;
11790: l_min_esd date;

Line 11787: l_suffix pqh_copy_entity_attribs.information1%type := null;

11783: l_object_version_number number ;
11784: l_effective_start_date date ;
11785: l_effective_end_date date ;
11786: l_prefix pqh_copy_entity_attribs.information1%type := null;
11787: l_suffix pqh_copy_entity_attribs.information1%type := null;
11788: l_new_value number(15);
11789: l_object_found_in_target boolean := false ;
11790: l_min_esd date;
11791: l_max_eed date;

Line 12115: l_prefix pqh_copy_entity_attribs.information1%type := null;

12111: l_benfts_grp_id number ;
12112: l_object_version_number number ;
12113: l_effective_start_date date ;
12114: l_effective_end_date date ;
12115: l_prefix pqh_copy_entity_attribs.information1%type := null;
12116: l_suffix pqh_copy_entity_attribs.information1%type := null;
12117: l_new_value number(15);
12118: l_object_found_in_target boolean := false ;
12119: l_min_esd date;

Line 12116: l_suffix pqh_copy_entity_attribs.information1%type := null;

12112: l_object_version_number number ;
12113: l_effective_start_date date ;
12114: l_effective_end_date date ;
12115: l_prefix pqh_copy_entity_attribs.information1%type := null;
12116: l_suffix pqh_copy_entity_attribs.information1%type := null;
12117: l_new_value number(15);
12118: l_object_found_in_target boolean := false ;
12119: l_min_esd date;
12120: l_max_eed date;

Line 12500: l_prefix pqh_copy_entity_attribs.information1%type := null;

12496: l_per_info_chg_cs_ler_id number ;
12497: l_object_version_number number ;
12498: l_effective_start_date date ;
12499: l_effective_end_date date ;
12500: l_prefix pqh_copy_entity_attribs.information1%type := null;
12501: l_suffix pqh_copy_entity_attribs.information1%type := null;
12502: l_new_value number(15);
12503: l_object_found_in_target boolean := false ;
12504: l_min_esd date;

Line 12501: l_suffix pqh_copy_entity_attribs.information1%type := null;

12497: l_object_version_number number ;
12498: l_effective_start_date date ;
12499: l_effective_end_date date ;
12500: l_prefix pqh_copy_entity_attribs.information1%type := null;
12501: l_suffix pqh_copy_entity_attribs.information1%type := null;
12502: l_new_value number(15);
12503: l_object_found_in_target boolean := false ;
12504: l_min_esd date;
12505: l_max_eed date;

Line 13017: l_prefix pqh_copy_entity_attribs.information1%type := null;

13013: l_cm_typ_id number ;
13014: l_object_version_number number ;
13015: l_effective_start_date date ;
13016: l_effective_end_date date ;
13017: l_prefix pqh_copy_entity_attribs.information1%type := null;
13018: l_suffix pqh_copy_entity_attribs.information1%type := null;
13019: l_new_value number(15);
13020: l_object_found_in_target boolean := false ;
13021: l_min_esd date;

Line 13018: l_suffix pqh_copy_entity_attribs.information1%type := null;

13014: l_object_version_number number ;
13015: l_effective_start_date date ;
13016: l_effective_end_date date ;
13017: l_prefix pqh_copy_entity_attribs.information1%type := null;
13018: l_suffix pqh_copy_entity_attribs.information1%type := null;
13019: l_new_value number(15);
13020: l_object_found_in_target boolean := false ;
13021: l_min_esd date;
13022: l_max_eed date;

Line 13496: l_prefix pqh_copy_entity_attribs.information1%type := null;

13492: l_ptd_lmt_id number ;
13493: l_object_version_number number ;
13494: l_effective_start_date date ;
13495: l_effective_end_date date ;
13496: l_prefix pqh_copy_entity_attribs.information1%type := null;
13497: l_suffix pqh_copy_entity_attribs.information1%type := null;
13498: l_new_value number(15);
13499: l_object_found_in_target boolean := false ;
13500: l_min_esd date;

Line 13497: l_suffix pqh_copy_entity_attribs.information1%type := null;

13493: l_object_version_number number ;
13494: l_effective_start_date date ;
13495: l_effective_end_date date ;
13496: l_prefix pqh_copy_entity_attribs.information1%type := null;
13497: l_suffix pqh_copy_entity_attribs.information1%type := null;
13498: l_new_value number(15);
13499: l_object_found_in_target boolean := false ;
13500: l_min_esd date;
13501: l_max_eed date;

Line 13944: l_prefix pqh_copy_entity_attribs.information1%type := null;

13940: l_yr_perd_id number ;
13941: l_object_version_number number ;
13942: l_effective_start_date date ;
13943: l_effective_end_date date ;
13944: l_prefix pqh_copy_entity_attribs.information1%type := null;
13945: l_suffix pqh_copy_entity_attribs.information1%type := null;
13946: l_new_value number(15);
13947: l_object_found_in_target boolean := false ;
13948: l_min_esd date;

Line 13945: l_suffix pqh_copy_entity_attribs.information1%type := null;

13941: l_object_version_number number ;
13942: l_effective_start_date date ;
13943: l_effective_end_date date ;
13944: l_prefix pqh_copy_entity_attribs.information1%type := null;
13945: l_suffix pqh_copy_entity_attribs.information1%type := null;
13946: l_new_value number(15);
13947: l_object_found_in_target boolean := false ;
13948: l_min_esd date;
13949: l_max_eed date;

Line 14288: l_prefix pqh_copy_entity_attribs.information1%type := null;

14284: l_wthn_yr_perd_id number ;
14285: l_object_version_number number ;
14286: l_effective_start_date date ;
14287: l_effective_end_date date ;
14288: l_prefix pqh_copy_entity_attribs.information1%type := null;
14289: l_suffix pqh_copy_entity_attribs.information1%type := null;
14290: l_new_value number(15);
14291: l_object_found_in_target boolean := false ;
14292: l_min_esd date;

Line 14289: l_suffix pqh_copy_entity_attribs.information1%type := null;

14285: l_object_version_number number ;
14286: l_effective_start_date date ;
14287: l_effective_end_date date ;
14288: l_prefix pqh_copy_entity_attribs.information1%type := null;
14289: l_suffix pqh_copy_entity_attribs.information1%type := null;
14290: l_new_value number(15);
14291: l_object_found_in_target boolean := false ;
14292: l_min_esd date;
14293: l_max_eed date;

Line 14663: l_prefix pqh_copy_entity_attribs.information1%type := null;

14659: l_group_pl_id number ;
14660: l_object_version_number number ;
14661: l_effective_start_date date ;
14662: l_effective_end_date date ;
14663: l_prefix pqh_copy_entity_attribs.information1%type := null;
14664: l_suffix pqh_copy_entity_attribs.information1%type := null;
14665: l_new_value number(15);
14666: l_object_found_in_target boolean := false ;
14667: l_min_esd date;

Line 14664: l_suffix pqh_copy_entity_attribs.information1%type := null;

14660: l_object_version_number number ;
14661: l_effective_start_date date ;
14662: l_effective_end_date date ;
14663: l_prefix pqh_copy_entity_attribs.information1%type := null;
14664: l_suffix pqh_copy_entity_attribs.information1%type := null;
14665: l_new_value number(15);
14666: l_object_found_in_target boolean := false ;
14667: l_min_esd date;
14668: l_max_eed date;

Line 15595: l_prefix pqh_copy_entity_attribs.information1%type := null;

15591: l_svc_area_id number ;
15592: l_object_version_number number ;
15593: l_effective_start_date date ;
15594: l_effective_end_date date ;
15595: l_prefix pqh_copy_entity_attribs.information1%type := null;
15596: l_suffix pqh_copy_entity_attribs.information1%type := null;
15597: l_new_value number(15);
15598: l_object_found_in_target boolean := false ;
15599: l_min_esd date;

Line 15596: l_suffix pqh_copy_entity_attribs.information1%type := null;

15592: l_object_version_number number ;
15593: l_effective_start_date date ;
15594: l_effective_end_date date ;
15595: l_prefix pqh_copy_entity_attribs.information1%type := null;
15596: l_suffix pqh_copy_entity_attribs.information1%type := null;
15597: l_new_value number(15);
15598: l_object_found_in_target boolean := false ;
15599: l_min_esd date;
15600: l_max_eed date;

Line 16053: l_prefix pqh_copy_entity_attribs.information1%type := null;

16049: l_pl_typ_opt_typ_id number ;
16050: l_object_version_number number ;
16051: l_effective_start_date date ;
16052: l_effective_end_date date ;
16053: l_prefix pqh_copy_entity_attribs.information1%type := null;
16054: l_suffix pqh_copy_entity_attribs.information1%type := null;
16055: l_new_value number(15);
16056: l_object_found_in_target boolean := false ;
16057: l_min_esd date;

Line 16054: l_suffix pqh_copy_entity_attribs.information1%type := null;

16050: l_object_version_number number ;
16051: l_effective_start_date date ;
16052: l_effective_end_date date ;
16053: l_prefix pqh_copy_entity_attribs.information1%type := null;
16054: l_suffix pqh_copy_entity_attribs.information1%type := null;
16055: l_new_value number(15);
16056: l_object_found_in_target boolean := false ;
16057: l_min_esd date;
16058: l_max_eed date;

Line 16605: FROM pqh_copy_entity_attribs

16601: --
16602: CURSOR c_target_type
16603: IS
16604: SELECT information3
16605: FROM pqh_copy_entity_attribs
16606: WHERE copy_entity_Txn_id = p_copy_entity_txn_id;
16607: --
16608: l_current_pk_id NUMBER := NULL;
16609: l_update BOOLEAN := FALSE;

Line 16620: l_prefix pqh_copy_entity_attribs.information1%TYPE

16616: l_eligy_criteria_id NUMBER;
16617: l_object_version_number NUMBER;
16618: l_effective_start_date DATE;
16619: l_effective_end_date DATE;
16620: l_prefix pqh_copy_entity_attribs.information1%TYPE
16621: := NULL;
16622: l_suffix pqh_copy_entity_attribs.information1%TYPE
16623: := NULL;
16624: l_new_value NUMBER (15);

Line 16622: l_suffix pqh_copy_entity_attribs.information1%TYPE

16618: l_effective_start_date DATE;
16619: l_effective_end_date DATE;
16620: l_prefix pqh_copy_entity_attribs.information1%TYPE
16621: := NULL;
16622: l_suffix pqh_copy_entity_attribs.information1%TYPE
16623: := NULL;
16624: l_new_value NUMBER (15);
16625: l_object_found_in_target BOOLEAN := FALSE;
16626: l_min_esd DATE;