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_BPD_ADVANCED_CASH_APP_PVT dependencies on OKC_K_HEADERS_V

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

412: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE
413: ,x_return_status OUT NOCOPY VARCHAR2
414: ,x_msg_count OUT NOCOPY NUMBER
415: ,x_msg_data OUT NOCOPY VARCHAR2
416: ,p_contract_num IN OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL
417: ,p_customer_num IN AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT NULL -- HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID indeed
418: ,p_receipt_num IN OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT NULL
419: ,p_cross_currency_allowed IN VARCHAR2 DEFAULT 'N'
420: ) IS

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

430: l_msg_count NUMBER;
431: l_msg_data VARCHAR2(2000);
432: l_api_name CONSTANT VARCHAR2(30) := 'advanced_cash_app';
433:
434: l_contract_id OKC_K_HEADERS_V.ID%TYPE DEFAULT NULL;
435: l_contract_num OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT p_contract_num;
436: l_customer_id OKL_TRX_CSH_RECEIPT_V.ILE_ID%TYPE DEFAULT NULL;
437: -- l_customer_num AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT p_customer_num;
438: --start:| 13-May-2008 cklee --Fixed bug 7036445 |

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

431: l_msg_data VARCHAR2(2000);
432: l_api_name CONSTANT VARCHAR2(30) := 'advanced_cash_app';
433:
434: l_contract_id OKC_K_HEADERS_V.ID%TYPE DEFAULT NULL;
435: l_contract_num OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT p_contract_num;
436: l_customer_id OKL_TRX_CSH_RECEIPT_V.ILE_ID%TYPE DEFAULT NULL;
437: -- l_customer_num AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT p_customer_num;
438: --start:| 13-May-2008 cklee --Fixed bug 7036445 |
439: -- note: p_customer_num = HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID indeed

Line 923: ,p_contract_id IN OKC_K_HEADERS_V.ID%TYPE DEFAULT NULL

919: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE
920: ,x_return_status OUT NOCOPY VARCHAR2
921: ,x_msg_count OUT NOCOPY NUMBER
922: ,x_msg_data OUT NOCOPY VARCHAR2
923: ,p_contract_id IN OKC_K_HEADERS_V.ID%TYPE DEFAULT NULL
924: ,p_contract_num IN OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL
925: ,p_customer_id IN OKL_TRX_CSH_RECEIPT_V.ILE_ID%TYPE DEFAULT NULL
926: ,p_customer_num IN AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT NULL-- note: p_customer_num = HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID indeed
927: ,p_receipt_id IN AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL

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

920: ,x_return_status OUT NOCOPY VARCHAR2
921: ,x_msg_count OUT NOCOPY NUMBER
922: ,x_msg_data OUT NOCOPY VARCHAR2
923: ,p_contract_id IN OKC_K_HEADERS_V.ID%TYPE DEFAULT NULL
924: ,p_contract_num IN OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL
925: ,p_customer_id IN OKL_TRX_CSH_RECEIPT_V.ILE_ID%TYPE DEFAULT NULL
926: ,p_customer_num IN AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT NULL-- note: p_customer_num = HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID indeed
927: ,p_receipt_id IN AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL
928: ,p_receipt_amount IN AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE

Line 953: l_contract_id OKC_K_HEADERS_V.ID%TYPE DEFAULT p_contract_id;

949: l_msg_count NUMBER;
950: l_msg_data VARCHAR2(2000);
951: l_api_name CONSTANT VARCHAR2(30) := 'apply_rcpt_to_contract_no_rule';
952:
953: l_contract_id OKC_K_HEADERS_V.ID%TYPE DEFAULT p_contract_id;
954: l_contract_num OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT p_contract_num;
955: l_customer_id OKL_TRX_CSH_RECEIPT_V.ILE_ID%TYPE DEFAULT p_customer_id;
956: --start:| 13-May-2008 cklee --Fixed bug 7036445 |
957: -- note: p_customer_num = HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID indeed

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

950: l_msg_data VARCHAR2(2000);
951: l_api_name CONSTANT VARCHAR2(30) := 'apply_rcpt_to_contract_no_rule';
952:
953: l_contract_id OKC_K_HEADERS_V.ID%TYPE DEFAULT p_contract_id;
954: l_contract_num OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT p_contract_num;
955: l_customer_id OKL_TRX_CSH_RECEIPT_V.ILE_ID%TYPE DEFAULT p_customer_id;
956: --start:| 13-May-2008 cklee --Fixed bug 7036445 |
957: -- note: p_customer_num = HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID indeed
958: l_customer_num hz_cust_accounts.account_number%TYPE;

Line 1212: ,p_contract_id IN OKC_K_HEADERS_V.ID%TYPE DEFAULT NULL

1208: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE
1209: ,x_return_status OUT NOCOPY VARCHAR2
1210: ,x_msg_count OUT NOCOPY NUMBER
1211: ,x_msg_data OUT NOCOPY VARCHAR2
1212: ,p_contract_id IN OKC_K_HEADERS_V.ID%TYPE DEFAULT NULL
1213: ,p_contract_num IN OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL
1214: ,p_customer_id IN OKL_TRX_CSH_RECEIPT_V.ILE_ID%TYPE DEFAULT NULL
1215: ,p_customer_num IN AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT NULL-- note: p_customer_num = HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID indeed
1216: ,p_receipt_id IN AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL

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

1209: ,x_return_status OUT NOCOPY VARCHAR2
1210: ,x_msg_count OUT NOCOPY NUMBER
1211: ,x_msg_data OUT NOCOPY VARCHAR2
1212: ,p_contract_id IN OKC_K_HEADERS_V.ID%TYPE DEFAULT NULL
1213: ,p_contract_num IN OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL
1214: ,p_customer_id IN OKL_TRX_CSH_RECEIPT_V.ILE_ID%TYPE DEFAULT NULL
1215: ,p_customer_num IN AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT NULL-- note: p_customer_num = HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID indeed
1216: ,p_receipt_id IN AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL
1217: ,p_receipt_amount IN AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE

Line 1241: l_contract_id OKC_K_HEADERS_V.ID%TYPE DEFAULT p_contract_id;

1237: l_msg_count NUMBER;
1238: l_msg_data VARCHAR2(2000);
1239: l_api_name CONSTANT VARCHAR2(30) := 'apply_rcpt_to_contract_w_rule';
1240:
1241: l_contract_id OKC_K_HEADERS_V.ID%TYPE DEFAULT p_contract_id;
1242: l_contract_num OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT p_contract_num;
1243: l_customer_id OKL_TRX_CSH_RECEIPT_V.ILE_ID%TYPE DEFAULT p_customer_id;
1244: --start:| 13-May-2008 cklee --Fixed bug 7036445 |
1245: -- note: p_customer_num = HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID indeed

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

1238: l_msg_data VARCHAR2(2000);
1239: l_api_name CONSTANT VARCHAR2(30) := 'apply_rcpt_to_contract_w_rule';
1240:
1241: l_contract_id OKC_K_HEADERS_V.ID%TYPE DEFAULT p_contract_id;
1242: l_contract_num OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT p_contract_num;
1243: l_customer_id OKL_TRX_CSH_RECEIPT_V.ILE_ID%TYPE DEFAULT p_customer_id;
1244: --start:| 13-May-2008 cklee --Fixed bug 7036445 |
1245: -- note: p_customer_num = HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID indeed
1246: l_customer_num hz_cust_accounts.account_number%TYPE;

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

1799: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE
1800: ,x_return_status OUT NOCOPY VARCHAR2
1801: ,x_msg_count OUT NOCOPY NUMBER
1802: ,x_msg_data OUT NOCOPY VARCHAR2
1803: ,p_contract_num IN OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL
1804: ,p_customer_num IN AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT NULL-- note: p_customer_num = HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID indeed
1805: ,p_receipt_id IN AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL
1806: ,p_receipt_num IN OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT NULL
1807: ,p_receipt_date_from IN OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT NULL

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

1821: l_msg_count NUMBER;
1822: l_msg_data VARCHAR2(2000);
1823: l_api_name CONSTANT VARCHAR2(30) := 'reapplic_advanced_cash_app';
1824:
1825: l_contract_id OKC_K_HEADERS_V.ID%TYPE DEFAULT NULL;
1826: l_contract_num OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT p_contract_num;
1827: l_customer_id OKL_TRX_CSH_RECEIPT_V.ILE_ID%TYPE DEFAULT NULL;
1828: -- l_customer_num AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT NULL;
1829: --start:| 13-May-2008 cklee --Fixed bug 7036445 |

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

1822: l_msg_data VARCHAR2(2000);
1823: l_api_name CONSTANT VARCHAR2(30) := 'reapplic_advanced_cash_app';
1824:
1825: l_contract_id OKC_K_HEADERS_V.ID%TYPE DEFAULT NULL;
1826: l_contract_num OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT p_contract_num;
1827: l_customer_id OKL_TRX_CSH_RECEIPT_V.ILE_ID%TYPE DEFAULT NULL;
1828: -- l_customer_num AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT NULL;
1829: --start:| 13-May-2008 cklee --Fixed bug 7036445 |
1830: l_customer_num hz_cust_accounts.account_number%TYPE;

Line 1848: l_temp_contract_id OKC_K_HEADERS_V.ID%TYPE DEFAULT NULL;

1844:
1845: l_dflt_days_to_hold_adv_pay OKL_CASH_ALLCTN_RLS.NUM_DAYS_HOLD_ADV_PAY%TYPE;
1846: l_days_to_hold_adv_pay OKL_CASH_ALLCTN_RLS.NUM_DAYS_HOLD_ADV_PAY%TYPE;
1847:
1848: l_temp_contract_id OKC_K_HEADERS_V.ID%TYPE DEFAULT NULL;
1849: l_temp_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL;
1850: l_temp_rcpt_date AR_CASH_RECEIPTS_ALL.RECEIPT_DATE%TYPE DEFAULT NULL;
1851:
1852: l_remittance_amount AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE;

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

2721:
2722: l_dflt_days_to_hold_adv_pay OKL_CASH_ALLCTN_RLS.NUM_DAYS_HOLD_ADV_PAY%TYPE;
2723: l_days_to_hold_adv_pay OKL_CASH_ALLCTN_RLS.NUM_DAYS_HOLD_ADV_PAY%TYPE;
2724:
2725: l_contract_id OKC_K_HEADERS_V.ID%TYPE DEFAULT NULL;
2726: l_contract_num OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT p_contract_num;
2727: l_customer_num HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER%TYPE DEFAULT NULL;
2728: l_customer_acct_id NUMBER DEFAULT p_customer_num;
2729: l_cross_currency_allowed VARCHAR2(1) DEFAULT p_cross_currency_allowed;

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

2722: l_dflt_days_to_hold_adv_pay OKL_CASH_ALLCTN_RLS.NUM_DAYS_HOLD_ADV_PAY%TYPE;
2723: l_days_to_hold_adv_pay OKL_CASH_ALLCTN_RLS.NUM_DAYS_HOLD_ADV_PAY%TYPE;
2724:
2725: l_contract_id OKC_K_HEADERS_V.ID%TYPE DEFAULT NULL;
2726: l_contract_num OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT p_contract_num;
2727: l_customer_num HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER%TYPE DEFAULT NULL;
2728: l_customer_acct_id NUMBER DEFAULT p_customer_num;
2729: l_cross_currency_allowed VARCHAR2(1) DEFAULT p_cross_currency_allowed;
2730:

Line 2731: l_temp_contract_id OKC_K_HEADERS_V.ID%TYPE DEFAULT NULL;

2727: l_customer_num HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER%TYPE DEFAULT NULL;
2728: l_customer_acct_id NUMBER DEFAULT p_customer_num;
2729: l_cross_currency_allowed VARCHAR2(1) DEFAULT p_cross_currency_allowed;
2730:
2731: l_temp_contract_id OKC_K_HEADERS_V.ID%TYPE DEFAULT NULL;
2732: l_temp_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL;
2733: l_temp_rcpt_date AR_CASH_RECEIPTS_ALL.RECEIPT_DATE%TYPE DEFAULT NULL;
2734:
2735: l_xcr_id NUMBER;