PACKAGE: APPS.ASO_COPY_TMPL_PUB

Source

1 PACKAGE ASO_COPY_TMPL_PUB AUTHID CURRENT_USER as
2 /* $Header: asoptcps.pls 120.0.12010000.1 2010/02/18 09:25:45 rassharm noship $ */
3 -- Start of Comments
4 -- Package name     : ASO_COPY_TMPL_PUB
5 -- Purpose          :
6 --   This package contains procedure for creating template from quote
7 --   Public  API of Order Capture.
8 --
9 --   Procedures:
10 --   Copy_Quote_To_Tmpl
11 --
12 -- History          :
13 -- NOTE             :
14 --
15 -- End of Comments
16 
17 PROCEDURE Copy_Quote_To_Tmpl (
18        P_Api_Version_Number IN NUMBER
19     , P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
20     , P_Commit IN VARCHAR2 := FND_API.G_FALSE
21     , P_old_quote_header_Id IN NUMBER
22     , X_Qte_Header_Id OUT NOCOPY /* file.sql.39 change */   NUMBER
23     , X_Qte_Number OUT NOCOPY /* file.sql.39 change */   NUMBER
24     , X_Return_Status OUT NOCOPY /* file.sql.39 change */   VARCHAR2
25     , X_Msg_Count OUT NOCOPY /* file.sql.39 change */   VARCHAR2
26     , X_Msg_Data OUT NOCOPY /* file.sql.39 change */   VARCHAR2
27     );
28 
29  PROCEDURE Copy_Tmpl_Header(
30        P_Api_Version_Number IN NUMBER
31     , P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
32     , P_Commit IN VARCHAR2 := FND_API.G_FALSE
33     , P_Qte_Header_Rec IN ASO_QUOTE_PUB.qte_header_rec_Type
34     , X_Qte_Header_Id OUT NOCOPY /* file.sql.39 change */   NUMBER
35     , X_Return_Status OUT NOCOPY /* file.sql.39 change */   VARCHAR2
36     , X_Msg_Count OUT NOCOPY /* file.sql.39 change */   NUMBER
37     , X_Msg_Data OUT NOCOPY /* file.sql.39 change */   VARCHAR2
38     );
39 
40 PROCEDURE Copy_Tmpl_Lines(
41      P_Api_Version_Number          IN   NUMBER,
42      P_Init_Msg_List               IN   VARCHAR2     := FND_API.G_FALSE,
43      P_Commit                      IN   VARCHAR2     := FND_API.G_FALSE,
44      P_Qte_Header_Id          IN   NUMBER,
45      P_New_Qte_Header_Id      IN   NUMBER,
46      --P_Qte_Line_Id            IN   NUMBER   := FND_API.G_MISS_NUM,
47      --P_Qte_Header_Rec         IN   ASO_QUOTE_PUB.Qte_Header_Rec_Type,
48      P_Control_Rec            IN   ASO_QUOTE_PUB.Control_Rec_Type,
49      --X_Qte_Line_Id            OUT NOCOPY /* file.sql.39 change */     NUMBER,
50      X_Return_Status          OUT NOCOPY /* file.sql.39 change */     VARCHAR2,
51      X_Msg_Count              OUT NOCOPY /* file.sql.39 change */     NUMBER,
52      X_Msg_Data               OUT NOCOPY /* file.sql.39 change */     VARCHAR2 );
53 
54 
55      PROCEDURE Copy_Tmpl_Service (
56        p_qte_line_id IN NUMBER
57     , p_new_qte_header_id IN NUMBER
58     , p_qte_header_id IN NUMBER
59     , lx_line_index_link_tbl IN OUT NOCOPY  ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type
60     , X_Return_Status OUT NOCOPY /* file.sql.39 change */   VARCHAR2
61     , X_Msg_Count OUT NOCOPY /* file.sql.39 change */   NUMBER
62     , X_Msg_Data OUT NOCOPY /* file.sql.39 change */   VARCHAR2
63    ) ;
64 
65     PROCEDURE Config_Copy_Tmpl (
66        p_old_config_header_id IN NUMBER
67     , p_old_config_revision_num IN NUMBER
68     , p_config_header_id IN NUMBER
69     , p_config_revision_num IN NUMBER
70     , p_new_qte_header_id IN NUMBER
71     , p_qte_header_id IN NUMBER
72     , lx_line_index_link_tbl IN OUT NOCOPY ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type
73     , X_Return_Status OUT NOCOPY /* file.sql.39 change */   VARCHAR2
74     , X_Msg_Count OUT NOCOPY /* file.sql.39 change */   NUMBER
75     , X_Msg_Data OUT NOCOPY /* file.sql.39 change */   VARCHAR2
76 );
77 
78     End ASO_COPY_TMPL_PUB;