[Home] [Help]
PACKAGE: APPS.EGO_TEMPL_ATTRS_PUB
Source
1 PACKAGE EGO_TEMPL_ATTRS_PUB AUTHID CURRENT_USER AS
2 /* $Header: EGOTMPLS.pls 120.3 2007/05/02 19:50:20 ssarnoba ship $ */
3
4 ----------------------
5 -- Global Constants --
6 ----------------------
7
8 G_TRANS_TEXT_DATA_TYPE CONSTANT VARCHAR2(1) := 'A';
9 G_CHAR_DATA_TYPE CONSTANT VARCHAR2(1) := 'C';
10 G_NUMBER_DATA_TYPE CONSTANT VARCHAR2(1) := 'N';
11 G_DATE_DATA_TYPE CONSTANT VARCHAR2(1) := 'X';
12 G_DATE_TIME_DATA_TYPE CONSTANT VARCHAR2(1) := 'Y';
13
14 G_INDEPENDENT_VALIDATION_CODE CONSTANT VARCHAR2(1) := 'I';
15 G_NONE_VALIDATION_CODE CONSTANT VARCHAR2(1) := 'N';
16 G_TABLE_VALIDATION_CODE CONSTANT VARCHAR2(1) := 'F';
17
18 G_ATTACH_DISP_TYPE CONSTANT VARCHAR2(1) := 'A';
19 G_CHECKBOX_DISP_TYPE CONSTANT VARCHAR2(1) := 'C';
20 G_DYN_URL_DISP_TYPE CONSTANT VARCHAR2(1) := 'D';
21 G_HIDDEN_DISP_TYPE CONSTANT VARCHAR2(1) := 'H';
22 G_RADIO_DISP_TYPE CONSTANT VARCHAR2(1) := 'R';
23 G_STATIC_URL_DISP_TYPE CONSTANT VARCHAR2(1) := 'S';
24 G_TEXT_FIELD_DISP_TYPE CONSTANT VARCHAR2(1) := 'T';
25
26 G_LOV_LONGLIST_FLAG CONSTANT VARCHAR2(1) := 'N';
27 G_POPLIST_LONGLIST_FLAG CONSTANT VARCHAR2(1) := 'X';
28
29 ----------------------
30 -- Data Types --
31 ----------------------
32 /* Template Attribute Record Type */
33 TYPE template_attribute_rec_type IS RECORD
34 (
35 attr_id NUMBER, -- EGO attribute id
36 attr_group_id NUMBER, -- EGO attribute group id
37 application_column_name VARCHAR2(30), -- MSI_B column for attribute
38 attr_group_name VARCHAR2(30), -- EGO attr_group_name
39 template_id NUMBER, -- INV/EGO template_id
40 enabled_flag VARCHAR2(1),
41 attribute_name VARCHAR2(50),
42 attribute_value VARCHAR2(240)
43 );
44
45 ----------------------
46 -- Procedures --
47 ----------------------
48
49 Procedure Sync_Template
50 ( p_template_id IN NUMBER,
51 p_commit IN VARCHAR2 := FND_API.G_FALSE,
52 x_return_status OUT NOCOPY VARCHAR2,
53 x_message_text OUT NOCOPY VARCHAR2
54 );
55
56
57 Procedure Sync_Template_Attribute
58 ( p_template_id IN NUMBER,
59 p_attribute_name IN VARCHAR2,
60 p_attribute_value IN VARCHAR2 ,
61 p_enabled_flag IN VARCHAR2 ,
62 p_commit IN VARCHAR2 := FND_API.G_FALSE,
63 p_ego_attr_id IN NUMBER,
64 p_ego_attr_group_id IN NUMBER,
65 x_return_status OUT NOCOPY VARCHAR2,
66 x_message_text OUT NOCOPY VARCHAR2,
67 p_always_insert IN VARCHAR2 := FND_API.G_FALSE
68 );
69
70 Procedure Sync_Template_Attribute
71 ( p_template_id IN NUMBER,
72 p_attribute_name IN VARCHAR2,
73 p_commit IN VARCHAR2 := FND_API.G_FALSE,
74 x_return_status OUT NOCOPY VARCHAR2,
75 x_message_text OUT NOCOPY VARCHAR2,
76 p_always_insert IN VARCHAR2 := FND_API.G_FALSE
77 );
78
79 Procedure Insert_Template_Attribute
80 ( p_template_id IN NUMBER,
81 p_attribute_group_id IN NUMBER,
82 p_attribute_id IN NUMBER,
83 p_data_level_id IN NUMBER,
84 p_enabled_flag IN VARCHAR2,
85 p_attribute_value IN VARCHAR2,
86 p_commit IN VARCHAR2 := FND_API.G_FALSE,
87 x_return_status OUT NOCOPY VARCHAR2,
88 x_message_text OUT NOCOPY VARCHAR2
89 );
90
91 Procedure Update_Template_Attribute
92 ( p_template_id IN NUMBER,
93 p_attribute_group_id IN NUMBER,
94 p_attribute_id IN NUMBER,
95 p_data_level_id IN NUMBER,
96 p_enabled_flag IN VARCHAR2,
97 p_attribute_value IN VARCHAR2,
98 p_commit IN VARCHAR2 := FND_API.G_FALSE,
99 x_return_status OUT NOCOPY VARCHAR2,
100 x_message_text OUT NOCOPY VARCHAR2
101 );
102
103 END EGO_TEMPL_ATTRS_PUB;
104