1 PACKAGE ja_tw_sh_gui_utils AS
2 /* $Header: jatwsgus.pls 120.2 2005/10/18 22:46:56 ykonishi ship $ */
3
4 PROCEDURE get_next_seq_num(
5 p_sequence_name IN VARCHAR2
6 , p_sequence_num OUT NOCOPY NUMBER
7 , p_error_code OUT NOCOPY NUMBER);
8
9 FUNCTION get_last_trx_num(
10 p_sequence_name IN VARCHAR2) RETURN NUMBER;
11
12 FUNCTION get_seq_name(
13 p_batch_source_id IN NUMBER) RETURN VARCHAR2;
14
15 PROCEDURE get_trx_src_info(
16 p_batch_source_id IN NUMBER
17 , p_auto_trx_num_flag OUT NOCOPY VARCHAR2
18 , p_inv_word OUT NOCOPY VARCHAR2
19 , p_init_trx_num OUT NOCOPY VARCHAR2
20 , p_fin_trx_num OUT NOCOPY VARCHAR2
21 , p_last_trx_date OUT NOCOPY VARCHAR2
22 , p_adv_days OUT NOCOPY NUMBER
23 -- Bug 4673732 : R12 MOAC
24 , p_org_id IN NUMBER);
25
26 PROCEDURE get_trx_type_info(
27 p_cust_trx_type_id IN NUMBER
28 , p_gui_type OUT NOCOPY VARCHAR2
29 , p_inv_class OUT NOCOPY VARCHAR2
30 -- Bug 4673732 : R12 MOAC
31 , p_org_id IN NUMBER);
32
33 FUNCTION get_ref_src_id(
34 p_batch_source_id IN NUMBER
35 -- Bug 4673732 : R12 MOAC
36 , p_org_id IN NUMBER) RETURN NUMBER;
37
38 FUNCTION get_inv_word(
39 p_batch_source_id IN NUMBER
40 -- Bug 4673732 : R12 MOAC
41 , p_org_id IN NUMBER
42 ) RETURN VARCHAR2;
43
44 FUNCTION get_gui_src_id(
45 p_batch_source_id IN NUMBER
46 -- Bug 4673732 : R12 MOAC
47 , p_org_id IN NUMBER) RETURN NUMBER;
48
49 FUNCTION get_trx_num_range(
50 p_batch_source_id IN NUMBER
51 , p_ini_or_fin IN VARCHAR2
52 -- Bug 4673732 : R12 MOAC
53 , p_org_id IN NUMBER) RETURN VARCHAR2;
54
55 FUNCTION get_last_trx_date(
56 p_batch_source_id IN NUMBER
57 -- Bug 4673732 : R12 MOAC
58 , p_org_id IN NUMBER) RETURN DATE;
59
60 FUNCTION get_adv_days(
61 p_batch_source_id IN NUMBER
62 -- Bug 4673732 : R12 MOAC
63 , p_org_id IN NUMBER) RETURN NUMBER;
64
65 FUNCTION val_src_type_rel(
66 p_interface_line_id IN NUMBER
67 , p_batch_source_id IN NUMBER
68 , p_cust_trx_type_id IN NUMBER
69 , p_created_from IN VARCHAR2) RETURN VARCHAR2;
70
71 FUNCTION val_trx_num(
72 p_interface_line_id IN NUMBER
73 , p_batch_source_id IN NUMBER
74 , p_fin_trx_num IN VARCHAR2
75 , p_created_from IN VARCHAR2) RETURN VARCHAR2;
76
77 FUNCTION val_trx_date(
78 p_interface_line_id IN NUMBER
79 , p_batch_source_id IN NUMBER
80 , p_trx_date IN DATE
81 , p_last_trx_date IN VARCHAR2 -- GDF Segment
82 , p_advance_days IN NUMBER
83 , p_created_from IN VARCHAR2
84 -- Bug 4673732 : R12 MOAC
85 , p_org_id IN NUMBER) RETURN VARCHAR2;
86
87 FUNCTION val_mixed_tax_codes(
88 p_interface_line_id IN NUMBER
89 , p_customer_trx_id IN NUMBER
90 , p_created_from IN VARCHAR2) RETURN VARCHAR2;
91
92 FUNCTION update_last_trx_date(
93 p_batch_source_id IN NUMBER
94 , p_last_trx_date IN DATE
95 , p_created_from IN VARCHAR2
96 -- Bug 4673732 : R12 MOAC
97 , p_org_id IN NUMBER) RETURN BOOLEAN;
98
99 FUNCTION copy_gui_type(
100 p_interface_line_id IN NUMBER
101 , p_gui_type IN VARCHAR2
102 , p_created_from IN VARCHAR2) RETURN BOOLEAN;
103
104 END ja_tw_sh_gui_utils;