[Home] [Help]
PACKAGE: APPS.ASO_INSTBASE_INT
Source
1 PACKAGE ASO_instbase_INT AUTHID CURRENT_USER as
2 /* $Header: asoicsis.pls 120.1 2005/06/29 12:32:57 appldev ship $ */
3 -- Start of Comments
4 -- Package name : ASO_InstBase_INT
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10
11
12 --
13 --
14 -- Record types
15 --
16 --
17 -- API
18 --
19 -- Delete_Installation_Details
20 -- Update_Inst_Details_Order
21 --
22
23
24
25
26 -- Default number of records fetch per call
27 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
28
29
30 --------------------------------------------------------------------------
31
32 -- Start of comments
33 -- API name : Delete_Installation_Details
34 -- Type : Public
35 -- Function : This API is used to delete Installation details records.
36 -- Pre-reqs : None.
37 --
38 -- Standard IN Parameters:
39 -- p_api_version_number IN NUMBER Required
40 -- p_init_msg_list IN VARCHAR2 Optional
41 -- Default = FND_API.G_FALSE
42 --
43 -- Standard OUT NOCOPY /* file.sql.39 change */ Parameters:
44 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2(1)
45 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
46 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2(2000)
47 --
48 -- Delete_Installation_Details IN Parameters:
49 -- p_line_inst_dtl_id NUMBER Required
50
51 -- Delete_Installation_Details OUT NOCOPY /* file.sql.39 change */ Parameters:
52 -- None
53 --
54 -- Version : Current version 1.0
55 -- Initial version 1.0
56 --
57 -- End of comments
58 --------------------------------------------------------------------------
59
60 PROCEDURE Delete_Installation_Detail
61 (
62 p_api_version_number IN NUMBER,
63 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
64 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
65 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
66 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
67 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
68 p_line_inst_dtl_id IN NUMBER
69 );
70
71 PROCEDURE Update_Inst_Details_ORDER
72 (
73 p_api_version_number IN NUMBER,
74 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
75 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
76 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
77 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
78 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
79 p_quote_line_shipment_id IN NUMBER,
80 p_order_line_id IN NUMBER
81 );
82
83 FUNCTION Get_top_model_line_id(
84 p_qte_line_id number
85 ) RETURN NUMBER;
86
87 END ASO_instbase_INT;