54: -- Procedure Clear_Dependent_Attr
55:
56: PROCEDURE Clear_Dependent_Attr
57: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
58: , p_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type
59: , p_old_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type :=
60: QP_Currency_PUB.G_MISS_CURR_DETAILS_REC
61: , x_CURR_DETAILS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Details_Rec_Type
62: );
55:
56: PROCEDURE Clear_Dependent_Attr
57: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
58: , p_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type
59: , p_old_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type :=
60: QP_Currency_PUB.G_MISS_CURR_DETAILS_REC
61: , x_CURR_DETAILS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Details_Rec_Type
62: );
63:
56: PROCEDURE Clear_Dependent_Attr
57: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
58: , p_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type
59: , p_old_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type :=
60: QP_Currency_PUB.G_MISS_CURR_DETAILS_REC
61: , x_CURR_DETAILS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Details_Rec_Type
62: );
63:
64: -- Procedure Apply_Attribute_Changes
57: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
58: , p_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type
59: , p_old_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type :=
60: QP_Currency_PUB.G_MISS_CURR_DETAILS_REC
61: , x_CURR_DETAILS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Details_Rec_Type
62: );
63:
64: -- Procedure Apply_Attribute_Changes
65:
63:
64: -- Procedure Apply_Attribute_Changes
65:
66: PROCEDURE Apply_Attribute_Changes
67: ( p_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type
68: , p_old_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type :=
69: QP_Currency_PUB.G_MISS_CURR_DETAILS_REC
70: , x_CURR_DETAILS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Details_Rec_Type
71: );
64: -- Procedure Apply_Attribute_Changes
65:
66: PROCEDURE Apply_Attribute_Changes
67: ( p_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type
68: , p_old_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type :=
69: QP_Currency_PUB.G_MISS_CURR_DETAILS_REC
70: , x_CURR_DETAILS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Details_Rec_Type
71: );
72:
65:
66: PROCEDURE Apply_Attribute_Changes
67: ( p_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type
68: , p_old_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type :=
69: QP_Currency_PUB.G_MISS_CURR_DETAILS_REC
70: , x_CURR_DETAILS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Details_Rec_Type
71: );
72:
73: -- Function Complete_Record
66: PROCEDURE Apply_Attribute_Changes
67: ( p_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type
68: , p_old_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type :=
69: QP_Currency_PUB.G_MISS_CURR_DETAILS_REC
70: , x_CURR_DETAILS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Details_Rec_Type
71: );
72:
73: -- Function Complete_Record
74:
72:
73: -- Function Complete_Record
74:
75: FUNCTION Complete_Record
76: ( p_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type
77: , p_old_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type
78: ) RETURN QP_Currency_PUB.Curr_Details_Rec_Type;
79:
80: -- Function Convert_Miss_To_Null
73: -- Function Complete_Record
74:
75: FUNCTION Complete_Record
76: ( p_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type
77: , p_old_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type
78: ) RETURN QP_Currency_PUB.Curr_Details_Rec_Type;
79:
80: -- Function Convert_Miss_To_Null
81:
74:
75: FUNCTION Complete_Record
76: ( p_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type
77: , p_old_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type
78: ) RETURN QP_Currency_PUB.Curr_Details_Rec_Type;
79:
80: -- Function Convert_Miss_To_Null
81:
82: FUNCTION Convert_Miss_To_Null
79:
80: -- Function Convert_Miss_To_Null
81:
82: FUNCTION Convert_Miss_To_Null
83: ( p_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type
84: ) RETURN QP_Currency_PUB.Curr_Details_Rec_Type;
85:
86: -- Procedure Update_Row
87:
80: -- Function Convert_Miss_To_Null
81:
82: FUNCTION Convert_Miss_To_Null
83: ( p_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type
84: ) RETURN QP_Currency_PUB.Curr_Details_Rec_Type;
85:
86: -- Procedure Update_Row
87:
88: PROCEDURE Update_Row
85:
86: -- Procedure Update_Row
87:
88: PROCEDURE Update_Row
89: ( p_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type
90: );
91:
92: -- Procedure Insert_Row
93:
91:
92: -- Procedure Insert_Row
93:
94: PROCEDURE Insert_Row
95: ( p_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type
96: );
97:
98: -- Procedure Delete_Row
99:
104: -- Function Query_Row
105:
106: FUNCTION Query_Row
107: ( p_currency_detail_id IN NUMBER
108: ) RETURN QP_Currency_PUB.Curr_Details_Rec_Type;
109:
110: -- Function Query_Rows
111:
112: --
115: ( p_currency_detail_id IN NUMBER :=
116: FND_API.G_MISS_NUM
117: , p_currency_header_id IN NUMBER :=
118: FND_API.G_MISS_NUM
119: ) RETURN QP_Currency_PUB.Curr_Details_Tbl_Type;
120:
121: -- Procedure lock_Row
122: --
123:
122: --
123:
124: PROCEDURE Lock_Row
125: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
126: , p_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type
127: , x_CURR_DETAILS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Details_Rec_Type
128: );
129:
130: -- Function Get_Values
123:
124: PROCEDURE Lock_Row
125: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
126: , p_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type
127: , x_CURR_DETAILS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Details_Rec_Type
128: );
129:
130: -- Function Get_Values
131:
129:
130: -- Function Get_Values
131:
132: FUNCTION Get_Values
133: ( p_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type
134: , p_old_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type :=
135: QP_Currency_PUB.G_MISS_CURR_DETAILS_REC
136: ) RETURN QP_Currency_PUB.Curr_Details_Val_Rec_Type;
137:
130: -- Function Get_Values
131:
132: FUNCTION Get_Values
133: ( p_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type
134: , p_old_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type :=
135: QP_Currency_PUB.G_MISS_CURR_DETAILS_REC
136: ) RETURN QP_Currency_PUB.Curr_Details_Val_Rec_Type;
137:
138: -- Function Get_Ids
131:
132: FUNCTION Get_Values
133: ( p_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type
134: , p_old_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type :=
135: QP_Currency_PUB.G_MISS_CURR_DETAILS_REC
136: ) RETURN QP_Currency_PUB.Curr_Details_Val_Rec_Type;
137:
138: -- Function Get_Ids
139:
132: FUNCTION Get_Values
133: ( p_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type
134: , p_old_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type :=
135: QP_Currency_PUB.G_MISS_CURR_DETAILS_REC
136: ) RETURN QP_Currency_PUB.Curr_Details_Val_Rec_Type;
137:
138: -- Function Get_Ids
139:
140: FUNCTION Get_Ids
137:
138: -- Function Get_Ids
139:
140: FUNCTION Get_Ids
141: ( p_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type
142: , p_CURR_DETAILS_val_rec IN QP_Currency_PUB.Curr_Details_Val_Rec_Type
143: ) RETURN QP_Currency_PUB.Curr_Details_Rec_Type;
144:
145: END QP_Curr_Details_Util;
138: -- Function Get_Ids
139:
140: FUNCTION Get_Ids
141: ( p_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type
142: , p_CURR_DETAILS_val_rec IN QP_Currency_PUB.Curr_Details_Val_Rec_Type
143: ) RETURN QP_Currency_PUB.Curr_Details_Rec_Type;
144:
145: END QP_Curr_Details_Util;
139:
140: FUNCTION Get_Ids
141: ( p_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type
142: , p_CURR_DETAILS_val_rec IN QP_Currency_PUB.Curr_Details_Val_Rec_Type
143: ) RETURN QP_Currency_PUB.Curr_Details_Rec_Type;
144:
145: END QP_Curr_Details_Util;