DBA Data[Home] [Help]

APPS.GMF_SUBLEDGER_PKG dependencies on IC_CLDR_DTL

Line 153: l_inv_fiscal_year ic_cldr_dtl.fiscal_year%TYPE;

149: l_open_gl_fiscal_year NUMBER(15);
150: l_open_gl_period NUMBER(15);
151:
152: /* Start INVCONV umoogala
153: l_inv_fiscal_year ic_cldr_dtl.fiscal_year%TYPE;
154: l_inv_period ic_cldr_dtl.period%TYPE;
155: */
156: l_inv_fiscal_year org_acct_periods.period_year%TYPE;
157: l_inv_period org_acct_periods.period_num%TYPE;

Line 154: l_inv_period ic_cldr_dtl.period%TYPE;

150: l_open_gl_period NUMBER(15);
151:
152: /* Start INVCONV umoogala
153: l_inv_fiscal_year ic_cldr_dtl.fiscal_year%TYPE;
154: l_inv_period ic_cldr_dtl.period%TYPE;
155: */
156: l_inv_fiscal_year org_acct_periods.period_year%TYPE;
157: l_inv_period org_acct_periods.period_num%TYPE;
158:

Line 2015: FROM ic_cldr_dtl

2011:
2012: CURSOR c_check_icperd(cp_co_code VARCHAR2,
2013: cp_inv_fiscal_year VARCHAR2, cp_inv_period NUMBER) IS
2014: SELECT closed_period_ind
2015: FROM ic_cldr_dtl
2016: WHERE
2017: orgn_code = cp_co_code
2018: AND fiscal_year = cp_inv_fiscal_year
2019: AND period = cp_inv_period;

Line 2078: l_inv_period ic_cldr_dtl.period%TYPE;

2074: X_count NUMBER(15);
2075: X_rvar NUMBER(15);
2076:
2077: l_inv_fiscal_year ic_cldr_hdr.fiscal_year%TYPE;
2078: l_inv_period ic_cldr_dtl.period%TYPE;
2079: l_inv_per_start_date DATE;
2080: l_inv_per_end_date DATE;
2081: l_inv_per_synch VARCHAR2(1);
2082: l_retstatus VARCHAR2(1);