1 PACKAGE JL_AR_DOC_NUMBERING_PKG as
2 /* $Header: jlarrdns.pls 120.6 2005/11/18 02:11:20 appradha ship $ */
3
4 /*----------------------------------------------------------------------------*
5 | PUBLIC FUNCTIONS/PROCEDURES |
6 *----------------------------------------------------------------------------*/
7
8 FUNCTION validate_trx_type (p_batch_source_id IN NUMBER,
9 p_trx_type IN NUMBER,
10 p_invoice_class IN VARCHAR2,
11 p_document_letter IN VARCHAR2,
12 p_interface_line_id IN NUMBER,
13 p_created_from IN VARCHAR2)
14 RETURN VARCHAR2;
15
16 FUNCTION validate_four_digit (p_batch_source_id IN NUMBER,
17 p_interface_line_id IN NUMBER,
18 p_created_from IN VARCHAR2,
19 p_inventory_item_id IN NUMBER,
20 p_memo_line_id IN NUMBER,
21 --added by venkat 12dec98 - start
22 p_so_org_id IN VARCHAR2)
23 --added by venkat 12dec98 - end
24 RETURN VARCHAR2;
25
26 FUNCTION validate_document_letter
27 (p_batch_source_id IN NUMBER,
28 p_interface_line_id IN NUMBER,
29 p_created_from IN VARCHAR2,
30 p_ship_to_address_id IN NUMBER,
31 p_document_letter IN OUT NOCOPY VARCHAR2,
32 --added by venkat 12dec98 - start
33 p_so_org_id IN VARCHAR2)
34 --added by venkat 12dec98 - end
35 RETURN VARCHAR2;
36
37 FUNCTION get_imported_batch_source (p_batch_source_id IN NUMBER)
38 RETURN NUMBER;
39
40 FUNCTION get_batch_source_type (p_batch_source_id IN NUMBER)
41 RETURN VARCHAR2;
42
43 FUNCTION validate_transaction_date
44 (p_trx_date IN DATE,
45 p_batch_source_id IN NUMBER)
46 RETURN VARCHAR2;
47
48
49 FUNCTION validate_interface_lines ( p_request_id IN NUMBER
50 , p_interface_line_id IN NUMBER
51 , p_trx_type IN NUMBER
52 , p_inventory_item_id IN NUMBER
53 , p_memo_line_id IN NUMBER
54 , p_trx_date IN DATE
55 , p_orig_system_address_id IN NUMBER
56 --added by venkat 12dec98 - start
57 , p_so_org_id IN VARCHAR2)
58 --added by venkat 12dec98 - end
59 RETURN BOOLEAN;
60
61 FUNCTION get_printing_count (p_cust_trx_id IN VARCHAR2)
62 RETURN NUMBER;
63
64 FUNCTION get_branch_number_method RETURN VARCHAR2;
65
66 FUNCTION get_flex_delimiter RETURN VARCHAR2;
67
68 FUNCTION get_flex_value(p_concat_segs IN VARCHAR2, p_flex_delimiter IN VARCHAR2) RETURN VARCHAR2;
69
70 FUNCTION get_num_bar_code(p_batch_source_id IN NUMBER, p_trx_type_id IN NUMBER, p_legal_entity_id IN NUMBER) RETURN VARCHAR2;
71
72 FUNCTION get_point_of_sale_code(p_inv_org_id IN VARCHAR2) RETURN VARCHAR2;
73
74 FUNCTION get_doc_letter(p_batch_source_id IN NUMBER) RETURN VARCHAR2;
75
76 FUNCTION get_branch_number(p_batch_source_id IN NUMBER) RETURN VARCHAR2;
77
78 FUNCTION get_last_trx_date(p_batch_source_id IN NUMBER) RETURN DATE;
79
80 FUNCTION get_adv_days(p_batch_source_id IN NUMBER) RETURN VARCHAR2;
81
82 FUNCTION get_hr_branch_number(p_location_id IN NUMBER) RETURN VARCHAR2;
83
84 -- Added by venkat 04-Aug-1999
85 FUNCTION trx_num_gen(p_batch_source_id IN NUMBER,
86 p_trx_number IN VARCHAR2) RETURN VARCHAR2;
87
88
89 END JL_AR_DOC_NUMBERING_PKG;