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 1156: pqp_gb_tp_pension_extracts.g_nested_level := g_nested_level;

1152:
1153: debug(':inside If g_business_group_id is null', 60 );
1154: --ENH3 And ENH4 .Added the new parameter lea number.
1155:
1156: pqp_gb_tp_pension_extracts.g_nested_level := g_nested_level;
1157:
1158:
1159:
1160: pqp_gb_tp_pension_extracts.set_extract_globals (p_business_group_id

Line 1160: pqp_gb_tp_pension_extracts.set_extract_globals (p_business_group_id

1156: pqp_gb_tp_pension_extracts.g_nested_level := g_nested_level;
1157:
1158:
1159:
1160: pqp_gb_tp_pension_extracts.set_extract_globals (p_business_group_id
1161: -- ,p_effective_date
1162: ,ben_ext_person.g_effective_date
1163: ,p_assignment_id
1164: );

Line 1166: pqp_gb_tp_pension_extracts.g_nested_level := 0;

1162: ,ben_ext_person.g_effective_date
1163: ,p_assignment_id
1164: );
1165:
1166: pqp_gb_tp_pension_extracts.g_nested_level := 0;
1167:
1168:
1169: g_business_group_id := pqp_gb_tp_pension_extracts.g_business_group_id;
1170: g_effective_date := pqp_gb_tp_pension_extracts.g_effective_date;

Line 1169: g_business_group_id := pqp_gb_tp_pension_extracts.g_business_group_id;

1165:
1166: pqp_gb_tp_pension_extracts.g_nested_level := 0;
1167:
1168:
1169: g_business_group_id := pqp_gb_tp_pension_extracts.g_business_group_id;
1170: g_effective_date := pqp_gb_tp_pension_extracts.g_effective_date;
1171: g_header_system_element := pqp_gb_tp_pension_extracts.g_header_system_element;
1172:
1173: debug(':g_business_group_id:'||g_business_group_id,80 );

Line 1170: g_effective_date := pqp_gb_tp_pension_extracts.g_effective_date;

1166: pqp_gb_tp_pension_extracts.g_nested_level := 0;
1167:
1168:
1169: g_business_group_id := pqp_gb_tp_pension_extracts.g_business_group_id;
1170: g_effective_date := pqp_gb_tp_pension_extracts.g_effective_date;
1171: g_header_system_element := pqp_gb_tp_pension_extracts.g_header_system_element;
1172:
1173: debug(':g_business_group_id:'||g_business_group_id,80 );
1174: debug(':g_effective_date:'||g_effective_date,90 );

Line 1171: g_header_system_element := pqp_gb_tp_pension_extracts.g_header_system_element;

1167:
1168:
1169: g_business_group_id := pqp_gb_tp_pension_extracts.g_business_group_id;
1170: g_effective_date := pqp_gb_tp_pension_extracts.g_effective_date;
1171: g_header_system_element := pqp_gb_tp_pension_extracts.g_header_system_element;
1172:
1173: debug(':g_business_group_id:'||g_business_group_id,80 );
1174: debug(':g_effective_date:'||g_effective_date,90 );
1175: debug(':g_header_system_element:'||g_header_system_element,110 );

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

1202: -- Bugfix -- Bugfix 3671727: Performance enhancement
1203: -- If no location exists in the list of valid criteria
1204: -- establishments, then no point doing all checks
1205: -- Just warn once and skip every assignment
1206: IF pqp_gb_tp_pension_extracts.g_criteria_estbs.COUNT = 0 THEN
1207:
1208: debug('Setting inclusion flag to N as no locations EXIST.', 145);
1209: l_inclusion_flag := 'N';
1210:

Line 1211: pqp_gb_tp_pension_extracts.g_nested_level := g_nested_level;

1207:
1208: debug('Setting inclusion flag to N as no locations EXIST.', 145);
1209: l_inclusion_flag := 'N';
1210:
1211: pqp_gb_tp_pension_extracts.g_nested_level := g_nested_level;
1212: -- Call TP4 pkg proc to warning for no locations
1213: pqp_gb_tp_pension_extracts.warn_if_no_loc_exist
1214: (p_assignment_id => p_assignment_id) ;
1215: pqp_gb_tp_pension_extracts.g_nested_level := 0;

Line 1213: pqp_gb_tp_pension_extracts.warn_if_no_loc_exist

1209: l_inclusion_flag := 'N';
1210:
1211: pqp_gb_tp_pension_extracts.g_nested_level := g_nested_level;
1212: -- Call TP4 pkg proc to warning for no locations
1213: pqp_gb_tp_pension_extracts.warn_if_no_loc_exist
1214: (p_assignment_id => p_assignment_id) ;
1215: pqp_gb_tp_pension_extracts.g_nested_level := 0;
1216:
1217: RETURN l_inclusion_flag ; -- the assignment will eventually fail for validity as no location exists.

Line 1215: pqp_gb_tp_pension_extracts.g_nested_level := 0;

1211: pqp_gb_tp_pension_extracts.g_nested_level := g_nested_level;
1212: -- Call TP4 pkg proc to warning for no locations
1213: pqp_gb_tp_pension_extracts.warn_if_no_loc_exist
1214: (p_assignment_id => p_assignment_id) ;
1215: pqp_gb_tp_pension_extracts.g_nested_level := 0;
1216:
1217: RETURN l_inclusion_flag ; -- the assignment will eventually fail for validity as no location exists.
1218:
1219: END IF ;

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

1257: debug('get_asg_info is true ', 170 );
1258:
1259: g_inclusion_flag := 'Y';
1260:
1261: pqp_gb_tp_pension_extracts.g_ext_asg_details(p_assignment_id).person_id :=
1262: l_person_id;
1263:
1264: pqp_gb_tp_pension_extracts.g_ext_asg_details(p_assignment_id).start_date :=
1265: g_effective_start_date;

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

1260:
1261: pqp_gb_tp_pension_extracts.g_ext_asg_details(p_assignment_id).person_id :=
1262: l_person_id;
1263:
1264: pqp_gb_tp_pension_extracts.g_ext_asg_details(p_assignment_id).start_date :=
1265: g_effective_start_date;
1266:
1267: pqp_gb_tp_pension_extracts.g_ext_asg_details(p_assignment_id).estb_number :=
1268: pqp_gb_tp_pension_extracts.g_criteria_estbs(l_location_id).estb_number;

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

1263:
1264: pqp_gb_tp_pension_extracts.g_ext_asg_details(p_assignment_id).start_date :=
1265: g_effective_start_date;
1266:
1267: pqp_gb_tp_pension_extracts.g_ext_asg_details(p_assignment_id).estb_number :=
1268: pqp_gb_tp_pension_extracts.g_criteria_estbs(l_location_id).estb_number;
1269:
1270: debug('estb_number is '||
1271: pqp_gb_tp_pension_extracts.g_criteria_estbs(l_location_id).estb_number

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

1264: pqp_gb_tp_pension_extracts.g_ext_asg_details(p_assignment_id).start_date :=
1265: g_effective_start_date;
1266:
1267: pqp_gb_tp_pension_extracts.g_ext_asg_details(p_assignment_id).estb_number :=
1268: pqp_gb_tp_pension_extracts.g_criteria_estbs(l_location_id).estb_number;
1269:
1270: debug('estb_number is '||
1271: pqp_gb_tp_pension_extracts.g_criteria_estbs(l_location_id).estb_number
1272: , 175 );

Line 1271: pqp_gb_tp_pension_extracts.g_criteria_estbs(l_location_id).estb_number

1267: pqp_gb_tp_pension_extracts.g_ext_asg_details(p_assignment_id).estb_number :=
1268: pqp_gb_tp_pension_extracts.g_criteria_estbs(l_location_id).estb_number;
1269:
1270: debug('estb_number is '||
1271: pqp_gb_tp_pension_extracts.g_criteria_estbs(l_location_id).estb_number
1272: , 175 );
1273:
1274: --
1275: -- Check the person is a teacher and has elected pension

Line 1305: pqp_gb_tp_pension_extracts.g_ext_asg_details(p_assignment_id).report_asg

1301: ELSE
1302:
1303: --if the primary assignment is not a valid type 2 record,set the report_asg
1304: --flag to 'N'
1305: pqp_gb_tp_pension_extracts.g_ext_asg_details(p_assignment_id).report_asg
1306: := 'N';
1307:
1308: debug('report_asg is N '|| p_assignment_id , 230 );
1309:

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

1351: debug('get_asg_info is true'|| l_curr_sec_asg_id, 260 + idx/10000);
1352:
1353: g_inclusion_flag := 'Y';
1354:
1355: pqp_gb_tp_pension_extracts.g_ext_asg_details(l_curr_sec_asg_id).person_id :=
1356: l_person_id;
1357:
1358: pqp_gb_tp_pension_extracts.g_ext_asg_details(l_curr_sec_asg_id).start_date :=
1359: g_effective_start_date;

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

1354:
1355: pqp_gb_tp_pension_extracts.g_ext_asg_details(l_curr_sec_asg_id).person_id :=
1356: l_person_id;
1357:
1358: pqp_gb_tp_pension_extracts.g_ext_asg_details(l_curr_sec_asg_id).start_date :=
1359: g_effective_start_date;
1360:
1361: pqp_gb_tp_pension_extracts.g_ext_asg_details(l_curr_sec_asg_id).estb_number :=
1362: pqp_gb_tp_pension_extracts.g_criteria_estbs(l_location_id).estb_number;

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

1357:
1358: pqp_gb_tp_pension_extracts.g_ext_asg_details(l_curr_sec_asg_id).start_date :=
1359: g_effective_start_date;
1360:
1361: pqp_gb_tp_pension_extracts.g_ext_asg_details(l_curr_sec_asg_id).estb_number :=
1362: pqp_gb_tp_pension_extracts.g_criteria_estbs(l_location_id).estb_number;
1363:
1364: debug('l_estb_number is '||
1365: pqp_gb_tp_pension_extracts.g_criteria_estbs(l_location_id).estb_number

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

1358: pqp_gb_tp_pension_extracts.g_ext_asg_details(l_curr_sec_asg_id).start_date :=
1359: g_effective_start_date;
1360:
1361: pqp_gb_tp_pension_extracts.g_ext_asg_details(l_curr_sec_asg_id).estb_number :=
1362: pqp_gb_tp_pension_extracts.g_criteria_estbs(l_location_id).estb_number;
1363:
1364: debug('l_estb_number is '||
1365: pqp_gb_tp_pension_extracts.g_criteria_estbs(l_location_id).estb_number
1366: ,265 );

Line 1365: pqp_gb_tp_pension_extracts.g_criteria_estbs(l_location_id).estb_number

1361: pqp_gb_tp_pension_extracts.g_ext_asg_details(l_curr_sec_asg_id).estb_number :=
1362: pqp_gb_tp_pension_extracts.g_criteria_estbs(l_location_id).estb_number;
1363:
1364: debug('l_estb_number is '||
1365: pqp_gb_tp_pension_extracts.g_criteria_estbs(l_location_id).estb_number
1366: ,265 );
1367:
1368: -- Check if hte Primary asg is not a valid asg
1369: -- then Add the secondary asg details at Primary asg also

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

1370: -- but only for the very first sec asg.
1371:
1372: IF l_first_time --Should be TRUE for the first time..
1373: AND -- the primary asg is not a valid asg
1374: (pqp_gb_tp_pension_extracts.g_ext_asg_details(p_assignment_id).report_asg ='N') THEN
1375:
1376: debug ('Primary is not valid, adding details of sec to primary in global collection',267) ;
1377:
1378: pqp_gb_tp_pension_extracts.g_ext_asg_details(p_assignment_id).person_id := l_person_id;

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

1374: (pqp_gb_tp_pension_extracts.g_ext_asg_details(p_assignment_id).report_asg ='N') THEN
1375:
1376: debug ('Primary is not valid, adding details of sec to primary in global collection',267) ;
1377:
1378: pqp_gb_tp_pension_extracts.g_ext_asg_details(p_assignment_id).person_id := l_person_id;
1379: pqp_gb_tp_pension_extracts.g_ext_asg_details(p_assignment_id).start_date := l_start_date;
1380: pqp_gb_tp_pension_extracts.g_ext_asg_details(p_assignment_id).estb_number :=
1381: pqp_gb_tp_pension_extracts.g_criteria_estbs(l_location_id).estb_number;
1382:

Line 1379: pqp_gb_tp_pension_extracts.g_ext_asg_details(p_assignment_id).start_date := l_start_date;

1375:
1376: debug ('Primary is not valid, adding details of sec to primary in global collection',267) ;
1377:
1378: pqp_gb_tp_pension_extracts.g_ext_asg_details(p_assignment_id).person_id := l_person_id;
1379: pqp_gb_tp_pension_extracts.g_ext_asg_details(p_assignment_id).start_date := l_start_date;
1380: pqp_gb_tp_pension_extracts.g_ext_asg_details(p_assignment_id).estb_number :=
1381: pqp_gb_tp_pension_extracts.g_criteria_estbs(l_location_id).estb_number;
1382:
1383: l_first_time := FALSE; -- reset the variable to prevent overwriting again and again.

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

1376: debug ('Primary is not valid, adding details of sec to primary in global collection',267) ;
1377:
1378: pqp_gb_tp_pension_extracts.g_ext_asg_details(p_assignment_id).person_id := l_person_id;
1379: pqp_gb_tp_pension_extracts.g_ext_asg_details(p_assignment_id).start_date := l_start_date;
1380: pqp_gb_tp_pension_extracts.g_ext_asg_details(p_assignment_id).estb_number :=
1381: pqp_gb_tp_pension_extracts.g_criteria_estbs(l_location_id).estb_number;
1382:
1383: l_first_time := FALSE; -- reset the variable to prevent overwriting again and again.
1384:

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

1377:
1378: pqp_gb_tp_pension_extracts.g_ext_asg_details(p_assignment_id).person_id := l_person_id;
1379: pqp_gb_tp_pension_extracts.g_ext_asg_details(p_assignment_id).start_date := l_start_date;
1380: pqp_gb_tp_pension_extracts.g_ext_asg_details(p_assignment_id).estb_number :=
1381: pqp_gb_tp_pension_extracts.g_criteria_estbs(l_location_id).estb_number;
1382:
1383: l_first_time := FALSE; -- reset the variable to prevent overwriting again and again.
1384:
1385: END IF;

Line 1467: pqp_gb_tp_pension_extracts.g_nested_level := g_nested_level;

1463: -- there exist more than one lea with the same lea Number within a BG.
1464: -- the warning is raised for the first valid assignment for a single Run.
1465: -- the flag for warning is set during the global setting through set_extract_globals.
1466:
1467: pqp_gb_tp_pension_extracts.g_nested_level := g_nested_level;
1468: pqp_gb_tp_pension_extracts.warn_if_multi_lea_exist (p_assignment_id => p_assignment_id);
1469: pqp_gb_tp_pension_extracts.g_nested_level := 0;
1470:
1471: IF l_is_a_teacher = 'N' THEN

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

1464: -- the warning is raised for the first valid assignment for a single Run.
1465: -- the flag for warning is set during the global setting through set_extract_globals.
1466:
1467: pqp_gb_tp_pension_extracts.g_nested_level := g_nested_level;
1468: pqp_gb_tp_pension_extracts.warn_if_multi_lea_exist (p_assignment_id => p_assignment_id);
1469: pqp_gb_tp_pension_extracts.g_nested_level := 0;
1470:
1471: IF l_is_a_teacher = 'N' THEN
1472:

Line 1469: pqp_gb_tp_pension_extracts.g_nested_level := 0;

1465: -- the flag for warning is set during the global setting through set_extract_globals.
1466:
1467: pqp_gb_tp_pension_extracts.g_nested_level := g_nested_level;
1468: pqp_gb_tp_pension_extracts.warn_if_multi_lea_exist (p_assignment_id => p_assignment_id);
1469: pqp_gb_tp_pension_extracts.g_nested_level := 0;
1470:
1471: IF l_is_a_teacher = 'N' THEN
1472:
1473: --set the warning

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

1720: hr_utility.set_location('Entering: '||l_proc_name, 5);
1721: --
1722: debug_enter(l_proc_name);
1723:
1724: If pqp_gb_tp_pension_extracts.g_estb_number = '0000' Then
1725: l_lea_run := 'Y';
1726: End If; -- End if of estb number check...
1727:
1728: debug(':l_lea_run:'||l_lea_run, 1300 );