DBA Data[Home] [Help]

APPS.OE_PRICE_LIST_UTIL dependencies on OE_PRICE_LIST_PUB

Line 49: , p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type

45: -- Procedure Clear_Dependent_Attr
46:
47: PROCEDURE Clear_Dependent_Attr
48: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
49: , p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
50: , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
51: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC
52: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
53: );

Line 50: , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=

46:
47: PROCEDURE Clear_Dependent_Attr
48: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
49: , p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
50: , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
51: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC
52: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
53: );
54:

Line 51: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC

47: PROCEDURE Clear_Dependent_Attr
48: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
49: , p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
50: , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
51: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC
52: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
53: );
54:
55: -- Procedure Apply_Attribute_Changes

Line 52: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type

48: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
49: , p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
50: , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
51: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC
52: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
53: );
54:
55: -- Procedure Apply_Attribute_Changes
56:

Line 58: ( p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type

54:
55: -- Procedure Apply_Attribute_Changes
56:
57: PROCEDURE Apply_Attribute_Changes
58: ( p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
59: , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
60: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC
61: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
62: );

Line 59: , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=

55: -- Procedure Apply_Attribute_Changes
56:
57: PROCEDURE Apply_Attribute_Changes
58: ( p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
59: , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
60: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC
61: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
62: );
63:

Line 60: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC

56:
57: PROCEDURE Apply_Attribute_Changes
58: ( p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
59: , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
60: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC
61: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
62: );
63:
64: -- Function Complete_Record

Line 61: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type

57: PROCEDURE Apply_Attribute_Changes
58: ( p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
59: , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
60: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC
61: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
62: );
63:
64: -- Function Complete_Record
65:

Line 67: ( p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type

63:
64: -- Function Complete_Record
65:
66: FUNCTION Complete_Record
67: ( p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
68: , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
69: ) RETURN OE_Price_List_PUB.Price_List_Rec_Type;
70:
71: -- Function Convert_Miss_To_Null

Line 68: , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type

64: -- Function Complete_Record
65:
66: FUNCTION Complete_Record
67: ( p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
68: , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
69: ) RETURN OE_Price_List_PUB.Price_List_Rec_Type;
70:
71: -- Function Convert_Miss_To_Null
72:

Line 69: ) RETURN OE_Price_List_PUB.Price_List_Rec_Type;

65:
66: FUNCTION Complete_Record
67: ( p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
68: , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
69: ) RETURN OE_Price_List_PUB.Price_List_Rec_Type;
70:
71: -- Function Convert_Miss_To_Null
72:
73: FUNCTION Convert_Miss_To_Null

Line 74: ( p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type

70:
71: -- Function Convert_Miss_To_Null
72:
73: FUNCTION Convert_Miss_To_Null
74: ( p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
75: ) RETURN OE_Price_List_PUB.Price_List_Rec_Type;
76:
77: -- Procedure Update_Row
78:

Line 75: ) RETURN OE_Price_List_PUB.Price_List_Rec_Type;

71: -- Function Convert_Miss_To_Null
72:
73: FUNCTION Convert_Miss_To_Null
74: ( p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
75: ) RETURN OE_Price_List_PUB.Price_List_Rec_Type;
76:
77: -- Procedure Update_Row
78:
79: PROCEDURE Update_Row

Line 80: ( p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type

76:
77: -- Procedure Update_Row
78:
79: PROCEDURE Update_Row
80: ( p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
81: );
82:
83: -- Procedure Insert_Row
84:

Line 86: ( p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type

82:
83: -- Procedure Insert_Row
84:
85: PROCEDURE Insert_Row
86: ( p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
87: );
88:
89: -- Procedure Delete_Row
90:

Line 101: ) RETURN OE_Price_List_PUB.Price_List_Rec_Type;

97:
98: FUNCTION Query_Row
99: ( p_name IN VARCHAR2
100: , p_price_list_id IN NUMBER
101: ) RETURN OE_Price_List_PUB.Price_List_Rec_Type;
102:
103: -- Procedure lock_Row
104: --
105:

Line 108: , p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type

104: --
105:
106: PROCEDURE Lock_Row
107: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
108: , p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
109: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
110: );
111:
112: -- Function Get_Values

Line 109: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type

105:
106: PROCEDURE Lock_Row
107: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
108: , p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
109: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
110: );
111:
112: -- Function Get_Values
113:

Line 115: ( p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type

111:
112: -- Function Get_Values
113:
114: FUNCTION Get_Values
115: ( p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
116: , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
117: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC
118: ) RETURN OE_Price_List_PUB.Price_List_Val_Rec_Type;
119:

Line 116: , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=

112: -- Function Get_Values
113:
114: FUNCTION Get_Values
115: ( p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
116: , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
117: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC
118: ) RETURN OE_Price_List_PUB.Price_List_Val_Rec_Type;
119:
120: -- Function Get_Ids

Line 117: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC

113:
114: FUNCTION Get_Values
115: ( p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
116: , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
117: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC
118: ) RETURN OE_Price_List_PUB.Price_List_Val_Rec_Type;
119:
120: -- Function Get_Ids
121:

Line 118: ) RETURN OE_Price_List_PUB.Price_List_Val_Rec_Type;

114: FUNCTION Get_Values
115: ( p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
116: , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
117: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC
118: ) RETURN OE_Price_List_PUB.Price_List_Val_Rec_Type;
119:
120: -- Function Get_Ids
121:
122: FUNCTION Get_Ids

Line 123: ( p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type

119:
120: -- Function Get_Ids
121:
122: FUNCTION Get_Ids
123: ( p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
124: , p_PRICE_LIST_val_rec IN OE_Price_List_PUB.Price_List_Val_Rec_Type
125: ) RETURN OE_Price_List_PUB.Price_List_Rec_Type;
126:
127: -- Function Get_Ids

Line 124: , p_PRICE_LIST_val_rec IN OE_Price_List_PUB.Price_List_Val_Rec_Type

120: -- Function Get_Ids
121:
122: FUNCTION Get_Ids
123: ( p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
124: , p_PRICE_LIST_val_rec IN OE_Price_List_PUB.Price_List_Val_Rec_Type
125: ) RETURN OE_Price_List_PUB.Price_List_Rec_Type;
126:
127: -- Function Get_Ids
128:

Line 125: ) RETURN OE_Price_List_PUB.Price_List_Rec_Type;

121:
122: FUNCTION Get_Ids
123: ( p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
124: , p_PRICE_LIST_val_rec IN OE_Price_List_PUB.Price_List_Val_Rec_Type
125: ) RETURN OE_Price_List_PUB.Price_List_Rec_Type;
126:
127: -- Function Get_Ids
128:
129: END OE_Price_List_Util;