DBA Data[Home] [Help]

APPS.GMF_SUBLEDGER_PKG dependencies on IC_CLDR_DTL

Line 136: l_inv_fiscal_year ic_cldr_dtl.fiscal_year%TYPE;

132: l_open_gl_fiscal_year NUMBER(15);
133: l_open_gl_period NUMBER(15);
134:
135: /* Start INVCONV umoogala
136: l_inv_fiscal_year ic_cldr_dtl.fiscal_year%TYPE;
137: l_inv_period ic_cldr_dtl.period%TYPE;
138: */
139: l_inv_fiscal_year org_acct_periods.period_year%TYPE;
140: l_inv_period org_acct_periods.period_num%TYPE;

Line 137: l_inv_period ic_cldr_dtl.period%TYPE;

133: l_open_gl_period NUMBER(15);
134:
135: /* Start INVCONV umoogala
136: l_inv_fiscal_year ic_cldr_dtl.fiscal_year%TYPE;
137: l_inv_period ic_cldr_dtl.period%TYPE;
138: */
139: l_inv_fiscal_year org_acct_periods.period_year%TYPE;
140: l_inv_period org_acct_periods.period_num%TYPE;
141:

Line 1495: FROM ic_cldr_dtl

1491:
1492: CURSOR c_check_icperd(cp_co_code VARCHAR2,
1493: cp_inv_fiscal_year VARCHAR2, cp_inv_period NUMBER) IS
1494: SELECT closed_period_ind
1495: FROM ic_cldr_dtl
1496: WHERE
1497: orgn_code = cp_co_code
1498: AND fiscal_year = cp_inv_fiscal_year
1499: AND period = cp_inv_period;

Line 1555: l_inv_period ic_cldr_dtl.period%TYPE;

1551: X_count NUMBER(15);
1552: X_rvar NUMBER(15);
1553:
1554: l_inv_fiscal_year ic_cldr_hdr.fiscal_year%TYPE;
1555: l_inv_period ic_cldr_dtl.period%TYPE;
1556: l_inv_per_start_date DATE;
1557: l_inv_per_end_date DATE;
1558: l_inv_per_synch VARCHAR2(1);
1559: l_retstatus VARCHAR2(1);