DBA Data[Home] [Help]

APPS.OKL_BPD_ADVANCED_CASH_APP_PUB dependencies on OKC_K_HEADERS_V

Line 9: ,p_contract_num IN OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL

5: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
6: ,x_return_status OUT NOCOPY VARCHAR2
7: ,x_msg_count OUT NOCOPY NUMBER
8: ,x_msg_data OUT NOCOPY VARCHAR2
9: ,p_contract_num IN OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL
10: ,p_customer_num IN AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT NULL
11: ,p_receipt_num IN OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT NULL
12: ,p_receipt_type IN OKL_TRX_CSH_RECEIPT_V.RECEIPT_TYPE%TYPE DEFAULT NULL
13: ,p_cross_currency_allowed IN VARCHAR2 DEFAULT 'N'

Line 23: l_contract_id OKC_K_HEADERS_V.ID%TYPE DEFAULT NULL;

19: l_init_msg_list VARCHAR2(1);
20: l_msg_count NUMBER;
21: l_msg_data VARCHAR(2000);
22:
23: l_contract_id OKC_K_HEADERS_V.ID%TYPE DEFAULT NULL;
24: l_contract_num OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT p_contract_num;
25: l_customer_id OKL_TRX_CSH_RECEIPT_V.ILE_ID%TYPE DEFAULT NULL;
26: l_customer_num AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT p_customer_num;
27: l_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL;

Line 24: l_contract_num OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT p_contract_num;

20: l_msg_count NUMBER;
21: l_msg_data VARCHAR(2000);
22:
23: l_contract_id OKC_K_HEADERS_V.ID%TYPE DEFAULT NULL;
24: l_contract_num OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT p_contract_num;
25: l_customer_id OKL_TRX_CSH_RECEIPT_V.ILE_ID%TYPE DEFAULT NULL;
26: l_customer_num AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT p_customer_num;
27: l_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL;
28: l_receipt_num OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT p_receipt_num;

Line 104: ,p_contract_num IN OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL

100: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
101: ,x_return_status OUT NOCOPY VARCHAR2
102: ,x_msg_count OUT NOCOPY NUMBER
103: ,x_msg_data OUT NOCOPY VARCHAR2
104: ,p_contract_num IN OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL
105: ,p_customer_num IN AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT NULL
106: ,p_receipt_id IN AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL
107: ,p_receipt_num IN OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT NULL
108: ,p_receipt_date_from IN OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT NULL

Line 121: l_contract_id OKC_K_HEADERS_V.ID%TYPE DEFAULT NULL;

117: l_init_msg_list VARCHAR2(1);
118: l_msg_count NUMBER;
119: l_msg_data VARCHAR(2000);
120:
121: l_contract_id OKC_K_HEADERS_V.ID%TYPE DEFAULT NULL;
122: l_contract_num OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT p_contract_num;
123: l_customer_id OKL_TRX_CSH_RECEIPT_V.ILE_ID%TYPE DEFAULT NULL;
124: l_customer_num AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT p_customer_num;
125: l_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT p_receipt_id;

Line 122: l_contract_num OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT p_contract_num;

118: l_msg_count NUMBER;
119: l_msg_data VARCHAR(2000);
120:
121: l_contract_id OKC_K_HEADERS_V.ID%TYPE DEFAULT NULL;
122: l_contract_num OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT p_contract_num;
123: l_customer_id OKL_TRX_CSH_RECEIPT_V.ILE_ID%TYPE DEFAULT NULL;
124: l_customer_num AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT p_customer_num;
125: l_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT p_receipt_id;
126: l_receipt_num OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT p_receipt_num;

Line 205: ,p_contract_num IN OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL

201: END REAPPLIC_ADVANCED_CASH_APP;
202:
203: PROCEDURE ADVANCED_CASH_APP_CONC ( errbuf OUT NOCOPY VARCHAR2
204: ,retcode OUT NOCOPY NUMBER
205: ,p_contract_num IN OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL
206: ,p_customer_num IN AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT NULL
207: ,p_receipt_id IN AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL
208: ,p_receipt_num IN OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT NULL
209: ,p_receipt_date_from IN VARCHAR2 DEFAULT NULL

Line 224: l_contract_id OKC_K_HEADERS_V.ID%TYPE DEFAULT NULL;

220:
221: l_msg_index_out NUMBER :=0;
222: l_error_msg_rec Okl_Accounting_Util.Error_message_Type;
223:
224: l_contract_id OKC_K_HEADERS_V.ID%TYPE DEFAULT NULL;
225: l_contract_num OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT p_contract_num;
226: l_customer_id OKL_TRX_CSH_RECEIPT_V.ILE_ID%TYPE DEFAULT NULL;
227: l_customer_num AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT p_customer_num;
228: l_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL;

Line 225: l_contract_num OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT p_contract_num;

221: l_msg_index_out NUMBER :=0;
222: l_error_msg_rec Okl_Accounting_Util.Error_message_Type;
223:
224: l_contract_id OKC_K_HEADERS_V.ID%TYPE DEFAULT NULL;
225: l_contract_num OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT p_contract_num;
226: l_customer_id OKL_TRX_CSH_RECEIPT_V.ILE_ID%TYPE DEFAULT NULL;
227: l_customer_num AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT p_customer_num;
228: l_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL;
229: l_receipt_num OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT p_receipt_num;

Line 376: ,p_contract_num IN OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL

372: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
373: ,x_return_status OUT NOCOPY VARCHAR2
374: ,x_msg_count OUT NOCOPY NUMBER
375: ,x_msg_data OUT NOCOPY VARCHAR2
376: ,p_contract_num IN OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL
377: ,p_customer_num IN AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT NULL
378: ,p_cross_currency_allowed IN VARCHAR2 DEFAULT 'N'
379: )IS
380:

Line 388: l_contract_num OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT p_contract_num;

384: l_init_msg_list VARCHAR2(1);
385: l_msg_count NUMBER;
386: l_msg_data VARCHAR(2000);
387:
388: l_contract_num OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT p_contract_num;
389: l_customer_num AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT p_customer_num;
390: l_cross_currency_allowed VARCHAR2(1) DEFAULT p_cross_currency_allowed;
391:
392:

Line 461: ,p_contract_num IN OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL

457: END REAPPLIC_RCPT_W_CNTRCT;
458:
459: PROCEDURE REAPPLIC_RCPT_W_CNTRCT_CONC ( errbuf OUT NOCOPY VARCHAR2
460: ,retcode OUT NOCOPY NUMBER
461: ,p_contract_num IN OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL
462: ,p_customer_num IN AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT NULL
463: ,p_cross_currency_allowed IN VARCHAR2 DEFAULT 'N'
464: ) IS
465:

Line 475: l_contract_num OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT p_contract_num;

471:
472: l_msg_index_out NUMBER :=0;
473: l_error_msg_rec Okl_Accounting_Util.Error_message_Type;
474:
475: l_contract_num OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT p_contract_num;
476: l_customer_num AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT p_customer_num;
477: l_cross_currency_allowed VARCHAR2(1) DEFAULT p_cross_currency_allowed;
478: l_request_id NUMBER;
479: l_data varchar2(2000);