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_T1_PENSION_EXTRACTS

Line 345: pqp_gb_t1_pension_extracts.g_lea_business_groups.exists(l_ele_ids.business_group_id)

341: Exit when csr_get_pay_ele_ids_from_bal%notfound;
342:
343: --get the valid element type ids for this BG.
344: IF (
345: pqp_gb_t1_pension_extracts.g_lea_business_groups.exists(l_ele_ids.business_group_id)
346: OR
347: g_business_group_id = l_ele_ids.business_group_id
348: )
349: THEN

Line 424: pqp_gb_t1_pension_extracts.g_nested_level := g_nested_level;

420: THEN
421: -- Store all BGs with same LEA Number and
422: -- enabled for cross BG reporting
423:
424: pqp_gb_t1_pension_extracts.g_nested_level := g_nested_level;
425:
426: pqp_gb_t1_pension_extracts.store_cross_bg_details;
427:
428: pqp_gb_t1_pension_extracts.g_nested_level := 0;

Line 426: pqp_gb_t1_pension_extracts.store_cross_bg_details;

422: -- enabled for cross BG reporting
423:
424: pqp_gb_t1_pension_extracts.g_nested_level := g_nested_level;
425:
426: pqp_gb_t1_pension_extracts.store_cross_bg_details;
427:
428: pqp_gb_t1_pension_extracts.g_nested_level := 0;
429:
430: ELSE -- Non-LEA Run

Line 428: pqp_gb_t1_pension_extracts.g_nested_level := 0;

424: pqp_gb_t1_pension_extracts.g_nested_level := g_nested_level;
425:
426: pqp_gb_t1_pension_extracts.store_cross_bg_details;
427:
428: pqp_gb_t1_pension_extracts.g_nested_level := 0;
429:
430: ELSE -- Non-LEA Run
431: g_master_bg_id := g_business_group_id;
432: END IF;

Line 791: l_ext_emp_cat_cd := pqp_gb_t1_pension_extracts.Get_Translate_Asg_Emp_Cat_Code

787: End If; -- End if of assignment qual for type2 check...
788:
789: IF l_return_status THEN
790:
791: l_ext_emp_cat_cd := pqp_gb_t1_pension_extracts.Get_Translate_Asg_Emp_Cat_Code
792: (
793: l_asg_emp_cat_cd
794: ,p_effective_start_date
795: ,'Pension Extracts Employment Category Code'

Line 805: pqp_gb_t1_pension_extracts.g_part_time_asg_count :=

801: l_ext_emp_cat_cd := nvl(l_ext_emp_cat_cd,'F');
802:
803: IF l_ext_emp_cat_cd = 'P' THEN
804:
805: pqp_gb_t1_pension_extracts.g_part_time_asg_count :=
806: pqp_gb_t1_pension_extracts.g_part_time_asg_count + 1;
807: debug('Incrementing part time assignment count',172);
808:
809: END IF;

Line 806: pqp_gb_t1_pension_extracts.g_part_time_asg_count + 1;

802:
803: IF l_ext_emp_cat_cd = 'P' THEN
804:
805: pqp_gb_t1_pension_extracts.g_part_time_asg_count :=
806: pqp_gb_t1_pension_extracts.g_part_time_asg_count + 1;
807: debug('Incrementing part time assignment count',172);
808:
809: END IF;
810:

Line 1034: ) RETURN pqp_gb_t1_pension_extracts.t_sec_asgs_type

1030: FUNCTION get_all_secondary_asgs
1031: (p_primary_assignment_id IN NUMBER
1032: ,p_effective_date IN DATE
1033: ,p_person_id IN NUMBER
1034: ) RETURN pqp_gb_t1_pension_extracts.t_sec_asgs_type
1035: IS
1036:
1037: -- Rowtype Variable Declaration
1038: l_sec_asgs pqp_gb_t1_pension_extracts.csr_sec_assignments%ROWTYPE;

Line 1038: l_sec_asgs pqp_gb_t1_pension_extracts.csr_sec_assignments%ROWTYPE;

1034: ) RETURN pqp_gb_t1_pension_extracts.t_sec_asgs_type
1035: IS
1036:
1037: -- Rowtype Variable Declaration
1038: l_sec_asgs pqp_gb_t1_pension_extracts.csr_sec_assignments%ROWTYPE;
1039: l_all_sec_asgs pqp_gb_t1_pension_extracts.t_sec_asgs_type;
1040: idx NUMBER;
1041:
1042: --

Line 1039: l_all_sec_asgs pqp_gb_t1_pension_extracts.t_sec_asgs_type;

1035: IS
1036:
1037: -- Rowtype Variable Declaration
1038: l_sec_asgs pqp_gb_t1_pension_extracts.csr_sec_assignments%ROWTYPE;
1039: l_all_sec_asgs pqp_gb_t1_pension_extracts.t_sec_asgs_type;
1040: idx NUMBER;
1041:
1042: --
1043: l_proc_name VARCHAR2(61):=

Line 1063: FOR l_sec_asgs IN pqp_gb_t1_pension_extracts.csr_sec_assignments(p_primary_assignment_id

1059:
1060: -- Fetch secondary assignments
1061: idx := 0;
1062:
1063: FOR l_sec_asgs IN pqp_gb_t1_pension_extracts.csr_sec_assignments(p_primary_assignment_id
1064: ,p_person_id
1065: ,p_effective_date
1066: )
1067: LOOP

Line 1109: l_sec_assignments pqp_gb_t1_pension_extracts.t_sec_asgs_type;

1105: ) return varchar2 -- Y or N
1106: is
1107: --
1108: l_inclusion_flag varchar2(20) := 'N';
1109: l_sec_assignments pqp_gb_t1_pension_extracts.t_sec_asgs_type;
1110: l_is_a_teacher varchar2(1) := 'Y';
1111: l_person_id per_all_people_f.person_id%TYPE;
1112: l_start_date DATE;
1113: l_proc_name varchar2(61) := g_proc_name || 'chk_teacher_qual_for_tp2';

Line 1185: pqp_gb_t1_pension_extracts.g_effective_run_date := g_effective_run_date;

1181:
1182: set_type2_globals;
1183:
1184: --set the g_effective_run_date for type1 as its being used in csr_sec_assignments.
1185: pqp_gb_t1_pension_extracts.g_effective_run_date := g_effective_run_date;
1186:
1187: If g_error_number is not null Then
1188:
1189: debug(':inside If g_error_number is not null'||g_error_number, 120 );

Line 1221: pqp_gb_t1_pension_extracts.g_part_time_asg_count := 0;

1217: RETURN l_inclusion_flag ; -- the assignment will eventually fail for validity as no location exists.
1218:
1219: END IF ;
1220:
1221: pqp_gb_t1_pension_extracts.g_part_time_asg_count := 0;
1222:
1223: -- Check if this person should be reported by the current run
1224:
1225: pqp_gb_t1_pension_extracts.g_nested_level := g_nested_level;

Line 1225: pqp_gb_t1_pension_extracts.g_nested_level := g_nested_level;

1221: pqp_gb_t1_pension_extracts.g_part_time_asg_count := 0;
1222:
1223: -- Check if this person should be reported by the current run
1224:
1225: pqp_gb_t1_pension_extracts.g_nested_level := g_nested_level;
1226:
1227: IF pqp_gb_t1_pension_extracts.chk_report_person
1228: (p_business_group_id
1229: ,p_effective_date

Line 1227: IF pqp_gb_t1_pension_extracts.chk_report_person

1223: -- Check if this person should be reported by the current run
1224:
1225: pqp_gb_t1_pension_extracts.g_nested_level := g_nested_level;
1226:
1227: IF pqp_gb_t1_pension_extracts.chk_report_person
1228: (p_business_group_id
1229: ,p_effective_date
1230: ,p_assignment_id
1231: )

Line 1452: pqp_gb_t1_pension_extracts.g_nested_level := 0;

1448: -- CLOSE csr_sec_assignments;
1449:
1450: END IF;--chk_report_person
1451:
1452: pqp_gb_t1_pension_extracts.g_nested_level := 0;
1453:
1454: l_inclusion_flag := g_inclusion_flag;
1455: --
1456: debug(':l_inclusion_flag:'||l_inclusion_flag, 350 );

Line 1643: OPEN pqp_gb_t1_pension_extracts.csr_ext_rcd_id

1639: -- get the ben_ext_rcd.ext_rcd_id
1640: -- and use this one for next the cursor
1641: -- This will prevent FTS on the table.
1642:
1643: OPEN pqp_gb_t1_pension_extracts.csr_ext_rcd_id
1644: (p_hide_flag => 'N'
1645: ,p_rcd_type_cd => 'D'
1646: );
1647: FETCH pqp_gb_t1_pension_extracts.csr_ext_rcd_id INTO l_ext_rcd_id;

Line 1647: FETCH pqp_gb_t1_pension_extracts.csr_ext_rcd_id INTO l_ext_rcd_id;

1643: OPEN pqp_gb_t1_pension_extracts.csr_ext_rcd_id
1644: (p_hide_flag => 'N'
1645: ,p_rcd_type_cd => 'D'
1646: );
1647: FETCH pqp_gb_t1_pension_extracts.csr_ext_rcd_id INTO l_ext_rcd_id;
1648: CLOSE pqp_gb_t1_pension_extracts.csr_ext_rcd_id ;
1649:
1650: debug('l_ext_rcd_id: '|| l_ext_rcd_id, 10) ;
1651:

Line 1648: CLOSE pqp_gb_t1_pension_extracts.csr_ext_rcd_id ;

1644: (p_hide_flag => 'N'
1645: ,p_rcd_type_cd => 'D'
1646: );
1647: FETCH pqp_gb_t1_pension_extracts.csr_ext_rcd_id INTO l_ext_rcd_id;
1648: CLOSE pqp_gb_t1_pension_extracts.csr_ext_rcd_id ;
1649:
1650: debug('l_ext_rcd_id: '|| l_ext_rcd_id, 10) ;
1651:
1652: Open csr_get_total_add_cont(p_ext_rcd_id => l_ext_rcd_id );