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.PER_BF_BALANCE_AMOUNTS_API dependencies on PER_BF_BALANCE_AMOUNTS

Line 1: Package Body PER_BF_BALANCE_AMOUNTS_API as

1: Package Body PER_BF_BALANCE_AMOUNTS_API as
2: /* $Header: pebbaapi.pkb 115.10 2002/11/29 14:31:02 apholt noship $ */
3: --
4: -- Package Variables
5: --

Line 6: g_package varchar2(33) := ' PER_BF_BALANCE_AMOUNTS_API.';

2: /* $Header: pebbaapi.pkb 115.10 2002/11/29 14:31:02 apholt noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' PER_BF_BALANCE_AMOUNTS_API.';
7: --
8: Procedure chk_currency_code (p_currency_code in varchar2
9: ,p_balance_type_id in varchar2
10: ,p_effective_date in DATE)

Line 141: l_balance_amount_id PER_BF_BALANCE_AMOUNTS.balance_amount_id%TYPE;

137: --
138: -- Two tables are being used in this API, so two sets of OUT parameters will
139: -- be created.
140: --
141: l_balance_amount_id PER_BF_BALANCE_AMOUNTS.balance_amount_id%TYPE;
142: l_balance_amount_ovn
143: PER_BF_BALANCE_AMOUNTS.object_version_number%TYPE;
144: l_processed_assignment_id
145: PER_BF_PROCESSED_ASSIGNMENTS.processed_assignment_id%TYPE;

Line 143: PER_BF_BALANCE_AMOUNTS.object_version_number%TYPE;

139: -- be created.
140: --
141: l_balance_amount_id PER_BF_BALANCE_AMOUNTS.balance_amount_id%TYPE;
142: l_balance_amount_ovn
143: PER_BF_BALANCE_AMOUNTS.object_version_number%TYPE;
144: l_processed_assignment_id
145: PER_BF_PROCESSED_ASSIGNMENTS.processed_assignment_id%TYPE;
146: l_processed_assignment_ovn
147: PER_BF_PROCESSED_ASSIGNMENTS.object_version_number%TYPE;

Line 165: PER_BF_BALANCE_AMOUNTS_BK1.CREATE_BALANCE_AMOUNT_B

161: --
162: -- Call Before Process User Hook
163: --
164: begin
165: PER_BF_BALANCE_AMOUNTS_BK1.CREATE_BALANCE_AMOUNT_B
166: (p_effective_date => p_effective_date
167: ,p_business_group_id => p_business_group_id
168: ,p_balance_type_id => p_balance_type_id
169: ,p_assignment_id => p_assignment_id

Line 322: PER_BF_BALANCE_AMOUNTS_BK1.CREATE_BALANCE_AMOUNT_A

318: --
319: -- Call After Process User Hook
320: --
321: begin
322: PER_BF_BALANCE_AMOUNTS_BK1.CREATE_BALANCE_AMOUNT_A
323: (p_effective_date => p_effective_date
324: ,p_business_group_id => p_business_group_id
325: ,p_balance_type_id => p_balance_type_id
326: ,p_assignment_id => p_assignment_id

Line 482: FROM per_bf_balance_amounts

478: --
479: -- Cursor to get the balance_type_id
480: CURSOR csr_get_bbt IS
481: SELECT balance_type_id
482: FROM per_bf_balance_amounts
483: WHERE balance_amount_id = p_balance_amount_id;
484: --
485: l_balance_type_id NUMBER;
486: --

Line 488: PER_BF_BALANCE_AMOUNTS.object_version_number%TYPE;

484: --
485: l_balance_type_id NUMBER;
486: --
487: l_balance_amount_ovn
488: PER_BF_BALANCE_AMOUNTS.object_version_number%TYPE;
489: --
490: l_proc varchar2(72) := g_package||'update_balance_amount';
491: begin
492: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 506: PER_BF_BALANCE_AMOUNTS_BK2.UPDATE_BALANCE_AMOUNT_B

502: --
503: -- Call Before Process User Hook
504: --
505: begin
506: PER_BF_BALANCE_AMOUNTS_BK2.UPDATE_BALANCE_AMOUNT_B
507: (p_effective_date => p_effective_date
508: ,p_ytd_amount => p_ytd_amount
509: ,p_fytd_amount => p_fytd_amount
510: ,p_ptd_amount => p_ptd_amount

Line 628: PER_BF_BALANCE_AMOUNTS_BK2.UPDATE_BALANCE_AMOUNT_A

624: --
625: -- Call After Process User Hook
626: --
627: begin
628: PER_BF_BALANCE_AMOUNTS_BK2.UPDATE_BALANCE_AMOUNT_A
629: (p_effective_date => p_effective_date
630: ,p_ytd_amount => p_ytd_amount
631: ,p_fytd_amount => p_fytd_amount
632: ,p_ptd_amount => p_ptd_amount

Line 732: FROM PER_BF_BALANCE_AMOUNTS ba

728: --
729: --
730: CURSOR csr_get_pa_id IS
731: SELECT pa.processed_assignment_id, pa.object_version_number
732: FROM PER_BF_BALANCE_AMOUNTS ba
733: ,PER_BF_PROCESSED_ASSIGNMENTS pa
734: WHERE ba.balance_amount_id = p_balance_amount_id
735: AND ba.processed_assignment_id = pa.processed_assignment_id;
736: --

Line 740: FROM per_bf_balance_amounts

736: --
737: CURSOR csr_chk_pa_for_del
738: (p_processed_assignment_id NUMBER) IS
739: SELECT 1
740: FROM per_bf_balance_amounts
741: WHERE processed_assignment_id = p_processed_assignment_id
742: AND balance_amount_id <> p_balance_amount_id
743: UNION
744: SELECT 1

Line 768: PER_BF_BALANCE_AMOUNTS_BK3.DELETE_BALANCE_AMOUNT_B

764: --
765: -- Call Before Process User Hook
766: --
767: begin
768: PER_BF_BALANCE_AMOUNTS_BK3.DELETE_BALANCE_AMOUNT_B
769: (
770: p_balance_amount_id => p_balance_amount_id
771: ,p_balance_amount_ovn => p_balance_amount_ovn
772: );

Line 792: -- in PER_BF_BALANCE_AMOUNTS references, then the row will be removed

788: -- Process Logic
789: --
790: --
791: -- If no other entity uses the processed_assignment row that the FK
792: -- in PER_BF_BALANCE_AMOUNTS references, then the row will be removed
793: -- from PER_BF_PROCESSED_ASSIGNMENTS.
794: --
795: -- Obtain the processed assignment ID related to this row.
796: --

Line 825: -- Delete the row in per_bf_balance_amounts

821: l_delete_pa_row := FALSE;
822: --
823: END IF;
824: --
825: -- Delete the row in per_bf_balance_amounts
826: --
827: PER_BBA_DEL.DEL
828: (
829: p_balance_amount_id => p_balance_amount_id

Line 851: PER_BF_BALANCE_AMOUNTS_BK3.DELETE_BALANCE_AMOUNT_A

847: --
848: -- Call After Process User Hook
849: --
850: begin
851: PER_BF_BALANCE_AMOUNTS_BK3.DELETE_BALANCE_AMOUNT_A
852: (
853: p_balance_amount_id => p_balance_amount_id
854: ,p_balance_amount_ovn => p_balance_amount_ovn
855: );

Line 896: end PER_BF_BALANCE_AMOUNTS_API;

892: hr_utility.set_location(' Leaving:'||l_proc, 90);
893: raise;
894: end DELETE_BALANCE_AMOUNT;
895: --
896: end PER_BF_BALANCE_AMOUNTS_API;