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_RECEIPTS_PVT dependencies on OKL_API

Line 10: g_app_name CONSTANT VARCHAR2(3) := okl_api.g_app_name;

6: ---------------------------------------------------------------------------
7: -- GLOBAL VARIABLES
8: ---------------------------------------------------------------------------
9:
10: g_app_name CONSTANT VARCHAR2(3) := okl_api.g_app_name;
11:
12: g_unexpected_error CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
13:
14: g_sqlerrm_token CONSTANT VARCHAR2(200) := 'SQLERRM';

Line 20: g_col_name_token CONSTANT VARCHAR2(200) := okl_api.g_col_name_token;

16: g_sqlcode_token CONSTANT VARCHAR2(200) := 'SQLCODE';
17:
18: g_pkg_name CONSTANT VARCHAR2(200) := 'OKL_RECEIPTS_PVT';
19:
20: g_col_name_token CONSTANT VARCHAR2(200) := okl_api.g_col_name_token;
21:
22: g_parent_table_token CONSTANT VARCHAR2(200) := okl_api.g_parent_table_token;
23:
24: g_child_table_token CONSTANT VARCHAR2(200) := okl_api.g_child_table_token;

Line 22: g_parent_table_token CONSTANT VARCHAR2(200) := okl_api.g_parent_table_token;

18: g_pkg_name CONSTANT VARCHAR2(200) := 'OKL_RECEIPTS_PVT';
19:
20: g_col_name_token CONSTANT VARCHAR2(200) := okl_api.g_col_name_token;
21:
22: g_parent_table_token CONSTANT VARCHAR2(200) := okl_api.g_parent_table_token;
23:
24: g_child_table_token CONSTANT VARCHAR2(200) := okl_api.g_child_table_token;
25:
26: g_no_parent_record CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';

Line 24: g_child_table_token CONSTANT VARCHAR2(200) := okl_api.g_child_table_token;

20: g_col_name_token CONSTANT VARCHAR2(200) := okl_api.g_col_name_token;
21:
22: g_parent_table_token CONSTANT VARCHAR2(200) := okl_api.g_parent_table_token;
23:
24: g_child_table_token CONSTANT VARCHAR2(200) := okl_api.g_child_table_token;
25:
26: g_no_parent_record CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
27:
28: g_invalid_value CONSTANT VARCHAR2(200) := okl_api.g_invalid_value;

Line 28: g_invalid_value CONSTANT VARCHAR2(200) := okl_api.g_invalid_value;

24: g_child_table_token CONSTANT VARCHAR2(200) := okl_api.g_child_table_token;
25:
26: g_no_parent_record CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
27:
28: g_invalid_value CONSTANT VARCHAR2(200) := okl_api.g_invalid_value;
29:
30: g_required_value CONSTANT VARCHAR2(200) := okl_api.g_required_value;
31:
32: g_exception_halt_validation EXCEPTION;

Line 30: g_required_value CONSTANT VARCHAR2(200) := okl_api.g_required_value;

26: g_no_parent_record CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
27:
28: g_invalid_value CONSTANT VARCHAR2(200) := okl_api.g_invalid_value;
29:
30: g_required_value CONSTANT VARCHAR2(200) := okl_api.g_required_value;
31:
32: g_exception_halt_validation EXCEPTION;
33: ---------------------------------------------------------------------------
34: -- Procedures and Functions

Line 40: TYPE rcpt_rec_type IS RECORD(cash_receipt_id NUMBER := okl_api.g_miss_num,

36: ---------------------------------------------------------------------------
37: -- GLOBAL DATASTRUCTURES
38: ---------------------------------------------------------------------------
39:
40: TYPE rcpt_rec_type IS RECORD(cash_receipt_id NUMBER := okl_api.g_miss_num,
41: amount NUMBER := okl_api.g_miss_num,
42: currency_code ar_cash_receipts.currency_code%TYPE := okl_api.g_miss_char,
43: customer_number hz_cust_accounts.account_number%TYPE := okl_api.g_miss_char,
44: customer_id NUMBER := okl_api.g_miss_num,

Line 41: amount NUMBER := okl_api.g_miss_num,

37: -- GLOBAL DATASTRUCTURES
38: ---------------------------------------------------------------------------
39:
40: TYPE rcpt_rec_type IS RECORD(cash_receipt_id NUMBER := okl_api.g_miss_num,
41: amount NUMBER := okl_api.g_miss_num,
42: currency_code ar_cash_receipts.currency_code%TYPE := okl_api.g_miss_char,
43: customer_number hz_cust_accounts.account_number%TYPE := okl_api.g_miss_char,
44: customer_id NUMBER := okl_api.g_miss_num,
45: receipt_number ar_cash_receipts.receipt_number%TYPE := okl_api.g_miss_char,

Line 42: currency_code ar_cash_receipts.currency_code%TYPE := okl_api.g_miss_char,

38: ---------------------------------------------------------------------------
39:
40: TYPE rcpt_rec_type IS RECORD(cash_receipt_id NUMBER := okl_api.g_miss_num,
41: amount NUMBER := okl_api.g_miss_num,
42: currency_code ar_cash_receipts.currency_code%TYPE := okl_api.g_miss_char,
43: customer_number hz_cust_accounts.account_number%TYPE := okl_api.g_miss_char,
44: customer_id NUMBER := okl_api.g_miss_num,
45: receipt_number ar_cash_receipts.receipt_number%TYPE := okl_api.g_miss_char,
46: receipt_date ar_cash_receipts.receipt_date%TYPE := okl_api.g_miss_date,

Line 43: customer_number hz_cust_accounts.account_number%TYPE := okl_api.g_miss_char,

39:
40: TYPE rcpt_rec_type IS RECORD(cash_receipt_id NUMBER := okl_api.g_miss_num,
41: amount NUMBER := okl_api.g_miss_num,
42: currency_code ar_cash_receipts.currency_code%TYPE := okl_api.g_miss_char,
43: customer_number hz_cust_accounts.account_number%TYPE := okl_api.g_miss_char,
44: customer_id NUMBER := okl_api.g_miss_num,
45: receipt_number ar_cash_receipts.receipt_number%TYPE := okl_api.g_miss_char,
46: receipt_date ar_cash_receipts.receipt_date%TYPE := okl_api.g_miss_date,
47: exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE := okl_api.g_miss_char,

Line 44: customer_id NUMBER := okl_api.g_miss_num,

40: TYPE rcpt_rec_type IS RECORD(cash_receipt_id NUMBER := okl_api.g_miss_num,
41: amount NUMBER := okl_api.g_miss_num,
42: currency_code ar_cash_receipts.currency_code%TYPE := okl_api.g_miss_char,
43: customer_number hz_cust_accounts.account_number%TYPE := okl_api.g_miss_char,
44: customer_id NUMBER := okl_api.g_miss_num,
45: receipt_number ar_cash_receipts.receipt_number%TYPE := okl_api.g_miss_char,
46: receipt_date ar_cash_receipts.receipt_date%TYPE := okl_api.g_miss_date,
47: exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE := okl_api.g_miss_char,
48: exchange_rate NUMBER := okl_api.g_miss_num,

Line 45: receipt_number ar_cash_receipts.receipt_number%TYPE := okl_api.g_miss_char,

41: amount NUMBER := okl_api.g_miss_num,
42: currency_code ar_cash_receipts.currency_code%TYPE := okl_api.g_miss_char,
43: customer_number hz_cust_accounts.account_number%TYPE := okl_api.g_miss_char,
44: customer_id NUMBER := okl_api.g_miss_num,
45: receipt_number ar_cash_receipts.receipt_number%TYPE := okl_api.g_miss_char,
46: receipt_date ar_cash_receipts.receipt_date%TYPE := okl_api.g_miss_date,
47: exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE := okl_api.g_miss_char,
48: exchange_rate NUMBER := okl_api.g_miss_num,
49: exchange_date ar_cash_receipts.exchange_date%TYPE := okl_api.g_miss_date,

Line 46: receipt_date ar_cash_receipts.receipt_date%TYPE := okl_api.g_miss_date,

42: currency_code ar_cash_receipts.currency_code%TYPE := okl_api.g_miss_char,
43: customer_number hz_cust_accounts.account_number%TYPE := okl_api.g_miss_char,
44: customer_id NUMBER := okl_api.g_miss_num,
45: receipt_number ar_cash_receipts.receipt_number%TYPE := okl_api.g_miss_char,
46: receipt_date ar_cash_receipts.receipt_date%TYPE := okl_api.g_miss_date,
47: exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE := okl_api.g_miss_char,
48: exchange_rate NUMBER := okl_api.g_miss_num,
49: exchange_date ar_cash_receipts.exchange_date%TYPE := okl_api.g_miss_date,
50: remittance_bank_account_id NUMBER := okl_api.g_miss_num,

Line 47: exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE := okl_api.g_miss_char,

43: customer_number hz_cust_accounts.account_number%TYPE := okl_api.g_miss_char,
44: customer_id NUMBER := okl_api.g_miss_num,
45: receipt_number ar_cash_receipts.receipt_number%TYPE := okl_api.g_miss_char,
46: receipt_date ar_cash_receipts.receipt_date%TYPE := okl_api.g_miss_date,
47: exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE := okl_api.g_miss_char,
48: exchange_rate NUMBER := okl_api.g_miss_num,
49: exchange_date ar_cash_receipts.exchange_date%TYPE := okl_api.g_miss_date,
50: remittance_bank_account_id NUMBER := okl_api.g_miss_num,
51: customer_bank_account_id NUMBER := okl_api.g_miss_num,

Line 48: exchange_rate NUMBER := okl_api.g_miss_num,

44: customer_id NUMBER := okl_api.g_miss_num,
45: receipt_number ar_cash_receipts.receipt_number%TYPE := okl_api.g_miss_char,
46: receipt_date ar_cash_receipts.receipt_date%TYPE := okl_api.g_miss_date,
47: exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE := okl_api.g_miss_char,
48: exchange_rate NUMBER := okl_api.g_miss_num,
49: exchange_date ar_cash_receipts.exchange_date%TYPE := okl_api.g_miss_date,
50: remittance_bank_account_id NUMBER := okl_api.g_miss_num,
51: customer_bank_account_id NUMBER := okl_api.g_miss_num,
52: remittance_bank_account_num ce_bank_accounts.bank_account_num%TYPE := okl_api.g_miss_char,

Line 49: exchange_date ar_cash_receipts.exchange_date%TYPE := okl_api.g_miss_date,

45: receipt_number ar_cash_receipts.receipt_number%TYPE := okl_api.g_miss_char,
46: receipt_date ar_cash_receipts.receipt_date%TYPE := okl_api.g_miss_date,
47: exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE := okl_api.g_miss_char,
48: exchange_rate NUMBER := okl_api.g_miss_num,
49: exchange_date ar_cash_receipts.exchange_date%TYPE := okl_api.g_miss_date,
50: remittance_bank_account_id NUMBER := okl_api.g_miss_num,
51: customer_bank_account_id NUMBER := okl_api.g_miss_num,
52: remittance_bank_account_num ce_bank_accounts.bank_account_num%TYPE := okl_api.g_miss_char,
53: remittance_bank_account_name ce_bank_accounts.bank_account_name%TYPE := okl_api.g_miss_char,

Line 50: remittance_bank_account_id NUMBER := okl_api.g_miss_num,

46: receipt_date ar_cash_receipts.receipt_date%TYPE := okl_api.g_miss_date,
47: exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE := okl_api.g_miss_char,
48: exchange_rate NUMBER := okl_api.g_miss_num,
49: exchange_date ar_cash_receipts.exchange_date%TYPE := okl_api.g_miss_date,
50: remittance_bank_account_id NUMBER := okl_api.g_miss_num,
51: customer_bank_account_id NUMBER := okl_api.g_miss_num,
52: remittance_bank_account_num ce_bank_accounts.bank_account_num%TYPE := okl_api.g_miss_char,
53: remittance_bank_account_name ce_bank_accounts.bank_account_name%TYPE := okl_api.g_miss_char,
54: payment_trx_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE,

Line 51: customer_bank_account_id NUMBER := okl_api.g_miss_num,

47: exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE := okl_api.g_miss_char,
48: exchange_rate NUMBER := okl_api.g_miss_num,
49: exchange_date ar_cash_receipts.exchange_date%TYPE := okl_api.g_miss_date,
50: remittance_bank_account_id NUMBER := okl_api.g_miss_num,
51: customer_bank_account_id NUMBER := okl_api.g_miss_num,
52: remittance_bank_account_num ce_bank_accounts.bank_account_num%TYPE := okl_api.g_miss_char,
53: remittance_bank_account_name ce_bank_accounts.bank_account_name%TYPE := okl_api.g_miss_char,
54: payment_trx_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE,
55: receipt_method_id NUMBER := okl_api.g_miss_num,

Line 52: remittance_bank_account_num ce_bank_accounts.bank_account_num%TYPE := okl_api.g_miss_char,

48: exchange_rate NUMBER := okl_api.g_miss_num,
49: exchange_date ar_cash_receipts.exchange_date%TYPE := okl_api.g_miss_date,
50: remittance_bank_account_id NUMBER := okl_api.g_miss_num,
51: customer_bank_account_id NUMBER := okl_api.g_miss_num,
52: remittance_bank_account_num ce_bank_accounts.bank_account_num%TYPE := okl_api.g_miss_char,
53: remittance_bank_account_name ce_bank_accounts.bank_account_name%TYPE := okl_api.g_miss_char,
54: payment_trx_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE,
55: receipt_method_id NUMBER := okl_api.g_miss_num,
56: org_id NUMBER := okl_api.g_miss_num,

Line 53: remittance_bank_account_name ce_bank_accounts.bank_account_name%TYPE := okl_api.g_miss_char,

49: exchange_date ar_cash_receipts.exchange_date%TYPE := okl_api.g_miss_date,
50: remittance_bank_account_id NUMBER := okl_api.g_miss_num,
51: customer_bank_account_id NUMBER := okl_api.g_miss_num,
52: remittance_bank_account_num ce_bank_accounts.bank_account_num%TYPE := okl_api.g_miss_char,
53: remittance_bank_account_name ce_bank_accounts.bank_account_name%TYPE := okl_api.g_miss_char,
54: payment_trx_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE,
55: receipt_method_id NUMBER := okl_api.g_miss_num,
56: org_id NUMBER := okl_api.g_miss_num,
57: gl_date DATE := okl_api.g_miss_date,

Line 55: receipt_method_id NUMBER := okl_api.g_miss_num,

51: customer_bank_account_id NUMBER := okl_api.g_miss_num,
52: remittance_bank_account_num ce_bank_accounts.bank_account_num%TYPE := okl_api.g_miss_char,
53: remittance_bank_account_name ce_bank_accounts.bank_account_name%TYPE := okl_api.g_miss_char,
54: payment_trx_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE,
55: receipt_method_id NUMBER := okl_api.g_miss_num,
56: org_id NUMBER := okl_api.g_miss_num,
57: gl_date DATE := okl_api.g_miss_date,
58: dff_attribute_category ar_cash_receipts.attribute_category%TYPE,
59: dff_attribute1 ar_cash_receipts.attribute1%TYPE,

Line 56: org_id NUMBER := okl_api.g_miss_num,

52: remittance_bank_account_num ce_bank_accounts.bank_account_num%TYPE := okl_api.g_miss_char,
53: remittance_bank_account_name ce_bank_accounts.bank_account_name%TYPE := okl_api.g_miss_char,
54: payment_trx_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE,
55: receipt_method_id NUMBER := okl_api.g_miss_num,
56: org_id NUMBER := okl_api.g_miss_num,
57: gl_date DATE := okl_api.g_miss_date,
58: dff_attribute_category ar_cash_receipts.attribute_category%TYPE,
59: dff_attribute1 ar_cash_receipts.attribute1%TYPE,
60: dff_attribute2 ar_cash_receipts.attribute2%TYPE,

Line 57: gl_date DATE := okl_api.g_miss_date,

53: remittance_bank_account_name ce_bank_accounts.bank_account_name%TYPE := okl_api.g_miss_char,
54: payment_trx_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE,
55: receipt_method_id NUMBER := okl_api.g_miss_num,
56: org_id NUMBER := okl_api.g_miss_num,
57: gl_date DATE := okl_api.g_miss_date,
58: dff_attribute_category ar_cash_receipts.attribute_category%TYPE,
59: dff_attribute1 ar_cash_receipts.attribute1%TYPE,
60: dff_attribute2 ar_cash_receipts.attribute2%TYPE,
61: dff_attribute3 ar_cash_receipts.attribute3%TYPE,

Line 75: p_original_onacc_amount NUMBER := okl_api.g_miss_num, -- should be zero if this is new receipt or new application

71: dff_attribute13 ar_cash_receipts.attribute13%TYPE,
72: dff_attribute14 ar_cash_receipts.attribute14%TYPE,
73: dff_attribute15 ar_cash_receipts.attribute15%TYPE,
74: create_mode VARCHAR2(30), -- can take values 'UNAPPLIED', 'UNIDENTIFIED', 'ONACCOUNT', 'APPLIED'
75: p_original_onacc_amount NUMBER := okl_api.g_miss_num, -- should be zero if this is new receipt or new application
76: p_apply_onacc_amount NUMBER := okl_api.g_miss_num
77: );
78:
79: TYPE appl_rec_type IS RECORD(contract_id okc_k_headers_all_b.id%TYPE,

Line 76: p_apply_onacc_amount NUMBER := okl_api.g_miss_num

72: dff_attribute14 ar_cash_receipts.attribute14%TYPE,
73: dff_attribute15 ar_cash_receipts.attribute15%TYPE,
74: create_mode VARCHAR2(30), -- can take values 'UNAPPLIED', 'UNIDENTIFIED', 'ONACCOUNT', 'APPLIED'
75: p_original_onacc_amount NUMBER := okl_api.g_miss_num, -- should be zero if this is new receipt or new application
76: p_apply_onacc_amount NUMBER := okl_api.g_miss_num
77: );
78:
79: TYPE appl_rec_type IS RECORD(contract_id okc_k_headers_all_b.id%TYPE,
80: con_inv_id okl_cnsld_ar_hdrs_all_b.id%TYPE,

Line 97: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false,

93:
94:
95: PROCEDURE handle_receipt
96: (p_api_version IN NUMBER,
97: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false,
98: x_return_status OUT NOCOPY VARCHAR2,
99: x_msg_count OUT NOCOPY NUMBER,
100: x_msg_data OUT NOCOPY VARCHAR2,
101: p_rcpt_rec IN RCPT_REC_TYPE,