DBA Data[Home] [Help]

APPS.AR_AUTOREC_API dependencies on AR_RECEIPT_CLASSES

Line 88: l_receipt_class_id ar_receipt_classes.receipt_class_id%TYPE ;

84:
85: l_request_id ar_cash_receipts.request_id%TYPE;
86: l_gl_date ar_cash_receipt_history.gl_date%TYPE;
87: l_batch_date ar_cash_receipts.receipt_date%TYPE ;
88: l_receipt_class_id ar_receipt_classes.receipt_class_id%TYPE ;
89: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE ;
90: l_currency_code ar_cash_receipts.currency_code%TYPE;
91: l_approve_flag ar_cash_receipts.confirmed_flag%TYPE ;
92: l_format_flag ar_cash_receipts.confirmed_flag%TYPE ;

Line 496: from ar_receipt_classes rc,

492:
493: select decode(rc.confirm_flag,'Y','AUTORECAPI',null),nvl(rm.RECEIPT_CREATION_RULE_CODE,'MANUAL')
494: ,nvl(rm.receipt_inherit_inv_num_flag,'N')
495: INTO l_called_from,l_rec_creation_rule_code,l_rec_inher_inv_num_flag
496: from ar_receipt_classes rc,
497: ar_receipt_methods rm
498: where rm.receipt_method_id = l_receipt_method_id
499: and rm.receipt_class_id = rc.receipt_class_id;
500:

Line 997: p_receipt_class_id IN ar_receipt_classes.receipt_class_id%TYPE DEFAULT NULL,

993:
994: PROCEDURE insert_batch(
995: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
996: p_batch_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
997: p_receipt_class_id IN ar_receipt_classes.receipt_class_id%TYPE DEFAULT NULL,
998: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
999: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,
1000: p_approve_flag IN ar_cash_receipts.confirmed_flag%TYPE DEFAULT NULL,
1001: p_format_flag IN ar_cash_receipts.confirmed_flag%TYPE DEFAULT NULL,

Line 1804: FROM ar_receipt_classes

1800:
1801:
1802: SELECT decode( confirm_flag, 'Y','AUTORECAPI',null)
1803: INTO l_called_from
1804: FROM ar_receipt_classes
1805: WHERE receipt_class_id = l_receipt_class_id;
1806:
1807:
1808: