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_US_SRS_EXTRACTS dependencies on PER_ALL_ASSIGNMENTS_F

Line 26: (p_business_group_id In per_all_assignments_f.business_group_id%TYPE -- Context

22: -- ~ Get_Balance_Value : Get the Balance Total for the given dimension as of
23: -- ~ an effective date for an assignment_id
24: -- =============================================================================
25: Function Get_Balance_Value
26: (p_business_group_id In per_all_assignments_f.business_group_id%TYPE -- Context
27: ,p_assignment_id In per_all_assignments_f.assignment_id%TYPE -- Context
28: ,p_effective_date In date -- Context
29: ,p_balance_name In varchar2
30: ,p_dimension_name In varchar2) Return Number As

Line 27: ,p_assignment_id In per_all_assignments_f.assignment_id%TYPE -- Context

23: -- ~ an effective date for an assignment_id
24: -- =============================================================================
25: Function Get_Balance_Value
26: (p_business_group_id In per_all_assignments_f.business_group_id%TYPE -- Context
27: ,p_assignment_id In per_all_assignments_f.assignment_id%TYPE -- Context
28: ,p_effective_date In date -- Context
29: ,p_balance_name In varchar2
30: ,p_dimension_name In varchar2) Return Number As
31:

Line 126: Function Get_Payroll_Name (p_assignment_id In per_all_assignments_f.assignment_id%TYPE

122:
123: -- ===============================================================================
124: -- ~ Get_Payroll_Name : Get the Payroll Name for an Assignment ~
125: -- ===============================================================================
126: Function Get_Payroll_Name (p_assignment_id In per_all_assignments_f.assignment_id%TYPE
127: ,p_payroll_name In out nocopy varchar2) Return Number Is
128:
129: Cursor csr_payroll_name (c_payroll_id In per_all_assignments_f.payroll_id%TYPE
130: ,c_effective_date In date ) Is

Line 129: Cursor csr_payroll_name (c_payroll_id In per_all_assignments_f.payroll_id%TYPE

125: -- ===============================================================================
126: Function Get_Payroll_Name (p_assignment_id In per_all_assignments_f.assignment_id%TYPE
127: ,p_payroll_name In out nocopy varchar2) Return Number Is
128:
129: Cursor csr_payroll_name (c_payroll_id In per_all_assignments_f.payroll_id%TYPE
130: ,c_effective_date In date ) Is
131: Select payroll_name, period_type
132: from pay_payrolls_f
133: Where c_effective_date Between effective_start_date

Line 137: l_payroll_id per_all_assignments_f.payroll_id%TYPE;

133: Where c_effective_date Between effective_start_date
134: and effective_end_date
135: and payroll_id = c_payroll_id;
136:
137: l_payroll_id per_all_assignments_f.payroll_id%TYPE;
138: l_start_date date;
139: l_end_date date;
140: l_payroll_name pay_payrolls_f.payroll_name%TYPE;
141: l_period_type pay_payrolls_f.period_type%TYPE;

Line 203: Function Get_Payroll_Start_Date( p_assignment_id In per_all_assignments_f.assignment_id%TYPE

199:
200: -- ===============================================================================
201: -- ~ Get_Payroll_Start_Date :
202: -- ===============================================================================
203: Function Get_Payroll_Start_Date( p_assignment_id In per_all_assignments_f.assignment_id%TYPE
204: ,p_start_date In out nocopy Varchar2) Return Number Is
205: l_proc_name varchar2(150) := g_proc_name ||'.Get_Payroll_Start_Date';
206: l_date_nc varchar2(20);
207: Begin

Line 229: Function Get_Payroll_End_Date (p_assignment_id In per_all_assignments_f.assignment_id%TYPE

225:
226: -- ===============================================================================
227: -- ~ Get_Payroll_End_Date :
228: -- ===============================================================================
229: Function Get_Payroll_End_Date (p_assignment_id In per_all_assignments_f.assignment_id%TYPE
230: ,p_end_date In out nocopy Varchar2) Return Number Is
231: l_proc_name varchar2(150) := g_proc_name ||'.Get_Payroll_End_Date';
232: -- nocopy changes tmehra
233: l_date_nc varchar2(20);

Line 256: Function Get_Actual_Pay_Date ( p_assignment_id In per_all_assignments_f.assignment_id%TYPE

252:
253: -- ===============================================================================
254: -- ~ Get_Actual_Pay_Date :
255: -- ===============================================================================
256: Function Get_Actual_Pay_Date ( p_assignment_id In per_all_assignments_f.assignment_id%TYPE
257: ,p_pay_date In out nocopy Varchar2) Return Number Is
258: l_proc_name varchar2(150) := g_proc_name ||'.Get_Actual_Pay_Date';
259: -- nocopy changes tmehra
260: l_date_nc varchar2(20);

Line 262: Cursor csr_pay_date ( c_assignment_id In per_all_assignments_f.assignment_id%TYPE

258: l_proc_name varchar2(150) := g_proc_name ||'.Get_Actual_Pay_Date';
259: -- nocopy changes tmehra
260: l_date_nc varchar2(20);
261:
262: Cursor csr_pay_date ( c_assignment_id In per_all_assignments_f.assignment_id%TYPE
263: ,c_effective_date In date) Is
264: Select max(ppa.effective_date)
265: from pay_payroll_actions ppa,
266: per_time_periods ptp

Line 319: Function Get_SRS_Plan_Name (p_assignment_id In per_all_assignments_f.assignment_id%TYPE

315:
316: -- ===============================================================================
317: -- ~ Get_SRS_Plan_Name :
318: -- ===============================================================================
319: Function Get_SRS_Plan_Name (p_assignment_id In per_all_assignments_f.assignment_id%TYPE
320: ,p_SRS_Plan_Name In out nocopy Varchar2) Return Number Is
321: l_proc_name varchar2(150) := g_proc_name ||'.Get_SRS_Plan_Name';
322: --Nocopy changes
323: l_srs_plan_name_nc varchar2(200);

Line 347: Function Get_Separation_Date (p_assignment_id In per_all_assignments_f.assignment_id%TYPE

343: -- ===============================================================================
344: -- ~ Get_Separation_Date : which occurs first Plan end date in Assig Extra Info ~
345: -- ~ or the assignment end date i.e. terminated or retired etc.
346: -- ===============================================================================
347: Function Get_Separation_Date (p_assignment_id In per_all_assignments_f.assignment_id%TYPE
348: ,p_Separation_Date In out nocopy Varchar2) Return Number Is
349:
350: l_proc_name varchar2(150) := g_proc_name ||'.Get_Separation_Date';
351: l_assig_end_date date;

Line 389: Function Get_Assig_Status (p_assignment_id In per_all_assignments_f.assignment_id%TYPE

385:
386: -- ===============================================================================
387: -- ~ Get_Assig_Status : Fetchs the Assignment status for a given assignment id ~
388: -- ===============================================================================
389: Function Get_Assig_Status (p_assignment_id In per_all_assignments_f.assignment_id%TYPE
390: ,p_status_code In out nocopy Varchar2) Return Number Is
391: Cursor cur_status_name
392: (c_assignment_status_type_id In per_all_assignments_f.assignment_status_type_id%TYPE) Is
393: select user_status

Line 392: (c_assignment_status_type_id In per_all_assignments_f.assignment_status_type_id%TYPE) Is

388: -- ===============================================================================
389: Function Get_Assig_Status (p_assignment_id In per_all_assignments_f.assignment_id%TYPE
390: ,p_status_code In out nocopy Varchar2) Return Number Is
391: Cursor cur_status_name
392: (c_assignment_status_type_id In per_all_assignments_f.assignment_status_type_id%TYPE) Is
393: select user_status
394: from per_assignment_status_types
395: where assignment_status_type_id = c_assignment_status_type_id;
396:

Line 398: l_assig_type_id per_all_assignments_f.assignment_status_type_id%TYPE;

394: from per_assignment_status_types
395: where assignment_status_type_id = c_assignment_status_type_id;
396:
397: l_assig_status per_assignment_status_types.user_status%TYPE;
398: l_assig_type_id per_all_assignments_f.assignment_status_type_id%TYPE;
399: l_proc_name varchar2(150) := g_proc_name ||'.Get_Assig_Status';
400: l_error varchar2(500);
401: -- nocopy changes
402: l_status_code_nc varchar2(100);

Line 440: Function Get_Person_Indentifier( p_assignment_id In per_all_assignments_f.assignment_id%TYPE -- context

436: -- ===============================================================================
437: -- ~ Get_Person_Indentifier : Return the Plan Id for the current plan being ~
438: -- ~ processed. This is used for both primary and secondary assignments ~
439: -- ===============================================================================
440: Function Get_Person_Indentifier( p_assignment_id In per_all_assignments_f.assignment_id%TYPE -- context
441: ,p_person_identifier In out nocopy Varchar2 ) Return Number Is
442: l_proc_name varchar2(150) := g_proc_name ||'.Get_Person_Indentifier';
443: -- nocopy changes
444: l_person_identifier_nc varchar2(100);

Line 463: Function Get_SRS_Deduction_Balances (p_assignment_id In per_all_assignments_f.assignment_id%TYPE -- context

459: -- ~ Get_SRS_Deduction_Balances : Returns the balance amount for an assignment for ~
460: -- ~ any given balance and the dimension is based the extract running i.e. YTD,QTD ~
461: -- ~ or MTD and is set in the main criteria function Pay_US_SRS_Main_Criteria ~
462: -- =================================================================================
463: Function Get_SRS_Deduction_Balances (p_assignment_id In per_all_assignments_f.assignment_id%TYPE -- context
464: ,p_balance_name In pay_balance_types.balance_name%TYPE
465: ,p_balance_amount In out nocopy Number
466: ) Return Number Is
467:

Line 468: Cursor c_tax_id ( c_assignment_id In per_all_assignments_f.assignment_id%Type

464: ,p_balance_name In pay_balance_types.balance_name%TYPE
465: ,p_balance_amount In out nocopy Number
466: ) Return Number Is
467:
468: Cursor c_tax_id ( c_assignment_id In per_all_assignments_f.assignment_id%Type
469: ,c_effective_date In Date) Is
470: Select to_number(sft.segment1),
471: asg.business_group_id
472: From hr_soft_coding_keyflex sft,

Line 487: l_tax_id per_all_assignments_f.organization_id%TYPE;

483: l_balance_amount Number := 0;
484: l_return_value Number := 0;
485: l_proc_name varchar2(150) := g_proc_name ||'.Get_SRS_Deduction_Balances';
486: l_error varchar2(500);
487: l_tax_id per_all_assignments_f.organization_id%TYPE;
488: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
489:
490: Begin
491: hr_utility.set_location('Entering: '||l_proc_name, 5);

Line 488: l_business_group_id per_all_assignments_f.business_group_id%TYPE;

484: l_return_value Number := 0;
485: l_proc_name varchar2(150) := g_proc_name ||'.Get_SRS_Deduction_Balances';
486: l_error varchar2(500);
487: l_tax_id per_all_assignments_f.organization_id%TYPE;
488: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
489:
490: Begin
491: hr_utility.set_location('Entering: '||l_proc_name, 5);
492:

Line 574: Function Get_PTD_Start_End_Date(p_assignment_id In per_all_assignments_f.assignment_id%TYPE

570:
571: -- ===============================================================================
572: -- ~ Get_PTD_Start_End_Date :
573: -- ===============================================================================
574: Function Get_PTD_Start_End_Date(p_assignment_id In per_all_assignments_f.assignment_id%TYPE
575: ,p_effective_date In Date
576: ) Return Varchar2 Is
577:
578: l_assig_rec csr_get_payroll_id%ROWTYPE;

Line 757: Function Check_Valid_Payroll ( p_assignment_id In per_all_assignments_f.assignment_id%TYPE

753:
754: -- ===============================================================================
755: -- ~ Check_Valid_Payroll : For the given assignment return the payroll name ~
756: -- ===============================================================================
757: Function Check_Valid_Payroll ( p_assignment_id In per_all_assignments_f.assignment_id%TYPE
758: ,p_effective_date In Date) Return Varchar2 Is
759:
760: l_payroll_id pay_payrolls_f.payroll_id%TYPE;
761: l_payroll_name pay_payrolls_f.payroll_name%TYPE;

Line 799: Function Check_Assig_Extra_Info ( p_assignment_id In per_all_assignments_f.assignment_id%TYPE

795:
796: -- ===============================================================================
797: -- ~ Check_Assig_Extra_Info : Check the SRS Plan details in the Assig Extra Info ~
798: -- ===============================================================================
799: Function Check_Assig_Extra_Info ( p_assignment_id In per_all_assignments_f.assignment_id%TYPE
800: ,p_extract_plan_name In varchar2
801: ,p_extract_start_date In date
802: ,p_extract_end_date In date
803: ) Return Varchar2 Is

Line 863: Function Pay_US_SRS_Main_Criteria ( p_assignment_id In per_all_assignments_f.assignment_id%TYPE

859:
860: -- ===============================================================================
861: -- ~ Pay_US_SRS_Main_Criteria : The Main Extract Criteria for the SRS Extracts ~
862: -- ===============================================================================
863: Function Pay_US_SRS_Main_Criteria ( p_assignment_id In per_all_assignments_f.assignment_id%TYPE
864: ,p_effective_date In date
865: ,p_business_group_id In per_all_assignments_f.business_group_id%TYPE
866: ,p_extract_plan_name In varchar2
867: ,p_extract_payroll_name In varchar2

Line 865: ,p_business_group_id In per_all_assignments_f.business_group_id%TYPE

861: -- ~ Pay_US_SRS_Main_Criteria : The Main Extract Criteria for the SRS Extracts ~
862: -- ===============================================================================
863: Function Pay_US_SRS_Main_Criteria ( p_assignment_id In per_all_assignments_f.assignment_id%TYPE
864: ,p_effective_date In date
865: ,p_business_group_id In per_all_assignments_f.business_group_id%TYPE
866: ,p_extract_plan_name In varchar2
867: ,p_extract_payroll_name In varchar2
868: ) Return Varchar2 Is
869:

Line 1065: ( p_primary_assignment_id in per_all_assignments_f.assignment_id%TYPE

1061: -- ===============================================================================
1062: -- ~ Get_Secondary_Assignments : Fetchs all the Secondary Assignments ~
1063: -- ===============================================================================
1064: Function Get_Secondary_Assignments
1065: ( p_primary_assignment_id in per_all_assignments_f.assignment_id%TYPE
1066: ,p_person_id in per_all_people_f.person_id%TYPE
1067: ,p_effective_date in date
1068: ,p_extract_start_date in date
1069: ,p_extract_end_date in date ) Return Varchar2 Is

Line 1073: l_curr_asg_id per_all_assignments_f.assignment_id%TYPE;

1069: ,p_extract_end_date in date ) Return Varchar2 Is
1070:
1071:
1072: l_sec_asgs csr_sec_assignments%ROWTYPE;
1073: l_curr_asg_id per_all_assignments_f.assignment_id%TYPE;
1074: l_prev_asg_id per_all_assignments_f.assignment_id%TYPE;
1075: l_return_value varchar2(1);
1076: l_proc_name varchar2(150) := g_proc_name ||'.Get_Secondary_Assignments';
1077: l_error varchar2(1000);

Line 1074: l_prev_asg_id per_all_assignments_f.assignment_id%TYPE;

1070:
1071:
1072: l_sec_asgs csr_sec_assignments%ROWTYPE;
1073: l_curr_asg_id per_all_assignments_f.assignment_id%TYPE;
1074: l_prev_asg_id per_all_assignments_f.assignment_id%TYPE;
1075: l_return_value varchar2(1);
1076: l_proc_name varchar2(150) := g_proc_name ||'.Get_Secondary_Assignments';
1077: l_error varchar2(1000);
1078: Begin

Line 1110: Function Create_Secondary_Assig_Lines ( p_assignment_id in per_all_assignments_f.assignment_id%TYPE

1106: -- ~ Create_Secondary_Lines : This function is called by the hidden record to ~
1107: -- ~ check if any secondary assignments exits for the employee. If found then ~
1108: -- ~ check the assignment extra info for the plan details. ~
1109: -- ===============================================================================
1110: Function Create_Secondary_Assig_Lines ( p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1111: ) Return Varchar2 Is
1112: l_primary_assig_id per_all_assignments_f.assignment_id%TYPE;
1113: l_curr_sec_asg_id per_all_assignments_f.assignment_id%TYPE;
1114: l_prev_sec_asg_id per_all_assignments_f.assignment_id%TYPE;

Line 1112: l_primary_assig_id per_all_assignments_f.assignment_id%TYPE;

1108: -- ~ check the assignment extra info for the plan details. ~
1109: -- ===============================================================================
1110: Function Create_Secondary_Assig_Lines ( p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1111: ) Return Varchar2 Is
1112: l_primary_assig_id per_all_assignments_f.assignment_id%TYPE;
1113: l_curr_sec_asg_id per_all_assignments_f.assignment_id%TYPE;
1114: l_prev_sec_asg_id per_all_assignments_f.assignment_id%TYPE;
1115:
1116: l_return_value varchar2(40);

Line 1113: l_curr_sec_asg_id per_all_assignments_f.assignment_id%TYPE;

1109: -- ===============================================================================
1110: Function Create_Secondary_Assig_Lines ( p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1111: ) Return Varchar2 Is
1112: l_primary_assig_id per_all_assignments_f.assignment_id%TYPE;
1113: l_curr_sec_asg_id per_all_assignments_f.assignment_id%TYPE;
1114: l_prev_sec_asg_id per_all_assignments_f.assignment_id%TYPE;
1115:
1116: l_return_value varchar2(40);
1117: l_valid_payroll varchar2(40);

Line 1114: l_prev_sec_asg_id per_all_assignments_f.assignment_id%TYPE;

1110: Function Create_Secondary_Assig_Lines ( p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1111: ) Return Varchar2 Is
1112: l_primary_assig_id per_all_assignments_f.assignment_id%TYPE;
1113: l_curr_sec_asg_id per_all_assignments_f.assignment_id%TYPE;
1114: l_prev_sec_asg_id per_all_assignments_f.assignment_id%TYPE;
1115:
1116: l_return_value varchar2(40);
1117: l_valid_payroll varchar2(40);
1118: l_error_value varchar2(5);

Line 1357: (p_pri_assignment_id In per_all_assignments_f.assignment_id%TYPE

1353: -- ~ table for each Retirement Plan of an assignment. It re-computes all the rule ~
1354: -- ~ based person level fast-formulas for the secondary assignment. ~
1355: -- ================================================================================
1356: Procedure Create_New_Lines
1357: (p_pri_assignment_id In per_all_assignments_f.assignment_id%TYPE
1358: ,p_sec_assignment_id In per_all_assignments_f.assignment_id%TYPE
1359: ,p_person_id In per_all_people_f.person_id%TYPE
1360: ,p_record_name In Varchar2
1361: ) Is

Line 1358: ,p_sec_assignment_id In per_all_assignments_f.assignment_id%TYPE

1354: -- ~ based person level fast-formulas for the secondary assignment. ~
1355: -- ================================================================================
1356: Procedure Create_New_Lines
1357: (p_pri_assignment_id In per_all_assignments_f.assignment_id%TYPE
1358: ,p_sec_assignment_id In per_all_assignments_f.assignment_id%TYPE
1359: ,p_person_id In per_all_people_f.person_id%TYPE
1360: ,p_record_name In Varchar2
1361: ) Is
1362:

Line 1404: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

1400: l_rec_serial_num NUMBER(3);
1401: l_itr NUMBER(3);
1402: l_next_itr NUMBER(3);
1403: l_foumula_type_id ff_formulas_f.formula_id%TYPE;
1404: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
1405: l_organization_id per_all_assignments_f.organization_id%TYPE;
1406: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
1407: l_ff_value ben_ext_rslt_dtl.val_01%TYPE;
1408: l_ff_value_fmt ben_ext_rslt_dtl.val_01%TYPE;

Line 1405: l_organization_id per_all_assignments_f.organization_id%TYPE;

1401: l_itr NUMBER(3);
1402: l_next_itr NUMBER(3);
1403: l_foumula_type_id ff_formulas_f.formula_id%TYPE;
1404: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
1405: l_organization_id per_all_assignments_f.organization_id%TYPE;
1406: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
1407: l_ff_value ben_ext_rslt_dtl.val_01%TYPE;
1408: l_ff_value_fmt ben_ext_rslt_dtl.val_01%TYPE;
1409: l_effective_date date;

Line 1406: l_business_group_id per_all_assignments_f.business_group_id%TYPE;

1402: l_next_itr NUMBER(3);
1403: l_foumula_type_id ff_formulas_f.formula_id%TYPE;
1404: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
1405: l_organization_id per_all_assignments_f.organization_id%TYPE;
1406: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
1407: l_ff_value ben_ext_rslt_dtl.val_01%TYPE;
1408: l_ff_value_fmt ben_ext_rslt_dtl.val_01%TYPE;
1409: l_effective_date date;
1410: l_outputs ff_exec.outputs_t;