PACKAGE: APPS.OE_OTA_UTIL

Source

1 Package OE_OTA_UTIL AUTHID CURRENT_USER As
2 /* $Header: OEXUOTAS.pls 120.0 2005/06/01 01:01:56 appldev noship $ */
3 
4 G_PKG_NAME                   CONSTANT VARCHAR2(30) := 'OE_OTA_UTIL';
5 
6 
7 --  Procedure : Notify_OTA
8 --
9 
10 PROCEDURE Notify_OTA
11 (   p_line_id                       IN  NUMBER
12 ,   p_org_id                        IN  NUMBER
13 ,   p_order_quantity_uom            IN  VARCHAR2
14 ,   p_daemon_type                   IN  VARCHAR2
15 , x_return_status OUT NOCOPY VARCHAR2
16 
17 );
18 
19 PROCEDURE Get_Enrollment_Status
20 ( p_line_id            IN   NUMBER
21 , x_valid OUT NOCOPY VARCHAR2
22 
23 , x_return_status OUT NOCOPY VARCHAR2
24 
25 );
26 
27 PROCEDURE Get_Event_Status
28 ( p_line_id            IN   NUMBER
29 , x_valid OUT NOCOPY VARCHAR2
30 
31 , x_return_status OUT NOCOPY VARCHAR2
32 
33 );
34 
35 PROCEDURE Get_OTA_Description
36 ( p_line_id        IN  NUMBER
37 , p_uom            IN  VARCHAR2
38 , x_description OUT NOCOPY VARCHAR2
39 
40 , x_course_end_date OUT NOCOPY DATE
41 
42 , x_return_status OUT NOCOPY VARCHAR2
43 
44 );
45 
46 
47 PROCEDURE Check_OTA_Line( p_application_id IN NUMBER,
48 					  p_entity_short_name in VARCHAR2,
49 					  p_validation_entity_short_name in VARCHAR2,
50 					  p_validation_tmplt_short_name in VARCHAR2,
51                            p_record_set_tmplt_short_name in VARCHAR2,
52                            p_scope in VARCHAR2,
53 p_result OUT NOCOPY NUMBER );
54 
55 
56 FUNCTION Is_OTA_Line
57 (p_order_quantity_uom   VARCHAR2 := FND_API.G_MISS_CHAR)
58 RETURN BOOLEAN;
59 
60 /*csheu added procedure Create_OTA_Enroll */
61 
62 PROCEDURE Create_OTA_Enroll(p_line_id IN NUMBER,
63 					   p_org_id  IN NUMBER,
64 					   p_sold_to_org_id IN NUMBER,
65 					   p_ship_to_org_id IN NUMBER,
66 					   p_sold_to_contact_id IN NUMBER,
67 					   p_ship_to_contact_id IN NUMBER,
68 					   p_event_id IN NUMBER,
69 					   p_order_date IN DATE,
70 x_enrollment_id OUT NOCOPY NUMBER,
71 
72 x_enrollment_status OUT NOCOPY VARCHAR2,
73 
74 x_return_status OUT NOCOPY VARCHAR2);
75 
76 
77 
78 -----------------------------------------
79 -- Function name: Get_OTA_Event_End_Date
80 -- Abstract: Given a line_id and UOM, return the event
81 --           information associated with the order line.
82 --           This API is called during cross item validation
83 --           for commitment.
84 ------------------------------------------
85 Function Get_OTA_Event_End_Date
86 (p_line_id      	IN  NUMBER,
87  p_UOM             	IN  VARCHAR2)
88 RETURN DATE;
89 
90 END OE_OTA_UTIL;
91