APPS.AR_RECEIPT_API_PUB dependencies on AR_CREATE_RECEIPTS_GT

Line 11335: from ar_create_receipts_gt

11331: SET last_update_date = sysdate,
11332: request_id = p_request_id
11333: WHERE cash_receipt_id in
11334: ( select cash_receipt_id
11335: from ar_create_receipts_gt
11336: where gt_id = p_gt_id
11337: and request_id = p_request_id
11338: and return_error_status = 'S'
11339: and org_id = p_org_id );

Line 11351: from ar_create_receipts_gt

11347: last_update_date = sysdate,
11348: request_id = p_request_id
11349: WHERE cash_receipt_id in
11350: ( select cash_receipt_id
11351: from ar_create_receipts_gt
11352: where gt_id = p_gt_id
11353: and request_id = p_request_id
11354: and return_error_status = 'S'
11355: and org_id = p_org_id );

Line 11366: from ar_create_receipts_gt

11362: last_update_date = sysdate,
11363: request_id = p_request_id
11364: WHERE cash_receipt_id in
11365: ( select cash_receipt_id
11366: from ar_create_receipts_gt
11367: where gt_id = p_gt_id
11368: and request_id = p_request_id
11369: and return_error_status = 'S'
11370: and org_id = p_org_id );

Line 11381: from ar_create_receipts_gt

11377: last_update_date = sysdate,
11378: request_id = p_request_id
11379: WHERE cash_receipt_id in
11380: ( select cash_receipt_id
11381: from ar_create_receipts_gt
11382: where gt_id = p_gt_id
11383: and request_id = p_request_id
11384: and return_error_status = 'S'
11385: and org_id = p_org_id );

Line 11392: select /*+ LEADING (GT) INDEX (GT AR_CREATE_RECEIPTS_GT_N2) USE_NL(GT RA)

11388: arp_standard.debug ( 'NO of RA updated = '|| to_char(SQL%ROWCOUNT));
11389: END IF;
11390:
11391:
11392: select /*+ LEADING (GT) INDEX (GT AR_CREATE_RECEIPTS_GT_N2) USE_NL(GT RA)
11393: INDEX (RA AR_RECEIVABLE_APPLICATIONS_N1) */
11394: min(gt.cash_receipt_id),
11395: max(gt.cash_receipt_id),
11396: min(ra.receivable_application_id),

Line 11402: from ar_create_receipts_gt gt, ar_receivable_applications ra

11398: into l_from_doc_id,
11399: l_to_doc_id,
11400: l_from_ra_doc_id,
11401: l_to_ra_doc_id
11402: from ar_create_receipts_gt gt, ar_receivable_applications ra
11403: where gt.cash_receipt_id = ra.cash_receipt_id
11404: AND gt_id = p_gt_id
11405: and gt.request_id = p_request_id
11406: and return_error_status = 'S'

Line 11462: | Before calling this routine customer has to populate AR_CREATE_RECEIPTS_GT

11458: | PROCEDURE Create_Cash_Bulk
11459: |
11460: | DESCRIPTION
11461: | This procedure is for calling Create_Cash routine in BULK mode.
11462: | Before calling this routine customer has to populate AR_CREATE_RECEIPTS_GT
11463: | After successful completion of thei procedure customer has to query
11464: | AR_CREATE_RECEIPTS_ERROR table to get the error records.
11465: |
11466: |

Line 11547: TYPE rcpt_info_rec IS TABLE OF ar_create_receipts_gt%rowtype INDEX BY BINARY_INTEGER;

11543: LAST_UPDATED_BY DBMS_SQL.NUMBER_TABLE );
11544:
11545: l_rcpt_error_info_tab rcpt_error_info_rec;
11546:
11547: TYPE rcpt_info_rec IS TABLE OF ar_create_receipts_gt%rowtype INDEX BY BINARY_INTEGER;
11548: l_rcpt_info_tab rcpt_info_rec;
11549:
11550: CURSOR org_cur IS
11551: SELECT org_id

Line 11552: FROM ar_create_receipts_gt

11548: l_rcpt_info_tab rcpt_info_rec;
11549:
11550: CURSOR org_cur IS
11551: SELECT org_id
11552: FROM ar_create_receipts_gt
11553: GROUP BY org_id;
11554:
11555: CURSOR create_rcpt_cursor(p_c_org_id NUMBER) IS
11556: SELECT *

Line 11557: FROM ar_create_receipts_gt

11553: GROUP BY org_id;
11554:
11555: CURSOR create_rcpt_cursor(p_c_org_id NUMBER) IS
11556: SELECT *
11557: FROM ar_create_receipts_gt
11558: WHERE org_id = p_c_org_id
11559: AND return_error_status IS NULL;
11560:
11561: l_attribute_rec attribute_rec_type;

Line 11852: UPDATE ar_create_receipts_gt

11848: END LOOP;
11849:
11850:
11851: FORALL j IN l_cash_receipt_info_rec.cash_receipt_id.FIRST..l_cash_receipt_info_rec.cash_receipt_id.LAST
11852: UPDATE ar_create_receipts_gt
11853: SET request_id = l_cash_receipt_info_rec.request_id(j),
11854: cash_receipt_id = l_cash_receipt_info_rec.cash_receipt_id(j),
11855: return_error_status = l_cash_receipt_info_rec.return_error_status(j),
11856: gt_id = l_cash_receipt_info_rec.gt_id(j)