[Home] [Help]
PACKAGE: APPS.QP_FNA_UTIL
Source
1 PACKAGE QP_Fna_Util AS
2 /* $Header: QPXUFNAS.pls 120.2 2005/08/18 15:37:13 sfiresto noship $ */
3
4 -- Attributes global constants
5
6 G_ATTRIBUTE1 CONSTANT NUMBER := 1;
7 G_ATTRIBUTE10 CONSTANT NUMBER := 2;
8 G_ATTRIBUTE11 CONSTANT NUMBER := 3;
9 G_ATTRIBUTE12 CONSTANT NUMBER := 4;
10 G_ATTRIBUTE13 CONSTANT NUMBER := 5;
11 G_ATTRIBUTE14 CONSTANT NUMBER := 6;
12 G_ATTRIBUTE15 CONSTANT NUMBER := 7;
13 G_ATTRIBUTE2 CONSTANT NUMBER := 8;
14 G_ATTRIBUTE3 CONSTANT NUMBER := 9;
15 G_ATTRIBUTE4 CONSTANT NUMBER := 10;
16 G_ATTRIBUTE5 CONSTANT NUMBER := 11;
17 G_ATTRIBUTE6 CONSTANT NUMBER := 12;
18 G_ATTRIBUTE7 CONSTANT NUMBER := 13;
19 G_ATTRIBUTE8 CONSTANT NUMBER := 14;
20 G_ATTRIBUTE9 CONSTANT NUMBER := 15;
21 G_CONTEXT CONSTANT NUMBER := 16;
22 G_CREATED_BY CONSTANT NUMBER := 17;
23 G_CREATION_DATE CONSTANT NUMBER := 18;
24 G_ENABLED CONSTANT NUMBER := 19;
25 G_FUNCTIONAL_AREA CONSTANT NUMBER := 20;
26 G_LAST_UPDATED_BY CONSTANT NUMBER := 21;
27 G_LAST_UPDATE_DATE CONSTANT NUMBER := 22;
28 G_LAST_UPDATE_LOGIN CONSTANT NUMBER := 23;
29 G_PROGRAM_APPLICATION CONSTANT NUMBER := 24;
30 G_PROGRAM CONSTANT NUMBER := 25;
31 G_PROGRAM_UPDATE_DATE CONSTANT NUMBER := 26;
32 G_PTE_SOURCESYSTEM_FNAREA CONSTANT NUMBER := 27;
33 G_PTE_SOURCE_SYSTEM CONSTANT NUMBER := 28;
34 G_REQUEST CONSTANT NUMBER := 29;
35 G_SEEDED CONSTANT NUMBER := 30;
36 G_MAX_ATTR_ID CONSTANT NUMBER := 31;
37
38 -- Procedure Clear_Dependent_Attr
39
40 PROCEDURE Clear_Dependent_Attr
41 ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
42 , p_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type
43 , p_old_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type :=
44 QP_Attr_Map_PUB.G_MISS_FNA_REC
45 , x_FNA_rec OUT NOCOPY QP_Attr_Map_PUB.Fna_Rec_Type
46 );
47
48 -- Procedure Apply_Attribute_Changes
49
50 PROCEDURE Apply_Attribute_Changes
51 ( p_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type
52 , p_old_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type :=
53 QP_Attr_Map_PUB.G_MISS_FNA_REC
54 , p_called_from_ui IN VARCHAR2
55 , x_FNA_rec OUT NOCOPY QP_Attr_Map_PUB.Fna_Rec_Type
56 );
57
58 -- Function Complete_Record
59
60 FUNCTION Complete_Record
61 ( p_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type
62 , p_old_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type
63 ) RETURN QP_Attr_Map_PUB.Fna_Rec_Type;
64
65 -- Function Convert_Miss_To_Null
66
67 FUNCTION Convert_Miss_To_Null
68 ( p_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type
69 ) RETURN QP_Attr_Map_PUB.Fna_Rec_Type;
70
71 -- Procedure Update_Row
72
73 PROCEDURE Update_Row
74 ( p_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type
75 );
76
77 -- Procedure Insert_Row
78
79 PROCEDURE Insert_Row
80 ( p_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type
81 );
82
83 -- Procedure Delete_Row
84
85 PROCEDURE Delete_Row
86 ( p_pte_sourcesystem_fnarea_id IN NUMBER
87 );
88
89 -- Function Query_Row
90
91 FUNCTION Query_Row
92 ( p_pte_sourcesystem_fnarea_id IN NUMBER
93 ) RETURN QP_Attr_Map_PUB.Fna_Rec_Type;
94
95 -- Function Query_Rows
96
97 --
98
99 FUNCTION Query_Rows
100 ( p_pte_sourcesystem_fnarea_id IN NUMBER :=
101 FND_API.G_MISS_NUM
102 , p_pte_source_system_id IN NUMBER :=
103 FND_API.G_MISS_NUM
104 ) RETURN QP_Attr_Map_PUB.Fna_Tbl_Type;
105
106 -- Procedure lock_Row
107 --
108
109 PROCEDURE Lock_Row
110 ( x_return_status OUT NOCOPY VARCHAR2
111 , p_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type
112 , x_FNA_rec OUT NOCOPY QP_Attr_Map_PUB.Fna_Rec_Type
113 );
114
115 -- Function Get_Values
116
117 FUNCTION Get_Values
118 ( p_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type
119 , p_old_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type :=
120 QP_Attr_Map_PUB.G_MISS_FNA_REC
121 ) RETURN QP_Attr_Map_PUB.Fna_Val_Rec_Type;
122
123 -- Function Get_Ids
124
125 FUNCTION Get_Ids
126 ( p_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type
127 , p_FNA_val_rec IN QP_Attr_Map_PUB.Fna_Val_Rec_Type
128 ) RETURN QP_Attr_Map_PUB.Fna_Rec_Type;
129
130 PROCEDURE Warn_Disable_Delete_Fna
131 ( p_action IN VARCHAR2
132 , p_called_from_ui IN VARCHAR2
133 , p_functional_area_id NUMBER
134 , p_pte_ss_id IN NUMBER
135 );
136
137 END QP_Fna_Util;