36: -- Procedure Clear_Dependent_Attr
37:
38: PROCEDURE Clear_Dependent_Attr
39: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
40: , p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
41: , p_old_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type :=
42: QP_Attr_Map_PUB.G_MISS_SSC_REC
43: , x_SSC_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Rec_Type
44: );
37:
38: PROCEDURE Clear_Dependent_Attr
39: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
40: , p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
41: , p_old_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type :=
42: QP_Attr_Map_PUB.G_MISS_SSC_REC
43: , x_SSC_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Rec_Type
44: );
45:
38: PROCEDURE Clear_Dependent_Attr
39: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
40: , p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
41: , p_old_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type :=
42: QP_Attr_Map_PUB.G_MISS_SSC_REC
43: , x_SSC_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Rec_Type
44: );
45:
46: -- Procedure Apply_Attribute_Changes
39: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
40: , p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
41: , p_old_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type :=
42: QP_Attr_Map_PUB.G_MISS_SSC_REC
43: , x_SSC_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Rec_Type
44: );
45:
46: -- Procedure Apply_Attribute_Changes
47:
45:
46: -- Procedure Apply_Attribute_Changes
47:
48: PROCEDURE Apply_Attribute_Changes
49: ( p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
50: , p_old_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type :=
51: QP_Attr_Map_PUB.G_MISS_SSC_REC
52: , x_SSC_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Rec_Type
53: );
46: -- Procedure Apply_Attribute_Changes
47:
48: PROCEDURE Apply_Attribute_Changes
49: ( p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
50: , p_old_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type :=
51: QP_Attr_Map_PUB.G_MISS_SSC_REC
52: , x_SSC_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Rec_Type
53: );
54:
47:
48: PROCEDURE Apply_Attribute_Changes
49: ( p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
50: , p_old_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type :=
51: QP_Attr_Map_PUB.G_MISS_SSC_REC
52: , x_SSC_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Rec_Type
53: );
54:
55: -- Function Complete_Record
48: PROCEDURE Apply_Attribute_Changes
49: ( p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
50: , p_old_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type :=
51: QP_Attr_Map_PUB.G_MISS_SSC_REC
52: , x_SSC_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Rec_Type
53: );
54:
55: -- Function Complete_Record
56:
54:
55: -- Function Complete_Record
56:
57: FUNCTION Complete_Record
58: ( p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
59: , p_old_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
60: ) RETURN QP_Attr_Map_PUB.Ssc_Rec_Type;
61:
62: -- Function Convert_Miss_To_Null
55: -- Function Complete_Record
56:
57: FUNCTION Complete_Record
58: ( p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
59: , p_old_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
60: ) RETURN QP_Attr_Map_PUB.Ssc_Rec_Type;
61:
62: -- Function Convert_Miss_To_Null
63:
56:
57: FUNCTION Complete_Record
58: ( p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
59: , p_old_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
60: ) RETURN QP_Attr_Map_PUB.Ssc_Rec_Type;
61:
62: -- Function Convert_Miss_To_Null
63:
64: FUNCTION Convert_Miss_To_Null
61:
62: -- Function Convert_Miss_To_Null
63:
64: FUNCTION Convert_Miss_To_Null
65: ( p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
66: ) RETURN QP_Attr_Map_PUB.Ssc_Rec_Type;
67:
68: -- Procedure Update_Row
69:
62: -- Function Convert_Miss_To_Null
63:
64: FUNCTION Convert_Miss_To_Null
65: ( p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
66: ) RETURN QP_Attr_Map_PUB.Ssc_Rec_Type;
67:
68: -- Procedure Update_Row
69:
70: PROCEDURE Update_Row
67:
68: -- Procedure Update_Row
69:
70: PROCEDURE Update_Row
71: ( p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
72: );
73:
74: -- Procedure Insert_Row
75:
73:
74: -- Procedure Insert_Row
75:
76: PROCEDURE Insert_Row
77: ( p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
78: );
79:
80: -- Procedure Delete_Row
81:
86: -- Function Query_Row
87:
88: FUNCTION Query_Row
89: ( p_pte_source_system_id IN NUMBER
90: ) RETURN QP_Attr_Map_PUB.Ssc_Rec_Type;
91:
92: -- Function Query_Rows
93:
94: --
97: ( p_pte_source_system_id IN NUMBER :=
98: FND_API.G_MISS_NUM
99: , p_lookup_code IN VARCHAR2 :=
100: FND_API.G_MISS_CHAR
101: ) RETURN QP_Attr_Map_PUB.Ssc_Tbl_Type;
102:
103: -- Procedure lock_Row
104: --
105:
104: --
105:
106: PROCEDURE Lock_Row
107: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
108: , p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
109: , x_SSC_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Rec_Type
110: );
111:
112: -- Function Get_Values
105:
106: PROCEDURE Lock_Row
107: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
108: , p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
109: , x_SSC_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Rec_Type
110: );
111:
112: -- Function Get_Values
113:
111:
112: -- Function Get_Values
113:
114: FUNCTION Get_Values
115: ( p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
116: , p_old_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type :=
117: QP_Attr_Map_PUB.G_MISS_SSC_REC
118: ) RETURN QP_Attr_Map_PUB.Ssc_Val_Rec_Type;
119:
112: -- Function Get_Values
113:
114: FUNCTION Get_Values
115: ( p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
116: , p_old_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type :=
117: QP_Attr_Map_PUB.G_MISS_SSC_REC
118: ) RETURN QP_Attr_Map_PUB.Ssc_Val_Rec_Type;
119:
120: -- Function Get_Ids
113:
114: FUNCTION Get_Values
115: ( p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
116: , p_old_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type :=
117: QP_Attr_Map_PUB.G_MISS_SSC_REC
118: ) RETURN QP_Attr_Map_PUB.Ssc_Val_Rec_Type;
119:
120: -- Function Get_Ids
121:
114: FUNCTION Get_Values
115: ( p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
116: , p_old_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type :=
117: QP_Attr_Map_PUB.G_MISS_SSC_REC
118: ) RETURN QP_Attr_Map_PUB.Ssc_Val_Rec_Type;
119:
120: -- Function Get_Ids
121:
122: FUNCTION Get_Ids
119:
120: -- Function Get_Ids
121:
122: FUNCTION Get_Ids
123: ( p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
124: , p_SSC_val_rec IN QP_Attr_Map_PUB.Ssc_Val_Rec_Type
125: ) RETURN QP_Attr_Map_PUB.Ssc_Rec_Type;
126:
127: END QP_Ssc_Util;
120: -- Function Get_Ids
121:
122: FUNCTION Get_Ids
123: ( p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
124: , p_SSC_val_rec IN QP_Attr_Map_PUB.Ssc_Val_Rec_Type
125: ) RETURN QP_Attr_Map_PUB.Ssc_Rec_Type;
126:
127: END QP_Ssc_Util;
121:
122: FUNCTION Get_Ids
123: ( p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
124: , p_SSC_val_rec IN QP_Attr_Map_PUB.Ssc_Val_Rec_Type
125: ) RETURN QP_Attr_Map_PUB.Ssc_Rec_Type;
126:
127: END QP_Ssc_Util;