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.FV_FEDERAL_PAYMENT_FIELDS_PKG dependencies on FV_PB_SEQ_ASSIGNMENTS_ALL

Line 348: l_nextseq Fv_Pb_Seq_Assignments_All.next_seq_value%TYPE;

344: FUNCTION GET_PAY_INSTR_SEQ_NUM ( p_org_id in number,
345: p_payment_reason_code in varchar2)
346: RETURN VARCHAR2
347: IS
348: l_nextseq Fv_Pb_Seq_Assignments_All.next_seq_value%TYPE;
349: l_finalseq Fv_Pb_Seq_Assignments_All.next_seq_value%TYPE;
350: l_prefix Fv_Pb_Seq_Assignments_All.prefix%TYPE;
351: l_suffix Fv_Pb_Seq_Assignments_All.suffix%TYPE;
352: l_seq_assignment_id Fv_Pb_Seq_Assignments_All.seq_assignment_id%TYPE;

Line 349: l_finalseq Fv_Pb_Seq_Assignments_All.next_seq_value%TYPE;

345: p_payment_reason_code in varchar2)
346: RETURN VARCHAR2
347: IS
348: l_nextseq Fv_Pb_Seq_Assignments_All.next_seq_value%TYPE;
349: l_finalseq Fv_Pb_Seq_Assignments_All.next_seq_value%TYPE;
350: l_prefix Fv_Pb_Seq_Assignments_All.prefix%TYPE;
351: l_suffix Fv_Pb_Seq_Assignments_All.suffix%TYPE;
352: l_seq_assignment_id Fv_Pb_Seq_Assignments_All.seq_assignment_id%TYPE;
353: l_instruction_name iby_pay_instructions_all.pay_admin_assigned_ref_code%TYPE;

Line 350: l_prefix Fv_Pb_Seq_Assignments_All.prefix%TYPE;

346: RETURN VARCHAR2
347: IS
348: l_nextseq Fv_Pb_Seq_Assignments_All.next_seq_value%TYPE;
349: l_finalseq Fv_Pb_Seq_Assignments_All.next_seq_value%TYPE;
350: l_prefix Fv_Pb_Seq_Assignments_All.prefix%TYPE;
351: l_suffix Fv_Pb_Seq_Assignments_All.suffix%TYPE;
352: l_seq_assignment_id Fv_Pb_Seq_Assignments_All.seq_assignment_id%TYPE;
353: l_instruction_name iby_pay_instructions_all.pay_admin_assigned_ref_code%TYPE;
354: l_count NUMBER;

Line 351: l_suffix Fv_Pb_Seq_Assignments_All.suffix%TYPE;

347: IS
348: l_nextseq Fv_Pb_Seq_Assignments_All.next_seq_value%TYPE;
349: l_finalseq Fv_Pb_Seq_Assignments_All.next_seq_value%TYPE;
350: l_prefix Fv_Pb_Seq_Assignments_All.prefix%TYPE;
351: l_suffix Fv_Pb_Seq_Assignments_All.suffix%TYPE;
352: l_seq_assignment_id Fv_Pb_Seq_Assignments_All.seq_assignment_id%TYPE;
353: l_instruction_name iby_pay_instructions_all.pay_admin_assigned_ref_code%TYPE;
354: l_count NUMBER;
355: l_pi_count NUMBER;

Line 352: l_seq_assignment_id Fv_Pb_Seq_Assignments_All.seq_assignment_id%TYPE;

348: l_nextseq Fv_Pb_Seq_Assignments_All.next_seq_value%TYPE;
349: l_finalseq Fv_Pb_Seq_Assignments_All.next_seq_value%TYPE;
350: l_prefix Fv_Pb_Seq_Assignments_All.prefix%TYPE;
351: l_suffix Fv_Pb_Seq_Assignments_All.suffix%TYPE;
352: l_seq_assignment_id Fv_Pb_Seq_Assignments_All.seq_assignment_id%TYPE;
353: l_instruction_name iby_pay_instructions_all.pay_admin_assigned_ref_code%TYPE;
354: l_count NUMBER;
355: l_pi_count NUMBER;
356: l_module varchar2(200) := G_PKG_NAME || '.GET_PAY_INSTR_SEQ_NUM';

Line 361: FROM Fv_Pb_Seq_Assignments_all FPSA

357: l_message VARCHAR2(1000);
358:
359: CURSOR assign_nextseq_cur(p_org_id_csr number) IS
360: SELECT seq_assignment_id, initial_seq_value, org_id
361: FROM Fv_Pb_Seq_Assignments_all FPSA
362: WHERE FPSA.org_id = p_org_id_csr
363: AND FPSA.next_seq_value IS NULL;
364: BEGIN
365:

Line 385: UPDATE Fv_Pb_Seq_Assignments_all

381: -- where next_seq_value IS NULL
382:
383: FOR c_assign IN assign_nextseq_cur(p_org_id)
384: LOOP
385: UPDATE Fv_Pb_Seq_Assignments_all
386: SET next_seq_value = c_assign.initial_seq_value
387: WHERE org_id=c_assign.org_id
388: AND seq_assignment_id = c_assign.seq_assignment_id;
389:

Line 397: FROM Fv_Pb_Seq_Assignments_all

393: BEGIN
394: -- Get the sequence information
395: SELECT next_seq_value, final_seq_value, prefix, suffix, seq_assignment_id
396: INTO l_nextseq, l_finalseq, l_prefix, l_suffix, l_seq_assignment_id
397: FROM Fv_Pb_Seq_Assignments_all
398: WHERE payment_reason_code = p_payment_reason_code
399: AND org_id = p_org_id
400: AND TRUNC(SYSDATE) BETWEEN TRUNC(start_date) AND NVL(TRUNC(end_date),TRUNC(SYSDATE));
401: EXCEPTION

Line 441: update fv_pb_seq_assignments_all

437: END LOOP;
438:
439: -- update table with next sequence to be used
440: l_nextseq := l_nextseq + 1;
441: update fv_pb_seq_assignments_all
442: set next_seq_value = l_nextseq
443: where seq_assignment_id = l_seq_assignment_id;
444: return l_instruction_name;
445: EXCEPTION