42: -- Procedure Clear_Dependent_Attr
43:
44: PROCEDURE Clear_Dependent_Attr
45: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
46: , p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
47: , p_old_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type :=
48: QP_Attr_Map_PUB.G_MISS_PSG_REC
49: , x_PSG_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Rec_Type
50: );
43:
44: PROCEDURE Clear_Dependent_Attr
45: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
46: , p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
47: , p_old_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type :=
48: QP_Attr_Map_PUB.G_MISS_PSG_REC
49: , x_PSG_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Rec_Type
50: );
51:
44: PROCEDURE Clear_Dependent_Attr
45: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
46: , p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
47: , p_old_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type :=
48: QP_Attr_Map_PUB.G_MISS_PSG_REC
49: , x_PSG_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Rec_Type
50: );
51:
52: -- Procedure Apply_Attribute_Changes
45: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
46: , p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
47: , p_old_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type :=
48: QP_Attr_Map_PUB.G_MISS_PSG_REC
49: , x_PSG_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Rec_Type
50: );
51:
52: -- Procedure Apply_Attribute_Changes
53:
51:
52: -- Procedure Apply_Attribute_Changes
53:
54: PROCEDURE Apply_Attribute_Changes
55: ( p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
56: , p_old_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type :=
57: QP_Attr_Map_PUB.G_MISS_PSG_REC
58: , x_PSG_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Rec_Type
59: );
52: -- Procedure Apply_Attribute_Changes
53:
54: PROCEDURE Apply_Attribute_Changes
55: ( p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
56: , p_old_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type :=
57: QP_Attr_Map_PUB.G_MISS_PSG_REC
58: , x_PSG_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Rec_Type
59: );
60:
53:
54: PROCEDURE Apply_Attribute_Changes
55: ( p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
56: , p_old_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type :=
57: QP_Attr_Map_PUB.G_MISS_PSG_REC
58: , x_PSG_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Rec_Type
59: );
60:
61: -- Function Complete_Record
54: PROCEDURE Apply_Attribute_Changes
55: ( p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
56: , p_old_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type :=
57: QP_Attr_Map_PUB.G_MISS_PSG_REC
58: , x_PSG_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Rec_Type
59: );
60:
61: -- Function Complete_Record
62:
60:
61: -- Function Complete_Record
62:
63: FUNCTION Complete_Record
64: ( p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
65: , p_old_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
66: ) RETURN QP_Attr_Map_PUB.Psg_Rec_Type;
67:
68: -- Function Convert_Miss_To_Null
61: -- Function Complete_Record
62:
63: FUNCTION Complete_Record
64: ( p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
65: , p_old_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
66: ) RETURN QP_Attr_Map_PUB.Psg_Rec_Type;
67:
68: -- Function Convert_Miss_To_Null
69:
62:
63: FUNCTION Complete_Record
64: ( p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
65: , p_old_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
66: ) RETURN QP_Attr_Map_PUB.Psg_Rec_Type;
67:
68: -- Function Convert_Miss_To_Null
69:
70: FUNCTION Convert_Miss_To_Null
67:
68: -- Function Convert_Miss_To_Null
69:
70: FUNCTION Convert_Miss_To_Null
71: ( p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
72: ) RETURN QP_Attr_Map_PUB.Psg_Rec_Type;
73:
74: -- Procedure Update_Row
75:
68: -- Function Convert_Miss_To_Null
69:
70: FUNCTION Convert_Miss_To_Null
71: ( p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
72: ) RETURN QP_Attr_Map_PUB.Psg_Rec_Type;
73:
74: -- Procedure Update_Row
75:
76: PROCEDURE Update_Row
73:
74: -- Procedure Update_Row
75:
76: PROCEDURE Update_Row
77: ( p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
78: );
79:
80: -- Procedure Insert_Row
81:
79:
80: -- Procedure Insert_Row
81:
82: PROCEDURE Insert_Row
83: ( p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
84: );
85:
86: -- Procedure Delete_Row
87:
92: -- Function Query_Row
93:
94: FUNCTION Query_Row
95: ( p_segment_pte_id IN NUMBER
96: ) RETURN QP_Attr_Map_PUB.Psg_Rec_Type;
97:
98: -- Function Query_Rows
99:
100: --
103: ( p_segment_pte_id IN NUMBER :=
104: FND_API.G_MISS_NUM
105: , p_lookup_code IN VARCHAR2 :=
106: FND_API.G_MISS_CHAR
107: ) RETURN QP_Attr_Map_PUB.Psg_Tbl_Type;
108:
109: -- Procedure lock_Row
110: --
111:
110: --
111:
112: PROCEDURE Lock_Row
113: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
114: , p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
115: , x_PSG_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Rec_Type
116: );
117:
118: -- Function Get_Values
111:
112: PROCEDURE Lock_Row
113: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
114: , p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
115: , x_PSG_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Rec_Type
116: );
117:
118: -- Function Get_Values
119:
117:
118: -- Function Get_Values
119:
120: FUNCTION Get_Values
121: ( p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
122: , p_old_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type :=
123: QP_Attr_Map_PUB.G_MISS_PSG_REC
124: ) RETURN QP_Attr_Map_PUB.Psg_Val_Rec_Type;
125:
118: -- Function Get_Values
119:
120: FUNCTION Get_Values
121: ( p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
122: , p_old_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type :=
123: QP_Attr_Map_PUB.G_MISS_PSG_REC
124: ) RETURN QP_Attr_Map_PUB.Psg_Val_Rec_Type;
125:
126: -- Function Get_Ids
119:
120: FUNCTION Get_Values
121: ( p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
122: , p_old_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type :=
123: QP_Attr_Map_PUB.G_MISS_PSG_REC
124: ) RETURN QP_Attr_Map_PUB.Psg_Val_Rec_Type;
125:
126: -- Function Get_Ids
127:
120: FUNCTION Get_Values
121: ( p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
122: , p_old_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type :=
123: QP_Attr_Map_PUB.G_MISS_PSG_REC
124: ) RETURN QP_Attr_Map_PUB.Psg_Val_Rec_Type;
125:
126: -- Function Get_Ids
127:
128: FUNCTION Get_Ids
125:
126: -- Function Get_Ids
127:
128: FUNCTION Get_Ids
129: ( p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
130: , p_PSG_val_rec IN QP_Attr_Map_PUB.Psg_Val_Rec_Type
131: ) RETURN QP_Attr_Map_PUB.Psg_Rec_Type;
132:
133: END QP_Psg_Util;
126: -- Function Get_Ids
127:
128: FUNCTION Get_Ids
129: ( p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
130: , p_PSG_val_rec IN QP_Attr_Map_PUB.Psg_Val_Rec_Type
131: ) RETURN QP_Attr_Map_PUB.Psg_Rec_Type;
132:
133: END QP_Psg_Util;
127:
128: FUNCTION Get_Ids
129: ( p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
130: , p_PSG_val_rec IN QP_Attr_Map_PUB.Psg_Val_Rec_Type
131: ) RETURN QP_Attr_Map_PUB.Psg_Rec_Type;
132:
133: END QP_Psg_Util;