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 115.29 2003/06/16 19:59:09 ssouresr noship $ */
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 2886: per_ca_ee_extract_pkg.k := per_ca_ee_extract_pkg.k + 1;

2882: ltrim(rtrim(v_employment_category))) or
2883: (prev_j <> j)
2884: ) then
2885:
2886: per_ca_ee_extract_pkg.k := per_ca_ee_extract_pkg.k + 1;
2887:
2888: insert into per_ca_ee_report_lines
2889: ( request_id,
2890: line_number,

Line 2912: per_ca_ee_extract_pkg.k,

2908: segment17,
2909: segment18,
2910: segment21) values
2911: ( p_request_id,
2912: per_ca_ee_extract_pkg.k,
2913: 'FORM2',
2914: decode(x,1,'PROVINCE'
2915: ,2,'CMA'),
2916: v_meaning1,

Line 2952: line_number=per_ca_ee_extract_pkg.k and

2948: update per_ca_ee_report_lines set
2949: segment7=segment7 + nvl(v_count,0),
2950: segment9=nvl(v_count,0)
2951: where request_id=p_request_id and
2952: line_number=per_ca_ee_extract_pkg.k and
2953: segment1=decode(x,1,'PROVINCE',
2954: 2,'CMA') and
2955: segment2=v_meaning1 and
2956: segment21 = v_naic_code;

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 2986: per_ca_ee_extract_pkg.k := per_ca_ee_extract_pkg.k + 1;

2982:
2983:
2984: if j_flag = 'F' then
2985:
2986: per_ca_ee_extract_pkg.k := per_ca_ee_extract_pkg.k + 1;
2987:
2988: insert into per_ca_ee_report_lines
2989: ( request_id,
2990: line_number,

Line 3012: per_ca_ee_extract_pkg.k,

3008: segment17,
3009: segment18,
3010: segment21) values
3011: ( p_request_id,
3012: per_ca_ee_extract_pkg.k,
3013: 'FORM2',
3014: decode(x,1,'PROVINCE'
3015: ,2,'CMA'),
3016: v_meaning1,

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

3798: ) then
3799:
3800: hr_utility.trace('v_meaning = '|| v_meaning );
3801:
3802: per_ca_ee_extract_pkg.k := per_ca_ee_extract_pkg.k + 1;
3803:
3804: insert into per_ca_ee_report_lines
3805: ( request_id,
3806: line_number,

Line 3826: per_ca_ee_extract_pkg.k,

3822: segment15,
3823: segment16,
3824: segment21) values
3825: ( p_request_id,
3826: per_ca_ee_extract_pkg.k,
3827: 'FORM3',
3828: decode(i,1,'PROVINCE',
3829: 2,'CMA'),
3830: v_meaning,

Line 3862: line_number=per_ca_ee_extract_pkg.k and

3858: segment5 = segment5 + nvl(v_count,0),
3859: segment7 = nvl(v_count,0)
3860: where
3861: request_id=p_request_id and
3862: line_number=per_ca_ee_extract_pkg.k and
3863: context = 'FORM3' and
3864: segment1 = decode(i,1,'PROVINCE',2,'CMA') and
3865: segment2 = v_meaning and
3866: segment3 = decode(v_employment_category,'FR',

Line 3879: line_number=per_ca_ee_extract_pkg.k and

3875: segment5=segment5 + nvl(v_count,0),
3876: segment6=nvl(v_count,0)
3877: where
3878: request_id=p_request_id and
3879: line_number=per_ca_ee_extract_pkg.k and
3880: context='FORM3' and
3881: segment1=decode(i,1,'PROVINCE',2,'CMA') and
3882: segment2=v_meaning and
3883: segment3=decode(v_employment_category,'FR',

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

4200: pc_count,
4201: emp_cat)
4202: loop
4203:
4204: per_ca_ee_extract_pkg.k := per_ca_ee_extract_pkg.k + 1;
4205:
4206: insert into per_ca_ee_report_lines
4207: ( request_id,
4208: line_number,

Line 4228: per_ca_ee_extract_pkg.k,

4224: segment15,
4225: segment16,
4226: segment21) values
4227: ( p_request_id,
4228: per_ca_ee_extract_pkg.k,
4229: 'FORM3',
4230: decode(pc_count,1,'PROVINCE','CMA'),
4231: l.provcma_name,
4232: decode(emp_cat,'FR',v_fr_min_range||' - '||v_fr_max_range,

Line 4281: per_ca_ee_extract_pkg.k,

4277: segment14,
4278: segment15,
4279: segment21) values
4280: ( p_request_id,
4281: per_ca_ee_extract_pkg.k,
4282: 'FORM3',
4283: 'NATIONAL',
4284: count_national.segment3,
4285: count_national.segment4,

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

4793: (ltrim(rtrim(prev_meaning)) <> ltrim(rtrim(v_meaning))) or
4794: (ltrim(rtrim(prev_naic_code)) <> ltrim(rtrim(v_naic_code))) or
4795: (ltrim(rtrim(prev_employment_category)) <> ltrim(rtrim(v_employment_category)))) then
4796:
4797: per_ca_ee_extract_pkg.k := per_ca_ee_extract_pkg.k + 1;
4798:
4799: insert into per_ca_ee_report_lines
4800: (request_id,
4801: line_number,

Line 4821: per_ca_ee_extract_pkg.k,

4817: segment15,
4818: segment16,
4819: segment21) values
4820: ( p_request_id,
4821: per_ca_ee_extract_pkg.k,
4822: 'FORM4',
4823: 'PROVINCE',
4824: v_province_name,
4825: v_meaning,

Line 4855: line_number=per_ca_ee_extract_pkg.k and

4851: update per_ca_ee_report_lines set
4852: segment7=nvl(v_count,0),
4853: segment5=segment5 + nvl(v_count,0)
4854: where request_id=p_request_id and
4855: line_number=per_ca_ee_extract_pkg.k and
4856: context='FORM4' and
4857: segment1='PROVINCE' and
4858: segment2=v_province_name and
4859: segment3=v_meaning and

Line 4869: line_number=per_ca_ee_extract_pkg.k and

4865: update per_ca_ee_report_lines set
4866: segment6=nvl(v_count,0),
4867: segment5=segment5 + nvl(v_count,0)
4868: where request_id=p_request_id and
4869: line_number=per_ca_ee_extract_pkg.k and
4870: context='FORM4' and
4871: segment1='PROVINCE' and
4872: segment2=v_province_name and
4873: segment3=v_meaning and

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

4988: for emp_cat in 1..3 loop
4989:
4990: for x in cur_notfound(emp_cat) loop
4991:
4992: per_ca_ee_extract_pkg.k := per_ca_ee_extract_pkg.k + 1;
4993:
4994: insert into per_ca_ee_report_lines
4995: (request_id,
4996: line_number,

Line 5016: per_ca_ee_extract_pkg.k,

5012: segment15,
5013: segment16,
5014: segment21) values
5015: ( p_request_id,
5016: per_ca_ee_extract_pkg.k,
5017: 'FORM4',
5018: 'PROVINCE',
5019: x.segment2,
5020: v_meaning,

Line 5070: per_ca_ee_extract_pkg.k,

5066: segment14,
5067: segment15,
5068: segment21) values
5069: ( p_request_id,
5070: per_ca_ee_extract_pkg.k,
5071: 'FORM4',
5072: 'NATIONAL',
5073: count_national.segment3,
5074: count_national.segment4,

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

6146: (ltrim(rtrim(prev_naic_code)) <> ltrim(rtrim(v_naic_code))) or
6147: (ltrim(rtrim(prev_employment_category)) <>
6148: ltrim(rtrim(v_employment_category)))) then
6149:
6150: per_ca_ee_extract_pkg.k := per_ca_ee_extract_pkg.k + 1;
6151:
6152: insert into per_ca_ee_report_lines
6153: (request_id,
6154: line_number,

Line 6174: per_ca_ee_extract_pkg.k,

6170: segment15,
6171: segment16,
6172: segment21) values
6173: ( p_request_id,
6174: per_ca_ee_extract_pkg.k,
6175: 'FORM5',
6176: 'PROVINCE',
6177: v_province_name,
6178: v_meaning,

Line 6207: line_number = per_ca_ee_extract_pkg.k and

6203: update per_ca_ee_report_lines set
6204: segment7=nvl(v_count,0),
6205: segment5=segment5 + nvl(v_count,0)
6206: where request_id=p_request_id and
6207: line_number = per_ca_ee_extract_pkg.k and
6208: context='FORM5' and
6209: segment1='PROVINCE' and
6210: segment2=v_province_name and
6211: segment3=v_meaning and

Line 6221: line_number = per_ca_ee_extract_pkg.k and

6217: update per_ca_ee_report_lines set
6218: segment6=nvl(v_count,0),
6219: segment5=segment5 + nvl(v_count,0)
6220: where request_id=p_request_id and
6221: line_number = per_ca_ee_extract_pkg.k and
6222: context='FORM5' and
6223: segment1='PROVINCE' and
6224: segment2=v_province_name and
6225: segment3=v_meaning and

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

6363: for emp_cat in 1..3 loop
6364:
6365: for x in cur_notfound(emp_cat) loop
6366:
6367: per_ca_ee_extract_pkg.k := per_ca_ee_extract_pkg.k + 1;
6368:
6369: insert into per_ca_ee_report_lines
6370: (request_id,
6371: line_number,

Line 6391: per_ca_ee_extract_pkg.k,

6387: segment15,
6388: segment16,
6389: segment21) values
6390: ( p_request_id,
6391: per_ca_ee_extract_pkg.k,
6392: 'FORM5',
6393: 'PROVINCE',
6394: x.segment2,
6395: v_meaning,

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

6444: (ltrim(rtrim(prev_employment_category)) <>
6445: ltrim(rtrim(v_employment_category)))) then
6446:
6447: hr_utility.trace('Form5P: cur_total_promotions : Inside If');
6448: per_ca_ee_extract_pkg.k := per_ca_ee_extract_pkg.k + 1;
6449:
6450: insert into per_ca_ee_report_lines
6451: (request_id,
6452: line_number,

Line 6471: per_ca_ee_extract_pkg.k,

6467: segment14,
6468: segment15,
6469: segment21) values
6470: (p_request_id,
6471: per_ca_ee_extract_pkg.k,
6472: 'FORM5P',
6473: 'PROVINCE',
6474: v_province_name,
6475: v_employment_category,

Line 6503: line_number = per_ca_ee_extract_pkg.k and

6499: update per_ca_ee_report_lines set
6500: segment5=nvl(v_count,0),
6501: segment4=segment4 + nvl(v_count,0)
6502: where request_id=p_request_id and
6503: line_number = per_ca_ee_extract_pkg.k and
6504: context='FORM5P' and
6505: segment1='PROVINCE' and
6506: segment2=v_province_name and
6507: segment3=v_employment_category and

Line 6516: line_number = per_ca_ee_extract_pkg.k and

6512: update per_ca_ee_report_lines set
6513: segment6=nvl(v_count,0),
6514: segment4=segment4 + nvl(v_count,0)
6515: where request_id=p_request_id and
6516: line_number = per_ca_ee_extract_pkg.k and
6517: context='FORM5P' and
6518: segment1='PROVINCE' and
6519: segment2=v_province_name and
6520: segment3=v_employment_category and

Line 6670: per_ca_ee_extract_pkg.k,

6666: segment14,
6667: segment15,
6668: segment21) values
6669: (p_request_id,
6670: per_ca_ee_extract_pkg.k,
6671: 'FORM5P',
6672: 'PROVINCE',
6673: j.segment2,
6674: j.emp_category,

Line 6714: per_ca_ee_extract_pkg.k,

6710: segment13,
6711: segment14,
6712: segment21) values
6713: (p_request_id,
6714: per_ca_ee_extract_pkg.k,
6715: 'FORM5P',
6716: 'NATIONAL',
6717: i.segment3,
6718: i.segment4,

Line 6760: per_ca_ee_extract_pkg.k,

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

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

7371: (ltrim(rtrim(prev_naic_code)) <> ltrim(rtrim(v_naic_code))) or
7372: (ltrim(rtrim(prev_employment_category)) <>
7373: ltrim(rtrim(v_employment_category)))) then
7374:
7375: per_ca_ee_extract_pkg.k := per_ca_ee_extract_pkg.k + 1;
7376:
7377: insert into per_ca_ee_report_lines
7378: (request_id,
7379: line_number,

Line 7399: per_ca_ee_extract_pkg.k,

7395: segment15,
7396: segment16,
7397: segment21) values
7398: ( p_request_id,
7399: per_ca_ee_extract_pkg.k,
7400: 'FORM5',
7401: 'PROVINCE',
7402: v_province_name,
7403: v_meaning,

Line 7432: line_number = per_ca_ee_extract_pkg.k and

7428: update per_ca_ee_report_lines set
7429: segment7=nvl(v_count,0),
7430: segment5=segment5 + nvl(v_count,0)
7431: where request_id=p_request_id and
7432: line_number = per_ca_ee_extract_pkg.k and
7433: context='FORM5' and
7434: segment1='PROVINCE' and
7435: segment2=v_province_name and
7436: segment3=v_meaning and

Line 7446: line_number = per_ca_ee_extract_pkg.k and

7442: update per_ca_ee_report_lines set
7443: segment6=nvl(v_count,0),
7444: segment5=segment5 + nvl(v_count,0)
7445: where request_id=p_request_id and
7446: line_number = per_ca_ee_extract_pkg.k and
7447: context='FORM5' and
7448: segment1='PROVINCE' and
7449: segment2=v_province_name and
7450: segment3=v_meaning and

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

7571: for emp_cat in 1..3 loop
7572:
7573: for x in cur_notfound(emp_cat) loop
7574:
7575: per_ca_ee_extract_pkg.k := per_ca_ee_extract_pkg.k + 1;
7576:
7577: insert into per_ca_ee_report_lines
7578: (request_id,
7579: line_number,

Line 7599: per_ca_ee_extract_pkg.k,

7595: segment15,
7596: segment16,
7597: segment21) values
7598: ( p_request_id,
7599: per_ca_ee_extract_pkg.k,
7600: 'FORM5',
7601: 'PROVINCE',
7602: x.segment2,
7603: v_meaning,

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

7658: (ltrim(rtrim(prev_employment_category)) <>
7659: ltrim(rtrim(v_employment_category)))) then
7660:
7661: hr_utility.trace('Form5P: cur_total_promotions : Inside If');
7662: per_ca_ee_extract_pkg.k := per_ca_ee_extract_pkg.k + 1;
7663:
7664: insert into per_ca_ee_report_lines
7665: (request_id,
7666: line_number,

Line 7685: per_ca_ee_extract_pkg.k,

7681: segment14,
7682: segment15,
7683: segment21) values
7684: (p_request_id,
7685: per_ca_ee_extract_pkg.k,
7686: 'FORM5P',
7687: 'PROVINCE',
7688: v_province_name,
7689: v_employment_category,

Line 7717: line_number = per_ca_ee_extract_pkg.k and

7713: update per_ca_ee_report_lines set
7714: segment5=nvl(v_count,0),
7715: segment4=segment4 + nvl(v_count,0)
7716: where request_id=p_request_id and
7717: line_number = per_ca_ee_extract_pkg.k and
7718: context='FORM5P' and
7719: segment1='PROVINCE' and
7720: segment2=v_province_name and
7721: segment3=v_employment_category and

Line 7730: line_number = per_ca_ee_extract_pkg.k and

7726: update per_ca_ee_report_lines set
7727: segment6=nvl(v_count,0),
7728: segment4=segment4 + nvl(v_count,0)
7729: where request_id=p_request_id and
7730: line_number = per_ca_ee_extract_pkg.k and
7731: context='FORM5P' and
7732: segment1='PROVINCE' and
7733: segment2=v_province_name and
7734: segment3=v_employment_category and

Line 7868: per_ca_ee_extract_pkg.k,

7864: segment14,
7865: segment15,
7866: segment21) values
7867: (p_request_id,
7868: per_ca_ee_extract_pkg.k,
7869: 'FORM5P',
7870: 'PROVINCE',
7871: j.segment2,
7872: j.emp_category,

Line 7912: per_ca_ee_extract_pkg.k,

7908: segment13,
7909: segment14,
7910: segment21) values
7911: (p_request_id,
7912: per_ca_ee_extract_pkg.k,
7913: 'FORM5P',
7914: 'NATIONAL',
7915: i.segment3,
7916: i.segment4,

Line 7957: per_ca_ee_extract_pkg.k,

7953: segment14,
7954: segment15,
7955: segment21) values
7956: ( p_request_id,
7957: per_ca_ee_extract_pkg.k,
7958: 'FORM5',
7959: 'NATIONAL',
7960: count_national.segment3,
7961: count_national.segment4,

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

8424: (ltrim(rtrim(prev_naic_code)) <> ltrim(rtrim(v_naic_code))) or
8425: (ltrim(rtrim(prev_employment_category)) <>
8426: ltrim(rtrim(v_employment_category)))) then
8427:
8428: per_ca_ee_extract_pkg.k := per_ca_ee_extract_pkg.k + 1;
8429:
8430: insert into per_ca_ee_report_lines
8431: (request_id,
8432: line_number,

Line 8488: line_number = per_ca_ee_extract_pkg.k and

8484: update per_ca_ee_report_lines set
8485: segment7=nvl(v_count,0),
8486: segment5=segment5 + nvl(v_count,0)
8487: where request_id=p_request_id and
8488: line_number = per_ca_ee_extract_pkg.k and
8489: context='FORM5' and
8490: segment1='PROVINCE' and
8491: segment2=v_province_name and
8492: segment3=v_meaning and

Line 8502: line_number = per_ca_ee_extract_pkg.k and

8498: update per_ca_ee_report_lines set
8499: segment6=nvl(v_count,0),
8500: segment5=segment5 + nvl(v_count,0)
8501: where request_id=p_request_id and
8502: line_number = per_ca_ee_extract_pkg.k and
8503: context='FORM5' and
8504: segment1='PROVINCE' and
8505: segment2=v_province_name and
8506: segment3=v_meaning and

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

8655: for x in cur_notfound(emp_cat) loop
8656:
8657: hr_utility.trace('Form6: cur_notfound' );
8658:
8659: per_ca_ee_extract_pkg.k := per_ca_ee_extract_pkg.k + 1;
8660:
8661: insert into per_ca_ee_report_lines
8662: (request_id,
8663: line_number,

Line 8683: per_ca_ee_extract_pkg.k,

8679: segment15,
8680: segment16,
8681: segment21) values
8682: ( p_request_id,
8683: per_ca_ee_extract_pkg.k,
8684: 'FORM6',
8685: 'PROVINCE',
8686: x.segment2,
8687: v_meaning,

Line 8734: per_ca_ee_extract_pkg.k,

8730: segment14,
8731: segment15,
8732: segment21) values
8733: ( p_request_id,
8734: per_ca_ee_extract_pkg.k,
8735: 'FORM6',
8736: 'NATIONAL',
8737: count_national.segment3,
8738: count_national.segment4,

Line 8949: end per_ca_ee_extract_pkg;

8945: end;
8946:
8947: end update_rec;
8948:
8949: end per_ca_ee_extract_pkg;