33: -- Procedure Clear_Dependent_Attr
34:
35: PROCEDURE Clear_Dependent_Attr
36: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
37: , p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type
38: , p_old_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type :=
39: OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC
40: , x_Contract_rec OUT OE_Pricing_Cont_PUB.Contract_Rec_Type
41: );
34:
35: PROCEDURE Clear_Dependent_Attr
36: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
37: , p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type
38: , p_old_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type :=
39: OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC
40: , x_Contract_rec OUT OE_Pricing_Cont_PUB.Contract_Rec_Type
41: );
42:
35: PROCEDURE Clear_Dependent_Attr
36: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
37: , p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type
38: , p_old_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type :=
39: OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC
40: , x_Contract_rec OUT OE_Pricing_Cont_PUB.Contract_Rec_Type
41: );
42:
43: -- Procedure Apply_Attribute_Changes
36: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
37: , p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type
38: , p_old_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type :=
39: OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC
40: , x_Contract_rec OUT OE_Pricing_Cont_PUB.Contract_Rec_Type
41: );
42:
43: -- Procedure Apply_Attribute_Changes
44:
42:
43: -- Procedure Apply_Attribute_Changes
44:
45: PROCEDURE Apply_Attribute_Changes
46: ( p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type
47: , p_old_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type :=
48: OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC
49: , x_Contract_rec OUT OE_Pricing_Cont_PUB.Contract_Rec_Type
50: );
43: -- Procedure Apply_Attribute_Changes
44:
45: PROCEDURE Apply_Attribute_Changes
46: ( p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type
47: , p_old_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type :=
48: OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC
49: , x_Contract_rec OUT OE_Pricing_Cont_PUB.Contract_Rec_Type
50: );
51:
44:
45: PROCEDURE Apply_Attribute_Changes
46: ( p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type
47: , p_old_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type :=
48: OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC
49: , x_Contract_rec OUT OE_Pricing_Cont_PUB.Contract_Rec_Type
50: );
51:
52: -- Function Complete_Record
45: PROCEDURE Apply_Attribute_Changes
46: ( p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type
47: , p_old_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type :=
48: OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC
49: , x_Contract_rec OUT OE_Pricing_Cont_PUB.Contract_Rec_Type
50: );
51:
52: -- Function Complete_Record
53:
51:
52: -- Function Complete_Record
53:
54: FUNCTION Complete_Record
55: ( p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type
56: , p_old_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type
57: ) RETURN OE_Pricing_Cont_PUB.Contract_Rec_Type;
58:
59: -- Function Convert_Miss_To_Null
52: -- Function Complete_Record
53:
54: FUNCTION Complete_Record
55: ( p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type
56: , p_old_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type
57: ) RETURN OE_Pricing_Cont_PUB.Contract_Rec_Type;
58:
59: -- Function Convert_Miss_To_Null
60:
53:
54: FUNCTION Complete_Record
55: ( p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type
56: , p_old_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type
57: ) RETURN OE_Pricing_Cont_PUB.Contract_Rec_Type;
58:
59: -- Function Convert_Miss_To_Null
60:
61: FUNCTION Convert_Miss_To_Null
58:
59: -- Function Convert_Miss_To_Null
60:
61: FUNCTION Convert_Miss_To_Null
62: ( p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type
63: ) RETURN OE_Pricing_Cont_PUB.Contract_Rec_Type;
64:
65: -- Procedure Update_Row
66:
59: -- Function Convert_Miss_To_Null
60:
61: FUNCTION Convert_Miss_To_Null
62: ( p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type
63: ) RETURN OE_Pricing_Cont_PUB.Contract_Rec_Type;
64:
65: -- Procedure Update_Row
66:
67: PROCEDURE Update_Row
64:
65: -- Procedure Update_Row
66:
67: PROCEDURE Update_Row
68: ( p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type
69: );
70:
71: -- Procedure Insert_Row
72:
70:
71: -- Procedure Insert_Row
72:
73: PROCEDURE Insert_Row
74: ( p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type
75: );
76:
77: -- Procedure Delete_Row
78:
83: -- Function Query_Row
84:
85: FUNCTION Query_Row
86: ( p_pricing_contract_id IN NUMBER
87: ) RETURN OE_Pricing_Cont_PUB.Contract_Rec_Type;
88:
89: -- Procedure lock_Row
90: --
91:
90: --
91:
92: PROCEDURE Lock_Row
93: ( x_return_status OUT VARCHAR2
94: , p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type
95: , x_Contract_rec OUT OE_Pricing_Cont_PUB.Contract_Rec_Type
96: );
97:
98: -- Function Get_Values
91:
92: PROCEDURE Lock_Row
93: ( x_return_status OUT VARCHAR2
94: , p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type
95: , x_Contract_rec OUT OE_Pricing_Cont_PUB.Contract_Rec_Type
96: );
97:
98: -- Function Get_Values
99:
97:
98: -- Function Get_Values
99:
100: FUNCTION Get_Values
101: ( p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type
102: , p_old_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type :=
103: OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC
104: ) RETURN OE_Pricing_Cont_PUB.Contract_Val_Rec_Type;
105:
98: -- Function Get_Values
99:
100: FUNCTION Get_Values
101: ( p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type
102: , p_old_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type :=
103: OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC
104: ) RETURN OE_Pricing_Cont_PUB.Contract_Val_Rec_Type;
105:
106: -- Function Get_Ids
99:
100: FUNCTION Get_Values
101: ( p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type
102: , p_old_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type :=
103: OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC
104: ) RETURN OE_Pricing_Cont_PUB.Contract_Val_Rec_Type;
105:
106: -- Function Get_Ids
107:
100: FUNCTION Get_Values
101: ( p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type
102: , p_old_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type :=
103: OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC
104: ) RETURN OE_Pricing_Cont_PUB.Contract_Val_Rec_Type;
105:
106: -- Function Get_Ids
107:
108: FUNCTION Get_Ids
105:
106: -- Function Get_Ids
107:
108: FUNCTION Get_Ids
109: ( p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type
110: , p_Contract_val_rec IN OE_Pricing_Cont_PUB.Contract_Val_Rec_Type
111: ) RETURN OE_Pricing_Cont_PUB.Contract_Rec_Type;
112:
113: END OE_Contract_Util;
106: -- Function Get_Ids
107:
108: FUNCTION Get_Ids
109: ( p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type
110: , p_Contract_val_rec IN OE_Pricing_Cont_PUB.Contract_Val_Rec_Type
111: ) RETURN OE_Pricing_Cont_PUB.Contract_Rec_Type;
112:
113: END OE_Contract_Util;
107:
108: FUNCTION Get_Ids
109: ( p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type
110: , p_Contract_val_rec IN OE_Pricing_Cont_PUB.Contract_Val_Rec_Type
111: ) RETURN OE_Pricing_Cont_PUB.Contract_Rec_Type;
112:
113: END OE_Contract_Util;