1762: FUNCTION get_unique_id
1763: RETURN NUMBER IS
1764: CURSOR c_getid IS
1765: SELECT gl_ledgers_s.NEXTVAL
1766: FROM DUAL;
1767:
1768: ID NUMBER;
1769: BEGIN
1770: OPEN c_getid;
2687: x_ledger_id NUMBER)
2688: RETURN BOOLEAN IS
2689: CURSOR check_avg_translation IS
2690: SELECT 'avg translated'
2691: FROM DUAL
2692: WHERE EXISTS(
2693: SELECT 'X'
2694: FROM gl_translation_tracking
2695: WHERE ledger_id = x_ledger_id
3923: x_ledger_id NUMBER,
3924: x_run_flag OUT NOCOPY VARCHAR2) IS
3925: CURSOR check_translation IS
3926: SELECT 'translated'
3927: FROM DUAL
3928: WHERE EXISTS(
3929: SELECT 'X'
3930: FROM gl_translation_tracking
3931: WHERE ledger_id = x_ledger_id