APPS.AR_PUBLIC_UTILS dependencies on AR_CASH_RECEIPTS

Line 53: ar_cash_receipts.payment_server_order_num%TYPE,

49: |
50: *=======================================================================*/
51: PROCEDURE get_payment_info(
52: p_payment_server_order_num IN
53: ar_cash_receipts.payment_server_order_num%TYPE,
54: p_application_type IN ar_receivable_applications.status%TYPE DEFAULT 'APP',
55: p_receipt_header OUT NOCOPY ar_cash_receipts%ROWTYPE,
56: p_app_rec OUT NOCOPY application_tbl_type,
57: x_return_status OUT NOCOPY VARCHAR2,

Line 55: p_receipt_header OUT NOCOPY ar_cash_receipts%ROWTYPE,

51: PROCEDURE get_payment_info(
52: p_payment_server_order_num IN
53: ar_cash_receipts.payment_server_order_num%TYPE,
54: p_application_type IN ar_receivable_applications.status%TYPE DEFAULT 'APP',
55: p_receipt_header OUT NOCOPY ar_cash_receipts%ROWTYPE,
56: p_app_rec OUT NOCOPY application_tbl_type,
57: x_return_status OUT NOCOPY VARCHAR2,
58: x_msg_count OUT NOCOPY NUMBER,
59: x_msg_data OUT NOCOPY VARCHAR2

Line 62: CURSOR app_rec_cur(c_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE) IS

58: x_msg_count OUT NOCOPY NUMBER,
59: x_msg_data OUT NOCOPY VARCHAR2
60: ) IS
61:
62: CURSOR app_rec_cur(c_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE) IS
63: SELECT *
64: FROM ar_receivable_applications
65: WHERE cash_receipt_id=c_cash_receipt_id
66: AND status = p_application_type

Line 69: l_receipt_header ar_cash_receipts%ROWTYPE;

65: WHERE cash_receipt_id=c_cash_receipt_id
66: AND status = p_application_type
67: AND display='Y';
68:
69: l_receipt_header ar_cash_receipts%ROWTYPE;
70: l_payment_server_order_num ar_cash_receipts.payment_server_order_num%TYPE;
71: table_index NUMBER := 1;
72:
73: BEGIN

Line 70: l_payment_server_order_num ar_cash_receipts.payment_server_order_num%TYPE;

66: AND status = p_application_type
67: AND display='Y';
68:
69: l_receipt_header ar_cash_receipts%ROWTYPE;
70: l_payment_server_order_num ar_cash_receipts.payment_server_order_num%TYPE;
71: table_index NUMBER := 1;
72:
73: BEGIN
74: arp_util.debug('ar_public_utils.get_payment_info (+)');

Line 81: FROM ar_cash_receipts cr

77: IF p_payment_server_order_num IS NOT NULL THEN
78:
79: SELECT cr.*
80: INTO l_receipt_header
81: FROM ar_cash_receipts cr
82: WHERE cr.payment_server_order_num=p_payment_server_order_num
83: AND EXISTS (SELECT status from ar_cash_receipt_history crh
84: WHERE crh.status = 'REMITTED'
85: AND crh.cash_receipt_id=cr.cash_receipt_id);