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_PENSION_TYPES_API dependencies on PAY_BALANCE_TYPES

Line 31: from pay_balance_types

27: where business_group_id = p_business_group_id;
28:
29: Cursor csr_bal_name(c_balance_name in varchar2) Is
30: Select 'x'
31: from pay_balance_types
32: where balance_name = c_balance_name
33: and business_group_id = p_business_group_id;
34:
35: Cursor csr_bal_dim ( c_legislation_code in varchar2 ) Is

Line 58: l_balance_type_id pay_balance_types.balance_type_id%TYPE;

54:
55: l_proc varchar2(150) := g_package||'Create_EE_ER_Balances';
56: l_bal_name_exists varchar2(3);
57: l_row_id rowid;
58: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
59: l_currency_code pay_balance_types.currency_code%TYPE;
60: l_legislation_code per_business_groups.legislation_code%TYPE;
61: l_balance_name pay_balance_types.balance_name%TYPE;
62: l_reporting_name pay_balance_types.reporting_name%TYPE;

Line 59: l_currency_code pay_balance_types.currency_code%TYPE;

55: l_proc varchar2(150) := g_package||'Create_EE_ER_Balances';
56: l_bal_name_exists varchar2(3);
57: l_row_id rowid;
58: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
59: l_currency_code pay_balance_types.currency_code%TYPE;
60: l_legislation_code per_business_groups.legislation_code%TYPE;
61: l_balance_name pay_balance_types.balance_name%TYPE;
62: l_reporting_name pay_balance_types.reporting_name%TYPE;
63: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;

Line 61: l_balance_name pay_balance_types.balance_name%TYPE;

57: l_row_id rowid;
58: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
59: l_currency_code pay_balance_types.currency_code%TYPE;
60: l_legislation_code per_business_groups.legislation_code%TYPE;
61: l_balance_name pay_balance_types.balance_name%TYPE;
62: l_reporting_name pay_balance_types.reporting_name%TYPE;
63: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
64: l_balance_dimension_id pay_balance_dimensions.balance_dimension_id%TYPE;
65: l_balance_cat_id pay_balance_categories_f.balance_category_id%TYPE := Null;

Line 62: l_reporting_name pay_balance_types.reporting_name%TYPE;

58: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
59: l_currency_code pay_balance_types.currency_code%TYPE;
60: l_legislation_code per_business_groups.legislation_code%TYPE;
61: l_balance_name pay_balance_types.balance_name%TYPE;
62: l_reporting_name pay_balance_types.reporting_name%TYPE;
63: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
64: l_balance_dimension_id pay_balance_dimensions.balance_dimension_id%TYPE;
65: l_balance_cat_id pay_balance_categories_f.balance_category_id%TYPE := Null;
66:

Line 115: Pay_Balance_Types_pkg.Insert_Row

111: l_balance_name := p_pension_type_name||' EE Contribution';
112: l_reporting_name := l_balance_name;
113:
114: hr_utility.set_location(' Creating balance : '||l_balance_name,20);
115: Pay_Balance_Types_pkg.Insert_Row
116: (x_Rowid => l_row_id
117: ,x_Balance_Type_Id => l_balance_type_id
118: ,x_Business_Group_Id => p_business_group_id
119: ,x_Legislation_Code => p_legislation_code

Line 212: from pay_balance_types

208: where business_group_id = p_business_group_id;
209:
210: Cursor csr_bal_name(c_balance_name in varchar2) Is
211: Select 'x'
212: from pay_balance_types
213: where balance_name = c_balance_name
214: and business_group_id = p_business_group_id;
215:
216: Cursor csr_bal_dim ( c_legislation_code in varchar2 ) Is

Line 239: l_balance_type_id pay_balance_types.balance_type_id%TYPE;

235:
236: l_proc varchar2(150) := g_package||'Create_EE_ER_Balances';
237: l_bal_name_exists varchar2(3);
238: l_row_id rowid;
239: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
240: l_currency_code pay_balance_types.currency_code%TYPE;
241: l_legislation_code per_business_groups.legislation_code%TYPE;
242: l_balance_name pay_balance_types.balance_name%TYPE;
243: l_reporting_name pay_balance_types.reporting_name%TYPE;

Line 240: l_currency_code pay_balance_types.currency_code%TYPE;

236: l_proc varchar2(150) := g_package||'Create_EE_ER_Balances';
237: l_bal_name_exists varchar2(3);
238: l_row_id rowid;
239: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
240: l_currency_code pay_balance_types.currency_code%TYPE;
241: l_legislation_code per_business_groups.legislation_code%TYPE;
242: l_balance_name pay_balance_types.balance_name%TYPE;
243: l_reporting_name pay_balance_types.reporting_name%TYPE;
244: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;

Line 242: l_balance_name pay_balance_types.balance_name%TYPE;

238: l_row_id rowid;
239: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
240: l_currency_code pay_balance_types.currency_code%TYPE;
241: l_legislation_code per_business_groups.legislation_code%TYPE;
242: l_balance_name pay_balance_types.balance_name%TYPE;
243: l_reporting_name pay_balance_types.reporting_name%TYPE;
244: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
245: l_balance_dimension_id pay_balance_dimensions.balance_dimension_id%TYPE;
246: l_balance_cat_id pay_balance_categories_f.balance_category_id%TYPE := Null;

Line 243: l_reporting_name pay_balance_types.reporting_name%TYPE;

239: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
240: l_currency_code pay_balance_types.currency_code%TYPE;
241: l_legislation_code per_business_groups.legislation_code%TYPE;
242: l_balance_name pay_balance_types.balance_name%TYPE;
243: l_reporting_name pay_balance_types.reporting_name%TYPE;
244: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
245: l_balance_dimension_id pay_balance_dimensions.balance_dimension_id%TYPE;
246: l_balance_cat_id pay_balance_categories_f.balance_category_id%TYPE := Null;
247:

Line 296: Pay_Balance_Types_pkg.Insert_Row

292: l_balance_name := p_pension_type_name||' ER Contribution';
293: l_reporting_name := l_balance_name;
294:
295: hr_utility.set_location(' Creating balance : '||l_balance_name,20);
296: Pay_Balance_Types_pkg.Insert_Row
297: (x_Rowid => l_row_id
298: ,x_Balance_Type_Id => l_balance_type_id
299: ,x_Business_Group_Id => p_business_group_id
300: ,x_Legislation_Code => p_legislation_code

Line 393: from pay_balance_types

389: where business_group_id = p_business_group_id;
390:
391: Cursor csr_bal_name(c_balance_name in varchar2) Is
392: Select 'x'
393: from pay_balance_types
394: where balance_name = c_balance_name
395: and business_group_id = p_business_group_id;
396:
397: Cursor csr_bal_dim ( c_legislation_code in varchar2 ) Is

Line 420: l_balance_type_id pay_balance_types.balance_type_id%TYPE;

416:
417: l_proc varchar2(150) := g_package||'Create_EE_ER_Balances';
418: l_bal_name_exists varchar2(3);
419: l_row_id rowid;
420: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
421: l_currency_code pay_balance_types.currency_code%TYPE;
422: l_legislation_code per_business_groups.legislation_code%TYPE;
423: l_balance_name pay_balance_types.balance_name%TYPE;
424: l_reporting_name pay_balance_types.reporting_name%TYPE;

Line 421: l_currency_code pay_balance_types.currency_code%TYPE;

417: l_proc varchar2(150) := g_package||'Create_EE_ER_Balances';
418: l_bal_name_exists varchar2(3);
419: l_row_id rowid;
420: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
421: l_currency_code pay_balance_types.currency_code%TYPE;
422: l_legislation_code per_business_groups.legislation_code%TYPE;
423: l_balance_name pay_balance_types.balance_name%TYPE;
424: l_reporting_name pay_balance_types.reporting_name%TYPE;
425: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;

Line 423: l_balance_name pay_balance_types.balance_name%TYPE;

419: l_row_id rowid;
420: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
421: l_currency_code pay_balance_types.currency_code%TYPE;
422: l_legislation_code per_business_groups.legislation_code%TYPE;
423: l_balance_name pay_balance_types.balance_name%TYPE;
424: l_reporting_name pay_balance_types.reporting_name%TYPE;
425: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
426: l_balance_dimension_id pay_balance_dimensions.balance_dimension_id%TYPE;
427: l_balance_cat_id pay_balance_categories_f.balance_category_id%TYPE := Null;

Line 424: l_reporting_name pay_balance_types.reporting_name%TYPE;

420: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
421: l_currency_code pay_balance_types.currency_code%TYPE;
422: l_legislation_code per_business_groups.legislation_code%TYPE;
423: l_balance_name pay_balance_types.balance_name%TYPE;
424: l_reporting_name pay_balance_types.reporting_name%TYPE;
425: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
426: l_balance_dimension_id pay_balance_dimensions.balance_dimension_id%TYPE;
427: l_balance_cat_id pay_balance_categories_f.balance_category_id%TYPE := Null;
428:

Line 500: Pay_Balance_Types_pkg.Insert_Row

496: l_balance_name := p_pension_type_name||' ER Contribution';
497: l_reporting_name := l_balance_name;
498: End if;
499: hr_utility.set_location(' Creating balance : '||l_balance_name,20);
500: Pay_Balance_Types_pkg.Insert_Row
501: (x_Rowid => l_row_id
502: ,x_Balance_Type_Id => l_balance_type_id
503: ,x_Business_Group_Id => p_business_group_id
504: ,x_Legislation_Code => p_legislation_code

Line 602: from pay_balance_types

598: where business_group_id = p_business_group_id;
599:
600: Cursor csr_bal_typ_id(c_balance_name in varchar2) Is
601: Select balance_type_id
602: from pay_balance_types
603: where balance_name = c_balance_name
604: and business_group_id = p_business_group_id;
605:
606: Cursor csr_bal_dim ( c_legislation_code in varchar2 ) Is

Line 619: l_balance_type_id pay_balance_types.balance_type_id%TYPE;

615: );
616:
617: l_proc varchar2(150) := g_package||'Create_ABP_EE_ER_Balances';
618: l_row_id rowid;
619: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
620: l_currency_code pay_balance_types.currency_code%TYPE;
621: l_legislation_code per_business_groups.legislation_code%TYPE;
622: l_balance_name pay_balance_types.balance_name%TYPE;
623: l_reporting_name pay_balance_types.reporting_name%TYPE;

Line 620: l_currency_code pay_balance_types.currency_code%TYPE;

616:
617: l_proc varchar2(150) := g_package||'Create_ABP_EE_ER_Balances';
618: l_row_id rowid;
619: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
620: l_currency_code pay_balance_types.currency_code%TYPE;
621: l_legislation_code per_business_groups.legislation_code%TYPE;
622: l_balance_name pay_balance_types.balance_name%TYPE;
623: l_reporting_name pay_balance_types.reporting_name%TYPE;
624: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;

Line 622: l_balance_name pay_balance_types.balance_name%TYPE;

618: l_row_id rowid;
619: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
620: l_currency_code pay_balance_types.currency_code%TYPE;
621: l_legislation_code per_business_groups.legislation_code%TYPE;
622: l_balance_name pay_balance_types.balance_name%TYPE;
623: l_reporting_name pay_balance_types.reporting_name%TYPE;
624: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
625: l_balance_dimension_id pay_balance_dimensions.balance_dimension_id%TYPE;
626: l_pension_sub_cat varchar2(80) := '';

Line 623: l_reporting_name pay_balance_types.reporting_name%TYPE;

619: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
620: l_currency_code pay_balance_types.currency_code%TYPE;
621: l_legislation_code per_business_groups.legislation_code%TYPE;
622: l_balance_name pay_balance_types.balance_name%TYPE;
623: l_reporting_name pay_balance_types.reporting_name%TYPE;
624: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
625: l_balance_dimension_id pay_balance_dimensions.balance_dimension_id%TYPE;
626: l_pension_sub_cat varchar2(80) := '';
627: l_balance_cat_id pay_balance_categories_f.balance_category_id%TYPE;

Line 716: Pay_Balance_Types_pkg.Insert_Row

712: Else
713: Close csr_bal_typ_id;
714:
715: hr_utility.set_location(' Creating balance : '||l_balance_name,20);
716: Pay_Balance_Types_pkg.Insert_Row
717: (x_Rowid => l_row_id
718: ,x_Balance_Type_Id => l_balance_type_id
719: ,x_Business_Group_Id => p_business_group_id
720: ,x_Legislation_Code => p_legislation_code

Line 816: from pay_balance_types

812: ) Is
813:
814: Cursor csr_bal_type (c_balance_name in varchar2) Is
815: Select balance_type_id
816: from pay_balance_types
817: where balance_name = c_balance_name
818: and (business_group_id = p_business_group_id
819: or
820: legislation_code = g_leg_code);

Line 1182: l_ee_contribution_bal_type_id pay_balance_types.balance_type_id%TYPE;

1178: l_proc varchar2(150) := g_package||'Create_Pension_Type';
1179: l_effective_date date;
1180: l_pension_type_id pqp_pension_types_f.pension_type_id%TYPE;
1181: l_object_version_number pqp_pension_types_f.object_version_number%TYPE;
1182: l_ee_contribution_bal_type_id pay_balance_types.balance_type_id%TYPE;
1183: l_er_contribution_bal_type_id pay_balance_types.balance_type_id%TYPE;
1184: l_balance_init_element_type_id pay_element_types_f.element_type_id%TYPE;
1185: l_effective_start_date date;
1186: l_effective_end_date date;

Line 1183: l_er_contribution_bal_type_id pay_balance_types.balance_type_id%TYPE;

1179: l_effective_date date;
1180: l_pension_type_id pqp_pension_types_f.pension_type_id%TYPE;
1181: l_object_version_number pqp_pension_types_f.object_version_number%TYPE;
1182: l_ee_contribution_bal_type_id pay_balance_types.balance_type_id%TYPE;
1183: l_er_contribution_bal_type_id pay_balance_types.balance_type_id%TYPE;
1184: l_balance_init_element_type_id pay_element_types_f.element_type_id%TYPE;
1185: l_effective_start_date date;
1186: l_effective_end_date date;
1187: l_api_warning varchar2(250);

Line 2509: From pay_balance_types

2505: -- Cursor to retrieve the rowid for balances
2506: Cursor csr_get_bal_rowid (c_balance_type_id number)
2507: Is
2508: Select rowid
2509: From pay_balance_types
2510: Where balance_type_id = c_balance_type_id;
2511:
2512: l_proc varchar2(80) := g_package || 'Delete_EE_ER_Balances';
2513: l_rowid ROWID;

Line 2545: pay_balance_types_pkg.delete_row

2541: -- This api does a delete cascade
2542: -- so no need to delete feeds / dimensions
2543: -- separately
2544:
2545: pay_balance_types_pkg.delete_row
2546: (x_rowid => l_rowid
2547: ,x_balance_type_id => l_bal_type_id (i)
2548: );
2549: END IF; -- End if of balance row found check ...