APPS.GL_CI_REMOTE_INVOKE_PKG dependencies on GL_JE_HEADERS

Line 751: v_Headers gl_je_headers%ROWTYPE;

747: ) IS
748: v_SelectSQL varchar2(500);
749: v_SelectSQL2 varchar2(500);
750: v_ReturnCursor t_RefCur;
751: v_Headers gl_je_headers%ROWTYPE;
752: v_header_id number;
753: v_count number;
754: v_temp number;
755: l_adb_je_source GL_JE_HEADERS.JE_SOURCE%type;

Line 755: l_adb_je_source GL_JE_HEADERS.JE_SOURCE%type;

751: v_Headers gl_je_headers%ROWTYPE;
752: v_header_id number;
753: v_count number;
754: v_temp number;
755: l_adb_je_source GL_JE_HEADERS.JE_SOURCE%type;
756: l_je_source GL_JE_HEADERS.JE_SOURCE%type;
757:
758: BEGIN
759: v_temp := 0;

Line 756: l_je_source GL_JE_HEADERS.JE_SOURCE%type;

752: v_header_id number;
753: v_count number;
754: v_temp number;
755: l_adb_je_source GL_JE_HEADERS.JE_SOURCE%type;
756: l_je_source GL_JE_HEADERS.JE_SOURCE%type;
757:
758: BEGIN
759: v_temp := 0;
760: l_adb_je_source := 'Average Consolidation';

Line 763: v_SelectSQL := 'select * from gl_je_headers' ||

759: v_temp := 0;
760: l_adb_je_source := 'Average Consolidation';
761: l_je_source := 'Consolidation';
762: IF avg_flag = 'Y' THEN
763: v_SelectSQL := 'select * from gl_je_headers' ||
764: ' where status = :s and je_batch_id = :b_id' ||
765: ' and ledger_id = :sid' ||
766: ' and je_source = :je' ||
767: ' and period_name = :name' ||

Line 772: v_SelectSQL := 'select * from gl_je_headers' ||

768: ' and actual_flag = :flag';
769: OPEN v_ReturnCursor FOR v_SelectSQL USING status, batch_id, ledger_id,
770: l_adb_je_source, pd_name, actual_flag;
771: ELSE
772: v_SelectSQL := 'select * from gl_je_headers' ||
773: ' where status = :s and je_batch_id = :b_id' ||
774: ' and ledger_id = :sid' ||
775: ' and je_source = :je' ||
776: ' and period_name = :name' ||

Line 936: 'FROM GL_JE_HEADERS JEH ' ||

932: EXECUTE IMMEDIATE v_SelectSQL INTO l_batch_name USING batch_id;
933: --+dbms_output.put_line('get batch name');
934:
935: v_Ledger_SQL := 'SELECT max(JEH.ledger_id) ' ||
936: 'FROM GL_JE_HEADERS JEH ' ||
937: 'WHERE JEH.je_batch_id = :je_batch_id ' ||
938: 'GROUP BY JEH.je_batch_id ' ||
939: 'HAVING count(distinct JEH.ledger_id) = 1';
940: OPEN v_Ledger_Cursor FOR v_Ledger_SQL USING batch_id;

Line 946: 'FROM GL_JE_HEADERS JEH ' ||

942: IF v_Ledger_Cursor%NOTFOUND THEN
943: l_ledger_id := -99;
944: ELSE
945: v_ALC_SQL := 'SELECT 1 ' ||
946: 'FROM GL_JE_HEADERS JEH ' ||
947: 'WHERE JEH.je_batch_id = :je_batch_id ' ||
948: 'AND JEH.actual_flag != ' || '''' || 'B' || '''' ||
949: ' AND JEH.reversed_je_header_id IS NULL ' ||
950: 'AND EXISTS ' ||