eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BOM_VALIDATE_REF_DESIGNATOR dependencies on BOM_BO_PUB

Line 42: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Designator_Rec_Type }

38: * @param x_return_status Indicating success or faliure
39: * @param x_Mesg_Token_Tbl Filled with any errors or warnings
40: * @rep:paraminfo { @rep:innertype Error_Handler.Mesg_Token_Tbl_Type }
41: * @param p_ref_designator_rec Reference Designator Record as given by the User
42: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Designator_Rec_Type }
43: * @param p_Ref_Desg_Unexp_Rec Reference Designator Unexposed Record
44: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type }
45: * @rep:scope private
46: * @rep:lifecycle active

Line 44: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type }

40: * @rep:paraminfo { @rep:innertype Error_Handler.Mesg_Token_Tbl_Type }
41: * @param p_ref_designator_rec Reference Designator Record as given by the User
42: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Designator_Rec_Type }
43: * @param p_Ref_Desg_Unexp_Rec Reference Designator Unexposed Record
44: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type }
45: * @rep:scope private
46: * @rep:lifecycle active
47: * @rep:displayname Check Entity
48: */

Line 53: , p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type

49:
50: PROCEDURE Check_Entity
51: ( x_return_status IN OUT NOCOPY VARCHAR2
52: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
53: , p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
54: , p_Ref_Desg_Unexp_Rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
55: );
56:
57: -- Procedure Attributes

Line 54: , p_Ref_Desg_Unexp_Rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type

50: PROCEDURE Check_Entity
51: ( x_return_status IN OUT NOCOPY VARCHAR2
52: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
53: , p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
54: , p_Ref_Desg_Unexp_Rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
55: );
56:
57: -- Procedure Attributes
58:

Line 66: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Designator_Rec_Type }

62: * @param x_return_status Indicating success or faliure
63: * @param x_Mesg_Token_Tbl Filled with any errors or warnings
64: * @rep:paraminfo { @rep:innertype Error_Handler.Mesg_Token_Tbl_Type }
65: * @param p_ref_designator_rec Reference Designator Record as given by the User
66: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Designator_Rec_Type }
67: * @rep:scope private
68: * @rep:lifecycle active
69: * @rep:displayname Check Attributes
70: */

Line 75: , p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type

71:
72: PROCEDURE Check_Attributes
73: ( x_return_status IN OUT NOCOPY VARCHAR2
74: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
75: , p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
76: );
77:
78: -- Procedure Entity_Delete
79: /*#

Line 88: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Designator_Rec_Type }

84: * @param x_return_status Indicating success or failure
85: * @param x_Mesg_Token_Tbl Filled with any errors or warnings
86: * @rep:paraminfo { @rep:innertype Error_Handler.Mesg_Token_Tbl_Type }
87: * @param p_ref_designator_rec Reference Designator Record as given by the User
88: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Designator_Rec_Type }
89: * @param p_Ref_Desg_Unexp_Rec Bom Reference Designator Unexposed Record
90: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type }
91: * @rep:scope private
92: * @rep:lifecycle active

Line 90: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type }

86: * @rep:paraminfo { @rep:innertype Error_Handler.Mesg_Token_Tbl_Type }
87: * @param p_ref_designator_rec Reference Designator Record as given by the User
88: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Designator_Rec_Type }
89: * @param p_Ref_Desg_Unexp_Rec Bom Reference Designator Unexposed Record
90: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type }
91: * @rep:scope private
92: * @rep:lifecycle active
93: * @rep:displayname Check Entity Delete
94: */

Line 99: , p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type

95:
96: PROCEDURE Check_Entity_Delete
97: ( x_return_status IN OUT NOCOPY VARCHAR2
98: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
99: , p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
100: , p_Ref_Desg_Unexp_Rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
101: );
102:
103: /*#

Line 100: , p_Ref_Desg_Unexp_Rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type

96: PROCEDURE Check_Entity_Delete
97: ( x_return_status IN OUT NOCOPY VARCHAR2
98: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
99: , p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
100: , p_Ref_Desg_Unexp_Rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
101: );
102:
103: /*#
104: * Check_Existence will perform a query using the primary key information and will return

Line 110: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Designator_Rec_Type }

106: * is UPDATE and the record DOES NOT EXIST.In case of UPDATE if the record exists then the procedure
107: * will return the old record in the old entity parameters with a success status.This can be used with
108: * ECO
109: * @param p_ref_designator_rec Reference Designator Record as given by the User
110: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Designator_Rec_Type }
111: * @param p_Ref_Desg_Unexp_Rec Reference Designator Unexposed Record
112: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type }
113: * @param x_old_ref_designator_rec Old Reference Designator exposed column record
114: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Designator_Rec_Type }

Line 112: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type }

108: * ECO
109: * @param p_ref_designator_rec Reference Designator Record as given by the User
110: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Designator_Rec_Type }
111: * @param p_Ref_Desg_Unexp_Rec Reference Designator Unexposed Record
112: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type }
113: * @param x_old_ref_designator_rec Old Reference Designator exposed column record
114: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Designator_Rec_Type }
115: * @param x_old_ref_desg_unexp_rec Old Reference Designator unexposed column record
116: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type }

Line 114: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Designator_Rec_Type }

110: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Designator_Rec_Type }
111: * @param p_Ref_Desg_Unexp_Rec Reference Designator Unexposed Record
112: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type }
113: * @param x_old_ref_designator_rec Old Reference Designator exposed column record
114: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Designator_Rec_Type }
115: * @param x_old_ref_desg_unexp_rec Old Reference Designator unexposed column record
116: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type }
117: * @param x_Mesg_Token_Tbl Filled with any errors or warnings
118: * @rep:paraminfo { @rep:innertype Error_Handler.Mesg_Token_Tbl_Type }

Line 116: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type }

112: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type }
113: * @param x_old_ref_designator_rec Old Reference Designator exposed column record
114: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Designator_Rec_Type }
115: * @param x_old_ref_desg_unexp_rec Old Reference Designator unexposed column record
116: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type }
117: * @param x_Mesg_Token_Tbl Filled with any errors or warnings
118: * @rep:paraminfo { @rep:innertype Error_Handler.Mesg_Token_Tbl_Type }
119: * @param x_return_status Indicating success or faliure
120: * @rep:scope private

Line 127: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type

123: */
124:
125:
126: PROCEDURE Check_Existence
127: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
128: , p_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
129: , x_old_ref_designator_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Rec_Type
130: , x_old_ref_desg_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
131: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 128: , p_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type

124:
125:
126: PROCEDURE Check_Existence
127: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
128: , p_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
129: , x_old_ref_designator_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Rec_Type
130: , x_old_ref_desg_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
131: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
132: , x_Return_Status IN OUT NOCOPY VARCHAR2

Line 129: , x_old_ref_designator_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Rec_Type

125:
126: PROCEDURE Check_Existence
127: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
128: , p_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
129: , x_old_ref_designator_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Rec_Type
130: , x_old_ref_desg_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
131: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
132: , x_Return_Status IN OUT NOCOPY VARCHAR2
133: );

Line 130: , x_old_ref_desg_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type

126: PROCEDURE Check_Existence
127: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
128: , p_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
129: , x_old_ref_designator_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Rec_Type
130: , x_old_ref_desg_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
131: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
132: , x_Return_Status IN OUT NOCOPY VARCHAR2
133: );
134:

Line 139: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Designator_Rec_Type }

135: /*#
136: * Performs lineage checks for entity records that do not belong to the top-most entity in the hierarchy
137: * This can be used with ECO
138: * @param p_ref_designator_rec Reference Designator Record as given by the User
139: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Designator_Rec_Type }
140: * @param p_Ref_Desg_Unexp_Rec Reference Designator Unexposed Record
141: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type }
142: * @param x_Mesg_Token_Tbl Filled with any errors or warnings
143: * @rep:paraminfo { @rep:innertype Error_Handler.Mesg_Token_Tbl_Type }

Line 141: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type }

137: * This can be used with ECO
138: * @param p_ref_designator_rec Reference Designator Record as given by the User
139: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Designator_Rec_Type }
140: * @param p_Ref_Desg_Unexp_Rec Reference Designator Unexposed Record
141: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type }
142: * @param x_Mesg_Token_Tbl Filled with any errors or warnings
143: * @rep:paraminfo { @rep:innertype Error_Handler.Mesg_Token_Tbl_Type }
144: * @param x_return_status Indicating success or faliure
145: * @rep:scope private

Line 151: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type

147: * @rep:displayname Check Lineage
148: */
149:
150: PROCEDURE Check_Lineage
151: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
152: , p_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
153: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
154: , x_Return_Status IN OUT NOCOPY VARCHAR2
155: );

Line 152: , p_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type

148: */
149:
150: PROCEDURE Check_Lineage
151: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
152: , p_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
153: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
154: , x_Return_Status IN OUT NOCOPY VARCHAR2
155: );
156:

Line 160: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Designator_Rec_Type }

156:
157: /*#
158: * Checks access constraints.This can be used with ECO
159: * @param p_ref_designator_rec Reference Designator Record as given by the User
160: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Designator_Rec_Type }
161: * @param p_Ref_Desg_Unexp_Rec Reference Designator Unexposed Record
162: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type }
163: * @param x_Mesg_Token_Tbl Filled with any errors or warnings
164: * @rep:paraminfo { @rep:innertype Error_Handler.Mesg_Token_Tbl_Type }

Line 162: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type }

158: * Checks access constraints.This can be used with ECO
159: * @param p_ref_designator_rec Reference Designator Record as given by the User
160: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Designator_Rec_Type }
161: * @param p_Ref_Desg_Unexp_Rec Reference Designator Unexposed Record
162: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type }
163: * @param x_Mesg_Token_Tbl Filled with any errors or warnings
164: * @rep:paraminfo { @rep:innertype Error_Handler.Mesg_Token_Tbl_Type }
165: * @param x_return_status Indicating success or faliure
166: * @rep:scope private

Line 172: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type

168: * @rep:displayname Check Access
169: */
170:
171: PROCEDURE CHECK_ACCESS
172: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
173: , p_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
174: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
175: , x_Return_Status IN OUT NOCOPY VARCHAR2
176: );

Line 173: , p_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type

169: */
170:
171: PROCEDURE CHECK_ACCESS
172: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
173: , p_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
174: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
175: , x_Return_Status IN OUT NOCOPY VARCHAR2
176: );
177:

Line 212: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type }

208: * @param x_return_status Indicating success or faliure
209: * @param x_Mesg_Token_Tbl Filled with any errors or warnings
210: * @rep:paraminfo { @rep:innertype Error_Handler.Mesg_Token_Tbl_Type }
211: * @param p_bom_ref_designator_rec BomReference Designator Record as given by the User
212: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type }
213: * @param p_bom_Ref_Desg_Unexp_Rec Bom Reference Designator Unexposed Record
214: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Bom_Ref_Desg_Unexposed_Rec_Type }
215: * @rep:scope private
216: * @rep:lifecycle active

Line 214: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Bom_Ref_Desg_Unexposed_Rec_Type }

210: * @rep:paraminfo { @rep:innertype Error_Handler.Mesg_Token_Tbl_Type }
211: * @param p_bom_ref_designator_rec BomReference Designator Record as given by the User
212: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type }
213: * @param p_bom_Ref_Desg_Unexp_Rec Bom Reference Designator Unexposed Record
214: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Bom_Ref_Desg_Unexposed_Rec_Type }
215: * @rep:scope private
216: * @rep:lifecycle active
217: * @rep:displayname Check Entity
218: */

Line 222: , p_bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type

218: */
219: PROCEDURE Check_Entity
220: ( x_return_status IN OUT NOCOPY VARCHAR2
221: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
222: , p_bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
223: , p_bom_Ref_Desg_Unexp_Rec IN Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
224: );
225:
226: -- Procedure Attributes

Line 223: , p_bom_Ref_Desg_Unexp_Rec IN Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type

219: PROCEDURE Check_Entity
220: ( x_return_status IN OUT NOCOPY VARCHAR2
221: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
222: , p_bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
223: , p_bom_Ref_Desg_Unexp_Rec IN Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
224: );
225:
226: -- Procedure Attributes
227:

Line 235: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type }

231: * @param x_return_status Indicating success or faliure
232: * @param x_Mesg_Token_Tbl Filled with any errors or warnings
233: * @rep:paraminfo { @rep:innertype Error_Handler.Mesg_Token_Tbl_Type }
234: * @param p_bom_ref_designator_rec Bom Reference Designator Record as given by the User
235: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type }
236: * @rep:scope private
237: * @rep:lifecycle active
238: * @rep:displayname Check Attributes
239: */

Line 244: , p_Bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type

240:
241: PROCEDURE Check_Attributes
242: ( x_return_status IN OUT NOCOPY VARCHAR2
243: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
244: , p_Bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
245: );
246:
247: -- Procedure Entity_Delete
248: /*#

Line 257: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type }

253: * @param x_return_status Indicating success or failure
254: * @param x_Mesg_Token_Tbl Filled with any errors or warnings
255: * @rep:paraminfo { @rep:innertype Error_Handler.Mesg_Token_Tbl_Type }
256: * @param p_bom_ref_designator_rec Bom Reference Designator Record as given by the User
257: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type }
258: * @param p_bom_Ref_Desg_Unexp_Rec Bom Reference Designator Unexposed Record
259: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Bom_Ref_Desg_Unexposed_Rec_Type }
260: * @rep:scope private
261: * @rep:lifecycle active

Line 259: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Bom_Ref_Desg_Unexposed_Rec_Type }

255: * @rep:paraminfo { @rep:innertype Error_Handler.Mesg_Token_Tbl_Type }
256: * @param p_bom_ref_designator_rec Bom Reference Designator Record as given by the User
257: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type }
258: * @param p_bom_Ref_Desg_Unexp_Rec Bom Reference Designator Unexposed Record
259: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Bom_Ref_Desg_Unexposed_Rec_Type }
260: * @rep:scope private
261: * @rep:lifecycle active
262: * @rep:displayname Check Entity Delete
263: */

Line 268: , p_bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type

264:
265: PROCEDURE Check_Entity_Delete
266: ( x_return_status IN OUT NOCOPY VARCHAR2
267: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
268: , p_bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
269: , p_bom_Ref_Desg_Unexp_Rec IN Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
270: );
271:
272: /*#

Line 269: , p_bom_Ref_Desg_Unexp_Rec IN Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type

265: PROCEDURE Check_Entity_Delete
266: ( x_return_status IN OUT NOCOPY VARCHAR2
267: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
268: , p_bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
269: , p_bom_Ref_Desg_Unexp_Rec IN Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
270: );
271:
272: /*#
273: * Check_Existence will convert the BOM Record to ECO and perform a query using the primary key information and will return

Line 278: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type }

274: * success if the operation is CREATE and the record EXISTS or will return an error if the operation
275: * is UPDATE and the record DOES NOT EXIST.In case of UPDATE if the record exists then the procedure
276: * will return the old record in the old entity parameters with a success status.
277: * @param p_bom_ref_designator_rec Bom Reference Designator Record as given by the User
278: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type }
279: * @param p_bom_Ref_Desg_Unexp_Rec Bom Reference Designator Unexposed Record
280: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Bom_Ref_Desg_Unexposed_Rec_Type }
281: * @param x_old_bom_ref_designator_rec Old Bom Reference Designator exposed column record
282: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type }

Line 280: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Bom_Ref_Desg_Unexposed_Rec_Type }

276: * will return the old record in the old entity parameters with a success status.
277: * @param p_bom_ref_designator_rec Bom Reference Designator Record as given by the User
278: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type }
279: * @param p_bom_Ref_Desg_Unexp_Rec Bom Reference Designator Unexposed Record
280: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Bom_Ref_Desg_Unexposed_Rec_Type }
281: * @param x_old_bom_ref_designator_rec Old Bom Reference Designator exposed column record
282: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type }
283: * @param x_old_bom_ref_desg_unexp_rec Old Bom Reference Designator unexposed column record
284: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Bom_Ref_Desg_Unexposed_Rec_Type }

Line 282: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type }

278: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type }
279: * @param p_bom_Ref_Desg_Unexp_Rec Bom Reference Designator Unexposed Record
280: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Bom_Ref_Desg_Unexposed_Rec_Type }
281: * @param x_old_bom_ref_designator_rec Old Bom Reference Designator exposed column record
282: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type }
283: * @param x_old_bom_ref_desg_unexp_rec Old Bom Reference Designator unexposed column record
284: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Bom_Ref_Desg_Unexposed_Rec_Type }
285: * @param x_Mesg_Token_Tbl Filled with any errors or warnings
286: * @rep:paraminfo { @rep:innertype Error_Handler.Mesg_Token_Tbl_Type }

Line 284: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Bom_Ref_Desg_Unexposed_Rec_Type }

280: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Bom_Ref_Desg_Unexposed_Rec_Type }
281: * @param x_old_bom_ref_designator_rec Old Bom Reference Designator exposed column record
282: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type }
283: * @param x_old_bom_ref_desg_unexp_rec Old Bom Reference Designator unexposed column record
284: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Bom_Ref_Desg_Unexposed_Rec_Type }
285: * @param x_Mesg_Token_Tbl Filled with any errors or warnings
286: * @rep:paraminfo { @rep:innertype Error_Handler.Mesg_Token_Tbl_Type }
287: * @param x_return_status Indicating success or faliure
288: * @rep:scope private

Line 294: ( p_bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type

290: * @rep:displayname Check Existence
291: */
292:
293: PROCEDURE Check_Existence
294: ( p_bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
295: , p_bom_ref_desg_unexp_rec IN Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
296: , x_old_bom_ref_designator_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
297: , x_old_bom_ref_desg_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
298: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 295: , p_bom_ref_desg_unexp_rec IN Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type

291: */
292:
293: PROCEDURE Check_Existence
294: ( p_bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
295: , p_bom_ref_desg_unexp_rec IN Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
296: , x_old_bom_ref_designator_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
297: , x_old_bom_ref_desg_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
298: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
299: , x_Return_Status IN OUT NOCOPY VARCHAR2

Line 296: , x_old_bom_ref_designator_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type

292:
293: PROCEDURE Check_Existence
294: ( p_bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
295: , p_bom_ref_desg_unexp_rec IN Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
296: , x_old_bom_ref_designator_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
297: , x_old_bom_ref_desg_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
298: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
299: , x_Return_Status IN OUT NOCOPY VARCHAR2
300: );

Line 297: , x_old_bom_ref_desg_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type

293: PROCEDURE Check_Existence
294: ( p_bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
295: , p_bom_ref_desg_unexp_rec IN Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
296: , x_old_bom_ref_designator_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
297: , x_old_bom_ref_desg_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
298: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
299: , x_Return_Status IN OUT NOCOPY VARCHAR2
300: );
301:

Line 306: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.bom_Ref_Designator_Rec_Type }

302: /*#
303: * Converts the BOM Record to ECO and Performs lineage checks for entity records that do not
304: * belong to the top-most entity in the hierarchy
305: * @param p_bom_ref_designator_rec Bom Reference Designator Record as given by the User
306: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.bom_Ref_Designator_Rec_Type }
307: * @param p_bom_Ref_Desg_Unexp_Rec Bom Reference Designator Unexposed Record
308: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.bom_Ref_Desg_Unexposed_Rec_Type }
309: * @param x_Mesg_Token_Tbl Filled with any errors or warnings
310: * @rep:paraminfo { @rep:innertype Error_Handler.Mesg_Token_Tbl_Type }

Line 308: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.bom_Ref_Desg_Unexposed_Rec_Type }

304: * belong to the top-most entity in the hierarchy
305: * @param p_bom_ref_designator_rec Bom Reference Designator Record as given by the User
306: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.bom_Ref_Designator_Rec_Type }
307: * @param p_bom_Ref_Desg_Unexp_Rec Bom Reference Designator Unexposed Record
308: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.bom_Ref_Desg_Unexposed_Rec_Type }
309: * @param x_Mesg_Token_Tbl Filled with any errors or warnings
310: * @rep:paraminfo { @rep:innertype Error_Handler.Mesg_Token_Tbl_Type }
311: * @param x_return_status Indicating success or faliure
312: * @rep:scope private

Line 318: ( p_bom_ref_designator_rec IN Bom_Bo_Pub.bom_Ref_Designator_Rec_Type

314: * @rep:displayname Check Lineage
315: */
316:
317: PROCEDURE Check_Lineage
318: ( p_bom_ref_designator_rec IN Bom_Bo_Pub.bom_Ref_Designator_Rec_Type
319: , p_bom_ref_desg_unexp_rec IN Bom_Bo_Pub.bom_Ref_Desg_Unexp_Rec_Type
320: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
321: , x_Return_Status IN OUT NOCOPY VARCHAR2
322: );

Line 319: , p_bom_ref_desg_unexp_rec IN Bom_Bo_Pub.bom_Ref_Desg_Unexp_Rec_Type

315: */
316:
317: PROCEDURE Check_Lineage
318: ( p_bom_ref_designator_rec IN Bom_Bo_Pub.bom_Ref_Designator_Rec_Type
319: , p_bom_ref_desg_unexp_rec IN Bom_Bo_Pub.bom_Ref_Desg_Unexp_Rec_Type
320: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
321: , x_Return_Status IN OUT NOCOPY VARCHAR2
322: );
323:

Line 327: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.bom_Ref_Designator_Rec_Type }

323:
324: /*#
325: * Check Access converts the BOM Record to ECO and checks access constraints
326: * @param p_bom_ref_designator_rec Bom Reference Designator Record as given by the User
327: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.bom_Ref_Designator_Rec_Type }
328: * @param p_bom_Ref_Desg_Unexp_Rec Bom Reference Designator Unexposed Record
329: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.bom_Ref_Desg_Unexposed_Rec_Type }
330: * @param x_Mesg_Token_Tbl Filled with any errors or warnings
331: * @rep:paraminfo { @rep:innertype Error_Handler.Mesg_Token_Tbl_Type }

Line 329: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.bom_Ref_Desg_Unexposed_Rec_Type }

325: * Check Access converts the BOM Record to ECO and checks access constraints
326: * @param p_bom_ref_designator_rec Bom Reference Designator Record as given by the User
327: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.bom_Ref_Designator_Rec_Type }
328: * @param p_bom_Ref_Desg_Unexp_Rec Bom Reference Designator Unexposed Record
329: * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.bom_Ref_Desg_Unexposed_Rec_Type }
330: * @param x_Mesg_Token_Tbl Filled with any errors or warnings
331: * @rep:paraminfo { @rep:innertype Error_Handler.Mesg_Token_Tbl_Type }
332: * @param x_return_status Indicating success or faliure
333: * @rep:scope private

Line 339: ( p_bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type

335: * @rep:displayname Check Access
336: */
337:
338: PROCEDURE CHECK_ACCESS
339: ( p_bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
340: , p_bom_ref_desg_unexp_rec IN Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
341: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
342: , x_Return_Status IN OUT NOCOPY VARCHAR2
343: );

Line 340: , p_bom_ref_desg_unexp_rec IN Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type

336: */
337:
338: PROCEDURE CHECK_ACCESS
339: ( p_bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
340: , p_bom_ref_desg_unexp_rec IN Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
341: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
342: , x_Return_Status IN OUT NOCOPY VARCHAR2
343: );
344: