DBA Data[Home] [Help]

APPS.ENG_REF_DESIGNATOR_UTIL dependencies on BOM_BO_PUB

Line 14: , p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type

10: -- Procedure Clear_Dependent_Attr
11:
12: PROCEDURE Clear_Dependent_Attr
13: ( p_attr_id IN NUMBER :=NULL-- FND_API.G_MISS_NUM
14: , p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
15: , p_old_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type :=
16: Bom_Bo_Pub.G_MISS_REF_DESIGNATOR_REC
17: , x_ref_designator_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Rec_Type
18: )

Line 15: , p_old_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type :=

11:
12: PROCEDURE Clear_Dependent_Attr
13: ( p_attr_id IN NUMBER :=NULL-- FND_API.G_MISS_NUM
14: , p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
15: , p_old_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type :=
16: Bom_Bo_Pub.G_MISS_REF_DESIGNATOR_REC
17: , x_ref_designator_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Rec_Type
18: )
19: IS

Line 16: Bom_Bo_Pub.G_MISS_REF_DESIGNATOR_REC

12: PROCEDURE Clear_Dependent_Attr
13: ( p_attr_id IN NUMBER :=NULL-- FND_API.G_MISS_NUM
14: , p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
15: , p_old_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type :=
16: Bom_Bo_Pub.G_MISS_REF_DESIGNATOR_REC
17: , x_ref_designator_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Rec_Type
18: )
19: IS
20: BEGIN

Line 17: , x_ref_designator_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Rec_Type

13: ( p_attr_id IN NUMBER :=NULL-- FND_API.G_MISS_NUM
14: , p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
15: , p_old_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type :=
16: Bom_Bo_Pub.G_MISS_REF_DESIGNATOR_REC
17: , x_ref_designator_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Rec_Type
18: )
19: IS
20: BEGIN
21: -- Load out record

Line 30: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type

26:
27: -- Procedure Apply_Attribute_Changes
28:
29: PROCEDURE Apply_Attribute_Changes
30: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
31: , p_old_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type :=
32: Bom_Bo_Pub.G_MISS_REF_DESIGNATOR_REC
33: , x_ref_designator_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Rec_Type
34: )

Line 31: , p_old_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type :=

27: -- Procedure Apply_Attribute_Changes
28:
29: PROCEDURE Apply_Attribute_Changes
30: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
31: , p_old_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type :=
32: Bom_Bo_Pub.G_MISS_REF_DESIGNATOR_REC
33: , x_ref_designator_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Rec_Type
34: )
35: IS

Line 32: Bom_Bo_Pub.G_MISS_REF_DESIGNATOR_REC

28:
29: PROCEDURE Apply_Attribute_Changes
30: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
31: , p_old_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type :=
32: Bom_Bo_Pub.G_MISS_REF_DESIGNATOR_REC
33: , x_ref_designator_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Rec_Type
34: )
35: IS
36: BEGIN

Line 33: , x_ref_designator_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Rec_Type

29: PROCEDURE Apply_Attribute_Changes
30: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
31: , p_old_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type :=
32: Bom_Bo_Pub.G_MISS_REF_DESIGNATOR_REC
33: , x_ref_designator_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Rec_Type
34: )
35: IS
36: BEGIN
37: -- Load out record

Line 46: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type

42:
43: -- Function Convert_Miss_To_Null
44:
45: FUNCTION Convert_Miss_To_Null
46: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
47: ) RETURN Bom_Bo_Pub.Ref_Designator_Rec_Type
48: IS
49: l_ref_designator_rec Bom_Bo_Pub.Ref_Designator_Rec_Type :=
50: p_ref_designator_rec;

Line 47: ) RETURN Bom_Bo_Pub.Ref_Designator_Rec_Type

43: -- Function Convert_Miss_To_Null
44:
45: FUNCTION Convert_Miss_To_Null
46: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
47: ) RETURN Bom_Bo_Pub.Ref_Designator_Rec_Type
48: IS
49: l_ref_designator_rec Bom_Bo_Pub.Ref_Designator_Rec_Type :=
50: p_ref_designator_rec;
51: BEGIN

Line 49: l_ref_designator_rec Bom_Bo_Pub.Ref_Designator_Rec_Type :=

45: FUNCTION Convert_Miss_To_Null
46: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
47: ) RETURN Bom_Bo_Pub.Ref_Designator_Rec_Type
48: IS
49: l_ref_designator_rec Bom_Bo_Pub.Ref_Designator_Rec_Type :=
50: p_ref_designator_rec;
51: BEGIN
52:
53: IF l_ref_designator_rec.Reference_Designator_Name = FND_API.G_MISS_CHAR THEN

Line 139: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type

135: *
136: ********************************************************************/
137:
138: PROCEDURE Update_Row
139: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
140: , p_Ref_Desg_Unexp_Rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
141: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
142: , x_Return_Status OUT NOCOPY VARCHAR2
143: )

Line 140: , p_Ref_Desg_Unexp_Rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type

136: ********************************************************************/
137:
138: PROCEDURE Update_Row
139: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
140: , p_Ref_Desg_Unexp_Rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
141: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
142: , x_Return_Status OUT NOCOPY VARCHAR2
143: )
144: IS

Line 147: l_ref_designator_rec Bom_Bo_Pub.Ref_Designator_Rec_Type;

143: )
144: IS
145: l_return_status varchar2(80);
146: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
147: l_ref_designator_rec Bom_Bo_Pub.Ref_Designator_Rec_Type;
148: l_Token_Tbl Error_Handler.Token_Tbl_Type;
149: BEGIN
150:
151: UPDATE BOM_REFERENCE_DESIGNATORS

Line 212: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type

208: *
209: ********************************************************************/
210:
211: PROCEDURE Insert_Row
212: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
213: , p_Ref_Desg_Unexp_Rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
214: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
215: , x_Return_Status OUT NOCOPY VARCHAR2
216: )

Line 213: , p_Ref_Desg_Unexp_Rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type

209: ********************************************************************/
210:
211: PROCEDURE Insert_Row
212: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
213: , p_Ref_Desg_Unexp_Rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
214: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
215: , x_Return_Status OUT NOCOPY VARCHAR2
216: )
217: IS

Line 376: , x_Ref_Designator_Rec OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Rec_Type

372: PROCEDURE Query_Row
373: ( p_ref_designator IN VARCHAR2
374: , p_component_sequence_id IN NUMBER
375: , p_acd_type IN NUMBER
376: , x_Ref_Designator_Rec OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Rec_Type
377: , x_Ref_Desg_Unexp_Rec OUT NOCOPY Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
378: , x_Return_Status OUT NOCOPY VARCHAR2
379: )
380: IS

Line 377: , x_Ref_Desg_Unexp_Rec OUT NOCOPY Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type

373: ( p_ref_designator IN VARCHAR2
374: , p_component_sequence_id IN NUMBER
375: , p_acd_type IN NUMBER
376: , x_Ref_Designator_Rec OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Rec_Type
377: , x_Ref_Desg_Unexp_Rec OUT NOCOPY Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
378: , x_Return_Status OUT NOCOPY VARCHAR2
379: )
380: IS
381: l_ref_designator_rec Bom_Bo_Pub.Ref_Designator_Rec_Type;

Line 381: l_ref_designator_rec Bom_Bo_Pub.Ref_Designator_Rec_Type;

377: , x_Ref_Desg_Unexp_Rec OUT NOCOPY Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
378: , x_Return_Status OUT NOCOPY VARCHAR2
379: )
380: IS
381: l_ref_designator_rec Bom_Bo_Pub.Ref_Designator_Rec_Type;
382: l_Ref_Desg_Unexp_Rec Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type;
383: l_err_text VARCHAR2(2000);
384: BEGIN
385:

Line 382: l_Ref_Desg_Unexp_Rec Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type;

378: , x_Return_Status OUT NOCOPY VARCHAR2
379: )
380: IS
381: l_ref_designator_rec Bom_Bo_Pub.Ref_Designator_Rec_Type;
382: l_Ref_Desg_Unexp_Rec Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type;
383: l_err_text VARCHAR2(2000);
384: BEGIN
385:
386: SELECT COMPONENT_REFERENCE_DESIGNATOR

Line 449: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_rec_Type

445:
446: END Query_Row;
447:
448: PROCEDURE Perform_Writes
449: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_rec_Type
450: , p_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
451: , x_mesg_token_tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
452: , x_return_status OUT NOCOPY VARCHAR2
453: )

Line 450: , p_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type

446: END Query_Row;
447:
448: PROCEDURE Perform_Writes
449: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_rec_Type
450: , p_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
451: , x_mesg_token_tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
452: , x_return_status OUT NOCOPY VARCHAR2
453: )
454: IS