1 PACKAGE FUN_TRX_TYPES_PUB AUTHID CURRENT_USER AS
2 -- $Header: funtrxutils.pls 120.8.12010000.3 2009/10/22 11:28:30 srampure ship $
3
4 /****************************************************************
5 * PROCEDURE get_trx_type_by_id *
6 * *
7 * This procedure returns status of a transaction and the *
8 * invoicing option for a given trx_type_id *
9 ****************************************************************/
10
11 PROCEDURE get_trx_type_by_id (
12 p_trx_type_id in number,
13 x_trx_type_code out NOCOPY varchar2,
14 x_need_invoice out NOCOPY varchar2,
15 x_enabled out NOCOPY varchar2
16 ) ;
17
18
19 /****************************************************************
20 * PROCEDURE :get_trx_type_code *
21 * *
22 * This procedure returns the status of a transaction and *
23 * invoicing option for a given transaction type code *
24 ****************************************************************/
25
26 PROCEDURE get_trx_type_by_code (
27 p_trx_type_code in varchar2,
28 x_trx_type_id out NOCOPY number,
29 x_need_invoice out NOCOPY varchar2,
30 x_enabled out NOCOPY varchar2
31 );
32
33 /****************************************************************
34 * FUNCTION : is_trx_type_manual_approve *
35 * *
36 * This function returns the manual approval option for a *
37 * transaction type name given trx_type_id *
38 ****************************************************************/
39
40 FUNCTION is_trx_type_manual_approve
41 (
42 p_trx_type_id in number
43 ) RETURN VARCHAR2;
44
45
46 /****************************************************************
47 * PROCEDURE : get_trx_type_map *
48 * *
49 * This procedure returns the mapping details of transation*
50 * type name given the org it is associated with and the id*
51 ****************************************************************/
52
53 PROCEDURE get_trx_type_map (
54 p_org_id in number,
55 p_trx_type_id in number,
56 p_trx_date in date,
57 p_trx_id in number,
58 x_memo_line_id out NOCOPY Number,
59 x_memo_line_name out NOCOPY varchar2,
60 x_ar_trx_type_id out NOCOPY Number,
61 x_ar_trx_type_name out NOCOPY varchar2,
62 x_default_term_id out NOCOPY NUMBER
63 );
64
65 /****************************************************************
66 * FUNCTION : get_ar_trx_creation_sign *
67 * *
68 * For a given intercompany transaction type, this function*
69 * returns the transaction creation sign of the associated *
70 * AR transaction type. The input to the function is the *
71 * intercompany transaction type, organization id and the *
72 * transaction batch date *
73 * *
74 ****************************************************************/
75
76 FUNCTION get_ar_trx_creation_sign (
77 p_org_id in number,
78 p_trx_type_id in number,
79 p_trx_date in date,
80 p_trx_type in varchar2
81 ) RETURN NUMBER;
82
83
84 END FUN_TRX_TYPES_PUB;