1 PACKAGE FUN_TRADING_RELATION AS
2 /* $Header: funtraderels.pls 120.7 2006/05/15 13:59:33 ashikuma noship $ */
3
4 /*-----------------------------------------------------
5 * FUNCTION validate_source
6 * ----------------------------------------------------
7 * Validates the source input.
8 * ---------------------------------------------------*/
9
10 FUNCTION validate_source (p_source IN VARCHAR2)
11 RETURN boolean;
12
13
14 /*-----------------------------------------------------
15 * FUNCTION get_customer
16 * ----------------------------------------------------
17 * Get the customer info.
18 * Returns TRUE iff a match is found.
19 * ---------------------------------------------------*/
20
21 FUNCTION get_customer (
22 p_source IN VARCHAR2,
23 p_trans_le_id IN NUMBER ,
24 p_tp_le_id IN NUMBER ,
25 p_trans_org_id IN NUMBER := NULL,
26 p_tp_org_id IN NUMBER := NULL,
27 p_trans_organization_id IN NUMBER,
28 p_tp_organization_id IN NUMBER,
29 x_msg_data OUT NOCOPY VARCHAR2,
30 x_cust_acct_id OUT NOCOPY NUMBER,
31 x_cust_acct_site_id OUT NOCOPY NUMBER,
32 x_site_use_id OUT NOCOPY NUMBER
33 ) RETURN boolean;
34
35
36 /*-----------------------------------------------------
37 * FUNCTION get_supplier
38 * ----------------------------------------------------
39 * Get the supplier info.
40 * Returns TRUE iff a match is found.
41 * ---------------------------------------------------*/
42
43 FUNCTION get_supplier (
44 p_source IN VARCHAR2,
45 p_trans_le_id IN NUMBER ,
46 p_tp_le_id IN NUMBER ,
47 p_trans_org_id IN NUMBER := NULL,
48 p_tp_org_id IN NUMBER := NULL,
49 p_trans_organization_id IN NUMBER,
50 p_tp_organization_id IN NUMBER,
51 p_trx_date IN DATE,
52 x_msg_data OUT NOCOPY VARCHAR2,
53 x_vendor_id OUT NOCOPY NUMBER,
54 x_pay_site_id OUT NOCOPY NUMBER
55 ) RETURN boolean;
56
57 /*-----------------------------------------------------
58 * PROCEDUTE get_relation
59 * ----------------------------------------------------
60 * Get the relation_id
61 * ---------------------------------------------------*/
62 PROCEDURE get_relation (
63 p_source IN VARCHAR2,
64 p_type IN VARCHAR2,
65 p_trans_le_id IN NUMBER ,
66 p_tp_le_id IN NUMBER ,
67 p_trans_org_id IN NUMBER := NULL,
68 p_tp_org_id IN NUMBER := NULL,
69 p_trans_organization_id IN NUMBER,
70 p_tp_organization_id IN NUMBER,
71 x_relation_id OUT NOCOPY NUMBER,
72 x_success OUT NOCOPY VARCHAR2,
73 x_msg_data OUT NOCOPY VARCHAR2
74 ) ;
75
76
77
78 END FUN_TRADING_RELATION;
79