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_PROCESSED_ASSIGNMENTS

Line 130: -- PER_BF_PROCESSED_ASSIGNMENTS should one exist.

126: --
127: -- Declare cursors and local variables
128: --
129: -- Cursor to retrieve the ID and OVN of the row in
130: -- PER_BF_PROCESSED_ASSIGNMENTS should one exist.
131: --
132: CURSOR csr_get_pa_id_ovn IS
133: SELECT processed_assignment_id, object_version_number
134: FROM per_bf_processed_assignments

Line 134: FROM per_bf_processed_assignments

130: -- PER_BF_PROCESSED_ASSIGNMENTS should one exist.
131: --
132: CURSOR csr_get_pa_id_ovn IS
133: SELECT processed_assignment_id, object_version_number
134: FROM per_bf_processed_assignments
135: WHERE payroll_run_id = p_payroll_run_id
136: AND assignment_id = p_assignment_id;
137: --
138: -- Two tables are being used in this API, so two sets of OUT parameters will

Line 145: PER_BF_PROCESSED_ASSIGNMENTS.processed_assignment_id%TYPE;

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;
148: --
149: l_proc varchar2(72) := g_package||'create_balance_amount';

Line 147: PER_BF_PROCESSED_ASSIGNMENTS.object_version_number%TYPE;

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;
148: --
149: l_proc varchar2(72) := g_package||'create_balance_amount';
150: begin
151: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 238: -- PER_BF_PROCESSED_ASSIGNMENTS.

234: hr_utility.set_location(l_proc, 35);
235: --
236: -- This is the first balance to be associated with this assignment and
237: -- payroll run, so a new row needs to be created in the table
238: -- PER_BF_PROCESSED_ASSIGNMENTS.
239: --
240: CLOSE csr_get_pa_id_ovn ;
241: --
242: per_bpa_ins.ins

Line 254: -- A row exists in PER_BF_PROCESSED_ASSIGNMENTS for this payroll run and

250: ELSE
251: --
252: hr_utility.set_location(l_proc, 36);
253: --
254: -- A row exists in PER_BF_PROCESSED_ASSIGNMENTS for this payroll run and
255: -- assignment combination, so no need to do anything as the values
256: -- for the processed_assignment_id and object_version number are
257: -- already in local variables.
258: --

Line 733: ,PER_BF_PROCESSED_ASSIGNMENTS pa

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: --
737: CURSOR csr_chk_pa_for_del

Line 793: -- from PER_BF_PROCESSED_ASSIGNMENTS.

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: --
797: OPEN csr_get_pa_id;

Line 812: -- The row can be deleted from PER_BF_PROCESSED_ASSIGNMENTS

808: IF csr_chk_pa_for_del%NOTFOUND THEN
809: --
810: CLOSE csr_chk_pa_for_del;
811: --
812: -- The row can be deleted from PER_BF_PROCESSED_ASSIGNMENTS
813: -- so set a boolean and it will be removed later.
814: --
815: l_delete_pa_row := TRUE;
816: --