APPS.XTR_COF_P dependencies on DBMS_SQL

Line 95: T_AS_AT_DATE DBMS_SQL.DATE_TABLE;

91: L_NEXT_YEAR DATE;
92:
93: L_DEAL_SUBTYPE XTR_POSITION_HISTORY.deal_subtype%TYPE;
94: L_TRANSACTION_RATE NUMBER;
95: T_AS_AT_DATE DBMS_SQL.DATE_TABLE;
96: T_AS_AT_DATE_INS DBMS_SQL.DATE_TABLE;
97: T_ROWID DBMS_SQL.VARCHAR2_TABLE;
98: N_COUNTER NUMBER;
99: N_AS_AT_DATE_CP NUMBER;

Line 96: T_AS_AT_DATE_INS DBMS_SQL.DATE_TABLE;

92:
93: L_DEAL_SUBTYPE XTR_POSITION_HISTORY.deal_subtype%TYPE;
94: L_TRANSACTION_RATE NUMBER;
95: T_AS_AT_DATE DBMS_SQL.DATE_TABLE;
96: T_AS_AT_DATE_INS DBMS_SQL.DATE_TABLE;
97: T_ROWID DBMS_SQL.VARCHAR2_TABLE;
98: N_COUNTER NUMBER;
99: N_AS_AT_DATE_CP NUMBER;
100: N_AS_AT_DATE_INS_CP NUMBER;

Line 97: T_ROWID DBMS_SQL.VARCHAR2_TABLE;

93: L_DEAL_SUBTYPE XTR_POSITION_HISTORY.deal_subtype%TYPE;
94: L_TRANSACTION_RATE NUMBER;
95: T_AS_AT_DATE DBMS_SQL.DATE_TABLE;
96: T_AS_AT_DATE_INS DBMS_SQL.DATE_TABLE;
97: T_ROWID DBMS_SQL.VARCHAR2_TABLE;
98: N_COUNTER NUMBER;
99: N_AS_AT_DATE_CP NUMBER;
100: N_AS_AT_DATE_INS_CP NUMBER;
101:

Line 202: T_COF_AS_AT_DATE DBMS_SQL.DATE_TABLE;

198:
199: N_COF_COUNTER NUMBER;
200: N_COF_AS_AT_DATE_CP NUMBER;
201: N_COF_AS_AT_DATE_INS_CP NUMBER;
202: T_COF_AS_AT_DATE DBMS_SQL.DATE_TABLE;
203: T_COF_AS_AT_DATE_INS DBMS_SQL.DATE_TABLE;
204: T_COF_ROWID DBMS_SQL.VARCHAR2_TABLE;
205:
206: cursor get_rounding_factor(l_in_currency in varchar2) is

Line 203: T_COF_AS_AT_DATE_INS DBMS_SQL.DATE_TABLE;

199: N_COF_COUNTER NUMBER;
200: N_COF_AS_AT_DATE_CP NUMBER;
201: N_COF_AS_AT_DATE_INS_CP NUMBER;
202: T_COF_AS_AT_DATE DBMS_SQL.DATE_TABLE;
203: T_COF_AS_AT_DATE_INS DBMS_SQL.DATE_TABLE;
204: T_COF_ROWID DBMS_SQL.VARCHAR2_TABLE;
205:
206: cursor get_rounding_factor(l_in_currency in varchar2) is
207: select hce_rate,rounding_factor

Line 204: T_COF_ROWID DBMS_SQL.VARCHAR2_TABLE;

200: N_COF_AS_AT_DATE_CP NUMBER;
201: N_COF_AS_AT_DATE_INS_CP NUMBER;
202: T_COF_AS_AT_DATE DBMS_SQL.DATE_TABLE;
203: T_COF_AS_AT_DATE_INS DBMS_SQL.DATE_TABLE;
204: T_COF_ROWID DBMS_SQL.VARCHAR2_TABLE;
205:
206: cursor get_rounding_factor(l_in_currency in varchar2) is
207: select hce_rate,rounding_factor
208: from XTR_MASTER_CURRENCIES_V