DBA Data[Home] [Help]

APPS.ARP_PROCESS_APPLICATION2 dependencies on AR_RECEIVABLE_APPLICATIONS

Line 12: ar_receivable_applications.application_ref_type%TYPE,

8: p_receipt_ps_id IN NUMBER,
9: p_invoice_ps_id IN NUMBER,
10: p_ussgl_transaction_code IN VARCHAR2,
11: p_application_ref_type IN
12: ar_receivable_applications.application_ref_type%TYPE,
13: p_application_ref_id IN
14: ar_receivable_applications.application_ref_id%TYPE,
15: p_application_ref_num IN
16: ar_receivable_applications.application_ref_num%TYPE,

Line 14: ar_receivable_applications.application_ref_id%TYPE,

10: p_ussgl_transaction_code IN VARCHAR2,
11: p_application_ref_type IN
12: ar_receivable_applications.application_ref_type%TYPE,
13: p_application_ref_id IN
14: ar_receivable_applications.application_ref_id%TYPE,
15: p_application_ref_num IN
16: ar_receivable_applications.application_ref_num%TYPE,
17: p_secondary_application_ref_id IN
18: ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,

Line 16: ar_receivable_applications.application_ref_num%TYPE,

12: ar_receivable_applications.application_ref_type%TYPE,
13: p_application_ref_id IN
14: ar_receivable_applications.application_ref_id%TYPE,
15: p_application_ref_num IN
16: ar_receivable_applications.application_ref_num%TYPE,
17: p_secondary_application_ref_id IN
18: ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
19: p_receivable_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE,
20: p_attribute_category IN VARCHAR2,

Line 18: ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,

14: ar_receivable_applications.application_ref_id%TYPE,
15: p_application_ref_num IN
16: ar_receivable_applications.application_ref_num%TYPE,
17: p_secondary_application_ref_id IN
18: ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
19: p_receivable_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE,
20: p_attribute_category IN VARCHAR2,
21: p_attribute1 IN VARCHAR2,
22: p_attribute2 IN VARCHAR2,

Line 19: p_receivable_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE,

15: p_application_ref_num IN
16: ar_receivable_applications.application_ref_num%TYPE,
17: p_secondary_application_ref_id IN
18: ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
19: p_receivable_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE,
20: p_attribute_category IN VARCHAR2,
21: p_attribute1 IN VARCHAR2,
22: p_attribute2 IN VARCHAR2,
23: p_attribute3 IN VARCHAR2,

Line 63: ar_receivable_applications.application_ref_id%TYPE,

59: p_customer_trx_line_id IN NUMBER,
60: p_module_name IN VARCHAR2,
61: p_module_version IN VARCHAR2,
62: x_application_ref_id OUT NOCOPY
63: ar_receivable_applications.application_ref_id%TYPE,
64: x_application_ref_num OUT NOCOPY
65: ar_receivable_applications.application_ref_num%TYPE,
66: x_return_status OUT NOCOPY VARCHAR2,
67: x_msg_count OUT NOCOPY NUMBER,

Line 65: ar_receivable_applications.application_ref_num%TYPE,

61: p_module_version IN VARCHAR2,
62: x_application_ref_id OUT NOCOPY
63: ar_receivable_applications.application_ref_id%TYPE,
64: x_application_ref_num OUT NOCOPY
65: ar_receivable_applications.application_ref_num%TYPE,
66: x_return_status OUT NOCOPY VARCHAR2,
67: x_msg_count OUT NOCOPY NUMBER,
68: x_msg_data OUT NOCOPY VARCHAR2,
69: p_acctd_amount_applied_to OUT NOCOPY NUMBER,

Line 72: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,

68: x_msg_data OUT NOCOPY VARCHAR2,
69: p_acctd_amount_applied_to OUT NOCOPY NUMBER,
70: p_acctd_amount_applied_from OUT NOCOPY NUMBER,
71: p_amount_due_remaining IN ar_payment_schedules.amount_due_remaining%TYPE DEFAULT NULL,
72: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
73: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
74: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
75: p_applied_rec_app_id IN ar_receivable_applications.applied_rec_app_id%TYPE,
76: x_claim_reason_name OUT NOCOPY VARCHAR2,

Line 73: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,

69: p_acctd_amount_applied_to OUT NOCOPY NUMBER,
70: p_acctd_amount_applied_from OUT NOCOPY NUMBER,
71: p_amount_due_remaining IN ar_payment_schedules.amount_due_remaining%TYPE DEFAULT NULL,
72: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
73: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
74: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
75: p_applied_rec_app_id IN ar_receivable_applications.applied_rec_app_id%TYPE,
76: x_claim_reason_name OUT NOCOPY VARCHAR2,
77: p_on_acct_cust_id IN ar_receivable_applications.on_acct_cust_id%TYPE DEFAULT NULL,

Line 74: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,

70: p_acctd_amount_applied_from OUT NOCOPY NUMBER,
71: p_amount_due_remaining IN ar_payment_schedules.amount_due_remaining%TYPE DEFAULT NULL,
72: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
73: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
74: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
75: p_applied_rec_app_id IN ar_receivable_applications.applied_rec_app_id%TYPE,
76: x_claim_reason_name OUT NOCOPY VARCHAR2,
77: p_on_acct_cust_id IN ar_receivable_applications.on_acct_cust_id%TYPE DEFAULT NULL,
78: p_on_acct_cust_site_use_id IN ar_receivable_applications.on_acct_cust_site_use_id%TYPE DEFAULT NULL,

Line 75: p_applied_rec_app_id IN ar_receivable_applications.applied_rec_app_id%TYPE,

71: p_amount_due_remaining IN ar_payment_schedules.amount_due_remaining%TYPE DEFAULT NULL,
72: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
73: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
74: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
75: p_applied_rec_app_id IN ar_receivable_applications.applied_rec_app_id%TYPE,
76: x_claim_reason_name OUT NOCOPY VARCHAR2,
77: p_on_acct_cust_id IN ar_receivable_applications.on_acct_cust_id%TYPE DEFAULT NULL,
78: p_on_acct_cust_site_use_id IN ar_receivable_applications.on_acct_cust_site_use_id%TYPE DEFAULT NULL,
79: p_on_acct_po_num IN ar_receivable_applications.on_acct_po_num%TYPE DEFAULT NULL

Line 77: p_on_acct_cust_id IN ar_receivable_applications.on_acct_cust_id%TYPE DEFAULT NULL,

73: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
74: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
75: p_applied_rec_app_id IN ar_receivable_applications.applied_rec_app_id%TYPE,
76: x_claim_reason_name OUT NOCOPY VARCHAR2,
77: p_on_acct_cust_id IN ar_receivable_applications.on_acct_cust_id%TYPE DEFAULT NULL,
78: p_on_acct_cust_site_use_id IN ar_receivable_applications.on_acct_cust_site_use_id%TYPE DEFAULT NULL,
79: p_on_acct_po_num IN ar_receivable_applications.on_acct_po_num%TYPE DEFAULT NULL
80: );
81:

Line 78: p_on_acct_cust_site_use_id IN ar_receivable_applications.on_acct_cust_site_use_id%TYPE DEFAULT NULL,

74: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
75: p_applied_rec_app_id IN ar_receivable_applications.applied_rec_app_id%TYPE,
76: x_claim_reason_name OUT NOCOPY VARCHAR2,
77: p_on_acct_cust_id IN ar_receivable_applications.on_acct_cust_id%TYPE DEFAULT NULL,
78: p_on_acct_cust_site_use_id IN ar_receivable_applications.on_acct_cust_site_use_id%TYPE DEFAULT NULL,
79: p_on_acct_po_num IN ar_receivable_applications.on_acct_po_num%TYPE DEFAULT NULL
80: );
81:
82: PROCEDURE delete_selected_transaction(

Line 79: p_on_acct_po_num IN ar_receivable_applications.on_acct_po_num%TYPE DEFAULT NULL

75: p_applied_rec_app_id IN ar_receivable_applications.applied_rec_app_id%TYPE,
76: x_claim_reason_name OUT NOCOPY VARCHAR2,
77: p_on_acct_cust_id IN ar_receivable_applications.on_acct_cust_id%TYPE DEFAULT NULL,
78: p_on_acct_cust_site_use_id IN ar_receivable_applications.on_acct_cust_site_use_id%TYPE DEFAULT NULL,
79: p_on_acct_po_num IN ar_receivable_applications.on_acct_po_num%TYPE DEFAULT NULL
80: );
81:
82: PROCEDURE delete_selected_transaction(
83: p_ra_id IN NUMBER

Line 88: , p_on_acct_cust_id IN ar_receivable_applications.on_acct_cust_id%TYPE DEFAULT NULL

84: , p_app_ps_id IN NUMBER);
85:
86: PROCEDURE update_onacct_cust_app(
87: p_ra_id IN NUMBER
88: , p_on_acct_cust_id IN ar_receivable_applications.on_acct_cust_id%TYPE DEFAULT NULL
89: , p_on_acct_cust_site_use_id IN ar_receivable_applications.on_acct_cust_site_use_id%TYPE DEFAULT NULL
90: , p_on_acct_po_num IN ar_receivable_applications.on_acct_po_num%TYPE DEFAULT NULL
91: );
92:

Line 89: , p_on_acct_cust_site_use_id IN ar_receivable_applications.on_acct_cust_site_use_id%TYPE DEFAULT NULL

85:
86: PROCEDURE update_onacct_cust_app(
87: p_ra_id IN NUMBER
88: , p_on_acct_cust_id IN ar_receivable_applications.on_acct_cust_id%TYPE DEFAULT NULL
89: , p_on_acct_cust_site_use_id IN ar_receivable_applications.on_acct_cust_site_use_id%TYPE DEFAULT NULL
90: , p_on_acct_po_num IN ar_receivable_applications.on_acct_po_num%TYPE DEFAULT NULL
91: );
92:
93: END arp_process_application2;

Line 90: , p_on_acct_po_num IN ar_receivable_applications.on_acct_po_num%TYPE DEFAULT NULL

86: PROCEDURE update_onacct_cust_app(
87: p_ra_id IN NUMBER
88: , p_on_acct_cust_id IN ar_receivable_applications.on_acct_cust_id%TYPE DEFAULT NULL
89: , p_on_acct_cust_site_use_id IN ar_receivable_applications.on_acct_cust_site_use_id%TYPE DEFAULT NULL
90: , p_on_acct_po_num IN ar_receivable_applications.on_acct_po_num%TYPE DEFAULT NULL
91: );
92:
93: END arp_process_application2;