DBA Data[Home] [Help]

APPS.AR_AUTOREM_API dependencies on AR_CASH_RECEIPTS_ALL

Line 3656: l_cr_rec ar_cash_receipts_all%ROWTYPE;

3652: AND cr.receipt_method_id = rm.receipt_method_id
3653: AND rm.receipt_class_id = rc.receipt_class_id;
3654:
3655: -- rct_info rct_info_cur%ROWTYPE;
3656: l_cr_rec ar_cash_receipts_all%ROWTYPE;
3657: l_org_type HR_ALL_ORGANIZATION_UNITS.TYPE%TYPE;
3658: l_action VARCHAR2(80);
3659: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3660: l_msg_count NUMBER;

Line 4401: CURSOR rct_date_cur (c_cash_receipt_id ar_cash_receipts_all.cash_receipt_id%TYPE)

4397: AND a.current_worker = WORKER_NUMBER;
4398:
4399:
4400: /*Bug 7666285*/
4401: CURSOR rct_date_cur (c_cash_receipt_id ar_cash_receipts_all.cash_receipt_id%TYPE)
4402: IS
4403: SELECT receipt_date
4404: FROM ar_cash_receipts
4405: WHERE cash_receipt_id = c_cash_receipt_id;

Line 4410: l_cr_rec ar_cash_receipts_all%ROWTYPE;

4406:
4407:
4408:
4409: -- rct_info rct_info_cur%ROWTYPE;
4410: l_cr_rec ar_cash_receipts_all%ROWTYPE;
4411: l_org_type HR_ALL_ORGANIZATION_UNITS.TYPE%TYPE;
4412: l_action VARCHAR2(80);
4413: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
4414: l_msg_count NUMBER;

Line 4425: l_receipt_date ar_cash_receipts_all.receipt_date%TYPE; /*Bug7666285*/

4421: l_amount_rec IBY_FNDCPT_TRXN_PUB.Amount_rec_type;
4422: l_payer_rec IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type;
4423: l_response_rec IBY_FNDCPT_COMMON_PUB.Result_rec_type; /* OUT RESPONSE STRUCTURE */
4424:
4425: l_receipt_date ar_cash_receipts_all.receipt_date%TYPE; /*Bug7666285*/
4426:
4427: /* DECLARE the variables required for the payment engine (AUTH) all the REC TYPES */
4428:
4429: l_payee_rec IBY_FNDCPT_TRXN_PUB.PayeeContext_rec_type;