1 PACKAGE ja_zz_validate_invoice_gdf AS
2 /* $Header: jazzrivs.pls 120.0 2004/02/07 02:04:00 thwon noship $ */
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
24 PROCEDURE get_trx_type_info(
25 p_cust_trx_type_id IN NUMBER
26 , p_gui_type OUT NOCOPY VARCHAR2
27 , p_inv_class OUT NOCOPY VARCHAR2);
28
29 FUNCTION get_ref_src_id(
30 p_batch_source_id IN NUMBER) RETURN NUMBER;
31
32 FUNCTION get_inv_word(
33 p_batch_source_id IN NUMBER) RETURN VARCHAR2;
34
35 FUNCTION get_gui_src_id(
36 p_batch_source_id IN NUMBER) RETURN NUMBER;
37
38 FUNCTION get_trx_num_range(
39 p_batch_source_id IN NUMBER
40 , p_ini_or_fin IN VARCHAR2) RETURN VARCHAR2;
41
42 FUNCTION get_last_trx_date(
43 p_batch_source_id IN NUMBER) RETURN DATE;
44
45 FUNCTION get_adv_days(
46 p_batch_source_id IN NUMBER) RETURN NUMBER;
47
48 FUNCTION val_src_type_rel(
49 p_trx_header_id IN NUMBER
50 , p_trx_line_id IN NUMBER
51 , p_batch_source_id IN NUMBER
52 , p_cust_trx_type_id IN NUMBER
53 , p_created_from IN VARCHAR2) RETURN VARCHAR2;
54
55 FUNCTION val_trx_num(
56 p_trx_header_id IN NUMBER
57 , p_trx_line_id IN NUMBER
58 , p_batch_source_id IN NUMBER
59 , p_fin_trx_num IN VARCHAR2
60 , p_created_from IN VARCHAR2) RETURN VARCHAR2;
61
62 FUNCTION val_trx_date(
63 p_trx_header_id IN NUMBER
64 , p_trx_line_id IN NUMBER
65 , p_batch_source_id IN NUMBER
66 , p_trx_date IN DATE
67 , p_last_trx_date IN VARCHAR2 -- GDF Segment
68 , p_advance_days IN NUMBER
69 , p_created_from IN VARCHAR2) RETURN VARCHAR2;
70
71 FUNCTION val_mixed_tax_codes(
72 p_trx_header_id IN NUMBER
73 , p_trx_line_id IN NUMBER
74 , p_customer_trx_id IN NUMBER
75 , p_created_from IN VARCHAR2) RETURN VARCHAR2;
76
77 FUNCTION update_last_trx_date(
78 p_batch_source_id IN NUMBER
79 , p_last_trx_date IN DATE
80 , p_created_from IN VARCHAR2) RETURN BOOLEAN;
81
82 FUNCTION copy_gui_type(
83 p_trx_line_id IN NUMBER
84 , p_gui_type IN VARCHAR2
85 , p_created_from IN VARCHAR2) RETURN BOOLEAN;
86
87 FUNCTION validate_trx_date(
88 p_customer_trx_id IN NUMBER
89 , p_trx_date IN DATE
90 , p_last_issued_date IN DATE
91 , p_advance_days IN NUMBER
92 , p_created_from IN VARCHAR2) RETURN NUMBER;
93
94 FUNCTION validate_tax_code(
95 p_customer_trx_id IN NUMBER
96 , p_created_from IN VARCHAR2) RETURN NUMBER;
97
98 FUNCTION update_last_issued_date(
99 p_customer_trx_id IN NUMBER
100 , p_cust_trx_type_id IN NUMBER
101 , p_trx_date IN DATE
102 , p_created_from IN VARCHAR2) RETURN NUMBER;
103
104 END ja_zz_validate_invoice_gdf;
[Home] [Help]