DBA Data[Home] [Help]

APPS.QP_QUALIFIER_RULES_UTIL dependencies on QP_QUALIFIER_RULES_PUB

Line 40: , p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type

36: -- Procedure Clear_Dependent_Attr
37:
38: PROCEDURE Clear_Dependent_Attr
39: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
40: , p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
41: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=
42: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
43: , x_QUALIFIER_RULES_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
44: );

Line 41: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=

37:
38: PROCEDURE Clear_Dependent_Attr
39: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
40: , p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
41: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=
42: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
43: , x_QUALIFIER_RULES_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
44: );
45:

Line 42: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC

38: PROCEDURE Clear_Dependent_Attr
39: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
40: , p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
41: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=
42: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
43: , x_QUALIFIER_RULES_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
44: );
45:
46: -- Procedure Apply_Attribute_Changes

Line 43: , x_QUALIFIER_RULES_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type

39: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
40: , p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
41: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=
42: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
43: , x_QUALIFIER_RULES_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
44: );
45:
46: -- Procedure Apply_Attribute_Changes
47:

Line 49: ( p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type

45:
46: -- Procedure Apply_Attribute_Changes
47:
48: PROCEDURE Apply_Attribute_Changes
49: ( p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
50: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=
51: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
52: , x_QUALIFIER_RULES_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
53: );

Line 50: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=

46: -- Procedure Apply_Attribute_Changes
47:
48: PROCEDURE Apply_Attribute_Changes
49: ( p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
50: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=
51: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
52: , x_QUALIFIER_RULES_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
53: );
54:

Line 51: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC

47:
48: PROCEDURE Apply_Attribute_Changes
49: ( p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
50: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=
51: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
52: , x_QUALIFIER_RULES_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
53: );
54:
55: -- Function Complete_Record

Line 52: , x_QUALIFIER_RULES_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type

48: PROCEDURE Apply_Attribute_Changes
49: ( p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
50: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=
51: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
52: , x_QUALIFIER_RULES_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
53: );
54:
55: -- Function Complete_Record
56:

Line 58: ( p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type

54:
55: -- Function Complete_Record
56:
57: FUNCTION Complete_Record
58: ( p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
59: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
60: ) RETURN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;
61:
62: -- Function Convert_Miss_To_Null

Line 59: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type

55: -- Function Complete_Record
56:
57: FUNCTION Complete_Record
58: ( p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
59: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
60: ) RETURN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;
61:
62: -- Function Convert_Miss_To_Null
63:

Line 60: ) RETURN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;

56:
57: FUNCTION Complete_Record
58: ( p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
59: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
60: ) RETURN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;
61:
62: -- Function Convert_Miss_To_Null
63:
64: FUNCTION Convert_Miss_To_Null

Line 65: ( p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type

61:
62: -- Function Convert_Miss_To_Null
63:
64: FUNCTION Convert_Miss_To_Null
65: ( p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
66: ) RETURN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;
67:
68: -- Procedure Update_Row
69:

Line 66: ) RETURN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;

62: -- Function Convert_Miss_To_Null
63:
64: FUNCTION Convert_Miss_To_Null
65: ( p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
66: ) RETURN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;
67:
68: -- Procedure Update_Row
69:
70: PROCEDURE Update_Row

Line 71: ( p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type

67:
68: -- Procedure Update_Row
69:
70: PROCEDURE Update_Row
71: ( p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
72: );
73:
74: -- Procedure Insert_Row
75:

Line 77: ( p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type

73:
74: -- Procedure Insert_Row
75:
76: PROCEDURE Insert_Row
77: ( p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
78: );
79:
80: -- Procedure Delete_Row
81:

Line 90: ) RETURN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;

86: -- Function Query_Row
87:
88: FUNCTION Query_Row
89: ( p_qualifier_rule_id IN NUMBER
90: ) RETURN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;
91:
92: -- Procedure lock_Row
93: --
94:

Line 97: , p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type

93: --
94:
95: PROCEDURE Lock_Row
96: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
97: , p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
98: , x_QUALIFIER_RULES_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
99: );
100:
101: -- Function Get_Values

Line 98: , x_QUALIFIER_RULES_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type

94:
95: PROCEDURE Lock_Row
96: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
97: , p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
98: , x_QUALIFIER_RULES_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
99: );
100:
101: -- Function Get_Values
102:

Line 104: ( p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type

100:
101: -- Function Get_Values
102:
103: FUNCTION Get_Values
104: ( p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
105: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=
106: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
107: ) RETURN QP_Qualifier_Rules_PUB.Qualifier_Rules_Val_Rec_Type;
108:

Line 105: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=

101: -- Function Get_Values
102:
103: FUNCTION Get_Values
104: ( p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
105: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=
106: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
107: ) RETURN QP_Qualifier_Rules_PUB.Qualifier_Rules_Val_Rec_Type;
108:
109: -- Function Get_Ids

Line 106: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC

102:
103: FUNCTION Get_Values
104: ( p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
105: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=
106: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
107: ) RETURN QP_Qualifier_Rules_PUB.Qualifier_Rules_Val_Rec_Type;
108:
109: -- Function Get_Ids
110:

Line 107: ) RETURN QP_Qualifier_Rules_PUB.Qualifier_Rules_Val_Rec_Type;

103: FUNCTION Get_Values
104: ( p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
105: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=
106: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
107: ) RETURN QP_Qualifier_Rules_PUB.Qualifier_Rules_Val_Rec_Type;
108:
109: -- Function Get_Ids
110:
111: FUNCTION Get_Ids

Line 112: ( p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type

108:
109: -- Function Get_Ids
110:
111: FUNCTION Get_Ids
112: ( p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
113: , p_QUALIFIER_RULES_val_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Val_Rec_Type
114: ) RETURN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;
115:
116: END QP_Qualifier_Rules_Util;

Line 113: , p_QUALIFIER_RULES_val_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Val_Rec_Type

109: -- Function Get_Ids
110:
111: FUNCTION Get_Ids
112: ( p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
113: , p_QUALIFIER_RULES_val_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Val_Rec_Type
114: ) RETURN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;
115:
116: END QP_Qualifier_Rules_Util;

Line 114: ) RETURN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;

110:
111: FUNCTION Get_Ids
112: ( p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
113: , p_QUALIFIER_RULES_val_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Val_Rec_Type
114: ) RETURN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;
115:
116: END QP_Qualifier_Rules_Util;