DBA Data[Home] [Help]

APPS.QP_SSC_UTIL dependencies on QP_ATTR_MAP_PUB

Line 40: , p_SSC_rec IN QP_Attr_Map_PUB.Ssc_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_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
41: , p_old_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type :=
42: QP_Attr_Map_PUB.G_MISS_SSC_REC
43: , x_SSC_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Rec_Type
44: );

Line 41: , p_old_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type :=

37:
38: PROCEDURE Clear_Dependent_Attr
39: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
40: , p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
41: , p_old_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type :=
42: QP_Attr_Map_PUB.G_MISS_SSC_REC
43: , x_SSC_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Rec_Type
44: );
45:

Line 42: QP_Attr_Map_PUB.G_MISS_SSC_REC

38: PROCEDURE Clear_Dependent_Attr
39: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
40: , p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
41: , p_old_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type :=
42: QP_Attr_Map_PUB.G_MISS_SSC_REC
43: , x_SSC_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Rec_Type
44: );
45:
46: -- Procedure Apply_Attribute_Changes

Line 43: , x_SSC_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Rec_Type

39: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
40: , p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
41: , p_old_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type :=
42: QP_Attr_Map_PUB.G_MISS_SSC_REC
43: , x_SSC_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Rec_Type
44: );
45:
46: -- Procedure Apply_Attribute_Changes
47:

Line 49: ( p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type

45:
46: -- Procedure Apply_Attribute_Changes
47:
48: PROCEDURE Apply_Attribute_Changes
49: ( p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
50: , p_old_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type :=
51: QP_Attr_Map_PUB.G_MISS_SSC_REC
52: , x_SSC_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Rec_Type
53: );

Line 50: , p_old_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type :=

46: -- Procedure Apply_Attribute_Changes
47:
48: PROCEDURE Apply_Attribute_Changes
49: ( p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
50: , p_old_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type :=
51: QP_Attr_Map_PUB.G_MISS_SSC_REC
52: , x_SSC_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Rec_Type
53: );
54:

Line 51: QP_Attr_Map_PUB.G_MISS_SSC_REC

47:
48: PROCEDURE Apply_Attribute_Changes
49: ( p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
50: , p_old_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type :=
51: QP_Attr_Map_PUB.G_MISS_SSC_REC
52: , x_SSC_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Rec_Type
53: );
54:
55: -- Function Complete_Record

Line 52: , x_SSC_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Rec_Type

48: PROCEDURE Apply_Attribute_Changes
49: ( p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
50: , p_old_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type :=
51: QP_Attr_Map_PUB.G_MISS_SSC_REC
52: , x_SSC_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Rec_Type
53: );
54:
55: -- Function Complete_Record
56:

Line 58: ( p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type

54:
55: -- Function Complete_Record
56:
57: FUNCTION Complete_Record
58: ( p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
59: , p_old_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
60: ) RETURN QP_Attr_Map_PUB.Ssc_Rec_Type;
61:
62: -- Function Convert_Miss_To_Null

Line 59: , p_old_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type

55: -- Function Complete_Record
56:
57: FUNCTION Complete_Record
58: ( p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
59: , p_old_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
60: ) RETURN QP_Attr_Map_PUB.Ssc_Rec_Type;
61:
62: -- Function Convert_Miss_To_Null
63:

Line 60: ) RETURN QP_Attr_Map_PUB.Ssc_Rec_Type;

56:
57: FUNCTION Complete_Record
58: ( p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
59: , p_old_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
60: ) RETURN QP_Attr_Map_PUB.Ssc_Rec_Type;
61:
62: -- Function Convert_Miss_To_Null
63:
64: FUNCTION Convert_Miss_To_Null

Line 65: ( p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type

61:
62: -- Function Convert_Miss_To_Null
63:
64: FUNCTION Convert_Miss_To_Null
65: ( p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
66: ) RETURN QP_Attr_Map_PUB.Ssc_Rec_Type;
67:
68: -- Procedure Update_Row
69:

Line 66: ) RETURN QP_Attr_Map_PUB.Ssc_Rec_Type;

62: -- Function Convert_Miss_To_Null
63:
64: FUNCTION Convert_Miss_To_Null
65: ( p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
66: ) RETURN QP_Attr_Map_PUB.Ssc_Rec_Type;
67:
68: -- Procedure Update_Row
69:
70: PROCEDURE Update_Row

Line 71: ( p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type

67:
68: -- Procedure Update_Row
69:
70: PROCEDURE Update_Row
71: ( p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
72: );
73:
74: -- Procedure Insert_Row
75:

Line 77: ( p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type

73:
74: -- Procedure Insert_Row
75:
76: PROCEDURE Insert_Row
77: ( p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
78: );
79:
80: -- Procedure Delete_Row
81:

Line 90: ) RETURN QP_Attr_Map_PUB.Ssc_Rec_Type;

86: -- Function Query_Row
87:
88: FUNCTION Query_Row
89: ( p_pte_source_system_id IN NUMBER
90: ) RETURN QP_Attr_Map_PUB.Ssc_Rec_Type;
91:
92: -- Function Query_Rows
93:
94: --

Line 101: ) RETURN QP_Attr_Map_PUB.Ssc_Tbl_Type;

97: ( p_pte_source_system_id IN NUMBER :=
98: FND_API.G_MISS_NUM
99: , p_lookup_code IN VARCHAR2 :=
100: FND_API.G_MISS_CHAR
101: ) RETURN QP_Attr_Map_PUB.Ssc_Tbl_Type;
102:
103: -- Procedure lock_Row
104: --
105:

Line 108: , p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type

104: --
105:
106: PROCEDURE Lock_Row
107: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
108: , p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
109: , x_SSC_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Rec_Type
110: );
111:
112: -- Function Get_Values

Line 109: , x_SSC_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Rec_Type

105:
106: PROCEDURE Lock_Row
107: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
108: , p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
109: , x_SSC_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Rec_Type
110: );
111:
112: -- Function Get_Values
113:

Line 115: ( p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type

111:
112: -- Function Get_Values
113:
114: FUNCTION Get_Values
115: ( p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
116: , p_old_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type :=
117: QP_Attr_Map_PUB.G_MISS_SSC_REC
118: ) RETURN QP_Attr_Map_PUB.Ssc_Val_Rec_Type;
119:

Line 116: , p_old_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type :=

112: -- Function Get_Values
113:
114: FUNCTION Get_Values
115: ( p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
116: , p_old_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type :=
117: QP_Attr_Map_PUB.G_MISS_SSC_REC
118: ) RETURN QP_Attr_Map_PUB.Ssc_Val_Rec_Type;
119:
120: -- Function Get_Ids

Line 117: QP_Attr_Map_PUB.G_MISS_SSC_REC

113:
114: FUNCTION Get_Values
115: ( p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
116: , p_old_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type :=
117: QP_Attr_Map_PUB.G_MISS_SSC_REC
118: ) RETURN QP_Attr_Map_PUB.Ssc_Val_Rec_Type;
119:
120: -- Function Get_Ids
121:

Line 118: ) RETURN QP_Attr_Map_PUB.Ssc_Val_Rec_Type;

114: FUNCTION Get_Values
115: ( p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
116: , p_old_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type :=
117: QP_Attr_Map_PUB.G_MISS_SSC_REC
118: ) RETURN QP_Attr_Map_PUB.Ssc_Val_Rec_Type;
119:
120: -- Function Get_Ids
121:
122: FUNCTION Get_Ids

Line 123: ( p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type

119:
120: -- Function Get_Ids
121:
122: FUNCTION Get_Ids
123: ( p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
124: , p_SSC_val_rec IN QP_Attr_Map_PUB.Ssc_Val_Rec_Type
125: ) RETURN QP_Attr_Map_PUB.Ssc_Rec_Type;
126:
127: END QP_Ssc_Util;

Line 124: , p_SSC_val_rec IN QP_Attr_Map_PUB.Ssc_Val_Rec_Type

120: -- Function Get_Ids
121:
122: FUNCTION Get_Ids
123: ( p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
124: , p_SSC_val_rec IN QP_Attr_Map_PUB.Ssc_Val_Rec_Type
125: ) RETURN QP_Attr_Map_PUB.Ssc_Rec_Type;
126:
127: END QP_Ssc_Util;

Line 125: ) RETURN QP_Attr_Map_PUB.Ssc_Rec_Type;

121:
122: FUNCTION Get_Ids
123: ( p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
124: , p_SSC_val_rec IN QP_Attr_Map_PUB.Ssc_Val_Rec_Type
125: ) RETURN QP_Attr_Map_PUB.Ssc_Rec_Type;
126:
127: END QP_Ssc_Util;