PACKAGE: APPS.INVICGDS

Source

1 PACKAGE INVICGDS AUTHID CURRENT_USER as
2 /* $Header: INVICGDS.pls 120.1 2005/06/21 06:31:45 appldev ship $ */
3 
4 PROCEDURE inv_update_item_desc(
5 inv_item_id                 IN    NUMBER   DEFAULT  NULL,
6 org_id                      IN    NUMBER   DEFAULT  NULL,
7 first_elem_break            IN    NUMBER   DEFAULT 30,
8 use_name_as_first_elem      IN    VARCHAR2 DEFAULT 'N',
9 delimiter                   IN    VARCHAR2 DEFAULT NULL,
10 show_all_delim              IN    VARCHAR2 DEFAULT 'Y'
11 );
12 
13 
14 FUNCTION inv_fn_get_icg_desc(
15 inv_item_id                 IN    NUMBER,
16 first_elem_break            IN    NUMBER   DEFAULT 30,
17 use_name_as_first_elem      IN    VARCHAR2 DEFAULT 'N',
18 delimiter                   IN    VARCHAR2 DEFAULT NULL,
19 show_all_delim              IN    VARCHAR2 DEFAULT 'Y',
20 show_error_flag             IN    VARCHAR2 DEFAULT 'Y'
21 ) return VARCHAR2;
22 
23 PROCEDURE inv_get_icg_desc(
24 inv_item_id                 IN    NUMBER,
25 first_elem_break            IN    NUMBER   DEFAULT 30,
26 use_name_as_first_elem      IN    VARCHAR2 DEFAULT 'N',
27 delimiter                   IN    VARCHAR2 DEFAULT NULL,
28 show_all_delim              IN    VARCHAR2 DEFAULT 'Y',
29 description_for_item       OUT    NOCOPY VARCHAR2,
30 error_text                IN OUT    NOCOPY VARCHAR2
31 );
32 
33 PROCEDURE inv_concat_desc_values(
34    inv_item_id                  IN  NUMBER,
35    icg_id                       IN  NUMBER,
36    delimiter                    IN  VARCHAR2 DEFAULT NULL,
37    show_all_delim               IN  VARCHAR2 DEFAULT 'Y',
38    concat_desc                  OUT NOCOPY VARCHAR2,
39    err_text                     IN OUT NOCOPY VARCHAR2
40  );
41 
42 END INVICGDS;