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_CASH_ALLCTN_RLS

Line 469: l_cat_id OKL_CASH_ALLCTN_RLS.ID%TYPE DEFAULT NULL;

465:
466:
467: l_rct_id NUMBER;
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;

Line 993: l_cat_id OKL_CASH_ALLCTN_RLS.ID%TYPE DEFAULT NULL;

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;
994: i NUMBER DEFAULT NULL;
995:
996: l_counter NUMBER;
997: l_unapply VARCHAR2(3);

Line 1297: l_rule_name OKL_CASH_ALLCTN_RLS.NAME%TYPE DEFAULT NULL;

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;
1300: l_cat_id OKL_CASH_ALLCTN_RLS.ID%TYPE DEFAULT NULL;
1301: l_tolerance OKL_CASH_ALLCTN_RLS.AMOUNT_TOLERANCE_PERCENT%TYPE DEFAULT NULL;

Line 1300: l_cat_id OKL_CASH_ALLCTN_RLS.ID%TYPE DEFAULT NULL;

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;
1300: l_cat_id OKL_CASH_ALLCTN_RLS.ID%TYPE DEFAULT NULL;
1301: l_tolerance OKL_CASH_ALLCTN_RLS.AMOUNT_TOLERANCE_PERCENT%TYPE DEFAULT NULL;
1302: l_days_past_quote_valid OKL_CASH_ALLCTN_RLS.DAYS_PAST_QUOTE_VALID_TOLERANC%TYPE DEFAULT NULL;
1303: l_months_to_bill_ahead OKL_CASH_ALLCTN_RLS.MONTHS_TO_BILL_AHEAD%TYPE DEFAULT NULL;
1304: l_under_payment OKL_CASH_ALLCTN_RLS.UNDER_PAYMENT_ALLOCATION_CODE%TYPE DEFAULT NULL;

Line 1301: l_tolerance OKL_CASH_ALLCTN_RLS.AMOUNT_TOLERANCE_PERCENT%TYPE DEFAULT NULL;

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;
1300: l_cat_id OKL_CASH_ALLCTN_RLS.ID%TYPE DEFAULT NULL;
1301: l_tolerance OKL_CASH_ALLCTN_RLS.AMOUNT_TOLERANCE_PERCENT%TYPE DEFAULT NULL;
1302: l_days_past_quote_valid OKL_CASH_ALLCTN_RLS.DAYS_PAST_QUOTE_VALID_TOLERANC%TYPE DEFAULT NULL;
1303: l_months_to_bill_ahead OKL_CASH_ALLCTN_RLS.MONTHS_TO_BILL_AHEAD%TYPE DEFAULT NULL;
1304: l_under_payment OKL_CASH_ALLCTN_RLS.UNDER_PAYMENT_ALLOCATION_CODE%TYPE DEFAULT NULL;
1305: l_over_payment OKL_CASH_ALLCTN_RLS.OVER_PAYMENT_ALLOCATION_CODE%TYPE DEFAULT NULL;

Line 1302: l_days_past_quote_valid OKL_CASH_ALLCTN_RLS.DAYS_PAST_QUOTE_VALID_TOLERANC%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;
1300: l_cat_id OKL_CASH_ALLCTN_RLS.ID%TYPE DEFAULT NULL;
1301: l_tolerance OKL_CASH_ALLCTN_RLS.AMOUNT_TOLERANCE_PERCENT%TYPE DEFAULT NULL;
1302: l_days_past_quote_valid OKL_CASH_ALLCTN_RLS.DAYS_PAST_QUOTE_VALID_TOLERANC%TYPE DEFAULT NULL;
1303: l_months_to_bill_ahead OKL_CASH_ALLCTN_RLS.MONTHS_TO_BILL_AHEAD%TYPE DEFAULT NULL;
1304: l_under_payment OKL_CASH_ALLCTN_RLS.UNDER_PAYMENT_ALLOCATION_CODE%TYPE DEFAULT NULL;
1305: l_over_payment OKL_CASH_ALLCTN_RLS.OVER_PAYMENT_ALLOCATION_CODE%TYPE DEFAULT NULL;
1306: l_receipt_msmtch OKL_CASH_ALLCTN_RLS.RECEIPT_MSMTCH_ALLOCATION_CODE%TYPE DEFAULT NULL;

Line 1303: l_months_to_bill_ahead OKL_CASH_ALLCTN_RLS.MONTHS_TO_BILL_AHEAD%TYPE DEFAULT NULL;

1299: l_cau_id OKL_CSH_ALLCTN_RL_HDR.ID%TYPE DEFAULT NULL;
1300: l_cat_id OKL_CASH_ALLCTN_RLS.ID%TYPE DEFAULT NULL;
1301: l_tolerance OKL_CASH_ALLCTN_RLS.AMOUNT_TOLERANCE_PERCENT%TYPE DEFAULT NULL;
1302: l_days_past_quote_valid OKL_CASH_ALLCTN_RLS.DAYS_PAST_QUOTE_VALID_TOLERANC%TYPE DEFAULT NULL;
1303: l_months_to_bill_ahead OKL_CASH_ALLCTN_RLS.MONTHS_TO_BILL_AHEAD%TYPE DEFAULT NULL;
1304: l_under_payment OKL_CASH_ALLCTN_RLS.UNDER_PAYMENT_ALLOCATION_CODE%TYPE DEFAULT NULL;
1305: l_over_payment OKL_CASH_ALLCTN_RLS.OVER_PAYMENT_ALLOCATION_CODE%TYPE DEFAULT NULL;
1306: l_receipt_msmtch OKL_CASH_ALLCTN_RLS.RECEIPT_MSMTCH_ALLOCATION_CODE%TYPE DEFAULT NULL;
1307:

Line 1304: l_under_payment OKL_CASH_ALLCTN_RLS.UNDER_PAYMENT_ALLOCATION_CODE%TYPE DEFAULT NULL;

1300: l_cat_id OKL_CASH_ALLCTN_RLS.ID%TYPE DEFAULT NULL;
1301: l_tolerance OKL_CASH_ALLCTN_RLS.AMOUNT_TOLERANCE_PERCENT%TYPE DEFAULT NULL;
1302: l_days_past_quote_valid OKL_CASH_ALLCTN_RLS.DAYS_PAST_QUOTE_VALID_TOLERANC%TYPE DEFAULT NULL;
1303: l_months_to_bill_ahead OKL_CASH_ALLCTN_RLS.MONTHS_TO_BILL_AHEAD%TYPE DEFAULT NULL;
1304: l_under_payment OKL_CASH_ALLCTN_RLS.UNDER_PAYMENT_ALLOCATION_CODE%TYPE DEFAULT NULL;
1305: l_over_payment OKL_CASH_ALLCTN_RLS.OVER_PAYMENT_ALLOCATION_CODE%TYPE DEFAULT NULL;
1306: l_receipt_msmtch OKL_CASH_ALLCTN_RLS.RECEIPT_MSMTCH_ALLOCATION_CODE%TYPE DEFAULT NULL;
1307:
1308: l_dflt_cat_id OKL_CASH_ALLCTN_RLS.ID%TYPE DEFAULT NULL;

Line 1305: l_over_payment OKL_CASH_ALLCTN_RLS.OVER_PAYMENT_ALLOCATION_CODE%TYPE DEFAULT NULL;

1301: l_tolerance OKL_CASH_ALLCTN_RLS.AMOUNT_TOLERANCE_PERCENT%TYPE DEFAULT NULL;
1302: l_days_past_quote_valid OKL_CASH_ALLCTN_RLS.DAYS_PAST_QUOTE_VALID_TOLERANC%TYPE DEFAULT NULL;
1303: l_months_to_bill_ahead OKL_CASH_ALLCTN_RLS.MONTHS_TO_BILL_AHEAD%TYPE DEFAULT NULL;
1304: l_under_payment OKL_CASH_ALLCTN_RLS.UNDER_PAYMENT_ALLOCATION_CODE%TYPE DEFAULT NULL;
1305: l_over_payment OKL_CASH_ALLCTN_RLS.OVER_PAYMENT_ALLOCATION_CODE%TYPE DEFAULT NULL;
1306: l_receipt_msmtch OKL_CASH_ALLCTN_RLS.RECEIPT_MSMTCH_ALLOCATION_CODE%TYPE DEFAULT NULL;
1307:
1308: l_dflt_cat_id OKL_CASH_ALLCTN_RLS.ID%TYPE DEFAULT NULL;
1309: l_dflt_name OKL_CASH_ALLCTN_RLS.NAME%TYPE DEFAULT NULL;

Line 1306: l_receipt_msmtch OKL_CASH_ALLCTN_RLS.RECEIPT_MSMTCH_ALLOCATION_CODE%TYPE DEFAULT NULL;

1302: l_days_past_quote_valid OKL_CASH_ALLCTN_RLS.DAYS_PAST_QUOTE_VALID_TOLERANC%TYPE DEFAULT NULL;
1303: l_months_to_bill_ahead OKL_CASH_ALLCTN_RLS.MONTHS_TO_BILL_AHEAD%TYPE DEFAULT NULL;
1304: l_under_payment OKL_CASH_ALLCTN_RLS.UNDER_PAYMENT_ALLOCATION_CODE%TYPE DEFAULT NULL;
1305: l_over_payment OKL_CASH_ALLCTN_RLS.OVER_PAYMENT_ALLOCATION_CODE%TYPE DEFAULT NULL;
1306: l_receipt_msmtch OKL_CASH_ALLCTN_RLS.RECEIPT_MSMTCH_ALLOCATION_CODE%TYPE DEFAULT NULL;
1307:
1308: l_dflt_cat_id OKL_CASH_ALLCTN_RLS.ID%TYPE DEFAULT NULL;
1309: l_dflt_name OKL_CASH_ALLCTN_RLS.NAME%TYPE DEFAULT NULL;
1310: l_dflt_tolerance OKL_CASH_ALLCTN_RLS.AMOUNT_TOLERANCE_PERCENT%TYPE DEFAULT NULL;

Line 1308: l_dflt_cat_id OKL_CASH_ALLCTN_RLS.ID%TYPE DEFAULT NULL;

1304: l_under_payment OKL_CASH_ALLCTN_RLS.UNDER_PAYMENT_ALLOCATION_CODE%TYPE DEFAULT NULL;
1305: l_over_payment OKL_CASH_ALLCTN_RLS.OVER_PAYMENT_ALLOCATION_CODE%TYPE DEFAULT NULL;
1306: l_receipt_msmtch OKL_CASH_ALLCTN_RLS.RECEIPT_MSMTCH_ALLOCATION_CODE%TYPE DEFAULT NULL;
1307:
1308: l_dflt_cat_id OKL_CASH_ALLCTN_RLS.ID%TYPE DEFAULT NULL;
1309: l_dflt_name OKL_CASH_ALLCTN_RLS.NAME%TYPE DEFAULT NULL;
1310: l_dflt_tolerance OKL_CASH_ALLCTN_RLS.AMOUNT_TOLERANCE_PERCENT%TYPE DEFAULT NULL;
1311: l_dflt_days_past_quote_valid OKL_CASH_ALLCTN_RLS.DAYS_PAST_QUOTE_VALID_TOLERANC%TYPE DEFAULT NULL;
1312: l_dflt_months_to_bill_ahead OKL_CASH_ALLCTN_RLS.MONTHS_TO_BILL_AHEAD%TYPE DEFAULT NULL;

Line 1309: l_dflt_name OKL_CASH_ALLCTN_RLS.NAME%TYPE DEFAULT NULL;

1305: l_over_payment OKL_CASH_ALLCTN_RLS.OVER_PAYMENT_ALLOCATION_CODE%TYPE DEFAULT NULL;
1306: l_receipt_msmtch OKL_CASH_ALLCTN_RLS.RECEIPT_MSMTCH_ALLOCATION_CODE%TYPE DEFAULT NULL;
1307:
1308: l_dflt_cat_id OKL_CASH_ALLCTN_RLS.ID%TYPE DEFAULT NULL;
1309: l_dflt_name OKL_CASH_ALLCTN_RLS.NAME%TYPE DEFAULT NULL;
1310: l_dflt_tolerance OKL_CASH_ALLCTN_RLS.AMOUNT_TOLERANCE_PERCENT%TYPE DEFAULT NULL;
1311: l_dflt_days_past_quote_valid OKL_CASH_ALLCTN_RLS.DAYS_PAST_QUOTE_VALID_TOLERANC%TYPE DEFAULT NULL;
1312: l_dflt_months_to_bill_ahead OKL_CASH_ALLCTN_RLS.MONTHS_TO_BILL_AHEAD%TYPE DEFAULT NULL;
1313: l_dflt_under_payment OKL_CASH_ALLCTN_RLS.UNDER_PAYMENT_ALLOCATION_CODE%TYPE DEFAULT NULL;

Line 1310: l_dflt_tolerance OKL_CASH_ALLCTN_RLS.AMOUNT_TOLERANCE_PERCENT%TYPE DEFAULT NULL;

1306: l_receipt_msmtch OKL_CASH_ALLCTN_RLS.RECEIPT_MSMTCH_ALLOCATION_CODE%TYPE DEFAULT NULL;
1307:
1308: l_dflt_cat_id OKL_CASH_ALLCTN_RLS.ID%TYPE DEFAULT NULL;
1309: l_dflt_name OKL_CASH_ALLCTN_RLS.NAME%TYPE DEFAULT NULL;
1310: l_dflt_tolerance OKL_CASH_ALLCTN_RLS.AMOUNT_TOLERANCE_PERCENT%TYPE DEFAULT NULL;
1311: l_dflt_days_past_quote_valid OKL_CASH_ALLCTN_RLS.DAYS_PAST_QUOTE_VALID_TOLERANC%TYPE DEFAULT NULL;
1312: l_dflt_months_to_bill_ahead OKL_CASH_ALLCTN_RLS.MONTHS_TO_BILL_AHEAD%TYPE DEFAULT NULL;
1313: l_dflt_under_payment OKL_CASH_ALLCTN_RLS.UNDER_PAYMENT_ALLOCATION_CODE%TYPE DEFAULT NULL;
1314: l_dflt_over_payment OKL_CASH_ALLCTN_RLS.OVER_PAYMENT_ALLOCATION_CODE%TYPE DEFAULT NULL;

Line 1311: l_dflt_days_past_quote_valid OKL_CASH_ALLCTN_RLS.DAYS_PAST_QUOTE_VALID_TOLERANC%TYPE DEFAULT NULL;

1307:
1308: l_dflt_cat_id OKL_CASH_ALLCTN_RLS.ID%TYPE DEFAULT NULL;
1309: l_dflt_name OKL_CASH_ALLCTN_RLS.NAME%TYPE DEFAULT NULL;
1310: l_dflt_tolerance OKL_CASH_ALLCTN_RLS.AMOUNT_TOLERANCE_PERCENT%TYPE DEFAULT NULL;
1311: l_dflt_days_past_quote_valid OKL_CASH_ALLCTN_RLS.DAYS_PAST_QUOTE_VALID_TOLERANC%TYPE DEFAULT NULL;
1312: l_dflt_months_to_bill_ahead OKL_CASH_ALLCTN_RLS.MONTHS_TO_BILL_AHEAD%TYPE DEFAULT NULL;
1313: l_dflt_under_payment OKL_CASH_ALLCTN_RLS.UNDER_PAYMENT_ALLOCATION_CODE%TYPE DEFAULT NULL;
1314: l_dflt_over_payment OKL_CASH_ALLCTN_RLS.OVER_PAYMENT_ALLOCATION_CODE%TYPE DEFAULT NULL;
1315: l_dflt_receipt_msmtch OKL_CASH_ALLCTN_RLS.RECEIPT_MSMTCH_ALLOCATION_CODE%TYPE DEFAULT NULL;

Line 1312: l_dflt_months_to_bill_ahead OKL_CASH_ALLCTN_RLS.MONTHS_TO_BILL_AHEAD%TYPE DEFAULT NULL;

1308: l_dflt_cat_id OKL_CASH_ALLCTN_RLS.ID%TYPE DEFAULT NULL;
1309: l_dflt_name OKL_CASH_ALLCTN_RLS.NAME%TYPE DEFAULT NULL;
1310: l_dflt_tolerance OKL_CASH_ALLCTN_RLS.AMOUNT_TOLERANCE_PERCENT%TYPE DEFAULT NULL;
1311: l_dflt_days_past_quote_valid OKL_CASH_ALLCTN_RLS.DAYS_PAST_QUOTE_VALID_TOLERANC%TYPE DEFAULT NULL;
1312: l_dflt_months_to_bill_ahead OKL_CASH_ALLCTN_RLS.MONTHS_TO_BILL_AHEAD%TYPE DEFAULT NULL;
1313: l_dflt_under_payment OKL_CASH_ALLCTN_RLS.UNDER_PAYMENT_ALLOCATION_CODE%TYPE DEFAULT NULL;
1314: l_dflt_over_payment OKL_CASH_ALLCTN_RLS.OVER_PAYMENT_ALLOCATION_CODE%TYPE DEFAULT NULL;
1315: l_dflt_receipt_msmtch OKL_CASH_ALLCTN_RLS.RECEIPT_MSMTCH_ALLOCATION_CODE%TYPE DEFAULT NULL;
1316:

Line 1313: l_dflt_under_payment OKL_CASH_ALLCTN_RLS.UNDER_PAYMENT_ALLOCATION_CODE%TYPE DEFAULT NULL;

1309: l_dflt_name OKL_CASH_ALLCTN_RLS.NAME%TYPE DEFAULT NULL;
1310: l_dflt_tolerance OKL_CASH_ALLCTN_RLS.AMOUNT_TOLERANCE_PERCENT%TYPE DEFAULT NULL;
1311: l_dflt_days_past_quote_valid OKL_CASH_ALLCTN_RLS.DAYS_PAST_QUOTE_VALID_TOLERANC%TYPE DEFAULT NULL;
1312: l_dflt_months_to_bill_ahead OKL_CASH_ALLCTN_RLS.MONTHS_TO_BILL_AHEAD%TYPE DEFAULT NULL;
1313: l_dflt_under_payment OKL_CASH_ALLCTN_RLS.UNDER_PAYMENT_ALLOCATION_CODE%TYPE DEFAULT NULL;
1314: l_dflt_over_payment OKL_CASH_ALLCTN_RLS.OVER_PAYMENT_ALLOCATION_CODE%TYPE DEFAULT NULL;
1315: l_dflt_receipt_msmtch OKL_CASH_ALLCTN_RLS.RECEIPT_MSMTCH_ALLOCATION_CODE%TYPE DEFAULT NULL;
1316:
1317: l_purpose_id OKL_TXL_RCPT_APPS_V.STY_ID%TYPE DEFAULT NULL;

Line 1314: l_dflt_over_payment OKL_CASH_ALLCTN_RLS.OVER_PAYMENT_ALLOCATION_CODE%TYPE DEFAULT NULL;

1310: l_dflt_tolerance OKL_CASH_ALLCTN_RLS.AMOUNT_TOLERANCE_PERCENT%TYPE DEFAULT NULL;
1311: l_dflt_days_past_quote_valid OKL_CASH_ALLCTN_RLS.DAYS_PAST_QUOTE_VALID_TOLERANC%TYPE DEFAULT NULL;
1312: l_dflt_months_to_bill_ahead OKL_CASH_ALLCTN_RLS.MONTHS_TO_BILL_AHEAD%TYPE DEFAULT NULL;
1313: l_dflt_under_payment OKL_CASH_ALLCTN_RLS.UNDER_PAYMENT_ALLOCATION_CODE%TYPE DEFAULT NULL;
1314: l_dflt_over_payment OKL_CASH_ALLCTN_RLS.OVER_PAYMENT_ALLOCATION_CODE%TYPE DEFAULT NULL;
1315: l_dflt_receipt_msmtch OKL_CASH_ALLCTN_RLS.RECEIPT_MSMTCH_ALLOCATION_CODE%TYPE DEFAULT NULL;
1316:
1317: l_purpose_id OKL_TXL_RCPT_APPS_V.STY_ID%TYPE DEFAULT NULL;
1318: l_purpose_amt OKL_TXL_RCPT_APPS_V.AMOUNT%TYPE DEFAULT NULL;

Line 1315: l_dflt_receipt_msmtch OKL_CASH_ALLCTN_RLS.RECEIPT_MSMTCH_ALLOCATION_CODE%TYPE DEFAULT NULL;

1311: l_dflt_days_past_quote_valid OKL_CASH_ALLCTN_RLS.DAYS_PAST_QUOTE_VALID_TOLERANC%TYPE DEFAULT NULL;
1312: l_dflt_months_to_bill_ahead OKL_CASH_ALLCTN_RLS.MONTHS_TO_BILL_AHEAD%TYPE DEFAULT NULL;
1313: l_dflt_under_payment OKL_CASH_ALLCTN_RLS.UNDER_PAYMENT_ALLOCATION_CODE%TYPE DEFAULT NULL;
1314: l_dflt_over_payment OKL_CASH_ALLCTN_RLS.OVER_PAYMENT_ALLOCATION_CODE%TYPE DEFAULT NULL;
1315: l_dflt_receipt_msmtch OKL_CASH_ALLCTN_RLS.RECEIPT_MSMTCH_ALLOCATION_CODE%TYPE DEFAULT NULL;
1316:
1317: l_purpose_id OKL_TXL_RCPT_APPS_V.STY_ID%TYPE DEFAULT NULL;
1318: l_purpose_amt OKL_TXL_RCPT_APPS_V.AMOUNT%TYPE DEFAULT NULL;
1319: l_purpose_total OKL_TXL_RCPT_APPS_V.AMOUNT%TYPE DEFAULT NULL;

Line 1436: FROM OKL_CASH_ALLCTN_RLS

1432: ,MONTHS_TO_BILL_AHEAD
1433: ,UNDER_PAYMENT_ALLOCATION_CODE
1434: ,OVER_PAYMENT_ALLOCATION_CODE
1435: ,RECEIPT_MSMTCH_ALLOCATION_CODE
1436: FROM OKL_CASH_ALLCTN_RLS
1437: WHERE CAU_ID = cp_cau_id
1438: AND START_DATE <= trunc(SYSDATE)
1439: AND (END_DATE >= trunc(SYSDATE) OR END_DATE IS NULL);
1440:

Line 1453: FROM OKL_CASH_ALLCTN_RLS

1449: ,MONTHS_TO_BILL_AHEAD
1450: ,UNDER_PAYMENT_ALLOCATION_CODE
1451: ,OVER_PAYMENT_ALLOCATION_CODE
1452: ,RECEIPT_MSMTCH_ALLOCATION_CODE
1453: FROM OKL_CASH_ALLCTN_RLS
1454: WHERE default_rule = 'YES'
1455: AND TRUNC(end_date) IS NULL;
1456:
1457: -- get default cash applic rule for organization

Line 1845: l_dflt_days_to_hold_adv_pay OKL_CASH_ALLCTN_RLS.NUM_DAYS_HOLD_ADV_PAY%TYPE;

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;
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;

Line 1846: l_days_to_hold_adv_pay OKL_CASH_ALLCTN_RLS.NUM_DAYS_HOLD_ADV_PAY%TYPE;

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;
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;

Line 1877: l_cat_id OKL_CASH_ALLCTN_RLS.ID%TYPE DEFAULT NULL;

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:
1880:
1881: l_org_id OKL_TRX_CSH_RECEIPT_V.ORG_ID%TYPE DEFAULT MO_GLOBAL.GET_CURRENT_ORG_ID();

Line 2081: FROM OKL_CASH_ALLCTN_RLS

2077:
2078: -- get cash applic rule for contract
2079: CURSOR c_cash_rule_csr ( cp_cau_id IN NUMBER ) IS
2080: SELECT NUM_DAYS_HOLD_ADV_PAY
2081: FROM OKL_CASH_ALLCTN_RLS
2082: WHERE CAU_ID = cp_cau_id
2083: AND START_DATE <= trunc(SYSDATE)
2084: AND (END_DATE >= trunc(SYSDATE) OR END_DATE IS NULL);
2085:

Line 2091: FROM OKL_CASH_ALLCTN_RLS

2087:
2088: -- get default cash applic rule for organization
2089: CURSOR c_dflt_cash_applic_rule IS
2090: SELECT NUM_DAYS_HOLD_ADV_PAY
2091: FROM OKL_CASH_ALLCTN_RLS
2092: WHERE default_rule = 'YES'
2093: AND TRUNC(end_date) IS NULL;
2094:
2095: CURSOR c_get_cust_Acct_num(cp_acct_id in number) IS

Line 2722: l_dflt_days_to_hold_adv_pay OKL_CASH_ALLCTN_RLS.NUM_DAYS_HOLD_ADV_PAY%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;
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;

Line 2723: l_days_to_hold_adv_pay OKL_CASH_ALLCTN_RLS.NUM_DAYS_HOLD_ADV_PAY%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;
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;

Line 2738: l_cat_id OKL_CASH_ALLCTN_RLS.ID%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:
2741: l_stat_total_rcpt_amt OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT 0;
2742: l_stat_num_of_rcpts NUMBER DEFAULT 0;

Line 2826: FROM OKL_CASH_ALLCTN_RLS

2822:
2823: -- get cash applic rule for contract
2824: CURSOR c_cash_rule_csr ( cp_cau_id IN NUMBER ) IS
2825: SELECT NUM_DAYS_HOLD_ADV_PAY
2826: FROM OKL_CASH_ALLCTN_RLS
2827: WHERE CAU_ID = cp_cau_id
2828: AND START_DATE <= trunc(SYSDATE)
2829: AND (END_DATE >= trunc(SYSDATE) OR END_DATE IS NULL);
2830:

Line 2867: FROM OKL_CASH_ALLCTN_RLS

2863:
2864: -- get default cash applic rule for organization
2865: CURSOR c_dflt_cash_applic_rule IS
2866: SELECT NUM_DAYS_HOLD_ADV_PAY
2867: FROM OKL_CASH_ALLCTN_RLS
2868: WHERE default_rule = 'YES'
2869: AND TRUNC(end_date) IS NULL;
2870:
2871: CURSOR c_get_cust_Acct_num(cp_acct_id in number) IS