DBA Data[Home] [Help]

APPS.QP_PSG_UTIL dependencies on QP_ATTR_MAP_PUB

Line 46: , p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type

42: -- Procedure Clear_Dependent_Attr
43:
44: PROCEDURE Clear_Dependent_Attr
45: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
46: , p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
47: , p_old_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type :=
48: QP_Attr_Map_PUB.G_MISS_PSG_REC
49: , x_PSG_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Rec_Type
50: );

Line 47: , p_old_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type :=

43:
44: PROCEDURE Clear_Dependent_Attr
45: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
46: , p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
47: , p_old_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type :=
48: QP_Attr_Map_PUB.G_MISS_PSG_REC
49: , x_PSG_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Rec_Type
50: );
51:

Line 48: QP_Attr_Map_PUB.G_MISS_PSG_REC

44: PROCEDURE Clear_Dependent_Attr
45: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
46: , p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
47: , p_old_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type :=
48: QP_Attr_Map_PUB.G_MISS_PSG_REC
49: , x_PSG_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Rec_Type
50: );
51:
52: -- Procedure Apply_Attribute_Changes

Line 49: , x_PSG_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Rec_Type

45: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
46: , p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
47: , p_old_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type :=
48: QP_Attr_Map_PUB.G_MISS_PSG_REC
49: , x_PSG_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Rec_Type
50: );
51:
52: -- Procedure Apply_Attribute_Changes
53:

Line 55: ( p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type

51:
52: -- Procedure Apply_Attribute_Changes
53:
54: PROCEDURE Apply_Attribute_Changes
55: ( p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
56: , p_old_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type :=
57: QP_Attr_Map_PUB.G_MISS_PSG_REC
58: , x_PSG_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Rec_Type
59: );

Line 56: , p_old_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type :=

52: -- Procedure Apply_Attribute_Changes
53:
54: PROCEDURE Apply_Attribute_Changes
55: ( p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
56: , p_old_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type :=
57: QP_Attr_Map_PUB.G_MISS_PSG_REC
58: , x_PSG_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Rec_Type
59: );
60:

Line 57: QP_Attr_Map_PUB.G_MISS_PSG_REC

53:
54: PROCEDURE Apply_Attribute_Changes
55: ( p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
56: , p_old_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type :=
57: QP_Attr_Map_PUB.G_MISS_PSG_REC
58: , x_PSG_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Rec_Type
59: );
60:
61: -- Function Complete_Record

Line 58: , x_PSG_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Rec_Type

54: PROCEDURE Apply_Attribute_Changes
55: ( p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
56: , p_old_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type :=
57: QP_Attr_Map_PUB.G_MISS_PSG_REC
58: , x_PSG_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Rec_Type
59: );
60:
61: -- Function Complete_Record
62:

Line 64: ( p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type

60:
61: -- Function Complete_Record
62:
63: FUNCTION Complete_Record
64: ( p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
65: , p_old_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
66: ) RETURN QP_Attr_Map_PUB.Psg_Rec_Type;
67:
68: -- Function Convert_Miss_To_Null

Line 65: , p_old_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type

61: -- Function Complete_Record
62:
63: FUNCTION Complete_Record
64: ( p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
65: , p_old_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
66: ) RETURN QP_Attr_Map_PUB.Psg_Rec_Type;
67:
68: -- Function Convert_Miss_To_Null
69:

Line 66: ) RETURN QP_Attr_Map_PUB.Psg_Rec_Type;

62:
63: FUNCTION Complete_Record
64: ( p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
65: , p_old_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
66: ) RETURN QP_Attr_Map_PUB.Psg_Rec_Type;
67:
68: -- Function Convert_Miss_To_Null
69:
70: FUNCTION Convert_Miss_To_Null

Line 71: ( p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type

67:
68: -- Function Convert_Miss_To_Null
69:
70: FUNCTION Convert_Miss_To_Null
71: ( p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
72: ) RETURN QP_Attr_Map_PUB.Psg_Rec_Type;
73:
74: -- Procedure Update_Row
75:

Line 72: ) RETURN QP_Attr_Map_PUB.Psg_Rec_Type;

68: -- Function Convert_Miss_To_Null
69:
70: FUNCTION Convert_Miss_To_Null
71: ( p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
72: ) RETURN QP_Attr_Map_PUB.Psg_Rec_Type;
73:
74: -- Procedure Update_Row
75:
76: PROCEDURE Update_Row

Line 77: ( p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type

73:
74: -- Procedure Update_Row
75:
76: PROCEDURE Update_Row
77: ( p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
78: );
79:
80: -- Procedure Insert_Row
81:

Line 83: ( p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type

79:
80: -- Procedure Insert_Row
81:
82: PROCEDURE Insert_Row
83: ( p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
84: );
85:
86: -- Procedure Delete_Row
87:

Line 96: ) RETURN QP_Attr_Map_PUB.Psg_Rec_Type;

92: -- Function Query_Row
93:
94: FUNCTION Query_Row
95: ( p_segment_pte_id IN NUMBER
96: ) RETURN QP_Attr_Map_PUB.Psg_Rec_Type;
97:
98: -- Function Query_Rows
99:
100: --

Line 107: ) RETURN QP_Attr_Map_PUB.Psg_Tbl_Type;

103: ( p_segment_pte_id IN NUMBER :=
104: FND_API.G_MISS_NUM
105: , p_lookup_code IN VARCHAR2 :=
106: FND_API.G_MISS_CHAR
107: ) RETURN QP_Attr_Map_PUB.Psg_Tbl_Type;
108:
109: -- Procedure lock_Row
110: --
111:

Line 114: , p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type

110: --
111:
112: PROCEDURE Lock_Row
113: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
114: , p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
115: , x_PSG_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Rec_Type
116: );
117:
118: -- Function Get_Values

Line 115: , x_PSG_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Rec_Type

111:
112: PROCEDURE Lock_Row
113: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
114: , p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
115: , x_PSG_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Rec_Type
116: );
117:
118: -- Function Get_Values
119:

Line 121: ( p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type

117:
118: -- Function Get_Values
119:
120: FUNCTION Get_Values
121: ( p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
122: , p_old_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type :=
123: QP_Attr_Map_PUB.G_MISS_PSG_REC
124: ) RETURN QP_Attr_Map_PUB.Psg_Val_Rec_Type;
125:

Line 122: , p_old_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type :=

118: -- Function Get_Values
119:
120: FUNCTION Get_Values
121: ( p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
122: , p_old_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type :=
123: QP_Attr_Map_PUB.G_MISS_PSG_REC
124: ) RETURN QP_Attr_Map_PUB.Psg_Val_Rec_Type;
125:
126: -- Function Get_Ids

Line 123: QP_Attr_Map_PUB.G_MISS_PSG_REC

119:
120: FUNCTION Get_Values
121: ( p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
122: , p_old_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type :=
123: QP_Attr_Map_PUB.G_MISS_PSG_REC
124: ) RETURN QP_Attr_Map_PUB.Psg_Val_Rec_Type;
125:
126: -- Function Get_Ids
127:

Line 124: ) RETURN QP_Attr_Map_PUB.Psg_Val_Rec_Type;

120: FUNCTION Get_Values
121: ( p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
122: , p_old_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type :=
123: QP_Attr_Map_PUB.G_MISS_PSG_REC
124: ) RETURN QP_Attr_Map_PUB.Psg_Val_Rec_Type;
125:
126: -- Function Get_Ids
127:
128: FUNCTION Get_Ids

Line 129: ( p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type

125:
126: -- Function Get_Ids
127:
128: FUNCTION Get_Ids
129: ( p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
130: , p_PSG_val_rec IN QP_Attr_Map_PUB.Psg_Val_Rec_Type
131: ) RETURN QP_Attr_Map_PUB.Psg_Rec_Type;
132:
133: END QP_Psg_Util;

Line 130: , p_PSG_val_rec IN QP_Attr_Map_PUB.Psg_Val_Rec_Type

126: -- Function Get_Ids
127:
128: FUNCTION Get_Ids
129: ( p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
130: , p_PSG_val_rec IN QP_Attr_Map_PUB.Psg_Val_Rec_Type
131: ) RETURN QP_Attr_Map_PUB.Psg_Rec_Type;
132:
133: END QP_Psg_Util;

Line 131: ) RETURN QP_Attr_Map_PUB.Psg_Rec_Type;

127:
128: FUNCTION Get_Ids
129: ( p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
130: , p_PSG_val_rec IN QP_Attr_Map_PUB.Psg_Val_Rec_Type
131: ) RETURN QP_Attr_Map_PUB.Psg_Rec_Type;
132:
133: END QP_Psg_Util;