38: ,x_return_status OUT NOCOPY VARCHAR2
39: ,x_msg_count OUT NOCOPY NUMBER
40: ,x_msg_data OUT NOCOPY VARCHAR2
41: ,p_contract_num IN OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL
42: ,p_customer_num IN AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT NULL
43: ,p_receipt_num IN OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT NULL
44: ,p_cross_currency_allowed IN VARCHAR2 DEFAULT 'N'
45: );
46:
52: ,x_msg_data OUT NOCOPY VARCHAR2
53: ,p_contract_id IN OKC_K_HEADERS_V.ID%TYPE DEFAULT NULL
54: ,p_contract_num IN OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL
55: ,p_customer_id IN OKL_TRX_CSH_RECEIPT_V.ILE_ID%TYPE DEFAULT NULL
56: ,p_customer_num IN AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT NULL
57: ,p_receipt_id IN AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL
58: ,p_receipt_amount IN AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE
59: ,p_remain_rcpt_amount OUT NOCOPY AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE
60: ,p_receipt_currency IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
53: ,p_contract_id IN OKC_K_HEADERS_V.ID%TYPE DEFAULT NULL
54: ,p_contract_num IN OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL
55: ,p_customer_id IN OKL_TRX_CSH_RECEIPT_V.ILE_ID%TYPE DEFAULT NULL
56: ,p_customer_num IN AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT NULL
57: ,p_receipt_id IN AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL
58: ,p_receipt_amount IN AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE
59: ,p_remain_rcpt_amount OUT NOCOPY AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE
60: ,p_receipt_currency IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
61: ,p_receipt_date IN OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT NULL
54: ,p_contract_num IN OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL
55: ,p_customer_id IN OKL_TRX_CSH_RECEIPT_V.ILE_ID%TYPE DEFAULT NULL
56: ,p_customer_num IN AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT NULL
57: ,p_receipt_id IN AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL
58: ,p_receipt_amount IN AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE
59: ,p_remain_rcpt_amount OUT NOCOPY AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE
60: ,p_receipt_currency IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
61: ,p_receipt_date IN OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT NULL
62: ,p_invoice_currency IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
55: ,p_customer_id IN OKL_TRX_CSH_RECEIPT_V.ILE_ID%TYPE DEFAULT NULL
56: ,p_customer_num IN AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT NULL
57: ,p_receipt_id IN AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL
58: ,p_receipt_amount IN AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE
59: ,p_remain_rcpt_amount OUT NOCOPY AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE
60: ,p_receipt_currency IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
61: ,p_receipt_date IN OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT NULL
62: ,p_invoice_currency IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
63: ,p_currency_conv_date IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE DEFAULT NULL
56: ,p_customer_num IN AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT NULL
57: ,p_receipt_id IN AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL
58: ,p_receipt_amount IN AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE
59: ,p_remain_rcpt_amount OUT NOCOPY AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE
60: ,p_receipt_currency IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
61: ,p_receipt_date IN OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT NULL
62: ,p_invoice_currency IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
63: ,p_currency_conv_date IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE DEFAULT NULL
64: ,p_currency_conv_rate IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE DEFAULT NULL
58: ,p_receipt_amount IN AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE
59: ,p_remain_rcpt_amount OUT NOCOPY AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE
60: ,p_receipt_currency IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
61: ,p_receipt_date IN OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT NULL
62: ,p_invoice_currency IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
63: ,p_currency_conv_date IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE DEFAULT NULL
64: ,p_currency_conv_rate IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE DEFAULT NULL
65: ,p_currency_conv_type IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE DEFAULT NULL
66: ,p_xcr_id IN NUMBER DEFAULT NULL
75: ,x_msg_data OUT NOCOPY VARCHAR2
76: ,p_contract_id IN OKC_K_HEADERS_V.ID%TYPE DEFAULT NULL
77: ,p_contract_num IN OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL
78: ,p_customer_id IN OKL_TRX_CSH_RECEIPT_V.ILE_ID%TYPE DEFAULT NULL
79: ,p_customer_num IN AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT NULL
80: ,p_receipt_id IN AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL
81: ,p_receipt_amount IN AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE
82: ,p_remain_rcpt_amount OUT NOCOPY AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE
83: ,p_receipt_currency IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
76: ,p_contract_id IN OKC_K_HEADERS_V.ID%TYPE DEFAULT NULL
77: ,p_contract_num IN OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL
78: ,p_customer_id IN OKL_TRX_CSH_RECEIPT_V.ILE_ID%TYPE DEFAULT NULL
79: ,p_customer_num IN AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT NULL
80: ,p_receipt_id IN AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL
81: ,p_receipt_amount IN AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE
82: ,p_remain_rcpt_amount OUT NOCOPY AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE
83: ,p_receipt_currency IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
84: ,p_receipt_date IN OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT NULL
77: ,p_contract_num IN OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL
78: ,p_customer_id IN OKL_TRX_CSH_RECEIPT_V.ILE_ID%TYPE DEFAULT NULL
79: ,p_customer_num IN AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT NULL
80: ,p_receipt_id IN AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL
81: ,p_receipt_amount IN AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE
82: ,p_remain_rcpt_amount OUT NOCOPY AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE
83: ,p_receipt_currency IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
84: ,p_receipt_date IN OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT NULL
85: ,p_invoice_currency IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
78: ,p_customer_id IN OKL_TRX_CSH_RECEIPT_V.ILE_ID%TYPE DEFAULT NULL
79: ,p_customer_num IN AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT NULL
80: ,p_receipt_id IN AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL
81: ,p_receipt_amount IN AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE
82: ,p_remain_rcpt_amount OUT NOCOPY AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE
83: ,p_receipt_currency IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
84: ,p_receipt_date IN OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT NULL
85: ,p_invoice_currency IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
86: ,p_invoice_total IN OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL
79: ,p_customer_num IN AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT NULL
80: ,p_receipt_id IN AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL
81: ,p_receipt_amount IN AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE
82: ,p_remain_rcpt_amount OUT NOCOPY AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE
83: ,p_receipt_currency IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
84: ,p_receipt_date IN OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT NULL
85: ,p_invoice_currency IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
86: ,p_invoice_total IN OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL
87: ,p_currency_conv_date IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE DEFAULT NULL
81: ,p_receipt_amount IN AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE
82: ,p_remain_rcpt_amount OUT NOCOPY AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE
83: ,p_receipt_currency IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
84: ,p_receipt_date IN OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT NULL
85: ,p_invoice_currency IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
86: ,p_invoice_total IN OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL
87: ,p_currency_conv_date IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE DEFAULT NULL
88: ,p_currency_conv_rate IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE DEFAULT NULL
89: ,p_currency_conv_type IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE DEFAULT NULL
107: ,x_return_status OUT NOCOPY VARCHAR2
108: ,x_msg_count OUT NOCOPY NUMBER
109: ,x_msg_data OUT NOCOPY VARCHAR2
110: ,p_contract_num IN OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL
111: ,p_customer_num IN AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT NULL
112: ,p_receipt_id IN AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL
113: ,p_receipt_num IN OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT NULL
114: ,p_receipt_date_from IN OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT NULL
115: ,p_receipt_date_to IN OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT NULL
108: ,x_msg_count OUT NOCOPY NUMBER
109: ,x_msg_data OUT NOCOPY VARCHAR2
110: ,p_contract_num IN OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL
111: ,p_customer_num IN AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT NULL
112: ,p_receipt_id IN AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL
113: ,p_receipt_num IN OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT NULL
114: ,p_receipt_date_from IN OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT NULL
115: ,p_receipt_date_to IN OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT NULL
116: ,p_receipt_type IN VARCHAR2 DEFAULT NULL
123: ,x_return_status OUT NOCOPY VARCHAR2
124: ,x_msg_count OUT NOCOPY NUMBER
125: ,x_msg_data OUT NOCOPY VARCHAR2
126: ,p_xcav_tbl IN xcav_tbl_type
127: ,p_receipt_id IN AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL
128: ,p_receipt_amount IN OUT NOCOPY AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE
129: ,p_receipt_date IN AR_CASH_RECEIPTS_ALL.RECEIPT_DATE%TYPE DEFAULT NULL
130: ,p_receipt_currency IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
131: ,p_currency_code IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
124: ,x_msg_count OUT NOCOPY NUMBER
125: ,x_msg_data OUT NOCOPY VARCHAR2
126: ,p_xcav_tbl IN xcav_tbl_type
127: ,p_receipt_id IN AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL
128: ,p_receipt_amount IN OUT NOCOPY AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE
129: ,p_receipt_date IN AR_CASH_RECEIPTS_ALL.RECEIPT_DATE%TYPE DEFAULT NULL
130: ,p_receipt_currency IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
131: ,p_currency_code IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
132: ,p_ar_inv_tbl IN OKL_BPD_ADVANCED_BILLING_PVT.ar_inv_tbl_type
125: ,x_msg_data OUT NOCOPY VARCHAR2
126: ,p_xcav_tbl IN xcav_tbl_type
127: ,p_receipt_id IN AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL
128: ,p_receipt_amount IN OUT NOCOPY AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE
129: ,p_receipt_date IN AR_CASH_RECEIPTS_ALL.RECEIPT_DATE%TYPE DEFAULT NULL
130: ,p_receipt_currency IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
131: ,p_currency_code IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
132: ,p_ar_inv_tbl IN OKL_BPD_ADVANCED_BILLING_PVT.ar_inv_tbl_type
133: );
126: ,p_xcav_tbl IN xcav_tbl_type
127: ,p_receipt_id IN AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL
128: ,p_receipt_amount IN OUT NOCOPY AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE
129: ,p_receipt_date IN AR_CASH_RECEIPTS_ALL.RECEIPT_DATE%TYPE DEFAULT NULL
130: ,p_receipt_currency IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
131: ,p_currency_code IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
132: ,p_ar_inv_tbl IN OKL_BPD_ADVANCED_BILLING_PVT.ar_inv_tbl_type
133: );
134:
127: ,p_receipt_id IN AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL
128: ,p_receipt_amount IN OUT NOCOPY AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE
129: ,p_receipt_date IN AR_CASH_RECEIPTS_ALL.RECEIPT_DATE%TYPE DEFAULT NULL
130: ,p_receipt_currency IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
131: ,p_currency_code IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
132: ,p_ar_inv_tbl IN OKL_BPD_ADVANCED_BILLING_PVT.ar_inv_tbl_type
133: );
134:
135: PROCEDURE migrate_Applications ( p_api_version IN NUMBER
136: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE
137: ,x_return_status OUT NOCOPY VARCHAR2
138: ,x_msg_count OUT NOCOPY NUMBER
139: ,x_msg_data OUT NOCOPY VARCHAR2
140: ,p_receipt_id IN AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL
141: ,p_appl_tbl IN okl_receipts_pvt.appl_tbl_type
142: ,x_appl_tbl OUT NOCOPY okl_receipts_pvt.appl_tbl_type
143: );
144: