42: -- Procedure Clear_Dependent_Attr
43:
44: PROCEDURE Clear_Dependent_Attr
45: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
46: , p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type
47: , p_old_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type :=
48: QP_Currency_PUB.G_MISS_CURR_LISTS_REC
49: , x_CURR_LISTS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Lists_Rec_Type
50: );
43:
44: PROCEDURE Clear_Dependent_Attr
45: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
46: , p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type
47: , p_old_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type :=
48: QP_Currency_PUB.G_MISS_CURR_LISTS_REC
49: , x_CURR_LISTS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Lists_Rec_Type
50: );
51:
44: PROCEDURE Clear_Dependent_Attr
45: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
46: , p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type
47: , p_old_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type :=
48: QP_Currency_PUB.G_MISS_CURR_LISTS_REC
49: , x_CURR_LISTS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Lists_Rec_Type
50: );
51:
52: -- Procedure Apply_Attribute_Changes
45: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
46: , p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type
47: , p_old_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type :=
48: QP_Currency_PUB.G_MISS_CURR_LISTS_REC
49: , x_CURR_LISTS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Lists_Rec_Type
50: );
51:
52: -- Procedure Apply_Attribute_Changes
53:
51:
52: -- Procedure Apply_Attribute_Changes
53:
54: PROCEDURE Apply_Attribute_Changes
55: ( p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type
56: , p_old_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type :=
57: QP_Currency_PUB.G_MISS_CURR_LISTS_REC
58: , x_CURR_LISTS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Lists_Rec_Type
59: );
52: -- Procedure Apply_Attribute_Changes
53:
54: PROCEDURE Apply_Attribute_Changes
55: ( p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type
56: , p_old_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type :=
57: QP_Currency_PUB.G_MISS_CURR_LISTS_REC
58: , x_CURR_LISTS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Lists_Rec_Type
59: );
60:
53:
54: PROCEDURE Apply_Attribute_Changes
55: ( p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type
56: , p_old_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type :=
57: QP_Currency_PUB.G_MISS_CURR_LISTS_REC
58: , x_CURR_LISTS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Lists_Rec_Type
59: );
60:
61: -- Function Complete_Record
54: PROCEDURE Apply_Attribute_Changes
55: ( p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type
56: , p_old_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type :=
57: QP_Currency_PUB.G_MISS_CURR_LISTS_REC
58: , x_CURR_LISTS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Lists_Rec_Type
59: );
60:
61: -- Function Complete_Record
62:
60:
61: -- Function Complete_Record
62:
63: FUNCTION Complete_Record
64: ( p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type
65: , p_old_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type
66: ) RETURN QP_Currency_PUB.Curr_Lists_Rec_Type;
67:
68: -- Function Convert_Miss_To_Null
61: -- Function Complete_Record
62:
63: FUNCTION Complete_Record
64: ( p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type
65: , p_old_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type
66: ) RETURN QP_Currency_PUB.Curr_Lists_Rec_Type;
67:
68: -- Function Convert_Miss_To_Null
69:
62:
63: FUNCTION Complete_Record
64: ( p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type
65: , p_old_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type
66: ) RETURN QP_Currency_PUB.Curr_Lists_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_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type
72: ) RETURN QP_Currency_PUB.Curr_Lists_Rec_Type;
73:
74: -- Procedure Update_Row
75:
68: -- Function Convert_Miss_To_Null
69:
70: FUNCTION Convert_Miss_To_Null
71: ( p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type
72: ) RETURN QP_Currency_PUB.Curr_Lists_Rec_Type;
73:
74: -- Procedure Update_Row
75:
76: PROCEDURE Update_Row
73:
74: -- Procedure Update_Row
75:
76: PROCEDURE Update_Row
77: ( p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type
78: );
79:
80: -- Procedure Insert_Row
81:
79:
80: -- Procedure Insert_Row
81:
82: PROCEDURE Insert_Row
83: ( p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type
84: );
85:
86: -- Procedure Delete_Row
87:
92: -- Function Query_Row
93:
94: FUNCTION Query_Row
95: ( p_currency_header_id IN NUMBER
96: ) RETURN QP_Currency_PUB.Curr_Lists_Rec_Type;
97:
98: -- Procedure lock_Row
99: --
100:
99: --
100:
101: PROCEDURE Lock_Row
102: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
103: , p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type
104: , x_CURR_LISTS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Lists_Rec_Type
105: );
106:
107: -- Function Get_Values
100:
101: PROCEDURE Lock_Row
102: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
103: , p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type
104: , x_CURR_LISTS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Lists_Rec_Type
105: );
106:
107: -- Function Get_Values
108:
106:
107: -- Function Get_Values
108:
109: FUNCTION Get_Values
110: ( p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type
111: , p_old_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type :=
112: QP_Currency_PUB.G_MISS_CURR_LISTS_REC
113: ) RETURN QP_Currency_PUB.Curr_Lists_Val_Rec_Type;
114:
107: -- Function Get_Values
108:
109: FUNCTION Get_Values
110: ( p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type
111: , p_old_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type :=
112: QP_Currency_PUB.G_MISS_CURR_LISTS_REC
113: ) RETURN QP_Currency_PUB.Curr_Lists_Val_Rec_Type;
114:
115: -- Function Get_Ids
108:
109: FUNCTION Get_Values
110: ( p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type
111: , p_old_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type :=
112: QP_Currency_PUB.G_MISS_CURR_LISTS_REC
113: ) RETURN QP_Currency_PUB.Curr_Lists_Val_Rec_Type;
114:
115: -- Function Get_Ids
116:
109: FUNCTION Get_Values
110: ( p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type
111: , p_old_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type :=
112: QP_Currency_PUB.G_MISS_CURR_LISTS_REC
113: ) RETURN QP_Currency_PUB.Curr_Lists_Val_Rec_Type;
114:
115: -- Function Get_Ids
116:
117: FUNCTION Get_Ids
114:
115: -- Function Get_Ids
116:
117: FUNCTION Get_Ids
118: ( p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type
119: , p_CURR_LISTS_val_rec IN QP_Currency_PUB.Curr_Lists_Val_Rec_Type
120: ) RETURN QP_Currency_PUB.Curr_Lists_Rec_Type;
121:
122: END QP_Curr_Lists_Util;
115: -- Function Get_Ids
116:
117: FUNCTION Get_Ids
118: ( p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type
119: , p_CURR_LISTS_val_rec IN QP_Currency_PUB.Curr_Lists_Val_Rec_Type
120: ) RETURN QP_Currency_PUB.Curr_Lists_Rec_Type;
121:
122: END QP_Curr_Lists_Util;
116:
117: FUNCTION Get_Ids
118: ( p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type
119: , p_CURR_LISTS_val_rec IN QP_Currency_PUB.Curr_Lists_Val_Rec_Type
120: ) RETURN QP_Currency_PUB.Curr_Lists_Rec_Type;
121:
122: END QP_Curr_Lists_Util;