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.PER_CA_EE_EXTRACT_PKG dependencies on PER_CA_EE_EXTRACT_PKG

Line 1: PACKAGE BODY per_ca_ee_extract_pkg AS

1: PACKAGE BODY per_ca_ee_extract_pkg AS
2: /* $Header: pecaeerp.pkb 120.1.12020000.2 2012/07/05 01:35:14 amnaraya ship $ */
3:
4: v_naic naic_tab;
5: v_naic_count naic_count_tab;

Line 872: per_ca_ee_extract_pkg.k,

868: segment7,
869: segment8,
870: segment16) values
871: ( p_request_id,
872: per_ca_ee_extract_pkg.k,
873: 'FORM11',
874: v_name,
875: v_address_line_1,
876: v_address_line_2,

Line 894: line_number = per_ca_ee_extract_pkg.k;

890: segment12 = i.contact_position, -- and his Position
891: segment17 = i.contact_phone -- and Phone Number
892: where request_id = p_request_id and
893: context = 'FORM11' and
894: line_number = per_ca_ee_extract_pkg.k;
895: end loop;
896:
897: -- The first NAIC will always have the maximum
898: -- value as the cur_naic_person is ordered by

Line 921: per_ca_ee_extract_pkg.k := per_ca_ee_extract_pkg.k + 1;

917: FOR i IN v_sorted_naic.first..v_sorted_naic.last LOOP
918:
919: -- for i in cur_naic_person loop
920:
921: per_ca_ee_extract_pkg.k := per_ca_ee_extract_pkg.k + 1;
922:
923: open cur_hl_meaning(v_sorted_naic(i));
924: fetch cur_hl_meaning into v_meaning;
925: close cur_hl_meaning;

Line 951: per_ca_ee_extract_pkg.k,

947: )
948: values
949: (
950: p_request_id,
951: per_ca_ee_extract_pkg.k,
952: 'FORM12',
953: 'NAIC',
954: v_meaning,
955: -- i.count_naic_person,

Line 978: per_ca_ee_extract_pkg.k,

974: )
975: values
976: (
977: p_request_id,
978: per_ca_ee_extract_pkg.k,
979: 'FORM13',
980: 'NAIC',
981: -- i.lcode,
982: v_sorted_naic(i),

Line 1000: --line_number = per_ca_ee_extract_pkg.k and

996:
997: update per_ca_ee_report_lines set
998: segment13 = i.count_category
999: where request_id = p_request_id and
1000: --line_number = per_ca_ee_extract_pkg.k and
1001: context = 'FORM11';
1002:
1003: elsif i.employment_category = 'PR' then
1004:

Line 1008: --line_number = per_ca_ee_extract_pkg.k and

1004:
1005: update per_ca_ee_report_lines set
1006: segment14 = i.count_category
1007: where request_id = p_request_id and
1008: --line_number = per_ca_ee_extract_pkg.k and
1009: context = 'FORM11';
1010:
1011:
1012: elsif i.employment_category = 'PT' then

Line 1019: --line_number = per_ca_ee_extract_pkg.k and

1015:
1016: update per_ca_ee_report_lines set
1017: segment15 = i.count_category
1018: where request_id = p_request_id and
1019: --line_number = per_ca_ee_extract_pkg.k and
1020: context = 'FORM11';
1021:
1022: end if;
1023:

Line 1031: per_ca_ee_extract_pkg.k := per_ca_ee_extract_pkg.k + 1;

1027: for i in 1..2 loop
1028:
1029: for l in cur_province_cma(i) loop
1030:
1031: per_ca_ee_extract_pkg.k := per_ca_ee_extract_pkg.k + 1;
1032:
1033: open cur_legislation_info('EER2');
1034: fetch cur_legislation_info
1035: into v_legislation_info;

Line 1053: per_ca_ee_extract_pkg.k,

1049: segment2,
1050: segment3,
1051: segment4) values
1052: (p_request_id,
1053: per_ca_ee_extract_pkg.k,
1054: decode(i,1,'FORM14',2,'FORM13'),
1055: decode(i,1,'PROVINCE',2,'CMA'),
1056: l.meaning,
1057: l.count_province_cma,

Line 1066: per_ca_ee_extract_pkg.k := per_ca_ee_extract_pkg.k + 1;

1062: end loop; -- End loop CMA/Province
1063:
1064: for i in cur_cma_notfound loop
1065:
1066: per_ca_ee_extract_pkg.k := per_ca_ee_extract_pkg.k + 1;
1067:
1068: insert into per_ca_ee_report_lines
1069: (request_id,
1070: line_number,

Line 1077: per_ca_ee_extract_pkg.k,

1073: segment2,
1074: segment3,
1075: segment4) values
1076: (p_request_id,
1077: per_ca_ee_extract_pkg.k,
1078: 'FORM13',
1079: 'CMA',
1080: i.meaning,
1081: 0,

Line 1088: per_ca_ee_extract_pkg.k := per_ca_ee_extract_pkg.k + 1;

1084: end loop;
1085:
1086: for i in cur_province_notfound loop
1087:
1088: per_ca_ee_extract_pkg.k := per_ca_ee_extract_pkg.k + 1;
1089:
1090: insert into per_ca_ee_report_lines
1091: (request_id,
1092: line_number,

Line 1099: per_ca_ee_extract_pkg.k,

1095: segment2,
1096: segment3,
1097: segment4) values
1098: (p_request_id,
1099: per_ca_ee_extract_pkg.k,
1100: 'FORM14',
1101: 'PROVINCE',
1102: i.meaning,
1103: 0,

Line 1825: per_ca_ee_extract_pkg.k := per_ca_ee_extract_pkg.k + 1;

1821: (ltrim(rtrim(prev_meaning)) <> ltrim(rtrim(v_meaning))) or
1822: (prev_j <> j)
1823: ) then
1824:
1825: per_ca_ee_extract_pkg.k := per_ca_ee_extract_pkg.k + 1;
1826:
1827: hr_utility.trace('If .....');
1828:
1829: insert into per_ca_ee_report_lines

Line 1852: per_ca_ee_extract_pkg.k,

1848: segment16,
1849: segment17,
1850: segment21) values
1851: (p_request_id,
1852: per_ca_ee_extract_pkg.k,
1853: 'FORM2',
1854: 'NATIONAL',
1855: v_meaning,
1856: v_employment_category,

Line 1896: line_number=per_ca_ee_extract_pkg.k and

1892: update per_ca_ee_report_lines set
1893: segment6=segment6 + nvl(v_count,0),
1894: segment8=nvl(v_count,0)
1895: where request_id=p_request_id and
1896: line_number=per_ca_ee_extract_pkg.k and
1897: segment1='NATIONAL' and
1898: segment21 = v_naic_code;
1899:
1900: elsif v_sex = 'F' then

Line 1908: line_number=per_ca_ee_extract_pkg.k and

1904: update per_ca_ee_report_lines set
1905: segment6=segment6 + nvl(v_count,0),
1906: segment7=nvl(v_count,0)
1907: where request_id=p_request_id and
1908: line_number=per_ca_ee_extract_pkg.k and
1909: segment1='NATIONAL' and
1910: segment21 = v_naic_code;
1911:
1912: end if;

Line 1926: per_ca_ee_extract_pkg.k := per_ca_ee_extract_pkg.k + 1;

1922: end loop;
1923:
1924: if j_flag = 'F' then
1925:
1926: per_ca_ee_extract_pkg.k := per_ca_ee_extract_pkg.k + 1;
1927:
1928: insert into per_ca_ee_report_lines
1929: ( request_id,
1930: line_number,

Line 1951: per_ca_ee_extract_pkg.k,

1947: segment16,
1948: segment17,
1949: segment21) values
1950: (p_request_id,
1951: per_ca_ee_extract_pkg.k,
1952: 'FORM2',
1953: 'NATIONAL',
1954: v_meaning,
1955: v_employment_category,

Line 2898: per_ca_ee_extract_pkg.k := per_ca_ee_extract_pkg.k + 1;

2894: ltrim(rtrim(v_employment_category))) or
2895: (prev_j <> j)
2896: ) then
2897:
2898: per_ca_ee_extract_pkg.k := per_ca_ee_extract_pkg.k + 1;
2899:
2900: insert into per_ca_ee_report_lines
2901: ( request_id,
2902: line_number,

Line 2924: per_ca_ee_extract_pkg.k,

2920: segment17,
2921: segment18,
2922: segment21) values
2923: ( p_request_id,
2924: per_ca_ee_extract_pkg.k,
2925: 'FORM2',
2926: decode(x,1,'PROVINCE'
2927: ,2,'CMA'),
2928: v_meaning1,

Line 2964: line_number=per_ca_ee_extract_pkg.k and

2960: update per_ca_ee_report_lines set
2961: segment7=segment7 + nvl(v_count,0),
2962: segment9=nvl(v_count,0)
2963: where request_id=p_request_id and
2964: line_number=per_ca_ee_extract_pkg.k and
2965: segment1=decode(x,1,'PROVINCE',
2966: 2,'CMA') and
2967: segment2=v_meaning1 and
2968: segment21 = v_naic_code;

Line 2976: line_number=per_ca_ee_extract_pkg.k and

2972: update per_ca_ee_report_lines set
2973: segment7=segment7 + nvl(v_count,0),
2974: segment9=nvl(v_count,0)
2975: where request_id=p_request_id and
2976: line_number=per_ca_ee_extract_pkg.k and
2977: segment1 = decode(x,1,'PROVINCE',
2978: 2,'CMA') and
2979: segment2 = v_meaning1 and
2980: segment21 = v_naic_code;

Line 2998: per_ca_ee_extract_pkg.k := per_ca_ee_extract_pkg.k + 1;

2994:
2995:
2996: if j_flag = 'F' then
2997:
2998: per_ca_ee_extract_pkg.k := per_ca_ee_extract_pkg.k + 1;
2999:
3000: insert into per_ca_ee_report_lines
3001: ( request_id,
3002: line_number,

Line 3024: per_ca_ee_extract_pkg.k,

3020: segment17,
3021: segment18,
3022: segment21) values
3023: ( p_request_id,
3024: per_ca_ee_extract_pkg.k,
3025: 'FORM2',
3026: decode(x,1,'PROVINCE'
3027: ,2,'CMA'),
3028: v_meaning1,

Line 3814: per_ca_ee_extract_pkg.k := per_ca_ee_extract_pkg.k + 1;

3810: ) then
3811:
3812: hr_utility.trace('v_meaning = '|| v_meaning );
3813:
3814: per_ca_ee_extract_pkg.k := per_ca_ee_extract_pkg.k + 1;
3815:
3816: insert into per_ca_ee_report_lines
3817: ( request_id,
3818: line_number,

Line 3838: per_ca_ee_extract_pkg.k,

3834: segment15,
3835: segment16,
3836: segment21) values
3837: ( p_request_id,
3838: per_ca_ee_extract_pkg.k,
3839: 'FORM3',
3840: decode(i,1,'PROVINCE',
3841: 2,'CMA'),
3842: v_meaning,

Line 3874: line_number=per_ca_ee_extract_pkg.k and

3870: segment5 = segment5 + nvl(v_count,0),
3871: segment7 = nvl(v_count,0)
3872: where
3873: request_id=p_request_id and
3874: line_number=per_ca_ee_extract_pkg.k and
3875: context = 'FORM3' and
3876: segment1 = decode(i,1,'PROVINCE',2,'CMA') and
3877: segment2 = v_meaning and
3878: segment3 = decode(v_employment_category,'FR',

Line 3891: line_number=per_ca_ee_extract_pkg.k and

3887: segment5=segment5 + nvl(v_count,0),
3888: segment6=nvl(v_count,0)
3889: where
3890: request_id=p_request_id and
3891: line_number=per_ca_ee_extract_pkg.k and
3892: context='FORM3' and
3893: segment1=decode(i,1,'PROVINCE',2,'CMA') and
3894: segment2=v_meaning and
3895: segment3=decode(v_employment_category,'FR',

Line 4216: per_ca_ee_extract_pkg.k := per_ca_ee_extract_pkg.k + 1;

4212: pc_count,
4213: emp_cat)
4214: loop
4215:
4216: per_ca_ee_extract_pkg.k := per_ca_ee_extract_pkg.k + 1;
4217:
4218: insert into per_ca_ee_report_lines
4219: ( request_id,
4220: line_number,

Line 4240: per_ca_ee_extract_pkg.k,

4236: segment15,
4237: segment16,
4238: segment21) values
4239: ( p_request_id,
4240: per_ca_ee_extract_pkg.k,
4241: 'FORM3',
4242: decode(pc_count,1,'PROVINCE','CMA'),
4243: l.provcma_name,
4244: decode(emp_cat,'FR',v_fr_min_range||' - '||v_fr_max_range,

Line 4293: per_ca_ee_extract_pkg.k,

4289: segment14,
4290: segment15,
4291: segment21) values
4292: ( p_request_id,
4293: per_ca_ee_extract_pkg.k,
4294: 'FORM3',
4295: 'NATIONAL',
4296: count_national.segment3,
4297: count_national.segment4,

Line 4843: per_ca_ee_extract_pkg.k := per_ca_ee_extract_pkg.k + 1;

4839: (ltrim(rtrim(prev_meaning)) <> ltrim(rtrim(v_meaning))) or
4840: (ltrim(rtrim(prev_naic_code)) <> ltrim(rtrim(v_naic_code))) or
4841: (ltrim(rtrim(prev_employment_category)) <> ltrim(rtrim(v_employment_category)))) then
4842:
4843: per_ca_ee_extract_pkg.k := per_ca_ee_extract_pkg.k + 1;
4844:
4845: insert into per_ca_ee_report_lines
4846: (request_id,
4847: line_number,

Line 4867: per_ca_ee_extract_pkg.k,

4863: segment15,
4864: segment16,
4865: segment21) values
4866: ( p_request_id,
4867: per_ca_ee_extract_pkg.k,
4868: 'FORM4',
4869: 'PROVINCE',
4870: v_province_name,
4871: v_meaning,

Line 4901: line_number=per_ca_ee_extract_pkg.k and

4897: update per_ca_ee_report_lines set
4898: segment7=nvl(v_count,0),
4899: segment5=segment5 + nvl(v_count,0)
4900: where request_id=p_request_id and
4901: line_number=per_ca_ee_extract_pkg.k and
4902: context='FORM4' and
4903: segment1='PROVINCE' and
4904: segment2=v_province_name and
4905: segment3=v_meaning and

Line 4915: line_number=per_ca_ee_extract_pkg.k and

4911: update per_ca_ee_report_lines set
4912: segment6=nvl(v_count,0),
4913: segment5=segment5 + nvl(v_count,0)
4914: where request_id=p_request_id and
4915: line_number=per_ca_ee_extract_pkg.k and
4916: context='FORM4' and
4917: segment1='PROVINCE' and
4918: segment2=v_province_name and
4919: segment3=v_meaning and

Line 5038: per_ca_ee_extract_pkg.k := per_ca_ee_extract_pkg.k + 1;

5034: for emp_cat in 1..3 loop
5035:
5036: for x in cur_notfound(emp_cat) loop
5037:
5038: per_ca_ee_extract_pkg.k := per_ca_ee_extract_pkg.k + 1;
5039:
5040: insert into per_ca_ee_report_lines
5041: (request_id,
5042: line_number,

Line 5062: per_ca_ee_extract_pkg.k,

5058: segment15,
5059: segment16,
5060: segment21) values
5061: ( p_request_id,
5062: per_ca_ee_extract_pkg.k,
5063: 'FORM4',
5064: 'PROVINCE',
5065: x.segment2,
5066: v_meaning,

Line 5116: per_ca_ee_extract_pkg.k,

5112: segment14,
5113: segment15,
5114: segment21) values
5115: ( p_request_id,
5116: per_ca_ee_extract_pkg.k,
5117: 'FORM4',
5118: 'NATIONAL',
5119: count_national.segment3,
5120: count_national.segment4,

Line 6196: per_ca_ee_extract_pkg.k := per_ca_ee_extract_pkg.k + 1;

6192: (ltrim(rtrim(prev_naic_code)) <> ltrim(rtrim(v_naic_code))) or
6193: (ltrim(rtrim(prev_employment_category)) <>
6194: ltrim(rtrim(v_employment_category)))) then
6195:
6196: per_ca_ee_extract_pkg.k := per_ca_ee_extract_pkg.k + 1;
6197:
6198: insert into per_ca_ee_report_lines
6199: (request_id,
6200: line_number,

Line 6220: per_ca_ee_extract_pkg.k,

6216: segment15,
6217: segment16,
6218: segment21) values
6219: ( p_request_id,
6220: per_ca_ee_extract_pkg.k,
6221: 'FORM5',
6222: 'PROVINCE',
6223: v_province_name,
6224: v_meaning,

Line 6253: line_number = per_ca_ee_extract_pkg.k and

6249: update per_ca_ee_report_lines set
6250: segment7=nvl(v_count,0),
6251: segment5=segment5 + nvl(v_count,0)
6252: where request_id=p_request_id and
6253: line_number = per_ca_ee_extract_pkg.k and
6254: context='FORM5' and
6255: segment1='PROVINCE' and
6256: segment2=v_province_name and
6257: segment3=v_meaning and

Line 6267: line_number = per_ca_ee_extract_pkg.k and

6263: update per_ca_ee_report_lines set
6264: segment6=nvl(v_count,0),
6265: segment5=segment5 + nvl(v_count,0)
6266: where request_id=p_request_id and
6267: line_number = per_ca_ee_extract_pkg.k and
6268: context='FORM5' and
6269: segment1='PROVINCE' and
6270: segment2=v_province_name and
6271: segment3=v_meaning and

Line 6413: per_ca_ee_extract_pkg.k := per_ca_ee_extract_pkg.k + 1;

6409: for emp_cat in 1..3 loop
6410:
6411: for x in cur_notfound(emp_cat) loop
6412:
6413: per_ca_ee_extract_pkg.k := per_ca_ee_extract_pkg.k + 1;
6414:
6415: insert into per_ca_ee_report_lines
6416: (request_id,
6417: line_number,

Line 6437: per_ca_ee_extract_pkg.k,

6433: segment15,
6434: segment16,
6435: segment21) values
6436: ( p_request_id,
6437: per_ca_ee_extract_pkg.k,
6438: 'FORM5',
6439: 'PROVINCE',
6440: x.segment2,
6441: v_meaning,

Line 6494: per_ca_ee_extract_pkg.k := per_ca_ee_extract_pkg.k + 1;

6490: (ltrim(rtrim(prev_employment_category)) <>
6491: ltrim(rtrim(v_employment_category)))) then
6492:
6493: hr_utility.trace('Form5P: cur_total_promotions : Inside If');
6494: per_ca_ee_extract_pkg.k := per_ca_ee_extract_pkg.k + 1;
6495:
6496: insert into per_ca_ee_report_lines
6497: (request_id,
6498: line_number,

Line 6517: per_ca_ee_extract_pkg.k,

6513: segment14,
6514: segment15,
6515: segment21) values
6516: (p_request_id,
6517: per_ca_ee_extract_pkg.k,
6518: 'FORM5P',
6519: 'PROVINCE',
6520: v_province_name,
6521: v_employment_category,

Line 6549: line_number = per_ca_ee_extract_pkg.k and

6545: update per_ca_ee_report_lines set
6546: segment5=nvl(v_count,0),
6547: segment4=segment4 + nvl(v_count,0)
6548: where request_id=p_request_id and
6549: line_number = per_ca_ee_extract_pkg.k and
6550: context='FORM5P' and
6551: segment1='PROVINCE' and
6552: segment2=v_province_name and
6553: segment3=v_employment_category and

Line 6562: line_number = per_ca_ee_extract_pkg.k and

6558: update per_ca_ee_report_lines set
6559: segment6=nvl(v_count,0),
6560: segment4=segment4 + nvl(v_count,0)
6561: where request_id=p_request_id and
6562: line_number = per_ca_ee_extract_pkg.k and
6563: context='FORM5P' and
6564: segment1='PROVINCE' and
6565: segment2=v_province_name and
6566: segment3=v_employment_category and

Line 6716: per_ca_ee_extract_pkg.k,

6712: segment14,
6713: segment15,
6714: segment21) values
6715: (p_request_id,
6716: per_ca_ee_extract_pkg.k,
6717: 'FORM5P',
6718: 'PROVINCE',
6719: j.segment2,
6720: j.emp_category,

Line 6760: per_ca_ee_extract_pkg.k,

6756: segment13,
6757: segment14,
6758: segment21) values
6759: (p_request_id,
6760: per_ca_ee_extract_pkg.k,
6761: 'FORM5P',
6762: 'NATIONAL',
6763: i.segment3,
6764: i.segment4,

Line 6806: per_ca_ee_extract_pkg.k,

6802: segment14,
6803: segment15,
6804: segment21) values
6805: ( p_request_id,
6806: per_ca_ee_extract_pkg.k,
6807: 'FORM5',
6808: 'NATIONAL',
6809: count_national.segment3,
6810: count_national.segment4,

Line 7421: per_ca_ee_extract_pkg.k := per_ca_ee_extract_pkg.k + 1;

7417: (ltrim(rtrim(prev_naic_code)) <> ltrim(rtrim(v_naic_code))) or
7418: (ltrim(rtrim(prev_employment_category)) <>
7419: ltrim(rtrim(v_employment_category)))) then
7420:
7421: per_ca_ee_extract_pkg.k := per_ca_ee_extract_pkg.k + 1;
7422:
7423: insert into per_ca_ee_report_lines
7424: (request_id,
7425: line_number,

Line 7445: per_ca_ee_extract_pkg.k,

7441: segment15,
7442: segment16,
7443: segment21) values
7444: ( p_request_id,
7445: per_ca_ee_extract_pkg.k,
7446: 'FORM5',
7447: 'PROVINCE',
7448: v_province_name,
7449: v_meaning,

Line 7478: line_number = per_ca_ee_extract_pkg.k and

7474: update per_ca_ee_report_lines set
7475: segment7=nvl(v_count,0),
7476: segment5=segment5 + nvl(v_count,0)
7477: where request_id=p_request_id and
7478: line_number = per_ca_ee_extract_pkg.k and
7479: context='FORM5' and
7480: segment1='PROVINCE' and
7481: segment2=v_province_name and
7482: segment3=v_meaning and

Line 7492: line_number = per_ca_ee_extract_pkg.k and

7488: update per_ca_ee_report_lines set
7489: segment6=nvl(v_count,0),
7490: segment5=segment5 + nvl(v_count,0)
7491: where request_id=p_request_id and
7492: line_number = per_ca_ee_extract_pkg.k and
7493: context='FORM5' and
7494: segment1='PROVINCE' and
7495: segment2=v_province_name and
7496: segment3=v_meaning and

Line 7621: per_ca_ee_extract_pkg.k := per_ca_ee_extract_pkg.k + 1;

7617: for emp_cat in 1..3 loop
7618:
7619: for x in cur_notfound(emp_cat) loop
7620:
7621: per_ca_ee_extract_pkg.k := per_ca_ee_extract_pkg.k + 1;
7622:
7623: insert into per_ca_ee_report_lines
7624: (request_id,
7625: line_number,

Line 7645: per_ca_ee_extract_pkg.k,

7641: segment15,
7642: segment16,
7643: segment21) values
7644: ( p_request_id,
7645: per_ca_ee_extract_pkg.k,
7646: 'FORM5',
7647: 'PROVINCE',
7648: x.segment2,
7649: v_meaning,

Line 7708: per_ca_ee_extract_pkg.k := per_ca_ee_extract_pkg.k + 1;

7704: (ltrim(rtrim(prev_employment_category)) <>
7705: ltrim(rtrim(v_employment_category)))) then
7706:
7707: hr_utility.trace('Form5P: cur_total_promotions : Inside If');
7708: per_ca_ee_extract_pkg.k := per_ca_ee_extract_pkg.k + 1;
7709:
7710: insert into per_ca_ee_report_lines
7711: (request_id,
7712: line_number,

Line 7731: per_ca_ee_extract_pkg.k,

7727: segment14,
7728: segment15,
7729: segment21) values
7730: (p_request_id,
7731: per_ca_ee_extract_pkg.k,
7732: 'FORM5P',
7733: 'PROVINCE',
7734: v_province_name,
7735: v_employment_category,

Line 7763: line_number = per_ca_ee_extract_pkg.k and

7759: update per_ca_ee_report_lines set
7760: segment5=nvl(v_count,0),
7761: segment4=segment4 + nvl(v_count,0)
7762: where request_id=p_request_id and
7763: line_number = per_ca_ee_extract_pkg.k and
7764: context='FORM5P' and
7765: segment1='PROVINCE' and
7766: segment2=v_province_name and
7767: segment3=v_employment_category and

Line 7776: line_number = per_ca_ee_extract_pkg.k and

7772: update per_ca_ee_report_lines set
7773: segment6=nvl(v_count,0),
7774: segment4=segment4 + nvl(v_count,0)
7775: where request_id=p_request_id and
7776: line_number = per_ca_ee_extract_pkg.k and
7777: context='FORM5P' and
7778: segment1='PROVINCE' and
7779: segment2=v_province_name and
7780: segment3=v_employment_category and

Line 7914: per_ca_ee_extract_pkg.k,

7910: segment14,
7911: segment15,
7912: segment21) values
7913: (p_request_id,
7914: per_ca_ee_extract_pkg.k,
7915: 'FORM5P',
7916: 'PROVINCE',
7917: j.segment2,
7918: j.emp_category,

Line 7958: per_ca_ee_extract_pkg.k,

7954: segment13,
7955: segment14,
7956: segment21) values
7957: (p_request_id,
7958: per_ca_ee_extract_pkg.k,
7959: 'FORM5P',
7960: 'NATIONAL',
7961: i.segment3,
7962: i.segment4,

Line 8003: per_ca_ee_extract_pkg.k,

7999: segment14,
8000: segment15,
8001: segment21) values
8002: ( p_request_id,
8003: per_ca_ee_extract_pkg.k,
8004: 'FORM5',
8005: 'NATIONAL',
8006: count_national.segment3,
8007: count_national.segment4,

Line 8474: per_ca_ee_extract_pkg.k := per_ca_ee_extract_pkg.k + 1;

8470: (ltrim(rtrim(prev_naic_code)) <> ltrim(rtrim(v_naic_code))) or
8471: (ltrim(rtrim(prev_employment_category)) <>
8472: ltrim(rtrim(v_employment_category)))) then
8473:
8474: per_ca_ee_extract_pkg.k := per_ca_ee_extract_pkg.k + 1;
8475:
8476: insert into per_ca_ee_report_lines
8477: (request_id,
8478: line_number,

Line 8534: line_number = per_ca_ee_extract_pkg.k and

8530: update per_ca_ee_report_lines set
8531: segment7=nvl(v_count,0),
8532: segment5=segment5 + nvl(v_count,0)
8533: where request_id=p_request_id and
8534: line_number = per_ca_ee_extract_pkg.k and
8535: context='FORM5' and
8536: segment1='PROVINCE' and
8537: segment2=v_province_name and
8538: segment3=v_meaning and

Line 8548: line_number = per_ca_ee_extract_pkg.k and

8544: update per_ca_ee_report_lines set
8545: segment6=nvl(v_count,0),
8546: segment5=segment5 + nvl(v_count,0)
8547: where request_id=p_request_id and
8548: line_number = per_ca_ee_extract_pkg.k and
8549: context='FORM5' and
8550: segment1='PROVINCE' and
8551: segment2=v_province_name and
8552: segment3=v_meaning and

Line 8705: per_ca_ee_extract_pkg.k := per_ca_ee_extract_pkg.k + 1;

8701: for x in cur_notfound(emp_cat) loop
8702:
8703: hr_utility.trace('Form6: cur_notfound' );
8704:
8705: per_ca_ee_extract_pkg.k := per_ca_ee_extract_pkg.k + 1;
8706:
8707: insert into per_ca_ee_report_lines
8708: (request_id,
8709: line_number,

Line 8729: per_ca_ee_extract_pkg.k,

8725: segment15,
8726: segment16,
8727: segment21) values
8728: ( p_request_id,
8729: per_ca_ee_extract_pkg.k,
8730: 'FORM6',
8731: 'PROVINCE',
8732: x.segment2,
8733: v_meaning,

Line 8780: per_ca_ee_extract_pkg.k,

8776: segment14,
8777: segment15,
8778: segment21) values
8779: ( p_request_id,
8780: per_ca_ee_extract_pkg.k,
8781: 'FORM6',
8782: 'NATIONAL',
8783: count_national.segment3,
8784: count_national.segment4,

Line 8995: end per_ca_ee_extract_pkg;

8991: end;
8992:
8993: end update_rec;
8994:
8995: end per_ca_ee_extract_pkg;