[Home] [Help]
PACKAGE: APPS.QP_PTE_UTIL
Source
1 PACKAGE QP_Pte_Util AUTHID CURRENT_USER AS
2 /* $Header: QPXUPTES.pls 120.1 2005/06/12 23:47:41 appldev $ */
3
4 -- Attributes global constants
5
6 G_DESCRIPTION CONSTANT NUMBER := 1;
7 G_ENABLED CONSTANT NUMBER := 2;
8 G_END_DATE_ACTIVE CONSTANT NUMBER := 3;
9 G_LOOKUP CONSTANT NUMBER := 4;
10 G_LOOKUP_TYPE CONSTANT NUMBER := 5;
11 G_MEANING CONSTANT NUMBER := 6;
12 G_START_DATE_ACTIVE CONSTANT NUMBER := 7;
13 G_MAX_ATTR_ID CONSTANT NUMBER := 8;
14
15 -- Procedure Clear_Dependent_Attr
16
17 PROCEDURE Clear_Dependent_Attr
18 ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
19 , p_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type
20 , p_old_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type :=
21 QP_Attr_Map_PUB.G_MISS_PTE_REC
22 , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Pte_Rec_Type
23 );
24
25 -- Procedure Apply_Attribute_Changes
26
27 PROCEDURE Apply_Attribute_Changes
28 ( p_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type
29 , p_old_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type :=
30 QP_Attr_Map_PUB.G_MISS_PTE_REC
31 , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Pte_Rec_Type
32 );
33
34 -- Function Complete_Record
35
36 FUNCTION Complete_Record
37 ( p_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type
38 , p_old_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type
39 ) RETURN QP_Attr_Map_PUB.Pte_Rec_Type;
40
41 -- Function Convert_Miss_To_Null
42
43 FUNCTION Convert_Miss_To_Null
44 ( p_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type
45 ) RETURN QP_Attr_Map_PUB.Pte_Rec_Type;
46
47 -- Procedure Update_Row
48
49 PROCEDURE Update_Row
50 ( p_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type
51 );
52
53 -- Procedure Insert_Row
54
55 PROCEDURE Insert_Row
56 ( p_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type
57 );
58
59 -- Procedure Delete_Row
60
61 PROCEDURE Delete_Row
62 ( p_lookup_code IN VARCHAR2
63 );
64
65 -- Function Query_Row
66
67 FUNCTION Query_Row
68 ( p_lookup_code IN VARCHAR2
69 ) RETURN QP_Attr_Map_PUB.Pte_Rec_Type;
70
71 -- Procedure lock_Row
72 --
73
74 PROCEDURE Lock_Row
75 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
76 , p_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type
77 , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Pte_Rec_Type
78 );
79
80 -- Function Get_Values
81
82 FUNCTION Get_Values
83 ( p_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type
84 , p_old_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type :=
85 QP_Attr_Map_PUB.G_MISS_PTE_REC
86 ) RETURN QP_Attr_Map_PUB.Pte_Val_Rec_Type;
87
88 -- Function Get_Ids
89
90 FUNCTION Get_Ids
91 ( p_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type
92 , p_PTE_val_rec IN QP_Attr_Map_PUB.Pte_Val_Rec_Type
93 ) RETURN QP_Attr_Map_PUB.Pte_Rec_Type;
94
95 END QP_Pte_Util;