APPS.JAI_AR_CR_TRIGGER_PKG dependencies on AR_CASH_RECEIPTS_ALL

Line 24: FROM JAI_AR_CASH_RECEIPTS_ALL

20: CUSTOMER_ID,
21: CONFIRM_FLAG,
22: CURRENCY_CODE,
23: EXCHANGE_RATE
24: FROM JAI_AR_CASH_RECEIPTS_ALL
25: WHERE TEMP_SEQUENCE_ID = PN_TEMP_SEQUENCE_ID
26: AND CASH_RECEIPT_ID IS NULL;
27:
28: r_check_tmp_data c_check_tmp_data%ROWTYPE;

Line 62: UPDATE jai_ar_cash_receipts_all

58: pv_return_message := 'Either of Receipt Amount or customer details or currency details are changed. Delete the record using Tools Menu';
59: return;
60: END IF;
61:
62: UPDATE jai_ar_cash_receipts_all
63: SET cash_receipt_id = pr_new.cash_receipt_id,
64: temp_sequence_id = NULL
65: WHERE loc_cash_receipt_id = r_check_tmp_data.loc_cash_receipt_id;
66:

Line 71: AND source_table_name = 'JAI_AR_CASH_RECEIPTS_ALL';

67: UPDATE jai_cmn_document_taxes
68: SET source_doc_id = pr_new.cash_receipt_id,
69: source_doc_line_id = NULL
70: WHERE source_doc_line_id = r_check_tmp_data.loc_cash_receipt_id
71: AND source_table_name = 'JAI_AR_CASH_RECEIPTS_ALL';
72:
73: IF r_check_tmp_data.confirm_flag = 'Y' THEN
74:
75: jai_ar_cr_pkg.process_cm_dm(

Line 116: FROM jai_ar_cash_receipts_all

112:
113: CURSOR c_ar_cash_receipts(cp_cash_receipt_id NUMBER)
114: IS
115: SELECT confirm_flag
116: FROM jai_ar_cash_receipts_all
117: WHERE cash_receipt_id = cp_cash_receipt_id;
118:
119: r_ar_cash_receipts c_ar_cash_receipts%ROWTYPE;
120: lv_process_flag VARCHAR2(2);

Line 135: WHERE source_table_name = 'JAI_AR_CASH_RECEIPTS_ALL'

131:
132: IF NVL(r_ar_cash_receipts.confirm_flag,'N') IN ('N','I') THEN
133:
134: DELETE jai_cmn_document_taxes
135: WHERE source_table_name = 'JAI_AR_CASH_RECEIPTS_ALL'
136: AND source_doc_id = pr_old.cash_receipt_id;
137:
138: DELETE jai_ar_cash_receipts_all
139: WHERE cash_receipt_id = pr_old.cash_receipt_id;

Line 138: DELETE jai_ar_cash_receipts_all

134: DELETE jai_cmn_document_taxes
135: WHERE source_table_name = 'JAI_AR_CASH_RECEIPTS_ALL'
136: AND source_doc_id = pr_old.cash_receipt_id;
137:
138: DELETE jai_ar_cash_receipts_all
139: WHERE cash_receipt_id = pr_old.cash_receipt_id;
140: ELSE
141: IF pr_old.reversal_date IS NULL AND pr_new.reversal_date is NOT NULL THEN
142: jai_ar_cr_pkg.process_cm_dm(

Line 182: FROM jai_ar_cash_receipts_all

178:
179: CURSOR c_ar_cash_receipts(cp_cash_receipt_id NUMBER)
180: IS
181: SELECT confirm_flag
182: FROM jai_ar_cash_receipts_all
183: WHERE cash_receipt_id = cp_cash_receipt_id;
184:
185: r_ar_cash_receipts c_ar_cash_receipts%ROWTYPE;
186: lv_process_flag VARCHAR2(2);

Line 196: WHERE source_table_name = 'JAI_AR_CASH_RECEIPTS_ALL'

192: CLOSE c_ar_cash_receipts;
193:
194: IF NVL(r_ar_cash_receipts.confirm_flag,'N') IN ('N','I') THEN
195: DELETE jai_cmn_document_taxes
196: WHERE source_table_name = 'JAI_AR_CASH_RECEIPTS_ALL'
197: AND source_doc_id = pr_old.cash_receipt_id;
198:
199: DELETE jai_ar_cash_receipts_all
200: WHERE cash_receipt_id = pr_old.cash_receipt_id;

Line 199: DELETE jai_ar_cash_receipts_all

195: DELETE jai_cmn_document_taxes
196: WHERE source_table_name = 'JAI_AR_CASH_RECEIPTS_ALL'
197: AND source_doc_id = pr_old.cash_receipt_id;
198:
199: DELETE jai_ar_cash_receipts_all
200: WHERE cash_receipt_id = pr_old.cash_receipt_id;
201: ELSE
202: --raise_application_error(-20011, 'You can''t delete this receipt. Reverse the receipt');
203: pv_return_code := jai_constants.expected_error;