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: -- Commented below to fix bug 7476796

Line 1040: ) RETURN pqp_gb_t1_pension_extracts.t_sec_asgs_type

1036: FUNCTION get_all_secondary_asgs
1037: (p_primary_assignment_id IN NUMBER
1038: ,p_effective_date IN DATE
1039: ,p_person_id IN NUMBER
1040: ) RETURN pqp_gb_t1_pension_extracts.t_sec_asgs_type
1041: IS
1042:
1043: -- Rowtype Variable Declaration
1044: l_sec_asgs pqp_gb_t1_pension_extracts.csr_sec_assignments%ROWTYPE;

Line 1044: l_sec_asgs pqp_gb_t1_pension_extracts.csr_sec_assignments%ROWTYPE;

1040: ) RETURN pqp_gb_t1_pension_extracts.t_sec_asgs_type
1041: IS
1042:
1043: -- Rowtype Variable Declaration
1044: l_sec_asgs pqp_gb_t1_pension_extracts.csr_sec_assignments%ROWTYPE;
1045: l_all_sec_asgs pqp_gb_t1_pension_extracts.t_sec_asgs_type;
1046: idx NUMBER;
1047:
1048: --

Line 1045: l_all_sec_asgs pqp_gb_t1_pension_extracts.t_sec_asgs_type;

1041: IS
1042:
1043: -- Rowtype Variable Declaration
1044: l_sec_asgs pqp_gb_t1_pension_extracts.csr_sec_assignments%ROWTYPE;
1045: l_all_sec_asgs pqp_gb_t1_pension_extracts.t_sec_asgs_type;
1046: idx NUMBER;
1047:
1048: --
1049: l_proc_name VARCHAR2(61):=

Line 1069: FOR l_sec_asgs IN pqp_gb_t1_pension_extracts.csr_sec_assignments(p_primary_assignment_id

1065:
1066: -- Fetch secondary assignments
1067: idx := 0;
1068:
1069: FOR l_sec_asgs IN pqp_gb_t1_pension_extracts.csr_sec_assignments(p_primary_assignment_id
1070: ,p_person_id
1071: ,p_effective_date
1072: )
1073: LOOP

Line 1115: l_sec_assignments pqp_gb_t1_pension_extracts.t_sec_asgs_type;

1111: ) return varchar2 -- Y or N
1112: is
1113: --
1114: l_inclusion_flag varchar2(20) := 'N';
1115: l_sec_assignments pqp_gb_t1_pension_extracts.t_sec_asgs_type;
1116: l_is_a_teacher varchar2(1) := 'Y';
1117: l_person_id per_all_people_f.person_id%TYPE;
1118: l_start_date DATE;
1119: l_proc_name varchar2(61) := g_proc_name || 'chk_teacher_qual_for_tp2';

Line 1192: pqp_gb_t1_pension_extracts.g_effective_run_date := g_effective_run_date;

1188:
1189: set_type2_globals;
1190:
1191: --set the g_effective_run_date for type1 as its being used in csr_sec_assignments.
1192: pqp_gb_t1_pension_extracts.g_effective_run_date := g_effective_run_date;
1193:
1194: If g_error_number is not null Then
1195:
1196: debug(':inside If g_error_number is not null'||g_error_number, 120 );

Line 1229: pqp_gb_t1_pension_extracts.g_part_time_asg_count := 0;

1225: RETURN l_inclusion_flag ; -- the assignment will eventually fail for validity as no location exists.
1226:
1227: END IF ;
1228:
1229: pqp_gb_t1_pension_extracts.g_part_time_asg_count := 0;
1230:
1231: -- Check if this person should be reported by the current run
1232:
1233: pqp_gb_t1_pension_extracts.g_nested_level := g_nested_level;

Line 1233: pqp_gb_t1_pension_extracts.g_nested_level := g_nested_level;

1229: pqp_gb_t1_pension_extracts.g_part_time_asg_count := 0;
1230:
1231: -- Check if this person should be reported by the current run
1232:
1233: pqp_gb_t1_pension_extracts.g_nested_level := g_nested_level;
1234:
1235: IF pqp_gb_t1_pension_extracts.chk_report_person
1236: (p_business_group_id
1237: ,p_effective_date

Line 1235: IF pqp_gb_t1_pension_extracts.chk_report_person

1231: -- Check if this person should be reported by the current run
1232:
1233: pqp_gb_t1_pension_extracts.g_nested_level := g_nested_level;
1234:
1235: IF pqp_gb_t1_pension_extracts.chk_report_person
1236: (p_business_group_id
1237: ,p_effective_date
1238: ,p_assignment_id
1239: )

Line 1460: pqp_gb_t1_pension_extracts.g_nested_level := 0;

1456: -- CLOSE csr_sec_assignments;
1457:
1458: END IF;--chk_report_person
1459:
1460: pqp_gb_t1_pension_extracts.g_nested_level := 0;
1461:
1462: l_inclusion_flag := g_inclusion_flag;
1463: --
1464: debug(':l_inclusion_flag:'||l_inclusion_flag, 350 );

Line 1663: OPEN pqp_gb_t1_pension_extracts.csr_ext_rcd_id

1659: -- get the ben_ext_rcd.ext_rcd_id
1660: -- and use this one for next the cursor
1661: -- This will prevent FTS on the table.
1662:
1663: OPEN pqp_gb_t1_pension_extracts.csr_ext_rcd_id
1664: (p_hide_flag => 'N'
1665: ,p_rcd_type_cd => 'D'
1666: );
1667: FETCH pqp_gb_t1_pension_extracts.csr_ext_rcd_id INTO l_ext_rcd_id;

Line 1667: FETCH pqp_gb_t1_pension_extracts.csr_ext_rcd_id INTO l_ext_rcd_id;

1663: OPEN pqp_gb_t1_pension_extracts.csr_ext_rcd_id
1664: (p_hide_flag => 'N'
1665: ,p_rcd_type_cd => 'D'
1666: );
1667: FETCH pqp_gb_t1_pension_extracts.csr_ext_rcd_id INTO l_ext_rcd_id;
1668: CLOSE pqp_gb_t1_pension_extracts.csr_ext_rcd_id ;
1669:
1670: debug('l_ext_rcd_id: '|| l_ext_rcd_id, 10) ;
1671:

Line 1668: CLOSE pqp_gb_t1_pension_extracts.csr_ext_rcd_id ;

1664: (p_hide_flag => 'N'
1665: ,p_rcd_type_cd => 'D'
1666: );
1667: FETCH pqp_gb_t1_pension_extracts.csr_ext_rcd_id INTO l_ext_rcd_id;
1668: CLOSE pqp_gb_t1_pension_extracts.csr_ext_rcd_id ;
1669:
1670: debug('l_ext_rcd_id: '|| l_ext_rcd_id, 10) ;
1671:
1672: Open csr_get_total_add_cont(p_ext_rcd_id => l_ext_rcd_id );