1 PACKAGE AHL_WARRANTY_CONTRACTS_PVT AUTHID CURRENT_USER AS
2 /* $Header: AHLVSWCS.pls 120.5.12020000.3 2013/05/29 04:24:30 sareepar ship $ */
3
4 ------------------------------------------------------------------------------------
5 -- Start of Comments
6 -- Procedure name : Auto_Create_Warranty_Contracts
7 -- Type : Public
8 -- Function : Procedure to auto create warranty contracts. Will be called by CP :
9 -- Pre-reqs :
10 -- Parameters :
11 --
12 -- Auto_Create_Warranty_Contracts Parameters:
13 -- p_api_version IN NUMBER Required
14 -- End of Comments
15
16 PROCEDURE Auto_Create_Warranty_Contracts (
17 errbuf OUT NOCOPY VARCHAR2,
18 retcode OUT NOCOPY NUMBER,
19 p_api_version IN NUMBER );
20
21 ------------------------------------------------------------------------------------
22 -- Start of Comments
23 -- Procedure name : Create_Contract
24 -- Type : Public
25 -- Function : Procedure to create warranty contracts based on an exisiting warranty template.
26 -- Pre-reqs :
27 -- Parameters :
28 --
29 -- Create_Contract Parameters:
30 -- p_api_version IN NUMBER Required
31 -- p_warranty_template_id IN NUMBER Required
32 -- p_item_instance_id IN NUMBER Required
33 --
34 -- End of Comments
35
36 PROCEDURE Create_Contract (
37 p_api_version IN NUMBER,
38 p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
39 p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
40 p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
41 p_module_type IN VARCHAR2 := NULL,
42 p_warranty_template_id IN NUMBER := NULL,
43 p_item_instance_id IN NUMBER,
44 x_warranty_contract_id OUT NOCOPY NUMBER,
45 x_return_status OUT NOCOPY VARCHAR2,
46 x_msg_count OUT NOCOPY NUMBER,
47 x_msg_data OUT NOCOPY VARCHAR2);
48
49 ------------------------------------------------------------------------------------
50 -- Start of Comments
51 -- Function name : Can_Contract_Be_Created
52 -- Type : Public
53 -- Function : Function to check if a given template and item combination is valid
54 -- for contract creation or not. Returns 'Y' or 'N'.
55 -- Pre-reqs :
56 -- Parameters :
57 --
58 -- Can_Contract_Be_Created Parameters:
59 -- p_warranty_tmpl_id IN NUMBER Required : Warranty template id
60 -- p_warranty_item_id IN NUMBER Required : Warranty item id, associated to the template
61 -- p_warranty_item_org_id IN NUMBER Required : Warranty item org id (master org id)
62 --
63 -- End of Comments
64
65 FUNCTION Can_Contract_Be_Created (
66 p_warranty_tmpl_id IN NUMBER,
67 p_warranty_item_id IN NUMBER,
68 p_warranty_item_org_id IN NUMBER
69 ) RETURN VARCHAR2;
70
71 ------------------------------------------------------------------------------------
72 -- Start of Comments
73 -- Function name : Is_Instance_Warranty_Available
74 -- Type : Public
75 -- Function : Function to check if a given instance has at least one 'ACTIVE'
76 -- contract available or not. Returns 'Y' or 'N'.
77 -- Pre-reqs :
78 -- Parameters :
79 --
80 -- Is_Instance_Warranty_Available Parameters:
81 -- p_warranty_instance_id IN NUMBER Required : Warranty instance id
82 --
83 -- End of Comments
84
85 FUNCTION Is_Instance_Warranty_Available (
86 p_warranty_instance_id IN NUMBER
87 ) RETURN VARCHAR2;
88
89 ------------------------------------------------------------------------------------
90 -- Start of Comments
91 -- Procedure name : ADD_LANGUAGE
92 -- Type : Public
93 -- Function : Procedure created using utility:$FND_TOP/bin/AFTBLGEN
94 -- To add language dependent rows to tables.
95 -- This procedure adds rows in below two tables
96 -- AHL_WARRANTY_CONTRACTS_TL
97 -- AHL_WARRANTY_CONT_CTR_TL
98 -- Pre-reqs :
99 -- Parameters :
100 --
101 -- End of Comments
102
103 PROCEDURE ADD_LANGUAGE;
104
105 END AHL_WARRANTY_CONTRACTS_PVT;
106