1 PACKAGE BODY ASO_QUOTE_HOOK as
2 /* $Header: asoczteb.pls 120.1 2011/04/26 06:49:21 rassharm noship $ */
3 -- Start of Comments
4 -- Start of Comments
5 -- Package name : ASO_QUOTE_HOOK
6 -- Purpose :
7 -- This is a new API to return the model configuration effective date
8 -- and the model configuration lookup date.
9
10
11
12
13
14 -- *******************************************************
15 -- Start of Comments
16 -- *******************************************************
17 -- API Name: Get_Model_Configuration_Date
18 -- Type : Public
19 -- Pre-Req :
20 -- Parameters:
21 -- IN
22 -- P_QUOTE_HEADER_ID IN NUMBER Optional Default = FND_API.G_MISS_NUM
23 -- P_QUOTE_LINE_ID IN NUMBER Optional Default = FND_API.G_MISS_NUM
24 --
25 --
26 -- OUT:
27 -- X_CONFIG_EFFECTIVE_DATE OUT NOCOPY /* file.sql.39 change */ DATE
28 -- X_CONFIG_MODEL_LOOKUP_DATE OUT NOCOPY /* file.sql.39 change */ DATE
29 -- Version : Current version 2.0
30 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
31 -- and basic operation, developer must manually add parameters and business logic as necessary.
32 --
33 -- End of Comments
34 --
35 PROCEDURE Get_Model_Configuration_Date(
36 P_QUOTE_HEADER_ID IN NUMBER ,
37 P_QUOTE_LINE_ID IN NUMBER,
38 X_CONFIG_EFFECTIVE_DATE OUT NOCOPY /* file.sql.39 change */ DATE,
39 X_CONFIG_MODEL_LOOKUP_DATE OUT NOCOPY /* file.sql.39 change */ DATE
40 ) IS
41 BEGIN
42 X_CONFIG_EFFECTIVE_DATE:= NULL;
43 X_CONFIG_MODEL_LOOKUP_DATE:=NULL;
44
45 END Get_Model_Configuration_Date;
46
47
48 PROCEDURE Get_Model_Init_Parameters(
49 P_QUOTE_HEADER_ID IN NUMBER ,
50 P_QUOTE_LINE_ID IN NUMBER,
51 X_CONFIG_INIT_PARAMETER OUT NOCOPY /* file.sql.39 change */ VARCHAR2
52 ) IS
53 BEGIN
54
55 X_CONFIG_INIT_PARAMETER := NULL;
56
57 END Get_Model_Init_Parameters;
58
59
60 End ASO_QUOTE_HOOK;