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 HZ_CUST_ACCOUNTS

Line 417: ,p_customer_num IN AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT NULL -- HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID indeed

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
421:

Line 439: -- note: p_customer_num = HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID indeed

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
440: l_customer_num hz_cust_accounts.account_number%TYPE;
441: --end:| 13-May-2008 cklee --Fixed bug 7036445 |
442: l_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL;
443: l_receipt_num OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT p_receipt_num;

Line 440: l_customer_num hz_cust_accounts.account_number%TYPE;

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
440: l_customer_num hz_cust_accounts.account_number%TYPE;
441: --end:| 13-May-2008 cklee --Fixed bug 7036445 |
442: l_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL;
443: l_receipt_num OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT p_receipt_num;
444: l_receipt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL;

Line 521: from HZ_CUST_ACCOUNTS ca

517:
518: --start:| 13-May-2008 cklee --Fixed bug 7036445 |
519: cursor c_customer_acc_num (cp_account_id number) is
520: select ca.account_number
521: from HZ_CUST_ACCOUNTS ca
522: where ca.cust_account_id = cp_account_id;
523: --end:| 13-May-2008 cklee --Fixed bug 7036445 |
524:
525: -- get all advanced receipts for newly booked contract

Line 747: ,p_customer_num => p_customer_num-- note: p_customer_num = HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID indeed

743: ,p_contract_num => l_contract_num
744: ,p_customer_id => l_customer_id
745: --start:| 13-May-2008 cklee --Fixed bug 7036445 |
746: -- ,p_customer_num => l_customer_num
747: ,p_customer_num => p_customer_num-- note: p_customer_num = HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID indeed
748: --end:| 13-May-2008 cklee --Fixed bug 7036445 |
749: ,p_receipt_id => l_cash_receipt_id
750: ,p_receipt_amount => l_remittance_amount
751: ,p_remain_rcpt_amount => l_remain_rcpt_amount

Line 779: ,p_customer_num => p_customer_num-- note: p_customer_num = HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID indeed

775: ,p_contract_num => l_contract_num
776: ,p_customer_id => l_customer_id
777: --start:| 13-May-2008 cklee --Fixed bug 7036445 |
778: -- ,p_customer_num => l_customer_num
779: ,p_customer_num => p_customer_num-- note: p_customer_num = HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID indeed
780: --end:| 13-May-2008 cklee --Fixed bug 7036445 |
781: ,p_receipt_id => l_cash_receipt_id
782: ,p_receipt_amount => l_remittance_amount
783: ,p_remain_rcpt_amount => l_remain_rcpt_amount

Line 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

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
929: ,p_remain_rcpt_amount OUT NOCOPY AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE
930: ,p_receipt_currency IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL

Line 957: -- note: p_customer_num = HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID indeed

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;
959: --end:| 13-May-2008 cklee --Fixed bug 7036445 |
960: l_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT p_receipt_id;
961: l_receipt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT p_receipt_amount;

Line 958: l_customer_num hz_cust_accounts.account_number%TYPE;

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;
959: --end:| 13-May-2008 cklee --Fixed bug 7036445 |
960: l_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT p_receipt_id;
961: l_receipt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT p_receipt_amount;
962: l_receipt_date AR_CASH_RECEIPTS_ALL.RECEIPT_DATE%TYPE DEFAULT p_receipt_date;

Line 1015: from HZ_CUST_ACCOUNTS ca

1011: -------------------------------------------------------------------------------
1012: --start:| 13-May-2008 cklee --Fixed bug 7036445 |
1013: cursor c_customer_acc_num (cp_account_id number) is
1014: select ca.account_number
1015: from HZ_CUST_ACCOUNTS ca
1016: where ca.cust_account_id = cp_account_id;
1017: --end:| 13-May-2008 cklee --Fixed bug 7036445 |
1018:
1019:

Line 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

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
1218: ,p_remain_rcpt_amount OUT NOCOPY AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE
1219: ,p_receipt_currency IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL

Line 1245: -- note: p_customer_num = HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID indeed

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;
1247: --end:| 13-May-2008 cklee --Fixed bug 7036445 |
1248: l_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT p_receipt_id;
1249: l_receipt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT p_receipt_amount;

Line 1246: l_customer_num hz_cust_accounts.account_number%TYPE;

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;
1247: --end:| 13-May-2008 cklee --Fixed bug 7036445 |
1248: l_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT p_receipt_id;
1249: l_receipt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT p_receipt_amount;
1250: l_receipt_date AR_CASH_RECEIPTS_ALL.RECEIPT_DATE%TYPE DEFAULT p_receipt_date;

Line 1350: from HZ_CUST_ACCOUNTS ca

1346: -------------------------------------------------------------------------------
1347: --start:| 13-May-2008 cklee --Fixed bug 7036445 |
1348: cursor c_customer_acc_num (cp_account_id number) is
1349: select ca.account_number
1350: from HZ_CUST_ACCOUNTS ca
1351: where ca.cust_account_id = cp_account_id;
1352: --end:| 13-May-2008 cklee --Fixed bug 7036445 |
1353:
1354:

Line 1382: FROM hz_cust_accounts_all hca,

1378: c_open_invs_rec c_open_invs%ROWTYPE;
1379:
1380: CURSOR c_get_cust_acct_num(cp_cash_receipt_id IN NUMBER) IS
1381: SELECT hca.account_number
1382: FROM hz_cust_accounts_all hca,
1383: ar_cash_receipts_all arcash
1384: WHERE hca.cust_account_id = arcash.pay_from_customer
1385: AND arcash.cash_receipt_id = cp_cash_receipt_id;
1386:

Line 1683: FETCH c_get_cust_acct_num INTO l_customer_num; -- now this is a real customer number: HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER%TYPE

1679:
1680: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'USING CASH APPLICATIONM RULE');
1681: IF l_customer_num IS NULL THEN
1682: OPEN c_get_cust_acct_num(l_receipt_id);
1683: FETCH c_get_cust_acct_num INTO l_customer_num; -- now this is a real customer number: HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER%TYPE
1684: CLOSE c_get_cust_acct_num;
1685: END IF;
1686: log_file('calling auto_cashapp_for_contract ');
1687: log_file('l_receipt_amount = '||l_receipt_amount);

Line 1693: p_customer_num => l_customer_num, -- HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER%TYPE

1689: p_init_msg_list => l_init_msg_list,
1690: x_return_status => l_return_status,
1691: x_msg_count => l_msg_count,
1692: x_msg_data => l_msg_data,
1693: p_customer_num => l_customer_num, -- HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER%TYPE
1694: p_contract_num => l_contract_num,
1695: p_currency_code => l_receipt_currency_code,
1696: p_amount_app_to => l_receipt_amount,
1697: p_receipt_date => l_receipt_date,

Line 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

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
1808: ,p_receipt_date_to IN OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT NULL

Line 1830: l_customer_num hz_cust_accounts.account_number%TYPE;

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;
1831: --end:| 13-May-2008 cklee --Fixed bug 7036445 |
1832:
1833: l_customer_acct_id NUMBER DEFAULT p_customer_num;
1834: l_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT p_receipt_id;

Line 1979: hz_cust_accounts_all hca

1975: b.cash_receipt_id icr_id,
1976: b.pay_from_customer customer_number
1977: FROM OKL_TRX_CSH_RECEIPT_V a,
1978: AR_CASH_RECEIPTS_ALL b,
1979: hz_cust_accounts_all hca
1980: WHERE a.cash_receipt_id = b.cash_receipt_id
1981: AND hca.account_number = cp_customer_num
1982: AND b.pay_from_customer = hca.cust_account_id
1983: AND a.fully_applied_flag = 'N';

Line 1990: -- replaced the reference ra_customers to hz_cust_accounts for bug#4891734

1986:
1987: -------------------------------------------------------------------------------
1988:
1989: -- get customer id from customer number
1990: -- replaced the reference ra_customers to hz_cust_accounts for bug#4891734
1991: CURSOR c_get_cust_id(cp_customer_num IN VARCHAR2) IS
1992: SELECT cust_account_id
1993: FROM hz_cust_accounts
1994: WHERE account_number = cp_customer_num;

Line 1993: FROM hz_cust_accounts

1989: -- get customer id from customer number
1990: -- replaced the reference ra_customers to hz_cust_accounts for bug#4891734
1991: CURSOR c_get_cust_id(cp_customer_num IN VARCHAR2) IS
1992: SELECT cust_account_id
1993: FROM hz_cust_accounts
1994: WHERE account_number = cp_customer_num;
1995:
1996: -------------------------------------------------------------------------------
1997:

Line 2059: hz_cust_Accounts_all hca

2055: CURSOR c_get_rcpt_id ( cp_receipt_number in VARCHAR2
2056: ,cp_customer_num in VARCHAR2) IS
2057: SELECT a.cash_receipt_id icr_id
2058: FROM AR_CASH_RECEIPTS a,
2059: hz_cust_Accounts_all hca
2060: WHERE a.receipt_number = l_receipt_num
2061: AND a.pay_from_customer = hca.cust_account_id
2062: AND hca.account_number = cp_customer_num;
2063:

Line 2097: from hz_cust_accounts

2093: AND TRUNC(end_date) IS NULL;
2094:
2095: CURSOR c_get_cust_Acct_num(cp_acct_id in number) IS
2096: SELECT account_number
2097: from hz_cust_accounts
2098: where cust_Account_id = cp_acct_id;
2099: -------------------------------------------------------------------------------
2100:
2101: BEGIN

Line 2136: FETCH c_get_cust_Acct_num INTO l_customer_num; -- HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER%TYPE

2132: CLOSE c_dflt_cash_applic_rule;
2133:
2134: IF l_customer_acct_id IS NOT NULL THEN
2135: OPEN c_get_cust_Acct_num(l_customer_acct_id);
2136: FETCH c_get_cust_Acct_num INTO l_customer_num; -- HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER%TYPE
2137: CLOSE c_get_cust_Acct_num;
2138: END IF;
2139: log_file('l_customer_num = '||l_customer_num);
2140: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '=================================================================================');

Line 2345: ,p_customer_num => p_customer_num -- cklee 7036445-- note: p_customer_num = HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID indeed

2341: ,p_contract_id => l_contract_id
2342: ,p_contract_num => l_contract_num
2343: ,p_customer_id => l_customer_id
2344: -- ,p_customer_num => l_customer_num
2345: ,p_customer_num => p_customer_num -- cklee 7036445-- note: p_customer_num = HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID indeed
2346: ,p_receipt_id => l_receipt_id
2347: ,p_receipt_amount => l_remittance_amount
2348: ,p_remain_rcpt_amount => l_remain_rcpt_amount
2349: ,p_receipt_currency => l_receipt_currency

Line 2369: ,p_customer_num => p_customer_num -- cklee 7036445-- note: p_customer_num = HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID indeed

2365: ,p_contract_id => l_contract_id
2366: ,p_contract_num => l_contract_num
2367: ,p_customer_id => l_customer_id
2368: -- ,p_customer_num => l_customer_num
2369: ,p_customer_num => p_customer_num -- cklee 7036445-- note: p_customer_num = HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID indeed
2370: ,p_receipt_id => l_receipt_id
2371: ,p_receipt_amount => l_remittance_amount
2372: ,p_remain_rcpt_amount => l_remain_rcpt_amount
2373: ,p_receipt_currency => l_receipt_currency

Line 2421: ,p_customer_num => p_customer_num -- cklee 7036445-- note: p_customer_num = HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID indeed

2417: ,x_msg_count => l_msg_count
2418: ,x_msg_data => l_msg_data
2419: ,p_contract_num => l_contract_num
2420: -- ,p_customer_num => l_customer_num
2421: ,p_customer_num => p_customer_num -- cklee 7036445-- note: p_customer_num = HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID indeed
2422: ,p_receipt_num => null
2423: ,p_cross_currency_allowed => l_cross_currency_allowed
2424: );
2425: log_file('l_return_status = '||l_return_status);

Line 2462: ,p_customer_num => p_customer_num -- cklee 7036445-- note: p_customer_num = HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID indeed

2458: ,x_msg_count => l_msg_count
2459: ,x_msg_data => l_msg_data
2460: ,p_contract_num => l_contract_num
2461: -- ,p_customer_num => l_customer_num
2462: ,p_customer_num => p_customer_num -- cklee 7036445-- note: p_customer_num = HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID indeed
2463: ,p_receipt_num => l_receipt_num
2464: ,p_cross_currency_allowed => l_cross_currency_allowed
2465: );
2466:

Line 2489: FETCH c_get_cust_id INTO l_customer_id;-- note: HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID

2485:
2486: -- get contract details first, then loop through receipts report all events on form
2487:
2488: OPEN c_get_cust_id(l_customer_num);
2489: FETCH c_get_cust_id INTO l_customer_id;-- note: HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID
2490: CLOSE c_get_cust_id;
2491: log_file('l_customer_id = '||l_customer_id);-- note: HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID
2492: FOR c_get_cont_for_cust_rec IN c_get_cont_for_cust (l_customer_num, l_contract_num)
2493: LOOP

Line 2491: log_file('l_customer_id = '||l_customer_id);-- note: HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID

2487:
2488: OPEN c_get_cust_id(l_customer_num);
2489: FETCH c_get_cust_id INTO l_customer_id;-- note: HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID
2490: CLOSE c_get_cust_id;
2491: log_file('l_customer_id = '||l_customer_id);-- note: HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID
2492: FOR c_get_cont_for_cust_rec IN c_get_cont_for_cust (l_customer_num, l_contract_num)
2493: LOOP
2494:
2495: l_contract_num := c_get_cont_for_cust_rec.contract_number;

Line 2727: l_customer_num HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER%TYPE DEFAULT NULL;

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:
2731: l_temp_contract_id OKC_K_HEADERS_V.ID%TYPE DEFAULT NULL;

Line 2873: from hz_cust_accounts

2869: AND TRUNC(end_date) IS NULL;
2870:
2871: CURSOR c_get_cust_Acct_num(cp_acct_id in number) IS
2872: SELECT account_number
2873: from hz_cust_accounts
2874: where cust_Account_id = cp_acct_id;
2875:
2876: -------------------------------------------------------------------------------
2877: