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_GB_TP_TYPE2_FUNCTIONS dependencies on PQP_GB_TP_PENSION_EXTRACTS

Line 124: l_extract_attributes pqp_gb_tp_pension_extracts.csr_pqp_extract_attributes%ROWTYPE;

120: ,p_trace_on IN VARCHAR2 default null
121: )
122: IS
123:
124: l_extract_attributes pqp_gb_tp_pension_extracts.csr_pqp_extract_attributes%ROWTYPE;
125: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
126:
127: BEGIN
128:

Line 138: OPEN pqp_gb_tp_pension_extracts.csr_pqp_extract_attributes;

134: debug(':g_trace:'||g_trace,000);
135:
136: IF g_trace IS NULL THEN
137:
138: OPEN pqp_gb_tp_pension_extracts.csr_pqp_extract_attributes;
139: FETCH pqp_gb_tp_pension_extracts.csr_pqp_extract_attributes INTO l_extract_attributes;
140: CLOSE pqp_gb_tp_pension_extracts.csr_pqp_extract_attributes;
141:
142: l_business_group_id := fnd_global.per_business_group_id;

Line 139: FETCH pqp_gb_tp_pension_extracts.csr_pqp_extract_attributes INTO l_extract_attributes;

135:
136: IF g_trace IS NULL THEN
137:
138: OPEN pqp_gb_tp_pension_extracts.csr_pqp_extract_attributes;
139: FETCH pqp_gb_tp_pension_extracts.csr_pqp_extract_attributes INTO l_extract_attributes;
140: CLOSE pqp_gb_tp_pension_extracts.csr_pqp_extract_attributes;
141:
142: l_business_group_id := fnd_global.per_business_group_id;
143:

Line 140: CLOSE pqp_gb_tp_pension_extracts.csr_pqp_extract_attributes;

136: IF g_trace IS NULL THEN
137:
138: OPEN pqp_gb_tp_pension_extracts.csr_pqp_extract_attributes;
139: FETCH pqp_gb_tp_pension_extracts.csr_pqp_extract_attributes INTO l_extract_attributes;
140: CLOSE pqp_gb_tp_pension_extracts.csr_pqp_extract_attributes;
141:
142: l_business_group_id := fnd_global.per_business_group_id;
143:
144: BEGIN

Line 264: pqp_gb_tp_pension_extracts.g_header_system_element := g_header_system_element;

260: fnd_date.date_to_canonical(g_effective_end_date)||':'||
261: fnd_date.date_to_canonical(g_effective_date)||':' ;
262:
263:
264: pqp_gb_tp_pension_extracts.g_header_system_element := g_header_system_element;
265:
266:
267:
268: --debug(':g_header_system_element:'||g_header_system_element,530);

Line 402: g_lea_number := pqp_gb_tp_pension_extracts.g_lea_number;

398: -- Set the globals in this package from type 4
399:
400: -- ********* Variables ***************
401:
402: g_lea_number := pqp_gb_tp_pension_extracts.g_lea_number;
403: g_crossbg_enabled := pqp_gb_tp_pension_extracts.g_crossbg_enabled;
404: g_estb_number := pqp_gb_tp_pension_extracts.g_estb_number;
405: -- "end of day" of a day before effective date
406: g_effective_run_date :=

Line 403: g_crossbg_enabled := pqp_gb_tp_pension_extracts.g_crossbg_enabled;

399:
400: -- ********* Variables ***************
401:
402: g_lea_number := pqp_gb_tp_pension_extracts.g_lea_number;
403: g_crossbg_enabled := pqp_gb_tp_pension_extracts.g_crossbg_enabled;
404: g_estb_number := pqp_gb_tp_pension_extracts.g_estb_number;
405: -- "end of day" of a day before effective date
406: g_effective_run_date :=
407: fnd_date.canonical_to_date(TO_CHAR(g_effective_date - 1,'YYYY/MM/DD')||'23:59:59');

Line 404: g_estb_number := pqp_gb_tp_pension_extracts.g_estb_number;

400: -- ********* Variables ***************
401:
402: g_lea_number := pqp_gb_tp_pension_extracts.g_lea_number;
403: g_crossbg_enabled := pqp_gb_tp_pension_extracts.g_crossbg_enabled;
404: g_estb_number := pqp_gb_tp_pension_extracts.g_estb_number;
405: -- "end of day" of a day before effective date
406: g_effective_run_date :=
407: fnd_date.canonical_to_date(TO_CHAR(g_effective_date - 1,'YYYY/MM/DD')||'23:59:59');
408: -- ********* Ennd of Variables ***************

Line 613: debug(':estb_number:'||pqp_gb_tp_pension_extracts.g_criteria_estbs(p_location_id).estb_number, 710 + idx/10000 );

609: debug(':l_eet_details.element_type_id :'||l_eet_details.element_type_id, 650 + idx/1000000 );
610:
611: l_ele_exists := 'Y';
612:
613: debug(':estb_number:'||pqp_gb_tp_pension_extracts.g_criteria_estbs(p_location_id).estb_number, 710 + idx/10000 );
614:
615: --ENH3 And ENH4
616: p_return_status := true;
617: debug('return status is true',720 + idx/10000);

Line 711: If pqp_gb_tp_pension_extracts.g_criteria_estbs.exists(l_asg_details.location_id) Then

707: debug(':l_asg_details.location_id:'||l_asg_details.location_id ,380 +idx/10000);
708: debug(':l_asg_details.business_group_id:'||l_asg_details.business_group_id ,390+idx/10000);
709:
710: -- Check whether the establishment is a criteria establishment
711: If pqp_gb_tp_pension_extracts.g_criteria_estbs.exists(l_asg_details.location_id) Then
712:
713: i := i + 1;
714:
715: l_tab_asg_details(i) := l_asg_details;

Line 732: If pqp_gb_tp_pension_extracts.g_criteria_estbs.exists(l_next_asg_details.location_id) Then

728: debug(':l_next_asg_details.person_id:'||l_next_asg_details.person_id , 410 + idy/10000);
729: debug(':l_next_asg_details.assignment_id:'||l_next_asg_details.assignment_id,420 + idy/10000);
730: debug(':l_next_asg_details.location_id:'||l_next_asg_details.location_id,430 + idy/10000 );
731:
732: If pqp_gb_tp_pension_extracts.g_criteria_estbs.exists(l_next_asg_details.location_id) Then
733:
734: debug(':inside if ', 440 +idy/10000) ;
735: -- Extend the effective end date
736: l_tab_asg_details(i).effective_end_date :=

Line 959: l_estb_number := pqp_gb_tp_pension_extracts.g_criteria_estbs(p_location_id).estb_number;

955: debug(':l_tab_aat_info(i).effective_start_date:'||l_tab_aat_info(i).effective_start_date , 450 + i/1000000);
956: debug(':l_tab_aat_info(i).effective_end_date:'||l_tab_aat_info(i).effective_end_date ,460 + i/1000000);
957: debug(':l_tab_aat_info(i).tp_is_teacher:'||l_tab_aat_info(i).tp_is_teacher ,470 + i/1000000);
958: debug(':l_tab_aat_info(i).tp_elected_pension:'||l_tab_aat_info(i).tp_elected_pension ,480 + i/1000000);
959: l_estb_number := pqp_gb_tp_pension_extracts.g_criteria_estbs(p_location_id).estb_number;
960: l_estb_type := pqp_gb_tp_pension_extracts.g_criteria_estbs(p_location_id).estb_type;
961:
962: debug(':l_estb_number:'||l_estb_number,490 + i/1000000);
963: debug(':p_ext_emp_cat_cd:'||p_ext_emp_cat_cd,490 + i/1000000);

Line 960: l_estb_type := pqp_gb_tp_pension_extracts.g_criteria_estbs(p_location_id).estb_type;

956: debug(':l_tab_aat_info(i).effective_end_date:'||l_tab_aat_info(i).effective_end_date ,460 + i/1000000);
957: debug(':l_tab_aat_info(i).tp_is_teacher:'||l_tab_aat_info(i).tp_is_teacher ,470 + i/1000000);
958: debug(':l_tab_aat_info(i).tp_elected_pension:'||l_tab_aat_info(i).tp_elected_pension ,480 + i/1000000);
959: l_estb_number := pqp_gb_tp_pension_extracts.g_criteria_estbs(p_location_id).estb_number;
960: l_estb_type := pqp_gb_tp_pension_extracts.g_criteria_estbs(p_location_id).estb_type;
961:
962: debug(':l_estb_number:'||l_estb_number,490 + i/1000000);
963: debug(':p_ext_emp_cat_cd:'||p_ext_emp_cat_cd,490 + i/1000000);
964: debug(':l_estb_type:'||l_estb_type,490 + i/1000000);

Line 1163: pqp_gb_tp_pension_extracts.g_nested_level := g_nested_level;

1159:
1160: debug(':inside If g_business_group_id is null', 60 );
1161: --ENH3 And ENH4 .Added the new parameter lea number.
1162:
1163: pqp_gb_tp_pension_extracts.g_nested_level := g_nested_level;
1164:
1165:
1166:
1167: pqp_gb_tp_pension_extracts.set_extract_globals (p_business_group_id

Line 1167: pqp_gb_tp_pension_extracts.set_extract_globals (p_business_group_id

1163: pqp_gb_tp_pension_extracts.g_nested_level := g_nested_level;
1164:
1165:
1166:
1167: pqp_gb_tp_pension_extracts.set_extract_globals (p_business_group_id
1168: -- ,p_effective_date
1169: ,ben_ext_person.g_effective_date
1170: ,p_assignment_id
1171: );

Line 1173: pqp_gb_tp_pension_extracts.g_nested_level := 0;

1169: ,ben_ext_person.g_effective_date
1170: ,p_assignment_id
1171: );
1172:
1173: pqp_gb_tp_pension_extracts.g_nested_level := 0;
1174:
1175:
1176: g_business_group_id := pqp_gb_tp_pension_extracts.g_business_group_id;
1177: g_effective_date := pqp_gb_tp_pension_extracts.g_effective_date;

Line 1176: g_business_group_id := pqp_gb_tp_pension_extracts.g_business_group_id;

1172:
1173: pqp_gb_tp_pension_extracts.g_nested_level := 0;
1174:
1175:
1176: g_business_group_id := pqp_gb_tp_pension_extracts.g_business_group_id;
1177: g_effective_date := pqp_gb_tp_pension_extracts.g_effective_date;
1178: g_header_system_element := pqp_gb_tp_pension_extracts.g_header_system_element;
1179:
1180: debug(':g_business_group_id:'||g_business_group_id,80 );

Line 1177: g_effective_date := pqp_gb_tp_pension_extracts.g_effective_date;

1173: pqp_gb_tp_pension_extracts.g_nested_level := 0;
1174:
1175:
1176: g_business_group_id := pqp_gb_tp_pension_extracts.g_business_group_id;
1177: g_effective_date := pqp_gb_tp_pension_extracts.g_effective_date;
1178: g_header_system_element := pqp_gb_tp_pension_extracts.g_header_system_element;
1179:
1180: debug(':g_business_group_id:'||g_business_group_id,80 );
1181: debug(':g_effective_date:'||g_effective_date,90 );

Line 1178: g_header_system_element := pqp_gb_tp_pension_extracts.g_header_system_element;

1174:
1175:
1176: g_business_group_id := pqp_gb_tp_pension_extracts.g_business_group_id;
1177: g_effective_date := pqp_gb_tp_pension_extracts.g_effective_date;
1178: g_header_system_element := pqp_gb_tp_pension_extracts.g_header_system_element;
1179:
1180: debug(':g_business_group_id:'||g_business_group_id,80 );
1181: debug(':g_effective_date:'||g_effective_date,90 );
1182: debug(':g_header_system_element:'||g_header_system_element,110 );

Line 1214: IF pqp_gb_tp_pension_extracts.g_criteria_estbs.COUNT = 0 THEN

1210: -- Bugfix -- Bugfix 3671727: Performance enhancement
1211: -- If no location exists in the list of valid criteria
1212: -- establishments, then no point doing all checks
1213: -- Just warn once and skip every assignment
1214: IF pqp_gb_tp_pension_extracts.g_criteria_estbs.COUNT = 0 THEN
1215:
1216: debug('Setting inclusion flag to N as no locations EXIST.', 145);
1217: l_inclusion_flag := 'N';
1218:

Line 1219: pqp_gb_tp_pension_extracts.g_nested_level := g_nested_level;

1215:
1216: debug('Setting inclusion flag to N as no locations EXIST.', 145);
1217: l_inclusion_flag := 'N';
1218:
1219: pqp_gb_tp_pension_extracts.g_nested_level := g_nested_level;
1220: -- Call TP4 pkg proc to warning for no locations
1221: pqp_gb_tp_pension_extracts.warn_if_no_loc_exist
1222: (p_assignment_id => p_assignment_id) ;
1223: pqp_gb_tp_pension_extracts.g_nested_level := 0;

Line 1221: pqp_gb_tp_pension_extracts.warn_if_no_loc_exist

1217: l_inclusion_flag := 'N';
1218:
1219: pqp_gb_tp_pension_extracts.g_nested_level := g_nested_level;
1220: -- Call TP4 pkg proc to warning for no locations
1221: pqp_gb_tp_pension_extracts.warn_if_no_loc_exist
1222: (p_assignment_id => p_assignment_id) ;
1223: pqp_gb_tp_pension_extracts.g_nested_level := 0;
1224:
1225: RETURN l_inclusion_flag ; -- the assignment will eventually fail for validity as no location exists.

Line 1223: pqp_gb_tp_pension_extracts.g_nested_level := 0;

1219: pqp_gb_tp_pension_extracts.g_nested_level := g_nested_level;
1220: -- Call TP4 pkg proc to warning for no locations
1221: pqp_gb_tp_pension_extracts.warn_if_no_loc_exist
1222: (p_assignment_id => p_assignment_id) ;
1223: pqp_gb_tp_pension_extracts.g_nested_level := 0;
1224:
1225: RETURN l_inclusion_flag ; -- the assignment will eventually fail for validity as no location exists.
1226:
1227: END IF ;

Line 1269: pqp_gb_tp_pension_extracts.g_ext_asg_details(p_assignment_id).person_id :=

1265: debug('get_asg_info is true ', 170 );
1266:
1267: g_inclusion_flag := 'Y';
1268:
1269: pqp_gb_tp_pension_extracts.g_ext_asg_details(p_assignment_id).person_id :=
1270: l_person_id;
1271:
1272: pqp_gb_tp_pension_extracts.g_ext_asg_details(p_assignment_id).start_date :=
1273: g_effective_start_date;

Line 1272: pqp_gb_tp_pension_extracts.g_ext_asg_details(p_assignment_id).start_date :=

1268:
1269: pqp_gb_tp_pension_extracts.g_ext_asg_details(p_assignment_id).person_id :=
1270: l_person_id;
1271:
1272: pqp_gb_tp_pension_extracts.g_ext_asg_details(p_assignment_id).start_date :=
1273: g_effective_start_date;
1274:
1275: pqp_gb_tp_pension_extracts.g_ext_asg_details(p_assignment_id).estb_number :=
1276: pqp_gb_tp_pension_extracts.g_criteria_estbs(l_location_id).estb_number;

Line 1275: pqp_gb_tp_pension_extracts.g_ext_asg_details(p_assignment_id).estb_number :=

1271:
1272: pqp_gb_tp_pension_extracts.g_ext_asg_details(p_assignment_id).start_date :=
1273: g_effective_start_date;
1274:
1275: pqp_gb_tp_pension_extracts.g_ext_asg_details(p_assignment_id).estb_number :=
1276: pqp_gb_tp_pension_extracts.g_criteria_estbs(l_location_id).estb_number;
1277:
1278: debug('estb_number is '||
1279: pqp_gb_tp_pension_extracts.g_criteria_estbs(l_location_id).estb_number

Line 1276: pqp_gb_tp_pension_extracts.g_criteria_estbs(l_location_id).estb_number;

1272: pqp_gb_tp_pension_extracts.g_ext_asg_details(p_assignment_id).start_date :=
1273: g_effective_start_date;
1274:
1275: pqp_gb_tp_pension_extracts.g_ext_asg_details(p_assignment_id).estb_number :=
1276: pqp_gb_tp_pension_extracts.g_criteria_estbs(l_location_id).estb_number;
1277:
1278: debug('estb_number is '||
1279: pqp_gb_tp_pension_extracts.g_criteria_estbs(l_location_id).estb_number
1280: , 175 );

Line 1279: pqp_gb_tp_pension_extracts.g_criteria_estbs(l_location_id).estb_number

1275: pqp_gb_tp_pension_extracts.g_ext_asg_details(p_assignment_id).estb_number :=
1276: pqp_gb_tp_pension_extracts.g_criteria_estbs(l_location_id).estb_number;
1277:
1278: debug('estb_number is '||
1279: pqp_gb_tp_pension_extracts.g_criteria_estbs(l_location_id).estb_number
1280: , 175 );
1281:
1282: --
1283: -- Check the person is a teacher and has elected pension

Line 1313: pqp_gb_tp_pension_extracts.g_ext_asg_details(p_assignment_id).report_asg

1309: ELSE
1310:
1311: --if the primary assignment is not a valid type 2 record,set the report_asg
1312: --flag to 'N'
1313: pqp_gb_tp_pension_extracts.g_ext_asg_details(p_assignment_id).report_asg
1314: := 'N';
1315:
1316: debug('report_asg is N '|| p_assignment_id , 230 );
1317:

Line 1363: pqp_gb_tp_pension_extracts.g_ext_asg_details(l_curr_sec_asg_id).person_id :=

1359: debug('get_asg_info is true'|| l_curr_sec_asg_id, 260 + idx/10000);
1360:
1361: g_inclusion_flag := 'Y';
1362:
1363: pqp_gb_tp_pension_extracts.g_ext_asg_details(l_curr_sec_asg_id).person_id :=
1364: l_person_id;
1365:
1366: pqp_gb_tp_pension_extracts.g_ext_asg_details(l_curr_sec_asg_id).start_date :=
1367: g_effective_start_date;

Line 1366: pqp_gb_tp_pension_extracts.g_ext_asg_details(l_curr_sec_asg_id).start_date :=

1362:
1363: pqp_gb_tp_pension_extracts.g_ext_asg_details(l_curr_sec_asg_id).person_id :=
1364: l_person_id;
1365:
1366: pqp_gb_tp_pension_extracts.g_ext_asg_details(l_curr_sec_asg_id).start_date :=
1367: g_effective_start_date;
1368:
1369: pqp_gb_tp_pension_extracts.g_ext_asg_details(l_curr_sec_asg_id).estb_number :=
1370: pqp_gb_tp_pension_extracts.g_criteria_estbs(l_location_id).estb_number;

Line 1369: pqp_gb_tp_pension_extracts.g_ext_asg_details(l_curr_sec_asg_id).estb_number :=

1365:
1366: pqp_gb_tp_pension_extracts.g_ext_asg_details(l_curr_sec_asg_id).start_date :=
1367: g_effective_start_date;
1368:
1369: pqp_gb_tp_pension_extracts.g_ext_asg_details(l_curr_sec_asg_id).estb_number :=
1370: pqp_gb_tp_pension_extracts.g_criteria_estbs(l_location_id).estb_number;
1371:
1372: debug('l_estb_number is '||
1373: pqp_gb_tp_pension_extracts.g_criteria_estbs(l_location_id).estb_number

Line 1370: pqp_gb_tp_pension_extracts.g_criteria_estbs(l_location_id).estb_number;

1366: pqp_gb_tp_pension_extracts.g_ext_asg_details(l_curr_sec_asg_id).start_date :=
1367: g_effective_start_date;
1368:
1369: pqp_gb_tp_pension_extracts.g_ext_asg_details(l_curr_sec_asg_id).estb_number :=
1370: pqp_gb_tp_pension_extracts.g_criteria_estbs(l_location_id).estb_number;
1371:
1372: debug('l_estb_number is '||
1373: pqp_gb_tp_pension_extracts.g_criteria_estbs(l_location_id).estb_number
1374: ,265 );

Line 1373: pqp_gb_tp_pension_extracts.g_criteria_estbs(l_location_id).estb_number

1369: pqp_gb_tp_pension_extracts.g_ext_asg_details(l_curr_sec_asg_id).estb_number :=
1370: pqp_gb_tp_pension_extracts.g_criteria_estbs(l_location_id).estb_number;
1371:
1372: debug('l_estb_number is '||
1373: pqp_gb_tp_pension_extracts.g_criteria_estbs(l_location_id).estb_number
1374: ,265 );
1375:
1376: -- Check if hte Primary asg is not a valid asg
1377: -- then Add the secondary asg details at Primary asg also

Line 1382: (pqp_gb_tp_pension_extracts.g_ext_asg_details(p_assignment_id).report_asg ='N') THEN

1378: -- but only for the very first sec asg.
1379:
1380: IF l_first_time --Should be TRUE for the first time..
1381: AND -- the primary asg is not a valid asg
1382: (pqp_gb_tp_pension_extracts.g_ext_asg_details(p_assignment_id).report_asg ='N') THEN
1383:
1384: debug ('Primary is not valid, adding details of sec to primary in global collection',267) ;
1385:
1386: pqp_gb_tp_pension_extracts.g_ext_asg_details(p_assignment_id).person_id := l_person_id;

Line 1386: pqp_gb_tp_pension_extracts.g_ext_asg_details(p_assignment_id).person_id := l_person_id;

1382: (pqp_gb_tp_pension_extracts.g_ext_asg_details(p_assignment_id).report_asg ='N') THEN
1383:
1384: debug ('Primary is not valid, adding details of sec to primary in global collection',267) ;
1385:
1386: pqp_gb_tp_pension_extracts.g_ext_asg_details(p_assignment_id).person_id := l_person_id;
1387: pqp_gb_tp_pension_extracts.g_ext_asg_details(p_assignment_id).start_date := g_effective_start_date; --l_start_date;
1388: pqp_gb_tp_pension_extracts.g_ext_asg_details(p_assignment_id).estb_number :=
1389: pqp_gb_tp_pension_extracts.g_criteria_estbs(l_location_id).estb_number;
1390:

Line 1387: pqp_gb_tp_pension_extracts.g_ext_asg_details(p_assignment_id).start_date := g_effective_start_date; --l_start_date;

1383:
1384: debug ('Primary is not valid, adding details of sec to primary in global collection',267) ;
1385:
1386: pqp_gb_tp_pension_extracts.g_ext_asg_details(p_assignment_id).person_id := l_person_id;
1387: pqp_gb_tp_pension_extracts.g_ext_asg_details(p_assignment_id).start_date := g_effective_start_date; --l_start_date;
1388: pqp_gb_tp_pension_extracts.g_ext_asg_details(p_assignment_id).estb_number :=
1389: pqp_gb_tp_pension_extracts.g_criteria_estbs(l_location_id).estb_number;
1390:
1391: l_first_time := FALSE; -- reset the variable to prevent overwriting again and again.

Line 1388: pqp_gb_tp_pension_extracts.g_ext_asg_details(p_assignment_id).estb_number :=

1384: debug ('Primary is not valid, adding details of sec to primary in global collection',267) ;
1385:
1386: pqp_gb_tp_pension_extracts.g_ext_asg_details(p_assignment_id).person_id := l_person_id;
1387: pqp_gb_tp_pension_extracts.g_ext_asg_details(p_assignment_id).start_date := g_effective_start_date; --l_start_date;
1388: pqp_gb_tp_pension_extracts.g_ext_asg_details(p_assignment_id).estb_number :=
1389: pqp_gb_tp_pension_extracts.g_criteria_estbs(l_location_id).estb_number;
1390:
1391: l_first_time := FALSE; -- reset the variable to prevent overwriting again and again.
1392:

Line 1389: pqp_gb_tp_pension_extracts.g_criteria_estbs(l_location_id).estb_number;

1385:
1386: pqp_gb_tp_pension_extracts.g_ext_asg_details(p_assignment_id).person_id := l_person_id;
1387: pqp_gb_tp_pension_extracts.g_ext_asg_details(p_assignment_id).start_date := g_effective_start_date; --l_start_date;
1388: pqp_gb_tp_pension_extracts.g_ext_asg_details(p_assignment_id).estb_number :=
1389: pqp_gb_tp_pension_extracts.g_criteria_estbs(l_location_id).estb_number;
1390:
1391: l_first_time := FALSE; -- reset the variable to prevent overwriting again and again.
1392:
1393: END IF;

Line 1475: pqp_gb_tp_pension_extracts.g_nested_level := g_nested_level;

1471: -- there exist more than one lea with the same lea Number within a BG.
1472: -- the warning is raised for the first valid assignment for a single Run.
1473: -- the flag for warning is set during the global setting through set_extract_globals.
1474:
1475: pqp_gb_tp_pension_extracts.g_nested_level := g_nested_level;
1476: pqp_gb_tp_pension_extracts.warn_if_multi_lea_exist (p_assignment_id => p_assignment_id);
1477: pqp_gb_tp_pension_extracts.g_nested_level := 0;
1478:
1479: IF l_is_a_teacher = 'N' THEN

Line 1476: pqp_gb_tp_pension_extracts.warn_if_multi_lea_exist (p_assignment_id => p_assignment_id);

1472: -- the warning is raised for the first valid assignment for a single Run.
1473: -- the flag for warning is set during the global setting through set_extract_globals.
1474:
1475: pqp_gb_tp_pension_extracts.g_nested_level := g_nested_level;
1476: pqp_gb_tp_pension_extracts.warn_if_multi_lea_exist (p_assignment_id => p_assignment_id);
1477: pqp_gb_tp_pension_extracts.g_nested_level := 0;
1478:
1479: IF l_is_a_teacher = 'N' THEN
1480:

Line 1477: pqp_gb_tp_pension_extracts.g_nested_level := 0;

1473: -- the flag for warning is set during the global setting through set_extract_globals.
1474:
1475: pqp_gb_tp_pension_extracts.g_nested_level := g_nested_level;
1476: pqp_gb_tp_pension_extracts.warn_if_multi_lea_exist (p_assignment_id => p_assignment_id);
1477: pqp_gb_tp_pension_extracts.g_nested_level := 0;
1478:
1479: IF l_is_a_teacher = 'N' THEN
1480:
1481: --set the warning

Line 1744: If pqp_gb_tp_pension_extracts.g_estb_number = '0000' Then

1740: hr_utility.set_location('Entering: '||l_proc_name, 5);
1741: --
1742: debug_enter(l_proc_name);
1743:
1744: If pqp_gb_tp_pension_extracts.g_estb_number = '0000' Then
1745: l_lea_run := 'Y';
1746: End If; -- End if of estb number check...
1747:
1748: debug(':l_lea_run:'||l_lea_run, 1300 );