APPS.GL_CI_REMOTE_INVOKE_PKG dependencies on GL_JE_HEADERS

Line 756: v_Headers gl_je_headers%ROWTYPE;

752: ) IS
753: v_SelectSQL varchar2(500);
754: v_SelectSQL2 varchar2(500);
755: v_ReturnCursor t_RefCur;
756: v_Headers gl_je_headers%ROWTYPE;
757: v_header_id number;
758: v_count number;
759: v_temp number;
760: l_adb_je_source GL_JE_HEADERS.JE_SOURCE%type;

Line 760: l_adb_je_source GL_JE_HEADERS.JE_SOURCE%type;

756: v_Headers gl_je_headers%ROWTYPE;
757: v_header_id number;
758: v_count number;
759: v_temp number;
760: l_adb_je_source GL_JE_HEADERS.JE_SOURCE%type;
761: l_je_source GL_JE_HEADERS.JE_SOURCE%type;
762:
763: BEGIN
764: v_temp := 0;

Line 761: l_je_source GL_JE_HEADERS.JE_SOURCE%type;

757: v_header_id number;
758: v_count number;
759: v_temp number;
760: l_adb_je_source GL_JE_HEADERS.JE_SOURCE%type;
761: l_je_source GL_JE_HEADERS.JE_SOURCE%type;
762:
763: BEGIN
764: v_temp := 0;
765: l_adb_je_source := 'Average Consolidation';

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

764: v_temp := 0;
765: l_adb_je_source := 'Average Consolidation';
766: l_je_source := 'Consolidation';
767: IF avg_flag = 'Y' THEN
768: v_SelectSQL := 'select * from gl_je_headers' ||
769: ' where status = :s and je_batch_id = :b_id' ||
770: ' and ledger_id = :sid' ||
771: ' and je_source = :je' ||
772: ' and period_name = :name' ||

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

773: ' and actual_flag = :flag';
774: OPEN v_ReturnCursor FOR v_SelectSQL USING status, batch_id, ledger_id,
775: l_adb_je_source, pd_name, actual_flag;
776: ELSE
777: v_SelectSQL := 'select * from gl_je_headers' ||
778: ' where status = :s and je_batch_id = :b_id' ||
779: ' and ledger_id = :sid' ||
780: ' and je_source = :je' ||
781: ' and period_name = :name' ||

Line 941: 'FROM GL_JE_HEADERS JEH ' ||

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

Line 951: 'FROM GL_JE_HEADERS JEH ' ||

947: IF v_Ledger_Cursor%NOTFOUND THEN
948: l_ledger_id := -99;
949: ELSE
950: v_ALC_SQL := 'SELECT 1 ' ||
951: 'FROM GL_JE_HEADERS JEH ' ||
952: 'WHERE JEH.je_batch_id = :je_batch_id ' ||
953: 'AND JEH.actual_flag != ' || '''' || 'B' || '''' ||
954: ' AND JEH.reversed_je_header_id IS NULL ' ||
955: 'AND EXISTS ' ||