[Home] [Help]
PACKAGE: APPS.ENG_SUB_COMPONENT_UTIL
Source
1 PACKAGE ENG_Sub_Component_Util AUTHID CURRENT_USER AS
2 /* $Header: ENGUSBCS.pls 115.7 2002/11/24 12:30:57 bbontemp ship $ */
3
4 -- Attributes global constants
5
6 G_SUBSTITUTE_COMPONENT CONSTANT NUMBER := 1;
7 G_LAST_UPDATE_DATE CONSTANT NUMBER := 2;
8 G_LAST_UPDATED_BY CONSTANT NUMBER := 3;
9 G_CREATION_DATE CONSTANT NUMBER := 4;
10 G_CREATED_BY CONSTANT NUMBER := 5;
11 G_LAST_UPDATE_LOGIN CONSTANT NUMBER := 6;
12 G_SUBSTITUTE_ITEM_QUANTITY CONSTANT NUMBER := 7;
13 G_COMPONENT_SEQUENCE CONSTANT NUMBER := 8;
14 G_ACD_TYPE CONSTANT NUMBER := 9;
15 G_CHANGE_NOTICE CONSTANT NUMBER := 10;
16 G_REQUEST CONSTANT NUMBER := 11;
17 G_PROGRAM_APPLICATION CONSTANT NUMBER := 12;
18 G_PROGRAM_UPDATE_DATE CONSTANT NUMBER := 13;
19 G_ATTRIBUTE_CATEGORY CONSTANT NUMBER := 14;
20 G_ATTRIBUTE1 CONSTANT NUMBER := 15;
21 G_ATTRIBUTE2 CONSTANT NUMBER := 16;
22 G_ATTRIBUTE4 CONSTANT NUMBER := 17;
23 G_ATTRIBUTE5 CONSTANT NUMBER := 18;
24 G_ATTRIBUTE6 CONSTANT NUMBER := 19;
25 G_ATTRIBUTE8 CONSTANT NUMBER := 20;
26 G_ATTRIBUTE9 CONSTANT NUMBER := 21;
27 G_ATTRIBUTE10 CONSTANT NUMBER := 22;
28 G_ATTRIBUTE12 CONSTANT NUMBER := 23;
29 G_ATTRIBUTE13 CONSTANT NUMBER := 24;
30 G_ATTRIBUTE14 CONSTANT NUMBER := 25;
31 G_ATTRIBUTE15 CONSTANT NUMBER := 26;
32 G_PROGRAM CONSTANT NUMBER := 27;
33 G_ATTRIBUTE3 CONSTANT NUMBER := 28;
34 G_ATTRIBUTE7 CONSTANT NUMBER := 29;
35 G_ATTRIBUTE11 CONSTANT NUMBER := 30;
36 G_MAX_ATTR_ID CONSTANT NUMBER := 31;
37
38 -- Function Convert_Miss_To_Null
39
40 FUNCTION Convert_Miss_To_Null
41 ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
42 ) RETURN Bom_Bo_Pub.Sub_Component_Rec_Type;
43
44 -- Function Query_Row
45
46 PROCEDURE Query_Row
47 ( p_substitute_component_id IN NUMBER
48 , p_component_sequence_id IN NUMBER
49 , p_acd_type IN NUMBER
50 , x_Sub_Component_Rec OUT NOCOPY Bom_Bo_Pub.Sub_Component_Rec_Type
51 , x_Sub_Comp_Unexp_Rec OUT NOCOPY Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
52 , x_return_status OUT NOCOPY VARCHAR2
53 );
54
55 -- Procedure lock_Row
56 --
57
58 PROCEDURE Lock_Row
59 ( x_return_status OUT NOCOPY VARCHAR2
60 , p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
61 , x_sub_component_rec OUT NOCOPY Bom_Bo_Pub.Sub_Component_Rec_Type
62 , x_err_text OUT NOCOPY VARCHAR2
63 );
64
65 PROCEDURE Perform_Writes
66 ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
67 , p_sub_comp_unexp_rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
68 , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
69 , x_Return_Status OUT NOCOPY VARCHAR2
70 );
71
72
73 END ENG_Sub_Component_Util;