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 86: UPDATE jai_ar_cash_receipts_all

82: pv_return_message := 'Either of Receipt Amount or customer details or currency details are changed. Delete the record using Tools Menu';
83: return;
84: END IF;
85:
86: UPDATE jai_ar_cash_receipts_all
87: SET cash_receipt_id = pr_new.cash_receipt_id,
88: temp_sequence_id = NULL
89: WHERE loc_cash_receipt_id = r_check_tmp_data.loc_cash_receipt_id;
90:

Line 95: AND source_table_name = 'JAI_AR_CASH_RECEIPTS_ALL';

91: UPDATE jai_cmn_document_taxes
92: SET source_doc_id = pr_new.cash_receipt_id,
93: source_doc_line_id = NULL
94: WHERE source_doc_line_id = r_check_tmp_data.loc_cash_receipt_id
95: AND source_table_name = 'JAI_AR_CASH_RECEIPTS_ALL';
96:
97: IF r_check_tmp_data.confirm_flag = 'Y' THEN
98: jai_ar_cr_pkg.process_cm_dm(
99: p_event => jai_constants.trx_type_adv_rcpts,--Changed by Qiong from ar_cash_tax_confirmed to trx_type_adv_rcpts for bug13569249

Line 140: FROM jai_ar_cash_receipts_all

136:
137: CURSOR c_ar_cash_receipts(cp_cash_receipt_id NUMBER)
138: IS
139: SELECT confirm_flag
140: FROM jai_ar_cash_receipts_all
141: WHERE cash_receipt_id = cp_cash_receipt_id;
142:
143: r_ar_cash_receipts c_ar_cash_receipts%ROWTYPE;
144: lv_process_flag VARCHAR2(2);

Line 159: WHERE source_table_name = 'JAI_AR_CASH_RECEIPTS_ALL'

155:
156: IF NVL(r_ar_cash_receipts.confirm_flag,'N') IN ('N','I') THEN
157:
158: DELETE jai_cmn_document_taxes
159: WHERE source_table_name = 'JAI_AR_CASH_RECEIPTS_ALL'
160: AND source_doc_id = pr_old.cash_receipt_id;
161:
162: DELETE jai_ar_cash_receipts_all
163: WHERE cash_receipt_id = pr_old.cash_receipt_id;

Line 162: DELETE jai_ar_cash_receipts_all

158: DELETE jai_cmn_document_taxes
159: WHERE source_table_name = 'JAI_AR_CASH_RECEIPTS_ALL'
160: AND source_doc_id = pr_old.cash_receipt_id;
161:
162: DELETE jai_ar_cash_receipts_all
163: WHERE cash_receipt_id = pr_old.cash_receipt_id;
164: ELSE
165: IF pr_old.reversal_date IS NULL AND pr_new.reversal_date is NOT NULL THEN
166:

Line 207: FROM jai_ar_cash_receipts_all

203:
204: CURSOR c_ar_cash_receipts(cp_cash_receipt_id NUMBER)
205: IS
206: SELECT confirm_flag
207: FROM jai_ar_cash_receipts_all
208: WHERE cash_receipt_id = cp_cash_receipt_id;
209:
210: r_ar_cash_receipts c_ar_cash_receipts%ROWTYPE;
211: lv_process_flag VARCHAR2(2);

Line 221: WHERE source_table_name = 'JAI_AR_CASH_RECEIPTS_ALL'

217: CLOSE c_ar_cash_receipts;
218:
219: IF NVL(r_ar_cash_receipts.confirm_flag,'N') IN ('N','I') THEN
220: DELETE jai_cmn_document_taxes
221: WHERE source_table_name = 'JAI_AR_CASH_RECEIPTS_ALL'
222: AND source_doc_id = pr_old.cash_receipt_id;
223:
224: DELETE jai_ar_cash_receipts_all
225: WHERE cash_receipt_id = pr_old.cash_receipt_id;

Line 224: DELETE jai_ar_cash_receipts_all

220: DELETE jai_cmn_document_taxes
221: WHERE source_table_name = 'JAI_AR_CASH_RECEIPTS_ALL'
222: AND source_doc_id = pr_old.cash_receipt_id;
223:
224: DELETE jai_ar_cash_receipts_all
225: WHERE cash_receipt_id = pr_old.cash_receipt_id;
226: ELSE
227: --raise_application_error(-20011, 'You can''t delete this receipt. Reverse the receipt');
228: pv_return_code := jai_constants.expected_error;