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 32: from pay_balance_types

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

Line 59: l_balance_type_id pay_balance_types.balance_type_id%TYPE;

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

Line 60: l_currency_code pay_balance_types.currency_code%TYPE;

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

Line 62: l_balance_name pay_balance_types.balance_name%TYPE;

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

Line 63: l_reporting_name pay_balance_types.reporting_name%TYPE;

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

Line 129: Pay_Balance_Types_pkg.Insert_Row

125: l_balance_name := p_pension_type_name||' EE Contribution';
126: l_reporting_name := l_balance_name;
127:
128: hr_utility.set_location(' Creating balance : '||l_balance_name,20);
129: Pay_Balance_Types_pkg.Insert_Row
130: (x_Rowid => l_row_id
131: ,x_Balance_Type_Id => l_balance_type_id
132: ,x_Business_Group_Id => p_business_group_id
133: ,x_Legislation_Code => p_legislation_code

Line 227: from pay_balance_types

223: where business_group_id = p_business_group_id;
224:
225: Cursor csr_bal_name(c_balance_name in varchar2) Is
226: Select 'x'
227: from pay_balance_types
228: where balance_name = c_balance_name
229: and business_group_id = p_business_group_id;
230:
231: Cursor csr_bal_dim ( c_legislation_code in varchar2 ) Is

Line 254: l_balance_type_id pay_balance_types.balance_type_id%TYPE;

250:
251: l_proc varchar2(150) := g_package||'Create_ER_Balances';
252: l_bal_name_exists varchar2(3);
253: l_row_id rowid;
254: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
255: l_currency_code pay_balance_types.currency_code%TYPE;
256: l_legislation_code per_business_groups.legislation_code%TYPE;
257: l_balance_name pay_balance_types.balance_name%TYPE;
258: l_reporting_name pay_balance_types.reporting_name%TYPE;

Line 255: l_currency_code pay_balance_types.currency_code%TYPE;

251: l_proc varchar2(150) := g_package||'Create_ER_Balances';
252: l_bal_name_exists varchar2(3);
253: l_row_id rowid;
254: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
255: l_currency_code pay_balance_types.currency_code%TYPE;
256: l_legislation_code per_business_groups.legislation_code%TYPE;
257: l_balance_name pay_balance_types.balance_name%TYPE;
258: l_reporting_name pay_balance_types.reporting_name%TYPE;
259: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;

Line 257: l_balance_name pay_balance_types.balance_name%TYPE;

253: l_row_id rowid;
254: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
255: l_currency_code pay_balance_types.currency_code%TYPE;
256: l_legislation_code per_business_groups.legislation_code%TYPE;
257: l_balance_name pay_balance_types.balance_name%TYPE;
258: l_reporting_name pay_balance_types.reporting_name%TYPE;
259: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
260: l_balance_dimension_id pay_balance_dimensions.balance_dimension_id%TYPE;
261: l_balance_cat_id pay_balance_categories_f.balance_category_id%TYPE := Null;

Line 258: l_reporting_name pay_balance_types.reporting_name%TYPE;

254: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
255: l_currency_code pay_balance_types.currency_code%TYPE;
256: l_legislation_code per_business_groups.legislation_code%TYPE;
257: l_balance_name pay_balance_types.balance_name%TYPE;
258: l_reporting_name pay_balance_types.reporting_name%TYPE;
259: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
260: l_balance_dimension_id pay_balance_dimensions.balance_dimension_id%TYPE;
261: l_balance_cat_id pay_balance_categories_f.balance_category_id%TYPE := Null;
262: l_category_name pay_balance_categories_f.category_name%TYPE;

Line 324: Pay_Balance_Types_pkg.Insert_Row

320: l_balance_name := p_pension_type_name||' ER Contribution';
321: l_reporting_name := l_balance_name;
322:
323: hr_utility.set_location(' Creating balance : '||l_balance_name,20);
324: Pay_Balance_Types_pkg.Insert_Row
325: (x_Rowid => l_row_id
326: ,x_Balance_Type_Id => l_balance_type_id
327: ,x_Business_Group_Id => p_business_group_id
328: ,x_Legislation_Code => p_legislation_code

Line 422: from pay_balance_types

418: where business_group_id = p_business_group_id;
419:
420: Cursor csr_bal_name(c_balance_name in varchar2) Is
421: Select 'x'
422: from pay_balance_types
423: where balance_name = c_balance_name
424: and business_group_id = p_business_group_id;
425:
426: Cursor csr_bal_dim ( c_legislation_code in varchar2 ) Is

Line 449: l_balance_type_id pay_balance_types.balance_type_id%TYPE;

445:
446: l_proc varchar2(150) := g_package||'Create_EE_ER_Balances';
447: l_bal_name_exists varchar2(3);
448: l_row_id rowid;
449: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
450: l_currency_code pay_balance_types.currency_code%TYPE;
451: l_legislation_code per_business_groups.legislation_code%TYPE;
452: l_balance_name pay_balance_types.balance_name%TYPE;
453: l_reporting_name pay_balance_types.reporting_name%TYPE;

Line 450: l_currency_code pay_balance_types.currency_code%TYPE;

446: l_proc varchar2(150) := g_package||'Create_EE_ER_Balances';
447: l_bal_name_exists varchar2(3);
448: l_row_id rowid;
449: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
450: l_currency_code pay_balance_types.currency_code%TYPE;
451: l_legislation_code per_business_groups.legislation_code%TYPE;
452: l_balance_name pay_balance_types.balance_name%TYPE;
453: l_reporting_name pay_balance_types.reporting_name%TYPE;
454: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;

Line 452: l_balance_name pay_balance_types.balance_name%TYPE;

448: l_row_id rowid;
449: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
450: l_currency_code pay_balance_types.currency_code%TYPE;
451: l_legislation_code per_business_groups.legislation_code%TYPE;
452: l_balance_name pay_balance_types.balance_name%TYPE;
453: l_reporting_name pay_balance_types.reporting_name%TYPE;
454: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
455: l_balance_dimension_id pay_balance_dimensions.balance_dimension_id%TYPE;
456: l_balance_cat_id pay_balance_categories_f.balance_category_id%TYPE := Null;

Line 453: l_reporting_name pay_balance_types.reporting_name%TYPE;

449: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
450: l_currency_code pay_balance_types.currency_code%TYPE;
451: l_legislation_code per_business_groups.legislation_code%TYPE;
452: l_balance_name pay_balance_types.balance_name%TYPE;
453: l_reporting_name pay_balance_types.reporting_name%TYPE;
454: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
455: l_balance_dimension_id pay_balance_dimensions.balance_dimension_id%TYPE;
456: l_balance_cat_id pay_balance_categories_f.balance_category_id%TYPE := Null;
457: l_category_name pay_balance_categories_f.category_name%TYPE;

Line 553: Pay_Balance_Types_pkg.Insert_Row

549: l_balance_name := p_pension_type_name||' ER Contribution';
550: l_reporting_name := l_balance_name;
551: End if;
552: hr_utility.set_location(' Creating balance : '||l_balance_name,20);
553: Pay_Balance_Types_pkg.Insert_Row
554: (x_Rowid => l_row_id
555: ,x_Balance_Type_Id => l_balance_type_id
556: ,x_Business_Group_Id => p_business_group_id
557: ,x_Legislation_Code => p_legislation_code

Line 655: from pay_balance_types

651: where business_group_id = p_business_group_id;
652:
653: Cursor csr_bal_typ_id(c_balance_name in varchar2) Is
654: Select balance_type_id
655: from pay_balance_types
656: where balance_name = c_balance_name
657: and business_group_id = p_business_group_id;
658:
659: Cursor csr_bal_dim ( c_legislation_code in varchar2 ) Is

Line 681: l_balance_type_id pay_balance_types.balance_type_id%TYPE;

677: AND c_effective_date BETWEEN effective_start_date AND effective_end_date;
678:
679: l_proc varchar2(150) := g_package||'Create_ABP_EE_ER_Balances';
680: l_row_id rowid;
681: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
682: l_currency_code pay_balance_types.currency_code%TYPE;
683: l_legislation_code per_business_groups.legislation_code%TYPE;
684: l_balance_name pay_balance_types.balance_name%TYPE;
685: l_reporting_name pay_balance_types.reporting_name%TYPE;

Line 682: l_currency_code pay_balance_types.currency_code%TYPE;

678:
679: l_proc varchar2(150) := g_package||'Create_ABP_EE_ER_Balances';
680: l_row_id rowid;
681: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
682: l_currency_code pay_balance_types.currency_code%TYPE;
683: l_legislation_code per_business_groups.legislation_code%TYPE;
684: l_balance_name pay_balance_types.balance_name%TYPE;
685: l_reporting_name pay_balance_types.reporting_name%TYPE;
686: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;

Line 684: l_balance_name pay_balance_types.balance_name%TYPE;

680: l_row_id rowid;
681: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
682: l_currency_code pay_balance_types.currency_code%TYPE;
683: l_legislation_code per_business_groups.legislation_code%TYPE;
684: l_balance_name pay_balance_types.balance_name%TYPE;
685: l_reporting_name pay_balance_types.reporting_name%TYPE;
686: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
687: l_balance_dimension_id pay_balance_dimensions.balance_dimension_id%TYPE;
688: l_pension_sub_cat varchar2(80) := '';

Line 685: l_reporting_name pay_balance_types.reporting_name%TYPE;

681: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
682: l_currency_code pay_balance_types.currency_code%TYPE;
683: l_legislation_code per_business_groups.legislation_code%TYPE;
684: l_balance_name pay_balance_types.balance_name%TYPE;
685: l_reporting_name pay_balance_types.reporting_name%TYPE;
686: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
687: l_balance_dimension_id pay_balance_dimensions.balance_dimension_id%TYPE;
688: l_pension_sub_cat varchar2(80) := '';
689: l_balance_cat_id pay_balance_categories_f.balance_category_id%TYPE;

Line 785: Pay_Balance_Types_pkg.Insert_Row

781: Else
782: Close csr_bal_typ_id;
783:
784: hr_utility.set_location(' Creating balance : '||l_balance_name,20);
785: Pay_Balance_Types_pkg.Insert_Row
786: (x_Rowid => l_row_id
787: ,x_Balance_Type_Id => l_balance_type_id
788: ,x_Business_Group_Id => p_business_group_id
789: ,x_Legislation_Code => p_legislation_code

Line 885: from pay_balance_types

881: ) Is
882:
883: Cursor csr_bal_type (c_balance_name in varchar2) Is
884: Select balance_type_id
885: from pay_balance_types
886: where balance_name = c_balance_name
887: and (business_group_id = p_business_group_id
888: or
889: legislation_code = g_leg_code);

Line 1251: l_ee_contribution_bal_type_id pay_balance_types.balance_type_id%TYPE;

1247: l_proc varchar2(150) := g_package||'Create_Pension_Type';
1248: l_effective_date date;
1249: l_pension_type_id pqp_pension_types_f.pension_type_id%TYPE;
1250: l_object_version_number pqp_pension_types_f.object_version_number%TYPE;
1251: l_ee_contribution_bal_type_id pay_balance_types.balance_type_id%TYPE;
1252: l_er_contribution_bal_type_id pay_balance_types.balance_type_id%TYPE;
1253: l_balance_init_element_type_id pay_element_types_f.element_type_id%TYPE;
1254: l_effective_start_date date;
1255: l_effective_end_date date;

Line 1252: l_er_contribution_bal_type_id pay_balance_types.balance_type_id%TYPE;

1248: l_effective_date date;
1249: l_pension_type_id pqp_pension_types_f.pension_type_id%TYPE;
1250: l_object_version_number pqp_pension_types_f.object_version_number%TYPE;
1251: l_ee_contribution_bal_type_id pay_balance_types.balance_type_id%TYPE;
1252: l_er_contribution_bal_type_id pay_balance_types.balance_type_id%TYPE;
1253: l_balance_init_element_type_id pay_element_types_f.element_type_id%TYPE;
1254: l_effective_start_date date;
1255: l_effective_end_date date;
1256: l_api_warning varchar2(250);

Line 2582: From pay_balance_types

2578: -- Cursor to retrieve the rowid for balances
2579: Cursor csr_get_bal_rowid (c_balance_type_id number)
2580: Is
2581: Select rowid
2582: From pay_balance_types
2583: Where balance_type_id = c_balance_type_id;
2584:
2585: l_proc varchar2(80) := g_package || 'Delete_EE_ER_Balances';
2586: l_rowid ROWID;

Line 2618: pay_balance_types_pkg.delete_row

2614: -- This api does a delete cascade
2615: -- so no need to delete feeds / dimensions
2616: -- separately
2617:
2618: pay_balance_types_pkg.delete_row
2619: (x_rowid => l_rowid
2620: ,x_balance_type_id => l_bal_type_id (i)
2621: );
2622: END IF; -- End if of balance row found check ...