1 PACKAGE ari_config AS
2 /* $Header: ARICNFGS.pls 120.14.12010000.3 2008/11/07 13:18:54 avepati ship $ */
3
4
5 /* -------------------------------------------------------------
6 * User Configuration Section
7 * -------------------------------------------------------------
8 * The section below can be modified to configure iReceivables to
9 * Customer's needs.
10 */
11
12
13 -- generates raw html code used by the homepage for the configurable section : the second column : when customer_id, user_id, or site_use_id are not available, the procedure should be passed -1.
14
15 PROCEDURE get_homepage_customization(
16 p_user_id IN NUMBER,
17 p_customer_id IN NUMBER,
18 p_site_use_id IN NUMBER,
19 p_encrypted_customer_id IN VARCHAR2,
20 p_encrypted_site_use_id IN VARCHAR2,
21 p_language IN VARCHAR2,
22 p_output_string OUT NOCOPY VARCHAR2);
23
24 -- this procedure outputs the number of rows that the default
25 -- account details page view should show in the results region.
26 -- its given a generic name because it could be used for other restrictions also
27 PROCEDURE Restrict_By_Rows (
28 x_output_number OUT NOCOPY NUMBER,
29 x_customer_id IN VARCHAR2,
30 x_customer_site_use_id IN VARCHAR2,
31 x_language_string IN VARCHAR2
32 );
33
34
35 PROCEDURE get_discount_customization(p_customer_id IN NUMBER,
36 p_site_use_id IN NUMBER,
37 p_language IN VARCHAR2,
38 p_render OUT NOCOPY VARCHAR2,
39 p_output_string OUT NOCOPY VARCHAR2);
40
41 PROCEDURE get_dispute_customization(p_customer_id IN NUMBER,
42 p_site_use_id IN NUMBER,
43 p_language IN VARCHAR2,
44 p_render OUT NOCOPY VARCHAR2,
45 p_output_string OUT NOCOPY VARCHAR2);
46
47
48 PROCEDURE search_custom_trx(
49 p_session_id IN VARCHAR2,
50 p_customer_id IN VARCHAR2,
51 p_customer_site_id IN VARCHAR2,
52 p_org_id IN VARCHAR2,
53 p_person_id IN VARCHAR2,
54 p_transaction_status IN VARCHAR2,
55 p_transaction_type IN VARCHAR2,
56 p_currency IN VARCHAR2,
57 p_keyword IN VARCHAR2,
58 p_amount_from IN VARCHAR2,
59 p_amount_to IN VARCHAR2,
60 p_trans_date_from IN VARCHAR2,
61 p_trans_date_to IN VARCHAR2,
62 p_due_date_from IN VARCHAR2,
63 p_due_date_to IN VARCHAR2,
64 p_org_name OUT NOCOPY VARCHAR2,
65 p_transaction_col OUT NOCOPY VARCHAR2,
66 p_type_col OUT NOCOPY VARCHAR2,
67 p_status_col OUT NOCOPY VARCHAR2,
68 p_date_col OUT NOCOPY VARCHAR2,
69 p_due_date_col OUT NOCOPY VARCHAR2,
70 p_purchase_order_col OUT NOCOPY VARCHAR2,
71 p_sales_order_col OUT NOCOPY VARCHAR2,
72 p_original_amt_col OUT NOCOPY VARCHAR2,
73 p_remaining_amt_col OUT NOCOPY VARCHAR2,
74 p_attribute1_col OUT NOCOPY VARCHAR2,
75 p_attribute2_col OUT NOCOPY VARCHAR2,
76 p_attribute3_col OUT NOCOPY VARCHAR2,
77 p_attribute4_col OUT NOCOPY VARCHAR2,
78 p_attribute5_col OUT NOCOPY VARCHAR2,
79 p_search_result OUT NOCOPY VARCHAR2,
80 p_message_id OUT NOCOPY VARCHAR2,
81 p_msg_app_id OUT NOCOPY VARCHAR2
82 );
83
84
85 PROCEDURE search_custom_customer(
86 p_user_name IN VARCHAR2,
87 p_is_external_user IN VARCHAR2,
88 p_search_attribute IN VARCHAR2,
89 p_search_keyword IN VARCHAR2,
90 p_org_id IN NUMBER,
91 p_org_name OUT NOCOPY VARCHAR2,
92 p_trx_number_col OUT NOCOPY VARCHAR2,
93 p_customer_name_col OUT NOCOPY VARCHAR2,
94 p_customer_number_col OUT NOCOPY VARCHAR2,
95 p_address_col OUT NOCOPY VARCHAR2,
96 p_address_type_col OUT NOCOPY VARCHAR2,
97 p_contact_name_col OUT NOCOPY VARCHAR2,
98 p_contact_phone_col OUT NOCOPY VARCHAR2,
99 p_account_summary_col OUT NOCOPY VARCHAR2,
100 p_attribute1_col OUT NOCOPY VARCHAR2,
101 p_attribute2_col OUT NOCOPY VARCHAR2,
102 p_attribute3_col OUT NOCOPY VARCHAR2,
103 p_attribute4_col OUT NOCOPY VARCHAR2,
104 p_attribute5_col OUT NOCOPY VARCHAR2,
105 p_search_result OUT NOCOPY VARCHAR2,
106 p_message_id OUT NOCOPY VARCHAR2,
107 p_msg_app_id OUT NOCOPY VARCHAR2,
108 p_customer_location_col OUT NOCOPY VARCHAR2
109 );
110
111 END ari_config;