41: -- Procedure Clear_Dependent_Attr
42:
43: PROCEDURE Clear_Dependent_Attr
44: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
45: , p_CON_rec IN QP_Attributes_PUB.Con_Rec_Type
46: , p_old_CON_rec IN QP_Attributes_PUB.Con_Rec_Type :=
47: QP_Attributes_PUB.G_MISS_CON_REC
48: , x_CON_rec OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Con_Rec_Type
49: );
42:
43: PROCEDURE Clear_Dependent_Attr
44: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
45: , p_CON_rec IN QP_Attributes_PUB.Con_Rec_Type
46: , p_old_CON_rec IN QP_Attributes_PUB.Con_Rec_Type :=
47: QP_Attributes_PUB.G_MISS_CON_REC
48: , x_CON_rec OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Con_Rec_Type
49: );
50:
43: PROCEDURE Clear_Dependent_Attr
44: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
45: , p_CON_rec IN QP_Attributes_PUB.Con_Rec_Type
46: , p_old_CON_rec IN QP_Attributes_PUB.Con_Rec_Type :=
47: QP_Attributes_PUB.G_MISS_CON_REC
48: , x_CON_rec OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Con_Rec_Type
49: );
50:
51: -- Procedure Apply_Attribute_Changes
44: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
45: , p_CON_rec IN QP_Attributes_PUB.Con_Rec_Type
46: , p_old_CON_rec IN QP_Attributes_PUB.Con_Rec_Type :=
47: QP_Attributes_PUB.G_MISS_CON_REC
48: , x_CON_rec OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Con_Rec_Type
49: );
50:
51: -- Procedure Apply_Attribute_Changes
52:
50:
51: -- Procedure Apply_Attribute_Changes
52:
53: PROCEDURE Apply_Attribute_Changes
54: ( p_CON_rec IN QP_Attributes_PUB.Con_Rec_Type
55: , p_old_CON_rec IN QP_Attributes_PUB.Con_Rec_Type :=
56: QP_Attributes_PUB.G_MISS_CON_REC
57: , x_CON_rec OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Con_Rec_Type
58: );
51: -- Procedure Apply_Attribute_Changes
52:
53: PROCEDURE Apply_Attribute_Changes
54: ( p_CON_rec IN QP_Attributes_PUB.Con_Rec_Type
55: , p_old_CON_rec IN QP_Attributes_PUB.Con_Rec_Type :=
56: QP_Attributes_PUB.G_MISS_CON_REC
57: , x_CON_rec OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Con_Rec_Type
58: );
59:
52:
53: PROCEDURE Apply_Attribute_Changes
54: ( p_CON_rec IN QP_Attributes_PUB.Con_Rec_Type
55: , p_old_CON_rec IN QP_Attributes_PUB.Con_Rec_Type :=
56: QP_Attributes_PUB.G_MISS_CON_REC
57: , x_CON_rec OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Con_Rec_Type
58: );
59:
60: -- Function Complete_Record
53: PROCEDURE Apply_Attribute_Changes
54: ( p_CON_rec IN QP_Attributes_PUB.Con_Rec_Type
55: , p_old_CON_rec IN QP_Attributes_PUB.Con_Rec_Type :=
56: QP_Attributes_PUB.G_MISS_CON_REC
57: , x_CON_rec OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Con_Rec_Type
58: );
59:
60: -- Function Complete_Record
61:
59:
60: -- Function Complete_Record
61:
62: FUNCTION Complete_Record
63: ( p_CON_rec IN QP_Attributes_PUB.Con_Rec_Type
64: , p_old_CON_rec IN QP_Attributes_PUB.Con_Rec_Type
65: ) RETURN QP_Attributes_PUB.Con_Rec_Type;
66:
67: -- Function Convert_Miss_To_Null
60: -- Function Complete_Record
61:
62: FUNCTION Complete_Record
63: ( p_CON_rec IN QP_Attributes_PUB.Con_Rec_Type
64: , p_old_CON_rec IN QP_Attributes_PUB.Con_Rec_Type
65: ) RETURN QP_Attributes_PUB.Con_Rec_Type;
66:
67: -- Function Convert_Miss_To_Null
68:
61:
62: FUNCTION Complete_Record
63: ( p_CON_rec IN QP_Attributes_PUB.Con_Rec_Type
64: , p_old_CON_rec IN QP_Attributes_PUB.Con_Rec_Type
65: ) RETURN QP_Attributes_PUB.Con_Rec_Type;
66:
67: -- Function Convert_Miss_To_Null
68:
69: FUNCTION Convert_Miss_To_Null
66:
67: -- Function Convert_Miss_To_Null
68:
69: FUNCTION Convert_Miss_To_Null
70: ( p_CON_rec IN QP_Attributes_PUB.Con_Rec_Type
71: ) RETURN QP_Attributes_PUB.Con_Rec_Type;
72:
73: -- Procedure Update_Row
74:
67: -- Function Convert_Miss_To_Null
68:
69: FUNCTION Convert_Miss_To_Null
70: ( p_CON_rec IN QP_Attributes_PUB.Con_Rec_Type
71: ) RETURN QP_Attributes_PUB.Con_Rec_Type;
72:
73: -- Procedure Update_Row
74:
75: PROCEDURE Update_Row
72:
73: -- Procedure Update_Row
74:
75: PROCEDURE Update_Row
76: ( p_CON_rec IN QP_Attributes_PUB.Con_Rec_Type
77: );
78:
79: -- Procedure Insert_Row
80:
78:
79: -- Procedure Insert_Row
80:
81: PROCEDURE Insert_Row
82: ( p_CON_rec IN QP_Attributes_PUB.Con_Rec_Type
83: );
84:
85: -- Procedure Delete_Row
86:
91: -- Function Query_Row
92:
93: FUNCTION Query_Row
94: ( p_prc_context_id IN NUMBER
95: ) RETURN QP_Attributes_PUB.Con_Rec_Type;
96:
97: -- Procedure lock_Row
98: --
99:
98: --
99:
100: PROCEDURE Lock_Row
101: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
102: , p_CON_rec IN QP_Attributes_PUB.Con_Rec_Type
103: , x_CON_rec OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Con_Rec_Type
104: );
105:
106: -- Function Get_Values
99:
100: PROCEDURE Lock_Row
101: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
102: , p_CON_rec IN QP_Attributes_PUB.Con_Rec_Type
103: , x_CON_rec OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Con_Rec_Type
104: );
105:
106: -- Function Get_Values
107:
105:
106: -- Function Get_Values
107:
108: FUNCTION Get_Values
109: ( p_CON_rec IN QP_Attributes_PUB.Con_Rec_Type
110: , p_old_CON_rec IN QP_Attributes_PUB.Con_Rec_Type :=
111: QP_Attributes_PUB.G_MISS_CON_REC
112: ) RETURN QP_Attributes_PUB.Con_Val_Rec_Type;
113:
106: -- Function Get_Values
107:
108: FUNCTION Get_Values
109: ( p_CON_rec IN QP_Attributes_PUB.Con_Rec_Type
110: , p_old_CON_rec IN QP_Attributes_PUB.Con_Rec_Type :=
111: QP_Attributes_PUB.G_MISS_CON_REC
112: ) RETURN QP_Attributes_PUB.Con_Val_Rec_Type;
113:
114: -- Function Get_Ids
107:
108: FUNCTION Get_Values
109: ( p_CON_rec IN QP_Attributes_PUB.Con_Rec_Type
110: , p_old_CON_rec IN QP_Attributes_PUB.Con_Rec_Type :=
111: QP_Attributes_PUB.G_MISS_CON_REC
112: ) RETURN QP_Attributes_PUB.Con_Val_Rec_Type;
113:
114: -- Function Get_Ids
115:
108: FUNCTION Get_Values
109: ( p_CON_rec IN QP_Attributes_PUB.Con_Rec_Type
110: , p_old_CON_rec IN QP_Attributes_PUB.Con_Rec_Type :=
111: QP_Attributes_PUB.G_MISS_CON_REC
112: ) RETURN QP_Attributes_PUB.Con_Val_Rec_Type;
113:
114: -- Function Get_Ids
115:
116: FUNCTION Get_Ids
113:
114: -- Function Get_Ids
115:
116: FUNCTION Get_Ids
117: ( p_CON_rec IN QP_Attributes_PUB.Con_Rec_Type
118: , p_CON_val_rec IN QP_Attributes_PUB.Con_Val_Rec_Type
119: ) RETURN QP_Attributes_PUB.Con_Rec_Type;
120:
121: END QP_Con_Util;
114: -- Function Get_Ids
115:
116: FUNCTION Get_Ids
117: ( p_CON_rec IN QP_Attributes_PUB.Con_Rec_Type
118: , p_CON_val_rec IN QP_Attributes_PUB.Con_Val_Rec_Type
119: ) RETURN QP_Attributes_PUB.Con_Rec_Type;
120:
121: END QP_Con_Util;
115:
116: FUNCTION Get_Ids
117: ( p_CON_rec IN QP_Attributes_PUB.Con_Rec_Type
118: , p_CON_val_rec IN QP_Attributes_PUB.Con_Val_Rec_Type
119: ) RETURN QP_Attributes_PUB.Con_Rec_Type;
120:
121: END QP_Con_Util;