APPS.GL_CI_DATA_TRANSFER_PKG dependencies on GL_LEDGERS

Line 646: ' p, gl_ledgers b ' ||

642: EXECUTE IMMEDIATE v_PDSQL USING IN p_r_ledger_id, IN p_pd_name,
643: OUT l_r_start_date, OUT l_r_end_date, OUT l_r_quarter_date, OUT l_r_year_date;
644: v_PDSQL := 'select p.start_date, p.end_date, p.quarter_start_date, ' ||
645: 'p.year_start_date from gl_periods' ||
646: ' p, gl_ledgers b ' ||
647: 'where p.period_set_name = b.period_set_name ' ||
648: 'and p.period_type = b.accounted_period_type ' ||
649: 'and b.ledger_id = :s ' ||
650: 'and p.period_name = :pd';

Line 693: v_ledgerSQL := 'select enable_average_balances_flag from gl_ledgers ' ||

689: l_access_set_name varchar2(30);
690: BEGIN
691: dblink := p_dblink ||'.' || domainName;
692: l_ledger_id := p_ledger;
693: v_ledgerSQL := 'select enable_average_balances_flag from gl_ledgers ' ||
694: 'where ledger_id = :ledger_id';
695: EXECUTE IMMEDIATE v_ledgerSQL INTO l_daily_bal USING l_ledger_id;
696: --+input: target ledger id
697: v_R_ledgerSQL := 'BEGIN '||' :a := ' || applSysSchema ||'.GL_CI_REMOTE_INVOKE_PKG.Get_Daily_Balance_Flag@' || dblink

Line 704: v_ledgerSQL := 'select consolidation_ledger_flag from gl_ledgers ' ||

700: --+dbms_output.put_line('what is the ledger id? ' || p_r_ledger_id);
701: if l_daily_bal <> l_r_daily_bal then
702: return 'FAILURE1';
703: end if;
704: v_ledgerSQL := 'select consolidation_ledger_flag from gl_ledgers ' ||
705: 'where ledger_id = :ledger_id';
706: EXECUTE IMMEDIATE v_ledgerSQL INTO l_cons_ledger USING l_ledger_id;
707: --+dbms_output.put_line('what is the source cons flag? ' || l_cons_ledger);
708: v_R_ledgerSQL := 'BEGIN '||' :a := ' || applSysSchema ||'.GL_CI_REMOTE_INVOKE_PKG.Get_Cons_ledger_Flag@' || dblink

Line 715: v_ledgerSQL := 'SELECT CURRENCY_CODE FROM GL_ledgers ' ||

711: --+dbms_output.put_line('what is the target cons flag? ' || l_r_cons_ledger);
712: if l_cons_ledger <> l_r_cons_ledger then
713: return 'FAILURE1';
714: end if;
715: v_ledgerSQL := 'SELECT CURRENCY_CODE FROM GL_ledgers ' ||
716: 'WHERE ledger_id = :ledger_id';
717: EXECUTE IMMEDIATE v_ledgerSQL INTO l_cur_code USING l_ledger_id;
718: --+dbms_output.put_line('what is source currency ' || l_cur_code);
719: v_R_ledgerSQL := 'BEGIN '||' :a := ' || applSysSchema ||'.GL_CI_REMOTE_INVOKE_PKG.Get_Currency_Code@' || dblink

Line 769: v_ledgerSQL := 'select chart_of_accounts_id from gl_ledgers ' ||

765: l_app_id := 101;
766: l_gl_short_name := 'GL#';
767: l_r_ledger_id := p_r_ledger_id;
768: l_ledger_id := p_ledger;
769: v_ledgerSQL := 'select chart_of_accounts_id from gl_ledgers ' ||
770: 'where ledger_id = :ledger_id';
771: EXECUTE IMMEDIATE v_ledgerSQL INTO l_coa_id USING l_ledger_id;
772: chart.DELETE;
773: --+get coa information from the fnd table in the source database

Line 869: SELECT name INTO t_ledger_name FROM gl_ledgers WHERE ledger_id = p_ledger;

865: l_access_set_id number;
866: t_ledger_name varchar2(300);
867: --l_temp_db varchar2(30);
868: BEGIN
869: SELECT name INTO t_ledger_name FROM gl_ledgers WHERE ledger_id = p_ledger;
870: l_count := 0;
871: --make sure db link exists
872: v_SelectSQL := 'select count(*) from rg_database_links ' ||
873: 'where name = :dblink';