PACKAGE: APPS.MRP_ASSIGNMENT_SET_UTIL

Source

1 PACKAGE MRP_Assignment_Set_Util AUTHID CURRENT_USER AS
2 /* $Header: MRPUASTS.pls 115.2 99/07/16 12:39:18 porting ship $ */
3 
4 --  Attributes global constants
5 
6 G_ASSIGNMENT_SET_ID           CONSTANT NUMBER := 1;
7 G_ASSIGNMENT_SET_NAME         CONSTANT NUMBER := 2;
8 G_ATTRIBUTE1                  CONSTANT NUMBER := 3;
9 G_ATTRIBUTE10                 CONSTANT NUMBER := 4;
10 G_ATTRIBUTE11                 CONSTANT NUMBER := 5;
11 G_ATTRIBUTE12                 CONSTANT NUMBER := 6;
12 G_ATTRIBUTE13                 CONSTANT NUMBER := 7;
13 G_ATTRIBUTE14                 CONSTANT NUMBER := 8;
14 G_ATTRIBUTE15                 CONSTANT NUMBER := 9;
15 G_ATTRIBUTE2                  CONSTANT NUMBER := 10;
16 G_ATTRIBUTE3                  CONSTANT NUMBER := 11;
17 G_ATTRIBUTE4                  CONSTANT NUMBER := 12;
18 G_ATTRIBUTE5                  CONSTANT NUMBER := 13;
19 G_ATTRIBUTE6                  CONSTANT NUMBER := 14;
20 G_ATTRIBUTE7                  CONSTANT NUMBER := 15;
21 G_ATTRIBUTE8                  CONSTANT NUMBER := 16;
22 G_ATTRIBUTE9                  CONSTANT NUMBER := 17;
23 G_ATTRIBUTE_CATEGORY          CONSTANT NUMBER := 18;
24 G_CREATED_BY                  CONSTANT NUMBER := 19;
25 G_CREATION_DATE               CONSTANT NUMBER := 20;
26 G_DESCRIPTION                 CONSTANT NUMBER := 21;
27 G_LAST_UPDATED_BY             CONSTANT NUMBER := 22;
28 G_LAST_UPDATE_DATE            CONSTANT NUMBER := 23;
29 G_LAST_UPDATE_LOGIN           CONSTANT NUMBER := 24;
30 G_PROGRAM_APPLICATION_ID      CONSTANT NUMBER := 25;
31 G_PROGRAM_ID                  CONSTANT NUMBER := 26;
32 G_PROGRAM_UPDATE_DATE         CONSTANT NUMBER := 27;
33 G_REQUEST_ID                  CONSTANT NUMBER := 28;
34 G_MAX_ATTR_ID                 CONSTANT NUMBER := 29;
35 
36 --  Procedure Clear_Dependent_Attr
37 
38 PROCEDURE Clear_Dependent_Attr
39 (   p_attr_id                       IN  NUMBER := FND_API.G_MISS_NUM
40 ,   p_Assignment_Set_rec            IN  MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
41 ,   p_old_Assignment_Set_rec        IN  MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type :=
42                                         MRP_Src_Assignment_PUB.G_MISS_ASSIGNMENT_SET_REC
43 ,   x_Assignment_Set_rec            OUT MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
44 );
45 
46 --  Procedure Apply_Attribute_Changes
47 
48 PROCEDURE Apply_Attribute_Changes
49 (   p_Assignment_Set_rec            IN  MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
50 ,   p_old_Assignment_Set_rec        IN  MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type :=
51                                         MRP_Src_Assignment_PUB.G_MISS_ASSIGNMENT_SET_REC
52 ,   x_Assignment_Set_rec            OUT MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
53 );
54 
55 --  Function Complete_Record
56 
57 FUNCTION Complete_Record
58 (   p_Assignment_Set_rec            IN  MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
59 ,   p_old_Assignment_Set_rec        IN  MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
60 ) RETURN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type;
61 
62 --  Function Convert_Miss_To_Null
63 
64 FUNCTION Convert_Miss_To_Null
65 (   p_Assignment_Set_rec            IN  MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
66 ) RETURN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type;
67 
68 --  Function Get_Values
69 
70 FUNCTION Get_Values
71 (   p_Assignment_Set_rec            IN  MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
72 ,   p_old_Assignment_Set_rec        IN  MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type :=
73                                         MRP_Src_Assignment_PUB.G_MISS_ASSIGNMENT_SET_REC
74 ) RETURN MRP_Src_Assignment_PUB.Assignment_Set_Val_Rec_Type;
75 
76 --  Function Get_Ids
77 
78 FUNCTION Get_Ids
79 (   p_Assignment_Set_rec            IN  MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
80 ,   p_Assignment_Set_val_rec        IN  MRP_Src_Assignment_PUB.Assignment_Set_Val_Rec_Type
81 ) RETURN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type;
82 
83 END MRP_Assignment_Set_Util;