[Home] [Help]
PACKAGE: APPS.MRP_SOURCING_RULE_UTIL
Source
1 PACKAGE MRP_Sourcing_Rule_Util AUTHID CURRENT_USER AS
2 /* $Header: MRPUSRLS.pls 115.1 99/07/16 12:40:43 porting ship $ */
3
4 -- Attributes global constants
5
6 G_SOURCING_RULE_ID CONSTANT NUMBER := 1;
7 G_ATTRIBUTE1 CONSTANT NUMBER := 2;
8 G_ATTRIBUTE10 CONSTANT NUMBER := 3;
9 G_ATTRIBUTE11 CONSTANT NUMBER := 4;
10 G_ATTRIBUTE12 CONSTANT NUMBER := 5;
11 G_ATTRIBUTE13 CONSTANT NUMBER := 6;
12 G_ATTRIBUTE14 CONSTANT NUMBER := 7;
13 G_ATTRIBUTE15 CONSTANT NUMBER := 8;
14 G_ATTRIBUTE2 CONSTANT NUMBER := 9;
15 G_ATTRIBUTE3 CONSTANT NUMBER := 10;
16 G_ATTRIBUTE4 CONSTANT NUMBER := 11;
17 G_ATTRIBUTE5 CONSTANT NUMBER := 12;
18 G_ATTRIBUTE6 CONSTANT NUMBER := 13;
19 G_ATTRIBUTE7 CONSTANT NUMBER := 14;
20 G_ATTRIBUTE8 CONSTANT NUMBER := 15;
21 G_ATTRIBUTE9 CONSTANT NUMBER := 16;
22 G_ATTRIBUTE_CATEGORY CONSTANT NUMBER := 17;
23 G_CREATED_BY CONSTANT NUMBER := 18;
24 G_CREATION_DATE CONSTANT NUMBER := 19;
25 G_DESCRIPTION CONSTANT NUMBER := 20;
26 G_LAST_UPDATED_BY CONSTANT NUMBER := 21;
27 G_LAST_UPDATE_DATE CONSTANT NUMBER := 22;
28 G_LAST_UPDATE_LOGIN CONSTANT NUMBER := 23;
29 G_ORGANIZATION_ID CONSTANT NUMBER := 24;
30 G_PLANNING_ACTIVE CONSTANT NUMBER := 25;
31 G_PROGRAM_APPLICATION_ID CONSTANT NUMBER := 26;
32 G_PROGRAM_ID CONSTANT NUMBER := 27;
33 G_PROGRAM_UPDATE_DATE CONSTANT NUMBER := 28;
34 G_REQUEST_ID CONSTANT NUMBER := 29;
35 G_SOURCING_RULE_NAME CONSTANT NUMBER := 30;
36 G_SOURCING_RULE_TYPE CONSTANT NUMBER := 31;
37 G_STATUS CONSTANT NUMBER := 32;
38 G_MAX_ATTR_ID CONSTANT NUMBER := 33;
39
40 -- Procedure Clear_Dependent_Attr
41
42 PROCEDURE Clear_Dependent_Attr
43 ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
44 , p_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
45 , p_old_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type :=
46 MRP_Sourcing_Rule_PUB.G_MISS_SOURCING_RULE_REC
47 , x_Sourcing_Rule_rec OUT MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
48 );
49
50 -- Procedure Apply_Attribute_Changes
51
52 PROCEDURE Apply_Attribute_Changes
53 ( p_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
54 , p_old_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type :=
55 MRP_Sourcing_Rule_PUB.G_MISS_SOURCING_RULE_REC
56 , x_Sourcing_Rule_rec OUT MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
57 );
58
59 -- Function Complete_Record
60
61 FUNCTION Complete_Record
62 ( p_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
63 , p_old_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
64 ) RETURN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type;
65
66 -- Function Convert_Miss_To_Null
67
68 FUNCTION Convert_Miss_To_Null
69 ( p_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
70 ) RETURN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type;
71
72 -- Function Get_Values
73
74 FUNCTION Get_Values
75 ( p_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
76 , p_old_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type :=
77 MRP_Sourcing_Rule_PUB.G_MISS_SOURCING_RULE_REC
78 ) RETURN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Val_Rec_Type;
79
80 -- Function Get_Ids
81
82 FUNCTION Get_Ids
83 ( p_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
84 , p_Sourcing_Rule_val_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Val_Rec_Type
85 ) RETURN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type;
86
87 END MRP_Sourcing_Rule_Util;