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_PAYMENT_DETAILS_API dependencies on PER_BF_PAYMENT_DETAILS

Line 1: Package Body PER_BF_PAYMENT_DETAILS_API as

1: Package Body PER_BF_PAYMENT_DETAILS_API as
2: /* $Header: pebpdapi.pkb 115.11 2003/09/25 03:40:32 rsahoo noship $ */
3: --
4: -- Package Variables
5: --

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

2: /* $Header: pebpdapi.pkb 115.11 2003/09/25 03:40:32 rsahoo noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' PER_BF_PAYMENT_DETAILS_API.';
7: --
8: --
9: Procedure chk_currency_code (p_currency_code IN VARCHAR2
10: ,p_payment_detail_id NUMBER DEFAULT NULL

Line 19: FROM per_bf_payment_details pd

15: -- Cursor to retrieve the personal payment method id
16: --
17: CURSOR csr_get_ppm_id IS
18: SELECT pd.personal_payment_method_id
19: FROM per_bf_payment_details pd
20: WHERE pd.payment_detail_id = p_payment_detail_id;
21:
22: -- Cursor to retrieve the currency code from the org payment method
23: --

Line 136: l_payment_detail_id PER_BF_PAYMENT_DETAILS.payment_detail_id%TYPE;

132: --
133: -- Two tables are being used in this API, so two sets of OUT parameters will
134: -- be created.
135: --
136: l_payment_detail_id PER_BF_PAYMENT_DETAILS.payment_detail_id%TYPE;
137: l_payment_detail_ovn
138: PER_BF_PAYMENT_DETAILS.object_version_number%TYPE;
139: l_processed_assignment_id
140: PER_BF_PROCESSED_ASSIGNMENTS.processed_assignment_id%TYPE;

Line 138: PER_BF_PAYMENT_DETAILS.object_version_number%TYPE;

134: -- be created.
135: --
136: l_payment_detail_id PER_BF_PAYMENT_DETAILS.payment_detail_id%TYPE;
137: l_payment_detail_ovn
138: PER_BF_PAYMENT_DETAILS.object_version_number%TYPE;
139: l_processed_assignment_id
140: PER_BF_PROCESSED_ASSIGNMENTS.processed_assignment_id%TYPE;
141: l_processed_assignment_ovn
142: PER_BF_PROCESSED_ASSIGNMENTS.object_version_number%TYPE;

Line 161: per_bf_payment_details_bk1.create_payment_detail_b

157: --
158: -- Call Before Process User Hook
159: --
160: begin
161: per_bf_payment_details_bk1.create_payment_detail_b
162: (p_effective_date => p_effective_date
163: ,p_business_group_id => p_business_group_id
164: ,p_personal_payment_method_id => p_personal_payment_method_id
165: ,p_check_number => p_check_number

Line 310: per_bf_payment_details_bk1.create_payment_detail_a

306: --
307: -- Call After Process User Hook
308: --
309: begin
310: per_bf_payment_details_bk1.create_payment_detail_a
311: (p_effective_date => p_effective_date
312: ,p_business_group_id => p_business_group_id
313: ,p_personal_payment_method_id => p_personal_payment_method_id
314: ,p_check_number => p_check_number

Line 455: l_payment_detail_ovn PER_BF_PAYMENT_DETAILS.OBJECT_VERSION_NUMBER%TYPE;

451: ,p_payment_detail_ovn in out nocopy number
452: ) is
453: --
454: -- Declare cursors and local variables
455: l_payment_detail_ovn PER_BF_PAYMENT_DETAILS.OBJECT_VERSION_NUMBER%TYPE;
456: --
457: l_proc varchar2(72) := g_package||'update_payment_detail';
458: begin
459: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 473: per_bf_payment_details_bk2.update_payment_detail_b

469: --
470: -- Call Before Process User Hook
471: --
472: begin
473: per_bf_payment_details_bk2.update_payment_detail_b
474: (p_effective_date => p_effective_date
475: ,p_check_number => p_check_number
476: ,p_payment_date => p_payment_date
477: ,p_amount => p_amount

Line 582: per_bf_payment_details_bk2.update_payment_detail_a

578: --
579: -- Call After Process User Hook
580: --
581: begin
582: per_bf_payment_details_bk2.update_payment_detail_a
583: (p_effective_date => p_effective_date
584: ,p_check_number => p_check_number
585: ,p_payment_date => p_payment_date
586: ,p_amount => p_amount

Line 680: FROM PER_BF_PAYMENT_DETAILS pd

676: -- Declare cursors and local variables
677: --
678: CURSOR csr_get_pa_id IS
679: SELECT pa.processed_assignment_id, pa.object_version_number
680: FROM PER_BF_PAYMENT_DETAILS pd
681: ,PER_BF_PROCESSED_ASSIGNMENTS pa
682: WHERE pd.payment_detail_id = p_payment_detail_id
683: AND pd.processed_assignment_id = pa.processed_assignment_id;
684: --

Line 688: FROM per_bf_payment_details

684: --
685: CURSOR csr_chk_pa_for_del
686: (p_processed_assignment_id NUMBER) IS
687: SELECT 1
688: FROM per_bf_payment_details
689: WHERE processed_assignment_id = p_processed_assignment_id
690: AND payment_detail_id <> p_payment_detail_id
691: UNION
692: SELECT 1

Line 718: per_bf_payment_details_bk3.delete_payment_detail_b

714: --
715: -- Call Before Process User Hook
716: --
717: begin
718: per_bf_payment_details_bk3.delete_payment_detail_b
719: (p_payment_detail_id => p_payment_detail_id
720: ,p_payment_detail_ovn => p_payment_detail_ovn
721: );
722: exception

Line 738: -- in PER_BF_PAYMENT_DETAILS references, then the row will be removed

734: --
735: -- Process Logic
736: --
737: -- If no other entity uses the processed_assignment row that the FK
738: -- in PER_BF_PAYMENT_DETAILS references, then the row will be removed
739: -- from PER_BF_PROCESSED_ASSIGNMENTS.
740: --
741: -- Obtain the processed assignment ID related to this row.
742: --

Line 793: per_bf_payment_details_bk3.delete_payment_detail_a

789: --
790: -- Call After Process User Hook
791: --
792: begin
793: per_bf_payment_details_bk3.delete_payment_detail_a
794: (p_payment_detail_id => p_payment_detail_id
795: ,p_payment_detail_ovn => p_payment_detail_ovn
796: );
797: exception

Line 838: end PER_BF_PAYMENT_DETAILS_API;

834: hr_utility.set_location(' Leaving:'||l_proc, 90);
835: raise;
836: end DELETE_PAYMENT_DETAIL;
837:
838: end PER_BF_PAYMENT_DETAILS_API;