1 PACKAGE ASO_QUOTE_HOOK AUTHID CURRENT_USER as
2 /* $Header: asocztes.pls 120.2 2011/06/30 07:56:51 vidsrini noship $ */
3 /*# These public APIs allows to return the model configuration effective date and the model configuration lookup date.
4 Also retruns initialization parameters to pass from Quoting to Configurator when the configurator session is launched
5 * @rep:scope public
6 * @rep:product ASO
7 * @rep:displayname Order Capture
8 * @rep:lifecycle active
9 * @rep:compatibility S
10 * @rep:category BUSINESS_ENTITY ASO_QUOTE
11 */
12
13 -- Start of Comments
14 -- Start of Comments
15 -- Package name : ASO_QUOTE_HOOK
16 -- Purpose :
17 -- This is a new API to return the model configuration effective date
18 -- and the model configuration lookup date.
19
20
21
22
23
24 -- *******************************************************
25 -- Start of Comments
26 -- *******************************************************
27 -- API Name: Get_Model_Configuration_Date
28 -- Type : Public
29 -- Pre-Req :
30 -- Parameters:
31 -- IN
32 -- P_QUOTE_HEADER_ID IN NUMBER Optional Default = FND_API.G_MISS_NUM
33 -- P_QUOTE_LINE_ID IN NUMBER Optional Default = FND_API.G_MISS_NUM
34 --
35 --
36 -- OUT:
37 -- X_CONFIG_EFFECTIVE_DATE OUT NOCOPY /* file.sql.39 change */ DATE
38 -- X_CONFIG_MODEL_LOOKUP_DATE OUT NOCOPY /* file.sql.39 change */ DATE
39 -- Version : Current version 2.0
40 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
41 -- and basic operation, developer must manually add parameters and business logic as necessary.
42 --
43 -- End of Comments
44 --
45 /*#
46 * Use this procedure to Get Model Configuration Date.
47 * @param P_QUOTE_HEADER_ID Quote header id for the quote.
48 * @param P_QUOTE_LINE_ID Quote line id for the top level model item in the quote.
49 * @param X_CONFIG_EFFECTIVE_DATE Model configuration effective date.
50 * @param X_CONFIG_MODEL_LOOKUP_DATE Model configuration lookup date.
51 * @rep:scope public
52 * @rep:lifecycle active
53 * @rep:category BUSINESS_ENTITY ASO_QUOTE
54 * @rep:displayname Get Model Configuration Date
55 */
56
57
58 PROCEDURE Get_Model_Configuration_Date(
59 P_QUOTE_HEADER_ID IN NUMBER ,
60 P_QUOTE_LINE_ID IN NUMBER,
61 X_CONFIG_EFFECTIVE_DATE OUT NOCOPY /* file.sql.39 change */ DATE,
62 X_CONFIG_MODEL_LOOKUP_DATE OUT NOCOPY /* file.sql.39 change */ DATE
63 );
64
65 /*#
66 * Use this procedure to Get Model Init Parameters.
67 * @param P_QUOTE_HEADER_ID Quote header id for the quote.
68 * @param P_QUOTE_LINE_ID Quote line id for the top level model item in the quote.
69 * @param X_CONFIG_INIT_PARAMETER Initialization parameters from Quoting to Configurator when the configurator session is launched.
70 * @rep:scope public
71 * @rep:lifecycle active
72 * @rep:category BUSINESS_ENTITY ASO_QUOTE
73 * @rep:displayname Get Model Init Parameters
74 */
75
76 PROCEDURE Get_Model_Init_Parameters(
77 P_QUOTE_HEADER_ID IN NUMBER ,
78 P_QUOTE_LINE_ID IN NUMBER,
79 X_CONFIG_INIT_PARAMETER OUT NOCOPY /* file.sql.39 change */ VARCHAR2
80 );
81
82 End ASO_QUOTE_HOOK;