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 OKL_TRX_CSH_RECEIPT_V

Line 418: ,p_receipt_num IN OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT NULL

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

Line 436: l_customer_id OKL_TRX_CSH_RECEIPT_V.ILE_ID%TYPE DEFAULT NULL;

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
440: l_customer_num hz_cust_accounts.account_number%TYPE;

Line 443: l_receipt_num OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT p_receipt_num;

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;
445: l_cross_currency_allowed VARCHAR2(1) DEFAULT p_cross_currency_allowed;
446:
447: l_cash_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL;

Line 444: l_receipt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL;

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;
445: l_cross_currency_allowed VARCHAR2(1) DEFAULT p_cross_currency_allowed;
446:
447: l_cash_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL;
448:

Line 451: l_check_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE;

447: l_cash_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL;
448:
449: l_remittance_amount AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE;
450: l_remain_rcpt_amount AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE;
451: l_check_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE;
452: l_actual_remittance_amount AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE;
453: l_receipt_currency OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE;
454: l_receipt_date OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE;
455: l_receipt_count NUMBER;

Line 453: l_receipt_currency OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE;

449: l_remittance_amount AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE;
450: l_remain_rcpt_amount AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE;
451: l_check_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE;
452: l_actual_remittance_amount AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE;
453: l_receipt_currency OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE;
454: l_receipt_date OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE;
455: l_receipt_count NUMBER;
456:
457: l_invoice_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL;

Line 454: l_receipt_date OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE;

450: l_remain_rcpt_amount AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE;
451: l_check_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE;
452: l_actual_remittance_amount AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE;
453: l_receipt_currency OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE;
454: l_receipt_date OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE;
455: l_receipt_count NUMBER;
456:
457: l_invoice_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL;
458: l_inv_tot NUMBER := 0;

Line 457: l_invoice_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL;

453: l_receipt_currency OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE;
454: l_receipt_date OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE;
455: l_receipt_count NUMBER;
456:
457: l_invoice_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL;
458: l_inv_tot NUMBER := 0;
459:
460: --
461: l_currency_conv_type OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE;

Line 461: l_currency_conv_type OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE;

457: l_invoice_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL;
458: l_inv_tot NUMBER := 0;
459:
460: --
461: l_currency_conv_type OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE;
462: l_currency_conv_date OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE;
463: l_currency_conv_rate OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE;
464: --
465:

Line 462: l_currency_conv_date OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE;

458: l_inv_tot NUMBER := 0;
459:
460: --
461: l_currency_conv_type OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE;
462: l_currency_conv_date OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE;
463: l_currency_conv_rate OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE;
464: --
465:
466:

Line 463: l_currency_conv_rate OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE;

459:
460: --
461: l_currency_conv_type OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE;
462: l_currency_conv_date OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE;
463: l_currency_conv_rate OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE;
464: --
465:
466:
467: l_rct_id NUMBER;

Line 472: l_stat_total_rcpt_amt OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT 0;

468: l_rca_id OKL_TXL_RCPT_APPS_V.ID%TYPE;
469: l_cat_id OKL_CASH_ALLCTN_RLS.ID%TYPE DEFAULT NULL;
470: i NUMBER DEFAULT NULL;
471:
472: l_stat_total_rcpt_amt OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT 0;
473: l_stat_num_of_rcpts NUMBER DEFAULT 0;
474: l_stat_num_of_cont NUMBER DEFAULT 0;
475:
476: l_org_id OKL_TRX_CSH_RECEIPT_V.ORG_ID%TYPE DEFAULT MO_GLOBAL.GET_CURRENT_ORG_ID();

Line 476: l_org_id OKL_TRX_CSH_RECEIPT_V.ORG_ID%TYPE DEFAULT MO_GLOBAL.GET_CURRENT_ORG_ID();

472: l_stat_total_rcpt_amt OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT 0;
473: l_stat_num_of_rcpts NUMBER DEFAULT 0;
474: l_stat_num_of_cont NUMBER DEFAULT 0;
475:
476: l_org_id OKL_TRX_CSH_RECEIPT_V.ORG_ID%TYPE DEFAULT MO_GLOBAL.GET_CURRENT_ORG_ID();
477:
478: l_exit_loop NUMBER DEFAULT 0;
479: l_exchange_rate_type VARCHAR2(100);
480: l_conversion_rate NUMBER;

Line 538: FROM OKL_TRX_CSH_RECEIPT_V a,

534: -- arcash.exchange_rate_type,
535: -- arcash.exchange_rate ,
536: a.id,
537: arcash.receipt_Date
538: FROM OKL_TRX_CSH_RECEIPT_V a,
539: OKL_TXL_RCPT_APPS_V b,
540: ar_cash_receipts_All arcash
541: WHERE a.id = b.rct_id_details
542: AND a.FULLY_APPLIED_FLAG = 'N'

Line 925: ,p_customer_id IN OKL_TRX_CSH_RECEIPT_V.ILE_ID%TYPE DEFAULT NULL

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
929: ,p_remain_rcpt_amount OUT NOCOPY AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE

Line 931: ,p_receipt_date IN OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT NULL

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
931: ,p_receipt_date IN OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT NULL
932: ,p_invoice_currency IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
933: ,p_currency_conv_date IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE DEFAULT NULL
934: ,p_currency_conv_rate IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE DEFAULT NULL
935: ,p_currency_conv_type IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE DEFAULT NULL

Line 933: ,p_currency_conv_date IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE DEFAULT NULL

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
931: ,p_receipt_date IN OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT NULL
932: ,p_invoice_currency IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
933: ,p_currency_conv_date IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE DEFAULT NULL
934: ,p_currency_conv_rate IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE DEFAULT NULL
935: ,p_currency_conv_type IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE DEFAULT NULL
936: ,p_xcr_id IN NUMBER DEFAULT NULL
937: ,p_cross_currency_allowed IN VARCHAR2 DEFAULT 'N'

Line 934: ,p_currency_conv_rate IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE DEFAULT NULL

930: ,p_receipt_currency IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
931: ,p_receipt_date IN OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT NULL
932: ,p_invoice_currency IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
933: ,p_currency_conv_date IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE DEFAULT NULL
934: ,p_currency_conv_rate IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE DEFAULT NULL
935: ,p_currency_conv_type IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE DEFAULT NULL
936: ,p_xcr_id IN NUMBER DEFAULT NULL
937: ,p_cross_currency_allowed IN VARCHAR2 DEFAULT 'N'
938: ) IS

Line 935: ,p_currency_conv_type IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE DEFAULT NULL

931: ,p_receipt_date IN OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT NULL
932: ,p_invoice_currency IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
933: ,p_currency_conv_date IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE DEFAULT NULL
934: ,p_currency_conv_rate IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE DEFAULT NULL
935: ,p_currency_conv_type IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE DEFAULT NULL
936: ,p_xcr_id IN NUMBER DEFAULT NULL
937: ,p_cross_currency_allowed IN VARCHAR2 DEFAULT 'N'
938: ) IS
939:

Line 955: l_customer_id OKL_TRX_CSH_RECEIPT_V.ILE_ID%TYPE DEFAULT p_customer_id;

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;
959: --end:| 13-May-2008 cklee --Fixed bug 7036445 |

Line 961: l_receipt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT p_receipt_amount;

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;
963: l_cross_currency_allowed VARCHAR2(1) DEFAULT p_cross_currency_allowed;
964: l_converted_receipt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL;
965:

Line 964: l_converted_receipt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL;

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;
963: l_cross_currency_allowed VARCHAR2(1) DEFAULT p_cross_currency_allowed;
964: l_converted_receipt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL;
965:
966:
967: l_customer_trx_id AR_PAYMENT_SCHEDULES_ALL.CUSTOMER_TRX_ID%TYPE DEFAULT NULL;
968:

Line 970: l_check_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE;

966:
967: l_customer_trx_id AR_PAYMENT_SCHEDULES_ALL.CUSTOMER_TRX_ID%TYPE DEFAULT NULL;
968:
969: l_cash_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT p_receipt_id;
970: l_check_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE;
971: l_receipt_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT p_receipt_currency;
972: l_receipt_count NUMBER;
973:
974: l_invoice_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT p_invoice_currency;

Line 971: l_receipt_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT p_receipt_currency;

967: l_customer_trx_id AR_PAYMENT_SCHEDULES_ALL.CUSTOMER_TRX_ID%TYPE DEFAULT NULL;
968:
969: l_cash_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT p_receipt_id;
970: l_check_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE;
971: l_receipt_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT p_receipt_currency;
972: l_receipt_count NUMBER;
973:
974: l_invoice_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT p_invoice_currency;
975:

Line 974: l_invoice_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT p_invoice_currency;

970: l_check_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE;
971: l_receipt_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT p_receipt_currency;
972: l_receipt_count NUMBER;
973:
974: l_invoice_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT p_invoice_currency;
975:
976: l_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL; -- entered currency code
977:
978: l_applied_amount AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED%TYPE DEFAULT NULL;

Line 976: l_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL; -- entered currency code

972: l_receipt_count NUMBER;
973:
974: l_invoice_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT p_invoice_currency;
975:
976: l_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL; -- entered currency code
977:
978: l_applied_amount AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED%TYPE DEFAULT NULL;
979: l_applied_amount_from AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED_FROM%TYPE DEFAULT NULL;
980:

Line 982: l_currency_conv_type OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE DEFAULT p_currency_conv_type;

978: l_applied_amount AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED%TYPE DEFAULT NULL;
979: l_applied_amount_from AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED_FROM%TYPE DEFAULT NULL;
980:
981: --
982: l_currency_conv_type OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE DEFAULT p_currency_conv_type;
983: l_currency_conv_date OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE DEFAULT p_currency_conv_date;
984: l_currency_conv_rate OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE DEFAULT p_currency_conv_rate;
985: --
986:

Line 983: l_currency_conv_date OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE DEFAULT p_currency_conv_date;

979: l_applied_amount_from AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED_FROM%TYPE DEFAULT NULL;
980:
981: --
982: l_currency_conv_type OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE DEFAULT p_currency_conv_type;
983: l_currency_conv_date OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE DEFAULT p_currency_conv_date;
984: l_currency_conv_rate OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE DEFAULT p_currency_conv_rate;
985: --
986:
987:

Line 984: l_currency_conv_rate OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE DEFAULT p_currency_conv_rate;

980:
981: --
982: l_currency_conv_type OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE DEFAULT p_currency_conv_type;
983: l_currency_conv_date OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE DEFAULT p_currency_conv_date;
984: l_currency_conv_rate OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE DEFAULT p_currency_conv_rate;
985: --
986:
987:
988: l_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;

Line 988: l_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;

984: l_currency_conv_rate OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE DEFAULT p_currency_conv_rate;
985: --
986:
987:
988: l_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;
989: l_apply_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;
990:
991: l_xcr_id NUMBER DEFAULT p_xcr_id;
992: l_rca_id OKL_TXL_RCPT_APPS_V.ID%TYPE;

Line 989: l_apply_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;

985: --
986:
987:
988: l_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;
989: l_apply_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;
990:
991: l_xcr_id NUMBER DEFAULT p_xcr_id;
992: l_rca_id OKL_TXL_RCPT_APPS_V.ID%TYPE;
993: l_cat_id OKL_CASH_ALLCTN_RLS.ID%TYPE DEFAULT NULL;

Line 1000: l_org_id OKL_TRX_CSH_RECEIPT_V.ORG_ID%TYPE DEFAULT MO_GLOBAL.GET_CURRENT_ORG_ID();

996: l_counter NUMBER;
997: l_unapply VARCHAR2(3);
998:
999: l_record_count NUMBER DEFAULT NULL;
1000: l_org_id OKL_TRX_CSH_RECEIPT_V.ORG_ID%TYPE DEFAULT MO_GLOBAL.GET_CURRENT_ORG_ID();
1001:
1002: l_cau_id OKL_CSH_ALLCTN_RL_HDR.ID%TYPE DEFAULT NULL;
1003:
1004: l_appl_tbl okl_receipts_pvt.appl_tbl_type;

Line 1214: ,p_customer_id IN OKL_TRX_CSH_RECEIPT_V.ILE_ID%TYPE DEFAULT NULL

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
1218: ,p_remain_rcpt_amount OUT NOCOPY AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE

Line 1220: ,p_receipt_date IN OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT NULL

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
1220: ,p_receipt_date IN OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT NULL
1221: ,p_invoice_currency IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
1222: ,p_invoice_total IN OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL
1223: ,p_currency_conv_date IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE DEFAULT NULL
1224: ,p_currency_conv_rate IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE DEFAULT NULL

Line 1222: ,p_invoice_total IN OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL

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
1220: ,p_receipt_date IN OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT NULL
1221: ,p_invoice_currency IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
1222: ,p_invoice_total IN OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL
1223: ,p_currency_conv_date IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE DEFAULT NULL
1224: ,p_currency_conv_rate IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE DEFAULT NULL
1225: ,p_currency_conv_type IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE DEFAULT NULL
1226: ,p_xcr_id IN NUMBER DEFAULT NULL

Line 1223: ,p_currency_conv_date IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE DEFAULT NULL

1219: ,p_receipt_currency IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
1220: ,p_receipt_date IN OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT NULL
1221: ,p_invoice_currency IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
1222: ,p_invoice_total IN OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL
1223: ,p_currency_conv_date IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE DEFAULT NULL
1224: ,p_currency_conv_rate IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE DEFAULT NULL
1225: ,p_currency_conv_type IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE DEFAULT NULL
1226: ,p_xcr_id IN NUMBER DEFAULT NULL
1227: ,p_cross_currency_allowed IN VARCHAR2 DEFAULT 'N'

Line 1224: ,p_currency_conv_rate IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE DEFAULT NULL

1220: ,p_receipt_date IN OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT NULL
1221: ,p_invoice_currency IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
1222: ,p_invoice_total IN OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL
1223: ,p_currency_conv_date IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE DEFAULT NULL
1224: ,p_currency_conv_rate IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE DEFAULT NULL
1225: ,p_currency_conv_type IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE DEFAULT NULL
1226: ,p_xcr_id IN NUMBER DEFAULT NULL
1227: ,p_cross_currency_allowed IN VARCHAR2 DEFAULT 'N'
1228: ) IS

Line 1225: ,p_currency_conv_type IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE DEFAULT NULL

1221: ,p_invoice_currency IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
1222: ,p_invoice_total IN OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL
1223: ,p_currency_conv_date IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE DEFAULT NULL
1224: ,p_currency_conv_rate IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE DEFAULT NULL
1225: ,p_currency_conv_type IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE DEFAULT NULL
1226: ,p_xcr_id IN NUMBER DEFAULT NULL
1227: ,p_cross_currency_allowed IN VARCHAR2 DEFAULT 'N'
1228: ) IS
1229:

Line 1243: l_customer_id OKL_TRX_CSH_RECEIPT_V.ILE_ID%TYPE DEFAULT p_customer_id;

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;
1247: --end:| 13-May-2008 cklee --Fixed bug 7036445 |

Line 1249: l_receipt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT p_receipt_amount;

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;
1251: l_cross_currency_allowed VARCHAR2(1) DEFAULT p_cross_currency_allowed;
1252:
1253: l_converted_receipt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL;

Line 1253: l_converted_receipt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL;

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;
1251: l_cross_currency_allowed VARCHAR2(1) DEFAULT p_cross_currency_allowed;
1252:
1253: l_converted_receipt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL;
1254:
1255: l_customer_trx_id AR_PAYMENT_SCHEDULES_ALL.CUSTOMER_TRX_ID%TYPE DEFAULT NULL;
1256:
1257: l_cash_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT p_receipt_id;

Line 1258: l_check_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE;

1254:
1255: l_customer_trx_id AR_PAYMENT_SCHEDULES_ALL.CUSTOMER_TRX_ID%TYPE DEFAULT NULL;
1256:
1257: l_cash_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT p_receipt_id;
1258: l_check_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE;
1259: l_expired_flag OKL_TRX_CSH_RECEIPT_V.FULLY_APPLIED_FLAG%TYPE;
1260: l_receipt_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT p_receipt_currency;
1261:
1262: l_receipt_remaining OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL;

Line 1259: l_expired_flag OKL_TRX_CSH_RECEIPT_V.FULLY_APPLIED_FLAG%TYPE;

1255: l_customer_trx_id AR_PAYMENT_SCHEDULES_ALL.CUSTOMER_TRX_ID%TYPE DEFAULT NULL;
1256:
1257: l_cash_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT p_receipt_id;
1258: l_check_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE;
1259: l_expired_flag OKL_TRX_CSH_RECEIPT_V.FULLY_APPLIED_FLAG%TYPE;
1260: l_receipt_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT p_receipt_currency;
1261:
1262: l_receipt_remaining OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL;
1263: l_amt_due_remaining_tot OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL;

Line 1260: l_receipt_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT p_receipt_currency;

1256:
1257: l_cash_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT p_receipt_id;
1258: l_check_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE;
1259: l_expired_flag OKL_TRX_CSH_RECEIPT_V.FULLY_APPLIED_FLAG%TYPE;
1260: l_receipt_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT p_receipt_currency;
1261:
1262: l_receipt_remaining OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL;
1263: l_amt_due_remaining_tot OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL;
1264:

Line 1262: l_receipt_remaining OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL;

1258: l_check_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE;
1259: l_expired_flag OKL_TRX_CSH_RECEIPT_V.FULLY_APPLIED_FLAG%TYPE;
1260: l_receipt_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT p_receipt_currency;
1261:
1262: l_receipt_remaining OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL;
1263: l_amt_due_remaining_tot OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL;
1264:
1265: l_inv_tot OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT p_invoice_total;
1266: l_temp_val NUMBER := 0;

Line 1263: l_amt_due_remaining_tot OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL;

1259: l_expired_flag OKL_TRX_CSH_RECEIPT_V.FULLY_APPLIED_FLAG%TYPE;
1260: l_receipt_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT p_receipt_currency;
1261:
1262: l_receipt_remaining OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL;
1263: l_amt_due_remaining_tot OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL;
1264:
1265: l_inv_tot OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT p_invoice_total;
1266: l_temp_val NUMBER := 0;
1267: l_receipt_count NUMBER;

Line 1265: l_inv_tot OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT p_invoice_total;

1261:
1262: l_receipt_remaining OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL;
1263: l_amt_due_remaining_tot OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL;
1264:
1265: l_inv_tot OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT p_invoice_total;
1266: l_temp_val NUMBER := 0;
1267: l_receipt_count NUMBER;
1268:
1269: l_appl_tolerance NUMBER := 0;

Line 1280: l_invoice_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT p_invoice_currency;

1276: l_sty_id OKL_CNSLD_AR_STRMS_V.STY_ID%TYPE;
1277:
1278:
1279:
1280: l_invoice_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT p_invoice_currency;
1281:
1282: l_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL; -- entered currency code
1283:
1284: l_applied_amount AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED%TYPE DEFAULT NULL;

Line 1282: l_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL; -- entered currency code

1278:
1279:
1280: l_invoice_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT p_invoice_currency;
1281:
1282: l_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL; -- entered currency code
1283:
1284: l_applied_amount AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED%TYPE DEFAULT NULL;
1285: l_applied_amount_from AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED_FROM%TYPE DEFAULT NULL;
1286:

Line 1288: l_currency_conv_type OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE DEFAULT p_currency_conv_type;

1284: l_applied_amount AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED%TYPE DEFAULT NULL;
1285: l_applied_amount_from AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED_FROM%TYPE DEFAULT NULL;
1286:
1287: --
1288: l_currency_conv_type OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE DEFAULT p_currency_conv_type;
1289: l_currency_conv_date OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE DEFAULT p_currency_conv_date;
1290: l_currency_conv_rate OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE DEFAULT p_currency_conv_rate;
1291: --
1292:

Line 1289: l_currency_conv_date OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE DEFAULT p_currency_conv_date;

1285: l_applied_amount_from AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED_FROM%TYPE DEFAULT NULL;
1286:
1287: --
1288: l_currency_conv_type OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE DEFAULT p_currency_conv_type;
1289: l_currency_conv_date OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE DEFAULT p_currency_conv_date;
1290: l_currency_conv_rate OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE DEFAULT p_currency_conv_rate;
1291: --
1292:
1293:

Line 1290: l_currency_conv_rate OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE DEFAULT p_currency_conv_rate;

1286:
1287: --
1288: l_currency_conv_type OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE DEFAULT p_currency_conv_type;
1289: l_currency_conv_date OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE DEFAULT p_currency_conv_date;
1290: l_currency_conv_rate OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE DEFAULT p_currency_conv_rate;
1291: --
1292:
1293:
1294: l_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;

Line 1294: l_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;

1290: l_currency_conv_rate OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE DEFAULT p_currency_conv_rate;
1291: --
1292:
1293:
1294: l_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;
1295: l_apply_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;
1296:
1297: l_rule_name OKL_CASH_ALLCTN_RLS.NAME%TYPE DEFAULT NULL;
1298: l_check_cau_id OKL_CSH_ALLCTN_RL_HDR.ID%TYPE DEFAULT NULL;

Line 1295: l_apply_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;

1291: --
1292:
1293:
1294: l_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;
1295: l_apply_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;
1296:
1297: l_rule_name OKL_CASH_ALLCTN_RLS.NAME%TYPE DEFAULT NULL;
1298: l_check_cau_id OKL_CSH_ALLCTN_RL_HDR.ID%TYPE DEFAULT NULL;
1299: l_cau_id OKL_CSH_ALLCTN_RL_HDR.ID%TYPE DEFAULT NULL;

Line 1332: l_org_id OKL_TRX_CSH_RECEIPT_V.ORG_ID%TYPE DEFAULT MO_GLOBAL.GET_CURRENT_ORG_ID();

1328: l_counter NUMBER;
1329: l_unapply VARCHAR2(3);
1330:
1331: l_record_count NUMBER DEFAULT NULL;
1332: l_org_id OKL_TRX_CSH_RECEIPT_V.ORG_ID%TYPE DEFAULT MO_GLOBAL.GET_CURRENT_ORG_ID();
1333: x_onacc_amount NUMBER;
1334: x_unapply_amount NUMBER;
1335: l_exchange_rate_type VARCHAR2(100);
1336: l_conversion_rate NUMBER;

Line 1392: FROM OKL_TRX_CSH_RECEIPT_V a, OKL_TXL_RCPT_APPS_V b

1388:
1389: -- get purpose for advance receipt if any
1390: CURSOR c_get_purpose_for_adv_rcpt(cp_cont_id IN NUMBER, cp_icr_id IN NUMBER) IS
1391: SELECT b.sty_id, b.amount
1392: FROM OKL_TRX_CSH_RECEIPT_V a, OKL_TXL_RCPT_APPS_V b
1393: WHERE a.id = b.rct_id_details
1394: AND a.receipt_type = 'ADV'
1395: AND a.EXPIRED_FLAG = 'N'
1396: AND a.FULLY_APPLIED_FLAG = 'N'

Line 1471: FROM OKL_TRX_CSH_RECEIPT_V

1467: AND cash_receipt_id = cp_csh_rcpt_id;
1468:
1469: CURSOR chk_exp_flag(cp_rct_id IN NUMBER) IS
1470: SELECT nvl(expired_flag,'N') INTO l_expired_flag
1471: FROM OKL_TRX_CSH_RECEIPT_V
1472: WHERE cash_receipt_id = cp_rct_id;
1473: -------------------------------------------------------------------------------
1474:
1475:

Line 1806: ,p_receipt_num IN OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT NULL

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
1809: ,p_receipt_type IN VARCHAR2 DEFAULT NULL
1810: ,p_cross_currency_allowed IN VARCHAR2 DEFAULT 'N'

Line 1807: ,p_receipt_date_from IN OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT NULL

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
1809: ,p_receipt_type IN VARCHAR2 DEFAULT NULL
1810: ,p_cross_currency_allowed IN VARCHAR2 DEFAULT 'N'
1811: ) IS

Line 1808: ,p_receipt_date_to IN OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%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
1809: ,p_receipt_type IN VARCHAR2 DEFAULT NULL
1810: ,p_cross_currency_allowed IN VARCHAR2 DEFAULT 'N'
1811: ) IS
1812:

Line 1827: l_customer_id OKL_TRX_CSH_RECEIPT_V.ILE_ID%TYPE DEFAULT NULL;

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;
1831: --end:| 13-May-2008 cklee --Fixed bug 7036445 |

Line 1835: l_receipt_num OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT p_receipt_num;

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;
1835: l_receipt_num OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT p_receipt_num;
1836: l_receipt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL;
1837: l_cross_currency_allowed VARCHAR2(1) DEFAULT p_cross_currency_allowed;
1838:
1839: l_receipt_date OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE;

Line 1836: l_receipt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL;

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;
1835: l_receipt_num OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT p_receipt_num;
1836: l_receipt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL;
1837: l_cross_currency_allowed VARCHAR2(1) DEFAULT p_cross_currency_allowed;
1838:
1839: l_receipt_date OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE;
1840: l_receipt_date_from OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT TRUNC(p_receipt_date_from);

Line 1839: l_receipt_date OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE;

1835: l_receipt_num OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT p_receipt_num;
1836: l_receipt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL;
1837: l_cross_currency_allowed VARCHAR2(1) DEFAULT p_cross_currency_allowed;
1838:
1839: l_receipt_date OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE;
1840: l_receipt_date_from OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT TRUNC(p_receipt_date_from);
1841: l_receipt_date_to OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT TRUNC(p_receipt_date_to);
1842:
1843: l_cash_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL;

Line 1840: l_receipt_date_from OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT TRUNC(p_receipt_date_from);

1836: l_receipt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL;
1837: l_cross_currency_allowed VARCHAR2(1) DEFAULT p_cross_currency_allowed;
1838:
1839: l_receipt_date OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE;
1840: l_receipt_date_from OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT TRUNC(p_receipt_date_from);
1841: l_receipt_date_to OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT TRUNC(p_receipt_date_to);
1842:
1843: l_cash_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL;
1844:

Line 1841: l_receipt_date_to OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT TRUNC(p_receipt_date_to);

1837: l_cross_currency_allowed VARCHAR2(1) DEFAULT p_cross_currency_allowed;
1838:
1839: l_receipt_date OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE;
1840: l_receipt_date_from OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT TRUNC(p_receipt_date_from);
1841: l_receipt_date_to OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT TRUNC(p_receipt_date_to);
1842:
1843: l_cash_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL;
1844:
1845: l_dflt_days_to_hold_adv_pay OKL_CASH_ALLCTN_RLS.NUM_DAYS_HOLD_ADV_PAY%TYPE;

Line 1854: l_check_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE;

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;
1853: l_remain_rcpt_amount AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE;
1854: l_check_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE;
1855: l_actual_remittance_amount AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE;
1856: l_on_account_bal AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE;
1857: l_receipt_currency OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE;
1858: l_receipt_count NUMBER;

Line 1857: l_receipt_currency OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE;

1853: l_remain_rcpt_amount AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE;
1854: l_check_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE;
1855: l_actual_remittance_amount AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE;
1856: l_on_account_bal AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE;
1857: l_receipt_currency OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE;
1858: l_receipt_count NUMBER;
1859: l_receipt_type VARCHAR2(30) := p_receipt_type;
1860:
1861: l_invoice_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL;

Line 1861: l_invoice_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL;

1857: l_receipt_currency OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE;
1858: l_receipt_count NUMBER;
1859: l_receipt_type VARCHAR2(30) := p_receipt_type;
1860:
1861: l_invoice_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL;
1862: l_inv_tot NUMBER := 0;
1863:
1864: --
1865: l_currency_conv_type OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE;

Line 1865: l_currency_conv_type OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE;

1861: l_invoice_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL;
1862: l_inv_tot NUMBER := 0;
1863:
1864: --
1865: l_currency_conv_type OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE;
1866: l_currency_conv_date OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE;
1867: l_currency_conv_rate OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE;
1868: --
1869:

Line 1866: l_currency_conv_date OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE;

1862: l_inv_tot NUMBER := 0;
1863:
1864: --
1865: l_currency_conv_type OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE;
1866: l_currency_conv_date OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE;
1867: l_currency_conv_rate OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE;
1868: --
1869:
1870:

Line 1867: l_currency_conv_rate OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE;

1863:
1864: --
1865: l_currency_conv_type OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE;
1866: l_currency_conv_date OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE;
1867: l_currency_conv_rate OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE;
1868: --
1869:
1870:
1871: l_cau_id OKL_CSH_ALLCTN_RL_HDR.ID%TYPE DEFAULT NULL;

Line 1875: l_rct_id OKL_TRX_CSH_RECEIPT_V.ID%TYPE;

1871: l_cau_id OKL_CSH_ALLCTN_RL_HDR.ID%TYPE DEFAULT NULL;
1872:
1873: l_okl_receipt_id NUMBER;
1874: l_xcr_id NUMBER;
1875: l_rct_id OKL_TRX_CSH_RECEIPT_V.ID%TYPE;
1876: l_rca_id OKL_TXL_RCPT_APPS_V.ID%TYPE;
1877: l_cat_id OKL_CASH_ALLCTN_RLS.ID%TYPE DEFAULT NULL;
1878: i NUMBER DEFAULT NULL;
1879:

Line 1881: l_org_id OKL_TRX_CSH_RECEIPT_V.ORG_ID%TYPE DEFAULT MO_GLOBAL.GET_CURRENT_ORG_ID();

1877: l_cat_id OKL_CASH_ALLCTN_RLS.ID%TYPE DEFAULT NULL;
1878: i NUMBER DEFAULT NULL;
1879:
1880:
1881: l_org_id OKL_TRX_CSH_RECEIPT_V.ORG_ID%TYPE DEFAULT MO_GLOBAL.GET_CURRENT_ORG_ID();
1882:
1883: l_stat_total_rcpt_amt OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT 0;
1884: l_stat_num_of_rcpts NUMBER DEFAULT 0;
1885: l_stat_num_of_cont NUMBER DEFAULT 0;

Line 1883: l_stat_total_rcpt_amt OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT 0;

1879:
1880:
1881: l_org_id OKL_TRX_CSH_RECEIPT_V.ORG_ID%TYPE DEFAULT MO_GLOBAL.GET_CURRENT_ORG_ID();
1882:
1883: l_stat_total_rcpt_amt OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT 0;
1884: l_stat_num_of_rcpts NUMBER DEFAULT 0;
1885: l_stat_num_of_cont NUMBER DEFAULT 0;
1886:
1887: l_exit_loop NUMBER DEFAULT 0;

Line 1936: FROM OKL_TRX_CSH_RECEIPT_V a,

1932: b.receipt_number,
1933: b.currency_code,
1934: b.receipt_date,
1935: a.id
1936: FROM OKL_TRX_CSH_RECEIPT_V a,
1937: ar_Cash_receipts_all b
1938: WHERE a.fully_applied_flag = 'N'
1939: AND a.expired_flag = 'N'
1940: AND a.receipt_type = 'ADV'

Line 1953: FROM OKL_TRX_CSH_RECEIPT_V a,

1949: SELECT DISTINCT(c.cash_receipt_id) icr_id,
1950: a.id RCT_ID,
1951: c.receipt_date,
1952: b.khr_id
1953: FROM OKL_TRX_CSH_RECEIPT_V a,
1954: OKL_TXL_RCPT_APPS_V b,
1955: AR_CASH_RECEIPTS_ALL c
1956: WHERE a.id = b.rct_id_details
1957: AND a.cash_receipt_id = c.cash_receipt_id

Line 1977: FROM OKL_TRX_CSH_RECEIPT_V a,

1973: a.ile_id,
1974: a.id,
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

Line 2716: l_check_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE;

2712: l_api_name CONSTANT VARCHAR2(30) := 'reapplic_rcpt_w_cntrct';
2713:
2714: l_remittance_amount AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE;
2715: l_remain_rcpt_amount AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE;
2716: l_check_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE;
2717: l_actual_remittance_amount AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE;
2718: l_on_account_bal AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE;
2719: l_receipt_currency OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE;
2720: l_receipt_count NUMBER;

Line 2719: l_receipt_currency OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE;

2715: l_remain_rcpt_amount AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE;
2716: l_check_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE;
2717: l_actual_remittance_amount AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE;
2718: l_on_account_bal AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE;
2719: l_receipt_currency OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE;
2720: l_receipt_count NUMBER;
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;

Line 2736: l_rct_id OKL_TRX_CSH_RECEIPT_V.ID%TYPE;

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;
2736: l_rct_id OKL_TRX_CSH_RECEIPT_V.ID%TYPE;
2737: l_rca_id OKL_TXL_RCPT_APPS_V.ID%TYPE;
2738: l_cat_id OKL_CASH_ALLCTN_RLS.ID%TYPE DEFAULT NULL;
2739: l_cau_id OKL_CSH_ALLCTN_RL_HDR.ID%TYPE DEFAULT NULL;
2740:

Line 2741: l_stat_total_rcpt_amt OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT 0;

2737: l_rca_id OKL_TXL_RCPT_APPS_V.ID%TYPE;
2738: l_cat_id OKL_CASH_ALLCTN_RLS.ID%TYPE DEFAULT NULL;
2739: l_cau_id OKL_CSH_ALLCTN_RL_HDR.ID%TYPE DEFAULT NULL;
2740:
2741: l_stat_total_rcpt_amt OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT 0;
2742: l_stat_num_of_rcpts NUMBER DEFAULT 0;
2743: l_stat_num_of_cont NUMBER DEFAULT 0;
2744:
2745:

Line 2789: FROM OKL_TRX_CSH_RECEIPT_V a, OKL_TXL_RCPT_APPS_V b, AR_CASH_RECEIPTS_ALL c

2785: SELECT DISTINCT(a.cash_receipt_id) icr_id,
2786: a.id RCT_ID,
2787: c.receipt_date,
2788: b.khr_id
2789: FROM OKL_TRX_CSH_RECEIPT_V a, OKL_TXL_RCPT_APPS_V b, AR_CASH_RECEIPTS_ALL c
2790: WHERE a.id = b.rct_id_details
2791: AND a.cash_receipt_id = c.cash_receipt_id
2792: AND a.FULLY_APPLIED_FLAG = 'N'
2793: AND a.receipt_type = 'ADV'

Line 3293: l_receipt_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT p_receipt_currency;

3289: l_msg_data VARCHAR2(2000);
3290: l_api_name CONSTANT VARCHAR2(30) := 'AR_advance_receipt';
3291:
3292: l_receipt_date AR_CASH_RECEIPTS_ALL.RECEIPT_DATE%TYPE DEFAULT p_receipt_date;
3293: l_receipt_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT p_receipt_currency;
3294: l_receipt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT p_receipt_amount;
3295:
3296: l_customer_trx_id AR_PAYMENT_SCHEDULES_ALL.CUSTOMER_TRX_ID%TYPE DEFAULT NULL;
3297: l_cash_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT p_receipt_id;

Line 3294: l_receipt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT p_receipt_amount;

3290: l_api_name CONSTANT VARCHAR2(30) := 'AR_advance_receipt';
3291:
3292: l_receipt_date AR_CASH_RECEIPTS_ALL.RECEIPT_DATE%TYPE DEFAULT p_receipt_date;
3293: l_receipt_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT p_receipt_currency;
3294: l_receipt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT p_receipt_amount;
3295:
3296: l_customer_trx_id AR_PAYMENT_SCHEDULES_ALL.CUSTOMER_TRX_ID%TYPE DEFAULT NULL;
3297: l_cash_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT p_receipt_id;
3298:

Line 3299: l_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT p_currency_code; -- entered currency code

3295:
3296: l_customer_trx_id AR_PAYMENT_SCHEDULES_ALL.CUSTOMER_TRX_ID%TYPE DEFAULT NULL;
3297: l_cash_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT p_receipt_id;
3298:
3299: l_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT p_currency_code; -- entered currency code
3300:
3301: l_applied_amount AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED%TYPE DEFAULT NULL;
3302: l_applied_amount_from AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED_FROM%TYPE DEFAULT NULL;
3303:

Line 3310: l_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;

3306: l_receivable_application_id AR_RECEIVABLE_APPLICATIONS_ALL.RECEIVABLE_APPLICATION_ID%TYPE DEFAULT NULL;
3307:
3308: l_invoice_balance AR_PAYMENT_SCHEDULES_ALL.AMOUNT_DUE_REMAINING%TYPE DEFAULT NULL;
3309:
3310: l_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;
3311: l_apply_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;
3312:
3313: l_ar_inv_id RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE DEFAULT NULL;
3314: l_ar_inv_date RA_CUSTOMER_TRX_ALL.TRX_DATE%TYPE DEFAULT NULL;

Line 3311: l_apply_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;

3307:
3308: l_invoice_balance AR_PAYMENT_SCHEDULES_ALL.AMOUNT_DUE_REMAINING%TYPE DEFAULT NULL;
3309:
3310: l_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;
3311: l_apply_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;
3312:
3313: l_ar_inv_id RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE DEFAULT NULL;
3314: l_ar_inv_date RA_CUSTOMER_TRX_ALL.TRX_DATE%TYPE DEFAULT NULL;
3315:

Line 3324: l_org_id OKL_TRX_CSH_RECEIPT_V.ORG_ID%TYPE DEFAULT MO_GLOBAL.GET_CURRENT_ORG_ID();

3320: l_unapply VARCHAR2(3);
3321:
3322: l_record_count NUMBER DEFAULT NULL;
3323:
3324: l_org_id OKL_TRX_CSH_RECEIPT_V.ORG_ID%TYPE DEFAULT MO_GLOBAL.GET_CURRENT_ORG_ID();
3325:
3326: -- abindal start bug#4897580 --
3327: l_inv_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;
3328: l_rec_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;

Line 3327: l_inv_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;

3323:
3324: l_org_id OKL_TRX_CSH_RECEIPT_V.ORG_ID%TYPE DEFAULT MO_GLOBAL.GET_CURRENT_ORG_ID();
3325:
3326: -- abindal start bug#4897580 --
3327: l_inv_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;
3328: l_rec_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;
3329: ar_invoice_num RA_CUSTOMER_TRX_ALL.TRX_NUMBER%TYPE DEFAULT NULL;
3330: ar_invoice_date OKL_BPD_LEASING_PAYMENT_TRX_V.INVOICE_DATE%TYPE DEFAULT NULL;
3331: -- abindal end bug#4897580 --

Line 3328: l_rec_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;

3324: l_org_id OKL_TRX_CSH_RECEIPT_V.ORG_ID%TYPE DEFAULT MO_GLOBAL.GET_CURRENT_ORG_ID();
3325:
3326: -- abindal start bug#4897580 --
3327: l_inv_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;
3328: l_rec_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;
3329: ar_invoice_num RA_CUSTOMER_TRX_ALL.TRX_NUMBER%TYPE DEFAULT NULL;
3330: ar_invoice_date OKL_BPD_LEASING_PAYMENT_TRX_V.INVOICE_DATE%TYPE DEFAULT NULL;
3331: -- abindal end bug#4897580 --
3332: