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_CASH_APPL_RULES dependencies on OKL_CASH_ALLCTN_RLS

Line 21: FROM OKL_CASH_ALLCTN_RLS_ALL

17:
18: BEGIN
19:
20: SELECT ID INTO RULES
21: FROM OKL_CASH_ALLCTN_RLS_ALL
22: WHERE DEFAULT_RULE = 'YES'
23: AND SYSDATE BETWEEN START_DATE AND NVL(END_DATE,SYSDATE)
24: AND org_id = p_org_id;
25:

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

140: l_xcr_id NUMBER;
141:
142: l_sty_id OKL_CNSLD_AR_STRMS_V.STY_ID%TYPE;
143:
144: l_rule_name OKL_CASH_ALLCTN_RLS.NAME%TYPE DEFAULT NULL;
145:
146: l_check_cau_id OKL_CSH_ALLCTN_RL_HDR.ID%TYPE DEFAULT NULL;
147: l_cau_id OKL_CSH_ALLCTN_RL_HDR.ID%TYPE DEFAULT NULL;
148: l_cat_id OKL_CASH_ALLCTN_RLS.ID%TYPE DEFAULT NULL;

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

144: l_rule_name OKL_CASH_ALLCTN_RLS.NAME%TYPE DEFAULT NULL;
145:
146: l_check_cau_id OKL_CSH_ALLCTN_RL_HDR.ID%TYPE DEFAULT NULL;
147: l_cau_id OKL_CSH_ALLCTN_RL_HDR.ID%TYPE DEFAULT NULL;
148: l_cat_id OKL_CASH_ALLCTN_RLS.ID%TYPE DEFAULT NULL;
149: l_tolerance OKL_CASH_ALLCTN_RLS.AMOUNT_TOLERANCE_PERCENT%TYPE DEFAULT NULL;
150: l_days_past_quote_valid OKL_CASH_ALLCTN_RLS.DAYS_PAST_QUOTE_VALID_TOLERANC%TYPE DEFAULT NULL;
151: l_months_to_bill_ahead OKL_CASH_ALLCTN_RLS.MONTHS_TO_BILL_AHEAD%TYPE DEFAULT NULL;
152: l_under_payment OKL_CASH_ALLCTN_RLS.UNDER_PAYMENT_ALLOCATION_CODE%TYPE DEFAULT NULL;

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

145:
146: l_check_cau_id OKL_CSH_ALLCTN_RL_HDR.ID%TYPE DEFAULT NULL;
147: l_cau_id OKL_CSH_ALLCTN_RL_HDR.ID%TYPE DEFAULT NULL;
148: l_cat_id OKL_CASH_ALLCTN_RLS.ID%TYPE DEFAULT NULL;
149: l_tolerance OKL_CASH_ALLCTN_RLS.AMOUNT_TOLERANCE_PERCENT%TYPE DEFAULT NULL;
150: l_days_past_quote_valid OKL_CASH_ALLCTN_RLS.DAYS_PAST_QUOTE_VALID_TOLERANC%TYPE DEFAULT NULL;
151: l_months_to_bill_ahead OKL_CASH_ALLCTN_RLS.MONTHS_TO_BILL_AHEAD%TYPE DEFAULT NULL;
152: l_under_payment OKL_CASH_ALLCTN_RLS.UNDER_PAYMENT_ALLOCATION_CODE%TYPE DEFAULT NULL;
153: l_over_payment OKL_CASH_ALLCTN_RLS.OVER_PAYMENT_ALLOCATION_CODE%TYPE DEFAULT NULL;

Line 150: l_days_past_quote_valid OKL_CASH_ALLCTN_RLS.DAYS_PAST_QUOTE_VALID_TOLERANC%TYPE DEFAULT NULL;

146: l_check_cau_id OKL_CSH_ALLCTN_RL_HDR.ID%TYPE DEFAULT NULL;
147: l_cau_id OKL_CSH_ALLCTN_RL_HDR.ID%TYPE DEFAULT NULL;
148: l_cat_id OKL_CASH_ALLCTN_RLS.ID%TYPE DEFAULT NULL;
149: l_tolerance OKL_CASH_ALLCTN_RLS.AMOUNT_TOLERANCE_PERCENT%TYPE DEFAULT NULL;
150: l_days_past_quote_valid OKL_CASH_ALLCTN_RLS.DAYS_PAST_QUOTE_VALID_TOLERANC%TYPE DEFAULT NULL;
151: l_months_to_bill_ahead OKL_CASH_ALLCTN_RLS.MONTHS_TO_BILL_AHEAD%TYPE DEFAULT NULL;
152: l_under_payment OKL_CASH_ALLCTN_RLS.UNDER_PAYMENT_ALLOCATION_CODE%TYPE DEFAULT NULL;
153: l_over_payment OKL_CASH_ALLCTN_RLS.OVER_PAYMENT_ALLOCATION_CODE%TYPE DEFAULT NULL;
154: l_receipt_msmtch OKL_CASH_ALLCTN_RLS.RECEIPT_MSMTCH_ALLOCATION_CODE%TYPE DEFAULT NULL;

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

147: l_cau_id OKL_CSH_ALLCTN_RL_HDR.ID%TYPE DEFAULT NULL;
148: l_cat_id OKL_CASH_ALLCTN_RLS.ID%TYPE DEFAULT NULL;
149: l_tolerance OKL_CASH_ALLCTN_RLS.AMOUNT_TOLERANCE_PERCENT%TYPE DEFAULT NULL;
150: l_days_past_quote_valid OKL_CASH_ALLCTN_RLS.DAYS_PAST_QUOTE_VALID_TOLERANC%TYPE DEFAULT NULL;
151: l_months_to_bill_ahead OKL_CASH_ALLCTN_RLS.MONTHS_TO_BILL_AHEAD%TYPE DEFAULT NULL;
152: l_under_payment OKL_CASH_ALLCTN_RLS.UNDER_PAYMENT_ALLOCATION_CODE%TYPE DEFAULT NULL;
153: l_over_payment OKL_CASH_ALLCTN_RLS.OVER_PAYMENT_ALLOCATION_CODE%TYPE DEFAULT NULL;
154: l_receipt_msmtch OKL_CASH_ALLCTN_RLS.RECEIPT_MSMTCH_ALLOCATION_CODE%TYPE DEFAULT NULL;
155:

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

148: l_cat_id OKL_CASH_ALLCTN_RLS.ID%TYPE DEFAULT NULL;
149: l_tolerance OKL_CASH_ALLCTN_RLS.AMOUNT_TOLERANCE_PERCENT%TYPE DEFAULT NULL;
150: l_days_past_quote_valid OKL_CASH_ALLCTN_RLS.DAYS_PAST_QUOTE_VALID_TOLERANC%TYPE DEFAULT NULL;
151: l_months_to_bill_ahead OKL_CASH_ALLCTN_RLS.MONTHS_TO_BILL_AHEAD%TYPE DEFAULT NULL;
152: l_under_payment OKL_CASH_ALLCTN_RLS.UNDER_PAYMENT_ALLOCATION_CODE%TYPE DEFAULT NULL;
153: l_over_payment OKL_CASH_ALLCTN_RLS.OVER_PAYMENT_ALLOCATION_CODE%TYPE DEFAULT NULL;
154: l_receipt_msmtch OKL_CASH_ALLCTN_RLS.RECEIPT_MSMTCH_ALLOCATION_CODE%TYPE DEFAULT NULL;
155:
156: l_dflt_name OKL_CASH_ALLCTN_RLS.NAME%TYPE DEFAULT NULL;

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

149: l_tolerance OKL_CASH_ALLCTN_RLS.AMOUNT_TOLERANCE_PERCENT%TYPE DEFAULT NULL;
150: l_days_past_quote_valid OKL_CASH_ALLCTN_RLS.DAYS_PAST_QUOTE_VALID_TOLERANC%TYPE DEFAULT NULL;
151: l_months_to_bill_ahead OKL_CASH_ALLCTN_RLS.MONTHS_TO_BILL_AHEAD%TYPE DEFAULT NULL;
152: l_under_payment OKL_CASH_ALLCTN_RLS.UNDER_PAYMENT_ALLOCATION_CODE%TYPE DEFAULT NULL;
153: l_over_payment OKL_CASH_ALLCTN_RLS.OVER_PAYMENT_ALLOCATION_CODE%TYPE DEFAULT NULL;
154: l_receipt_msmtch OKL_CASH_ALLCTN_RLS.RECEIPT_MSMTCH_ALLOCATION_CODE%TYPE DEFAULT NULL;
155:
156: l_dflt_name OKL_CASH_ALLCTN_RLS.NAME%TYPE DEFAULT NULL;
157:

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

150: l_days_past_quote_valid OKL_CASH_ALLCTN_RLS.DAYS_PAST_QUOTE_VALID_TOLERANC%TYPE DEFAULT NULL;
151: l_months_to_bill_ahead OKL_CASH_ALLCTN_RLS.MONTHS_TO_BILL_AHEAD%TYPE DEFAULT NULL;
152: l_under_payment OKL_CASH_ALLCTN_RLS.UNDER_PAYMENT_ALLOCATION_CODE%TYPE DEFAULT NULL;
153: l_over_payment OKL_CASH_ALLCTN_RLS.OVER_PAYMENT_ALLOCATION_CODE%TYPE DEFAULT NULL;
154: l_receipt_msmtch OKL_CASH_ALLCTN_RLS.RECEIPT_MSMTCH_ALLOCATION_CODE%TYPE DEFAULT NULL;
155:
156: l_dflt_name OKL_CASH_ALLCTN_RLS.NAME%TYPE DEFAULT NULL;
157:
158: l_dflt_cat_id OKL_CASH_ALLCTN_RLS.ID%TYPE DEFAULT NULL;

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

152: l_under_payment OKL_CASH_ALLCTN_RLS.UNDER_PAYMENT_ALLOCATION_CODE%TYPE DEFAULT NULL;
153: l_over_payment OKL_CASH_ALLCTN_RLS.OVER_PAYMENT_ALLOCATION_CODE%TYPE DEFAULT NULL;
154: l_receipt_msmtch OKL_CASH_ALLCTN_RLS.RECEIPT_MSMTCH_ALLOCATION_CODE%TYPE DEFAULT NULL;
155:
156: l_dflt_name OKL_CASH_ALLCTN_RLS.NAME%TYPE DEFAULT NULL;
157:
158: l_dflt_cat_id OKL_CASH_ALLCTN_RLS.ID%TYPE DEFAULT NULL;
159: l_dflt_tolerance OKL_CASH_ALLCTN_RLS.AMOUNT_TOLERANCE_PERCENT%TYPE DEFAULT NULL;
160: l_dflt_days_past_quote_valid OKL_CASH_ALLCTN_RLS.DAYS_PAST_QUOTE_VALID_TOLERANC%TYPE DEFAULT NULL;

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

154: l_receipt_msmtch OKL_CASH_ALLCTN_RLS.RECEIPT_MSMTCH_ALLOCATION_CODE%TYPE DEFAULT NULL;
155:
156: l_dflt_name OKL_CASH_ALLCTN_RLS.NAME%TYPE DEFAULT NULL;
157:
158: l_dflt_cat_id OKL_CASH_ALLCTN_RLS.ID%TYPE DEFAULT NULL;
159: l_dflt_tolerance OKL_CASH_ALLCTN_RLS.AMOUNT_TOLERANCE_PERCENT%TYPE DEFAULT NULL;
160: l_dflt_days_past_quote_valid OKL_CASH_ALLCTN_RLS.DAYS_PAST_QUOTE_VALID_TOLERANC%TYPE DEFAULT NULL;
161: l_dflt_months_to_bill_ahead OKL_CASH_ALLCTN_RLS.MONTHS_TO_BILL_AHEAD%TYPE DEFAULT NULL;
162: l_dflt_under_payment OKL_CASH_ALLCTN_RLS.UNDER_PAYMENT_ALLOCATION_CODE%TYPE DEFAULT NULL;

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

155:
156: l_dflt_name OKL_CASH_ALLCTN_RLS.NAME%TYPE DEFAULT NULL;
157:
158: l_dflt_cat_id OKL_CASH_ALLCTN_RLS.ID%TYPE DEFAULT NULL;
159: l_dflt_tolerance OKL_CASH_ALLCTN_RLS.AMOUNT_TOLERANCE_PERCENT%TYPE DEFAULT NULL;
160: l_dflt_days_past_quote_valid OKL_CASH_ALLCTN_RLS.DAYS_PAST_QUOTE_VALID_TOLERANC%TYPE DEFAULT NULL;
161: l_dflt_months_to_bill_ahead OKL_CASH_ALLCTN_RLS.MONTHS_TO_BILL_AHEAD%TYPE DEFAULT NULL;
162: l_dflt_under_payment OKL_CASH_ALLCTN_RLS.UNDER_PAYMENT_ALLOCATION_CODE%TYPE DEFAULT NULL;
163: l_dflt_over_payment OKL_CASH_ALLCTN_RLS.OVER_PAYMENT_ALLOCATION_CODE%TYPE DEFAULT NULL;

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

156: l_dflt_name OKL_CASH_ALLCTN_RLS.NAME%TYPE DEFAULT NULL;
157:
158: l_dflt_cat_id OKL_CASH_ALLCTN_RLS.ID%TYPE DEFAULT NULL;
159: l_dflt_tolerance OKL_CASH_ALLCTN_RLS.AMOUNT_TOLERANCE_PERCENT%TYPE DEFAULT NULL;
160: l_dflt_days_past_quote_valid OKL_CASH_ALLCTN_RLS.DAYS_PAST_QUOTE_VALID_TOLERANC%TYPE DEFAULT NULL;
161: l_dflt_months_to_bill_ahead OKL_CASH_ALLCTN_RLS.MONTHS_TO_BILL_AHEAD%TYPE DEFAULT NULL;
162: l_dflt_under_payment OKL_CASH_ALLCTN_RLS.UNDER_PAYMENT_ALLOCATION_CODE%TYPE DEFAULT NULL;
163: l_dflt_over_payment OKL_CASH_ALLCTN_RLS.OVER_PAYMENT_ALLOCATION_CODE%TYPE DEFAULT NULL;
164: l_dflt_receipt_msmtch OKL_CASH_ALLCTN_RLS.RECEIPT_MSMTCH_ALLOCATION_CODE%TYPE DEFAULT NULL;

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

157:
158: l_dflt_cat_id OKL_CASH_ALLCTN_RLS.ID%TYPE DEFAULT NULL;
159: l_dflt_tolerance OKL_CASH_ALLCTN_RLS.AMOUNT_TOLERANCE_PERCENT%TYPE DEFAULT NULL;
160: l_dflt_days_past_quote_valid OKL_CASH_ALLCTN_RLS.DAYS_PAST_QUOTE_VALID_TOLERANC%TYPE DEFAULT NULL;
161: l_dflt_months_to_bill_ahead OKL_CASH_ALLCTN_RLS.MONTHS_TO_BILL_AHEAD%TYPE DEFAULT NULL;
162: l_dflt_under_payment OKL_CASH_ALLCTN_RLS.UNDER_PAYMENT_ALLOCATION_CODE%TYPE DEFAULT NULL;
163: l_dflt_over_payment OKL_CASH_ALLCTN_RLS.OVER_PAYMENT_ALLOCATION_CODE%TYPE DEFAULT NULL;
164: l_dflt_receipt_msmtch OKL_CASH_ALLCTN_RLS.RECEIPT_MSMTCH_ALLOCATION_CODE%TYPE DEFAULT NULL;
165: l_sequence_number OKL_STRM_TYP_ALLOCS.SEQUENCE_NUMBER%TYPE DEFAULT NULL;

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

158: l_dflt_cat_id OKL_CASH_ALLCTN_RLS.ID%TYPE DEFAULT NULL;
159: l_dflt_tolerance OKL_CASH_ALLCTN_RLS.AMOUNT_TOLERANCE_PERCENT%TYPE DEFAULT NULL;
160: l_dflt_days_past_quote_valid OKL_CASH_ALLCTN_RLS.DAYS_PAST_QUOTE_VALID_TOLERANC%TYPE DEFAULT NULL;
161: l_dflt_months_to_bill_ahead OKL_CASH_ALLCTN_RLS.MONTHS_TO_BILL_AHEAD%TYPE DEFAULT NULL;
162: l_dflt_under_payment OKL_CASH_ALLCTN_RLS.UNDER_PAYMENT_ALLOCATION_CODE%TYPE DEFAULT NULL;
163: l_dflt_over_payment OKL_CASH_ALLCTN_RLS.OVER_PAYMENT_ALLOCATION_CODE%TYPE DEFAULT NULL;
164: l_dflt_receipt_msmtch OKL_CASH_ALLCTN_RLS.RECEIPT_MSMTCH_ALLOCATION_CODE%TYPE DEFAULT NULL;
165: l_sequence_number OKL_STRM_TYP_ALLOCS.SEQUENCE_NUMBER%TYPE DEFAULT NULL;
166:

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

159: l_dflt_tolerance OKL_CASH_ALLCTN_RLS.AMOUNT_TOLERANCE_PERCENT%TYPE DEFAULT NULL;
160: l_dflt_days_past_quote_valid OKL_CASH_ALLCTN_RLS.DAYS_PAST_QUOTE_VALID_TOLERANC%TYPE DEFAULT NULL;
161: l_dflt_months_to_bill_ahead OKL_CASH_ALLCTN_RLS.MONTHS_TO_BILL_AHEAD%TYPE DEFAULT NULL;
162: l_dflt_under_payment OKL_CASH_ALLCTN_RLS.UNDER_PAYMENT_ALLOCATION_CODE%TYPE DEFAULT NULL;
163: l_dflt_over_payment OKL_CASH_ALLCTN_RLS.OVER_PAYMENT_ALLOCATION_CODE%TYPE DEFAULT NULL;
164: l_dflt_receipt_msmtch OKL_CASH_ALLCTN_RLS.RECEIPT_MSMTCH_ALLOCATION_CODE%TYPE DEFAULT NULL;
165: l_sequence_number OKL_STRM_TYP_ALLOCS.SEQUENCE_NUMBER%TYPE DEFAULT NULL;
166:
167: l_dup_rcpt_flag NUMBER DEFAULT NULL;

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

160: l_dflt_days_past_quote_valid OKL_CASH_ALLCTN_RLS.DAYS_PAST_QUOTE_VALID_TOLERANC%TYPE DEFAULT NULL;
161: l_dflt_months_to_bill_ahead OKL_CASH_ALLCTN_RLS.MONTHS_TO_BILL_AHEAD%TYPE DEFAULT NULL;
162: l_dflt_under_payment OKL_CASH_ALLCTN_RLS.UNDER_PAYMENT_ALLOCATION_CODE%TYPE DEFAULT NULL;
163: l_dflt_over_payment OKL_CASH_ALLCTN_RLS.OVER_PAYMENT_ALLOCATION_CODE%TYPE DEFAULT NULL;
164: l_dflt_receipt_msmtch OKL_CASH_ALLCTN_RLS.RECEIPT_MSMTCH_ALLOCATION_CODE%TYPE DEFAULT NULL;
165: l_sequence_number OKL_STRM_TYP_ALLOCS.SEQUENCE_NUMBER%TYPE DEFAULT NULL;
166:
167: l_dup_rcpt_flag NUMBER DEFAULT NULL;
168: l_create_receipt_flag VARCHAR2(2) DEFAULT p_create_receipt_flag;

Line 454: FROM OKL_CASH_ALLCTN_RLS

450: ,MONTHS_TO_BILL_AHEAD
451: ,UNDER_PAYMENT_ALLOCATION_CODE
452: ,OVER_PAYMENT_ALLOCATION_CODE
453: ,RECEIPT_MSMTCH_ALLOCATION_CODE
454: FROM OKL_CASH_ALLCTN_RLS
455: WHERE CAU_ID = cp_cau_id
456: AND START_DATE <= trunc(SYSDATE)
457: AND (END_DATE >= trunc(SYSDATE) OR END_DATE IS NULL);
458:

Line 471: FROM OKL_CASH_ALLCTN_RLS

467: ,MONTHS_TO_BILL_AHEAD
468: ,UNDER_PAYMENT_ALLOCATION_CODE
469: ,OVER_PAYMENT_ALLOCATION_CODE
470: ,RECEIPT_MSMTCH_ALLOCATION_CODE
471: FROM OKL_CASH_ALLCTN_RLS
472: WHERE default_rule = 'YES'
473: AND TRUNC(end_date) IS NULL;
474:
475: