APPS.JAI_AR_RCTA_TRIGGER_PKG dependencies on JAI_AR_TRX_COPY_HDR_T

Line 176: Insert Into JAI_AR_TRX_COPY_HDR_T

172: IF NVL(v_trans_type,'N') NOT IN('CM','INV','DM') THEN
173: Return;
174: END IF;
175: IF pr_new.created_from = 'ARXREC' THEN
176: Insert Into JAI_AR_TRX_COPY_HDR_T
177: (TRX_NUMBER, CUSTOMER_TRX_ID, RECURRED_FROM_TRX_NUMBER, BATCH_SOURCE_ID,
178: CREATED_FROM, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE,
179: LAST_UPDATED_BY, LAST_UPDATE_LOGIN )
180: VALUES

Line 4538: FROM JAI_AR_TRX_COPY_HDR_T

4534:
4535: CURSOR temp_fetch IS
4536: SELECT trx_number, customer_trx_id, recurred_from_trx_number, batch_source_id, created_from,
4537: creation_date, created_by, last_update_date, last_updated_by, last_update_login
4538: FROM JAI_AR_TRX_COPY_HDR_T
4539: ORDER BY customer_trx_id;
4540:
4541: CURSOR ONCE_COMPLETE_FLAG_CUR(p_header_id IN NUMBER, p_batch_source_id IN Number) IS
4542: SELECT once_completed_flag, 1

Line 4589: DELETE JAI_AR_TRX_COPY_HDR_T

4585: v_created_from, v_creation_date, v_created_by,
4586: v_last_update_date, v_last_updated_by, v_last_update_login;
4587: CLOSE temp_fetch;
4588:
4589: DELETE JAI_AR_TRX_COPY_HDR_T
4590: WHERE customer_trx_id = v_header_id;
4591:
4592: IF v_trx_number IS NULL THEN
4593: Return;