eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_GENERATE_ACCRUALS_PVT dependencies on OKL_TRX_TYPES_V

Line 12: G_TRY_ID OKL_TRX_TYPES_V.id%TYPE;

8: l_sty_select_basis VARCHAR2(2000);
9: -- Bug 4884618
10:
11: -- MGAAP start 7263041
12: G_TRY_ID OKL_TRX_TYPES_V.id%TYPE;
13: G_PERIOD_NAME_REP VARCHAR2(2000);
14: G_PERIOD_START_DATE_REP DATE;
15: G_PERIOD_END_DATE_REP DATE;
16: G_SOB_ID_REP OKL_SYS_ACCT_OPTS.set_of_books_id%TYPE;

Line 65: try_id OKL_TRX_TYPES_V.ID%TYPE,

61: currency_conv_type OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_TYPE%TYPE,
62: currency_conv_date OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_DATE%TYPE,
63: currency_conv_rate OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_RATE%TYPE,
64: func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE,
65: try_id OKL_TRX_TYPES_V.ID%TYPE,
66: reverse_date_to DATE,
67: batch_name VARCHAR2(2000),
68: sob_id OKL_TRX_CONTRACTS.SET_OF_BOOKS_ID%TYPE,
69: accrual_date DATE,

Line 413: OKL_TRX_TYPES_V try,

409: --Bug 5036337
410: CURSOR check_actual_trx(p_khr_id NUMBER) IS
411: SELECT TRUNC(MAX(trx.date_transaction_occurred)) last_accrual_date
412: FROM OKL_TRX_CONTRACTS trx,
413: OKL_TRX_TYPES_V try,
414: OKL_TXL_CNTRCT_LNS txl,
415: OKL_STRM_TYPE_V sty
416: WHERE trx.khr_id = p_khr_id
417: AND trx.try_id = try.id

Line 1160: x_try_id OUT NOCOPY OKL_TRX_TYPES_V.id%TYPE,

1156: END GET_ACCOUNT_GEN_DETAILS;
1157:
1158: PROCEDURE GET_COMMON_INFO (p_accrual_date IN DATE,
1159: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY',
1160: x_try_id OUT NOCOPY OKL_TRX_TYPES_V.id%TYPE,
1161: x_period_name OUT NOCOPY VARCHAR2,
1162: x_period_start_date OUT NOCOPY DATE,
1163: x_period_end_date OUT NOCOPY DATE,
1164: x_sob_id OUT NOCOPY OKL_SYS_ACCT_OPTS.set_of_books_id%TYPE,

Line 1179: l_try_id OKL_TRX_TYPES_V.id%TYPE;

1175: l_period_end_date DATE;
1176: l_period_status VARCHAR2(2000);
1177: l_sob_id OKL_SYS_ACCT_OPTS.set_of_books_id%TYPE;
1178: l_sob_name VARCHAR2(2000);
1179: l_try_id OKL_TRX_TYPES_V.id%TYPE;
1180: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
1181: l_org_id OKL_SYS_ACCT_OPTS.org_id%TYPE;
1182: l_org_name VARCHAR2(2000);
1183: l_accrual_reversal_days NUMBER;

Line 3710: FROM OKL_TRX_CONTRACTS trx, okl_trx_types_v typ

3706:
3707: -- Cursor to select accrual transactions for cancellation using specified tcn_type
3708: CURSOR reverse_trx_csr IS
3709: SELECT trx.id,trx.transaction_date
3710: FROM OKL_TRX_CONTRACTS trx, okl_trx_types_v typ
3711: WHERE trx.khr_id = p_khr_id
3712: AND trx.tsu_code = l_tsu_code_ent
3713: AND trx.tcn_type = NVL(p_tcn_type,trx.tcn_type)
3714: AND trx.try_id = typ.id

Line 5218: l_try_id OKL_TRX_TYPES_V.id%TYPE;

5214: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;
5215: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;
5216: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;
5217: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;
5218: l_try_id OKL_TRX_TYPES_V.id%TYPE;
5219: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
5220: l_khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
5221: l_currency_conv_type OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_TYPE%TYPE;
5222: l_currency_conv_rate OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_RATE%TYPE;

Line 5355: FROM OKL_TRX_CONTRACTS trx, OKL_TRX_TYPES_V try, OKL_TXL_CNTRCT_LNS txl, OKL_STRM_TYPE_V sty

5351: -- cursor to check for accrual trx for a given period for variable rate contracts
5352: -- 12/5/05. Bug 4862620. Check for trx with variable interest income only
5353: CURSOR check_variable_trx(p_khr_id NUMBER, p_date DATE) IS
5354: SELECT 'Y'
5355: FROM OKL_TRX_CONTRACTS trx, OKL_TRX_TYPES_V try, OKL_TXL_CNTRCT_LNS txl, OKL_STRM_TYPE_V sty
5356: WHERE trx.khr_id = p_khr_id
5357: AND trx.try_id = try.id
5358: AND try.name = 'Accrual'
5359: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED

Line 5373: OKL_TRX_TYPES_V try,

5369: -- SELECT 'Y'
5370: CURSOR check_actual_trx(p_khr_id NUMBER) IS
5371: SELECT TRUNC(MAX(trx.date_transaction_occurred)) last_accrual_date
5372: FROM OKL_TRX_CONTRACTS trx,
5373: OKL_TRX_TYPES_V try,
5374: OKL_TXL_CNTRCT_LNS txl,
5375: OKL_STRM_TYPE_V sty
5376: WHERE trx.khr_id = p_khr_id
5377: AND trx.try_id = try.id

Line 8967: l_try_id OKL_TRX_TYPES_V.id%TYPE;

8963: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;
8964: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;
8965: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;
8966: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;
8967: l_try_id OKL_TRX_TYPES_V.id%TYPE;
8968: l_accrual_reversal_days OKL_SYS_ACCT_OPTS.accrual_reversal_days%TYPE;
8969: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
8970: l_khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
8971: l_currency_conv_type OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_TYPE%TYPE;

Line 9634: l_try_id OKL_TRX_TYPES_V.id%TYPE;

9630: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;
9631: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;
9632: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;
9633: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;
9634: l_try_id OKL_TRX_TYPES_V.id%TYPE;
9635: l_accrual_reversal_days OKL_SYS_ACCT_OPTS.accrual_reversal_days%TYPE;
9636: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
9637: l_khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
9638: l_currency_conv_type OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_TYPE%TYPE;

Line 9642: l_try_name OKL_TRX_TYPES_V.NAME%TYPE := 'Accrual';

9638: l_currency_conv_type OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_TYPE%TYPE;
9639: l_currency_conv_rate OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_RATE%TYPE;
9640: l_currency_conv_date OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_DATE%TYPE;
9641: l_sob_id OKL_SYS_ACCT_OPTS.set_of_books_id%TYPE;
9642: l_try_name OKL_TRX_TYPES_V.NAME%TYPE := 'Accrual';
9643: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
9644: l_tsu_code_ent OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';
9645: l_tcn_type OKL_TRX_CONTRACTS.TCN_TYPE%TYPE := 'ACL';
9646: l_reverse_date_to DATE;

Line 10026: l_try_id OKL_TRX_TYPES_V.id%TYPE;

10022: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;
10023: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;
10024: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;
10025: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;
10026: l_try_id OKL_TRX_TYPES_V.id%TYPE;
10027: l_accrual_reversal_days OKL_SYS_ACCT_OPTS.accrual_reversal_days%TYPE;
10028: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
10029: l_khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
10030: l_currency_conv_type OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_TYPE%TYPE;

Line 10036: l_try_name OKL_TRX_TYPES_V.NAME%TYPE := 'Accrual';

10032: l_currency_conv_date OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_DATE%TYPE;
10033: l_sob_id OKL_SYS_ACCT_OPTS.set_of_books_id%TYPE;
10034: l_source_trx_type OKL_TRX_CONTRACTS.SOURCE_TRX_TYPE%TYPE;
10035: l_source_trx_id OKL_TRX_CONTRACTS.SOURCE_TRX_ID%TYPE;
10036: l_try_name OKL_TRX_TYPES_V.NAME%TYPE := 'Accrual';
10037: l_reverse_date_to DATE;
10038: l_sob_name VARCHAR2(2000);
10039: l_api_version CONSTANT NUMBER := 1.0;
10040: l_api_name CONSTANT VARCHAR2(30) := 'GENERATE_ACCRUALS';