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_OPEN_INTERFACE_PVT dependencies on OKL_TERMS_INTERFACE

Line 3281: FROM okl_terms_interface

3277: --
3278:
3279: CURSOR okl_term_csr (p_contract_number okc_k_headers_v.contract_number%TYPE) IS
3280: SELECT *
3281: FROM okl_terms_interface
3282: WHERE contract_number_old = p_contract_number;
3283:
3284: --
3285: -- Cursor to fetch Payments Records

Line 21854: p_bill_to_address_id IN okl_terms_interface.bill_to_address_id%TYPE,

21850: p_auth_org_id IN okl_header_interface.authoring_org_id%TYPE,
21851: p_line_number IN okc_k_lines_v.line_number%TYPE,
21852: p_line_type IN okl_lines_interface.line_type%TYPE,
21853: p_cle_id IN okc_k_lines_v.id%TYPE,
21854: p_bill_to_address_id IN okl_terms_interface.bill_to_address_id%TYPE,
21855: p_bill_to_address IN okl_terms_interface.bill_to_address%TYPE,
21856: p_bank_account_id IN okl_terms_interface.bank_account_id%TYPE,
21857: p_bank_account_number IN okl_terms_interface.bank_account_number%TYPE,
21858: p_reason_for_invoice_review IN okl_terms_interface.reason_for_invoice_review%TYPE,

Line 21855: p_bill_to_address IN okl_terms_interface.bill_to_address%TYPE,

21851: p_line_number IN okc_k_lines_v.line_number%TYPE,
21852: p_line_type IN okl_lines_interface.line_type%TYPE,
21853: p_cle_id IN okc_k_lines_v.id%TYPE,
21854: p_bill_to_address_id IN okl_terms_interface.bill_to_address_id%TYPE,
21855: p_bill_to_address IN okl_terms_interface.bill_to_address%TYPE,
21856: p_bank_account_id IN okl_terms_interface.bank_account_id%TYPE,
21857: p_bank_account_number IN okl_terms_interface.bank_account_number%TYPE,
21858: p_reason_for_invoice_review IN okl_terms_interface.reason_for_invoice_review%TYPE,
21859: p_invoice_review_until_date IN okl_terms_interface.invoice_review_until_date%TYPE,

Line 21856: p_bank_account_id IN okl_terms_interface.bank_account_id%TYPE,

21852: p_line_type IN okl_lines_interface.line_type%TYPE,
21853: p_cle_id IN okc_k_lines_v.id%TYPE,
21854: p_bill_to_address_id IN okl_terms_interface.bill_to_address_id%TYPE,
21855: p_bill_to_address IN okl_terms_interface.bill_to_address%TYPE,
21856: p_bank_account_id IN okl_terms_interface.bank_account_id%TYPE,
21857: p_bank_account_number IN okl_terms_interface.bank_account_number%TYPE,
21858: p_reason_for_invoice_review IN okl_terms_interface.reason_for_invoice_review%TYPE,
21859: p_invoice_review_until_date IN okl_terms_interface.invoice_review_until_date%TYPE,
21860: p_invoice_format_id IN okl_terms_interface.invoice_format_id%TYPE,

Line 21857: p_bank_account_number IN okl_terms_interface.bank_account_number%TYPE,

21853: p_cle_id IN okc_k_lines_v.id%TYPE,
21854: p_bill_to_address_id IN okl_terms_interface.bill_to_address_id%TYPE,
21855: p_bill_to_address IN okl_terms_interface.bill_to_address%TYPE,
21856: p_bank_account_id IN okl_terms_interface.bank_account_id%TYPE,
21857: p_bank_account_number IN okl_terms_interface.bank_account_number%TYPE,
21858: p_reason_for_invoice_review IN okl_terms_interface.reason_for_invoice_review%TYPE,
21859: p_invoice_review_until_date IN okl_terms_interface.invoice_review_until_date%TYPE,
21860: p_invoice_format_id IN okl_terms_interface.invoice_format_id%TYPE,
21861: p_invoice_format_code IN okl_terms_interface.invoice_format_code%TYPE,

Line 21858: p_reason_for_invoice_review IN okl_terms_interface.reason_for_invoice_review%TYPE,

21854: p_bill_to_address_id IN okl_terms_interface.bill_to_address_id%TYPE,
21855: p_bill_to_address IN okl_terms_interface.bill_to_address%TYPE,
21856: p_bank_account_id IN okl_terms_interface.bank_account_id%TYPE,
21857: p_bank_account_number IN okl_terms_interface.bank_account_number%TYPE,
21858: p_reason_for_invoice_review IN okl_terms_interface.reason_for_invoice_review%TYPE,
21859: p_invoice_review_until_date IN okl_terms_interface.invoice_review_until_date%TYPE,
21860: p_invoice_format_id IN okl_terms_interface.invoice_format_id%TYPE,
21861: p_invoice_format_code IN okl_terms_interface.invoice_format_code%TYPE,
21862: p_review_invoice_flag IN okl_terms_interface.review_invoice_flag%TYPE,

Line 21859: p_invoice_review_until_date IN okl_terms_interface.invoice_review_until_date%TYPE,

21855: p_bill_to_address IN okl_terms_interface.bill_to_address%TYPE,
21856: p_bank_account_id IN okl_terms_interface.bank_account_id%TYPE,
21857: p_bank_account_number IN okl_terms_interface.bank_account_number%TYPE,
21858: p_reason_for_invoice_review IN okl_terms_interface.reason_for_invoice_review%TYPE,
21859: p_invoice_review_until_date IN okl_terms_interface.invoice_review_until_date%TYPE,
21860: p_invoice_format_id IN okl_terms_interface.invoice_format_id%TYPE,
21861: p_invoice_format_code IN okl_terms_interface.invoice_format_code%TYPE,
21862: p_review_invoice_flag IN okl_terms_interface.review_invoice_flag%TYPE,
21863: p_payment_method_id IN okl_terms_interface.payment_method_id%TYPE,

Line 21860: p_invoice_format_id IN okl_terms_interface.invoice_format_id%TYPE,

21856: p_bank_account_id IN okl_terms_interface.bank_account_id%TYPE,
21857: p_bank_account_number IN okl_terms_interface.bank_account_number%TYPE,
21858: p_reason_for_invoice_review IN okl_terms_interface.reason_for_invoice_review%TYPE,
21859: p_invoice_review_until_date IN okl_terms_interface.invoice_review_until_date%TYPE,
21860: p_invoice_format_id IN okl_terms_interface.invoice_format_id%TYPE,
21861: p_invoice_format_code IN okl_terms_interface.invoice_format_code%TYPE,
21862: p_review_invoice_flag IN okl_terms_interface.review_invoice_flag%TYPE,
21863: p_payment_method_id IN okl_terms_interface.payment_method_id%TYPE,
21864: p_payment_method IN okl_terms_interface.payment_method%TYPE,

Line 21861: p_invoice_format_code IN okl_terms_interface.invoice_format_code%TYPE,

21857: p_bank_account_number IN okl_terms_interface.bank_account_number%TYPE,
21858: p_reason_for_invoice_review IN okl_terms_interface.reason_for_invoice_review%TYPE,
21859: p_invoice_review_until_date IN okl_terms_interface.invoice_review_until_date%TYPE,
21860: p_invoice_format_id IN okl_terms_interface.invoice_format_id%TYPE,
21861: p_invoice_format_code IN okl_terms_interface.invoice_format_code%TYPE,
21862: p_review_invoice_flag IN okl_terms_interface.review_invoice_flag%TYPE,
21863: p_payment_method_id IN okl_terms_interface.payment_method_id%TYPE,
21864: p_payment_method IN okl_terms_interface.payment_method%TYPE,
21865: p_prescribed_asset_flag IN okl_terms_interface.prescribed_asset_flag%TYPE,

Line 21862: p_review_invoice_flag IN okl_terms_interface.review_invoice_flag%TYPE,

21858: p_reason_for_invoice_review IN okl_terms_interface.reason_for_invoice_review%TYPE,
21859: p_invoice_review_until_date IN okl_terms_interface.invoice_review_until_date%TYPE,
21860: p_invoice_format_id IN okl_terms_interface.invoice_format_id%TYPE,
21861: p_invoice_format_code IN okl_terms_interface.invoice_format_code%TYPE,
21862: p_review_invoice_flag IN okl_terms_interface.review_invoice_flag%TYPE,
21863: p_payment_method_id IN okl_terms_interface.payment_method_id%TYPE,
21864: p_payment_method IN okl_terms_interface.payment_method%TYPE,
21865: p_prescribed_asset_flag IN okl_terms_interface.prescribed_asset_flag%TYPE,
21866: p_cash_appl_rule_name IN okl_terms_interface.cash_appl_rule_name%TYPE

Line 21863: p_payment_method_id IN okl_terms_interface.payment_method_id%TYPE,

21859: p_invoice_review_until_date IN okl_terms_interface.invoice_review_until_date%TYPE,
21860: p_invoice_format_id IN okl_terms_interface.invoice_format_id%TYPE,
21861: p_invoice_format_code IN okl_terms_interface.invoice_format_code%TYPE,
21862: p_review_invoice_flag IN okl_terms_interface.review_invoice_flag%TYPE,
21863: p_payment_method_id IN okl_terms_interface.payment_method_id%TYPE,
21864: p_payment_method IN okl_terms_interface.payment_method%TYPE,
21865: p_prescribed_asset_flag IN okl_terms_interface.prescribed_asset_flag%TYPE,
21866: p_cash_appl_rule_name IN okl_terms_interface.cash_appl_rule_name%TYPE
21867: ) IS

Line 21864: p_payment_method IN okl_terms_interface.payment_method%TYPE,

21860: p_invoice_format_id IN okl_terms_interface.invoice_format_id%TYPE,
21861: p_invoice_format_code IN okl_terms_interface.invoice_format_code%TYPE,
21862: p_review_invoice_flag IN okl_terms_interface.review_invoice_flag%TYPE,
21863: p_payment_method_id IN okl_terms_interface.payment_method_id%TYPE,
21864: p_payment_method IN okl_terms_interface.payment_method%TYPE,
21865: p_prescribed_asset_flag IN okl_terms_interface.prescribed_asset_flag%TYPE,
21866: p_cash_appl_rule_name IN okl_terms_interface.cash_appl_rule_name%TYPE
21867: ) IS
21868:

Line 21865: p_prescribed_asset_flag IN okl_terms_interface.prescribed_asset_flag%TYPE,

21861: p_invoice_format_code IN okl_terms_interface.invoice_format_code%TYPE,
21862: p_review_invoice_flag IN okl_terms_interface.review_invoice_flag%TYPE,
21863: p_payment_method_id IN okl_terms_interface.payment_method_id%TYPE,
21864: p_payment_method IN okl_terms_interface.payment_method%TYPE,
21865: p_prescribed_asset_flag IN okl_terms_interface.prescribed_asset_flag%TYPE,
21866: p_cash_appl_rule_name IN okl_terms_interface.cash_appl_rule_name%TYPE
21867: ) IS
21868:
21869: l_proc_name VARCHAR2(35) := 'PROCESS_TERM';

Line 21866: p_cash_appl_rule_name IN okl_terms_interface.cash_appl_rule_name%TYPE

21862: p_review_invoice_flag IN okl_terms_interface.review_invoice_flag%TYPE,
21863: p_payment_method_id IN okl_terms_interface.payment_method_id%TYPE,
21864: p_payment_method IN okl_terms_interface.payment_method%TYPE,
21865: p_prescribed_asset_flag IN okl_terms_interface.prescribed_asset_flag%TYPE,
21866: p_cash_appl_rule_name IN okl_terms_interface.cash_appl_rule_name%TYPE
21867: ) IS
21868:
21869: l_proc_name VARCHAR2(35) := 'PROCESS_TERM';
21870: term_failed EXCEPTION;

Line 28535: FROM okl_terms_interface

28531: --
28532: CURSOR okl_term_csr (p_contract_number_old VARCHAR2,
28533: p_line_number NUMBER) IS
28534: SELECT *
28535: FROM okl_terms_interface
28536: WHERE contract_number_old = p_contract_number_old
28537: AND ( line_number = p_line_number
28538: AND
28539: p_line_number IS NOT NULL