DBA Data[Home] [Help]

PACKAGE: APPS.JL_ZZ_AUTO_INVOICE

Source


1 PACKAGE JL_ZZ_AUTO_INVOICE AUTHID CURRENT_USER as
2 /* $Header: jlzzrais.pls 120.5 2009/12/15 17:51:07 rsaini ship $ */
3 
4 /*----------------------------------------------------------------------------*
5  |   PUBLIC FUNCTIONS/PROCEDURES  					      |
6  *----------------------------------------------------------------------------*/
7 
8 /*----------------------------------------------------------------------------*
9  | FUNCTION                                                                   |
10  |    validate_gdff                                                           |
11  |                                                                            |
12  | DESCRIPTION                                                                |
13  |                                                                            |
14  | PARAMETERS                                                                 |
15  |   INPUT                                                                    |
16  |      p_request_id            Number   -- Concurrent Request id             |
17  |                                                                            |
18  |   RETURNS                                                                  |
19  |      0                       Number   -- Validations Failed                |
20  |      1                       Number   -- Validation Succeeded              |
21  |                                                                            |
22  | HISTORY                                                                    |
23  |    10-Aug-97  Marcia Toriyama   Created.                                   |
24  |    02-Sep-97  German Bertot     Changed validate_gdff specification from   |
25  |                                 Procedure to Function.                     |
26  |    02-Sep-2004 Octavio Pedregal  Bug 2367111 - MOAC changes             |
27  *----------------------------------------------------------------------------*/
28   FUNCTION validate_gdff
29        (p_request_id  IN NUMBER,
30         p_org_id      IN NUMBER DEFAULT           --Bugfix 2367111
31                          to_number(fnd_profile.value('ORG_ID'))) RETURN NUMBER;
32 -- Added by venkat  04-Aug-1999
33   FUNCTION trx_num_upd
34        (p_batch_source_id IN NUMBER,
35         p_trx_number      IN VARCHAR2,
36         p_org_id          IN NUMBER DEFAULT           --Bugfix 2367111
37                          to_number(fnd_profile.value('ORG_ID'))
38        ) RETURN VARCHAR2;
39 
40   FUNCTION validate_tax_attributes  (p_interface_line_id            IN NUMBER
41                                    , p_line_type                    IN VARCHAR2
42                                    , p_memo_line_id                 IN NUMBER
43                                    , p_inventory_item_id            IN NUMBER
44                                    , p_product_fiscal_class         IN VARCHAR2
45                                    , p_product_category             IN VARCHAR2
46                                    , p_trx_business_category        IN VARCHAR2
47                                    , p_line_attribute11             IN VARCHAR2
48                                    , p_line_attribute12             IN VARCHAR2
49                                    , p_address_id                   IN NUMBER
50                                    , p_warehouse_id                 IN NUMBER)
51   RETURN BOOLEAN;
52 
53   FUNCTION validate_interest_attributes (p_interface_line_id IN NUMBER
54                                     , p_line_type              IN VARCHAR2
55                                     , p_header_attribute1      IN VARCHAR2
56                                     , p_header_attribute2      IN VARCHAR2
57                                     , p_header_attribute3      IN VARCHAR2
58                                     , p_header_attribute4      IN VARCHAR2
59                                     , p_header_attribute5      IN VARCHAR2
60                                     , p_header_attribute6      IN VARCHAR2
61                                     , p_header_attribute7      IN VARCHAR2)
62   RETURN BOOLEAN;
63 
64   FUNCTION validate_billing_attributes (p_interface_line_id IN NUMBER
65                                     , p_line_type             IN VARCHAR2
66                                     , p_memo_line_id          IN NUMBER
67                                     , p_inventory_item_id     IN NUMBER
68                                     , p_header_attribute9     IN VARCHAR2
69                                     , p_header_attribute10    IN VARCHAR2
70                                     , p_header_attribute11    IN VARCHAR2
71                                     , p_header_attribute13    IN VARCHAR2
72                                     , p_header_attribute15    IN VARCHAR2
73                                     , p_header_attribute16    IN VARCHAR2
74                                     , p_header_attribute17    IN VARCHAR2
75                                     , p_line_attribute1       IN VARCHAR2
76                                     , p_line_attribute4       IN VARCHAR2
77                                     , p_line_attribute5       IN VARCHAR2
78                                     , p_line_attribute6       IN VARCHAR2
79                                     , p_line_attribute7       IN VARCHAR2)
80       RETURN BOOLEAN;
81 
82   FUNCTION jl_br_cm_upd_inv_status (p_request_id IN NUMBER)
83       RETURN NUMBER;        -- Added for bug no 9183563
84 
85 END JL_ZZ_AUTO_INVOICE;