1 PACKAGE CHV_CONFIRM_SCHEDULES AUTHID CURRENT_USER as
2 /* $Header: CHVPRCSS.pls 115.1 2002/11/25 19:52:55 sbull ship $ */
3
4 /*===========================================================================
5 PACKAGE NAME: CHV_CONFIRM_SCHEDULES
6 DESCRIPTION: This package contains the server side of Supplier Scheduling
7 APIs to confirm schedules
8
9 CLIENT/SERVER: Server
10
11 OWNER: Sri Rumalla
12
13 NOTE:
14
15 FUNCTION/PROCEDURE
16 confirm_schedule_item()
17 confirm_schedule_header()
18
19 ============================================================================*/
20
21 /*===========================================================================
22 FUNCTION NAME : confirm_schedule_item
23
24 DESCRIPTION : Confirm_schedules is a procedure that will confirm
25 the schedule by updating schedule status.
26
27 PARAMETERS : p_schedule_id in NUMBER,
28 p_schedule_item_id in NUMBER,
29 p_vendor_id in NUMBER,
30 p_vendor_site_id in NUMBER,
31 p_organization_id in NUMBER,
32 p_item_id in NUMBER,
33 RETURN BOOLEAN
34
35 DESIGN REFERENCES :
36
37 ALGORITHM :
38
39 NOTES :
40
41 OPEN ISSUES :
42
43 CLOSED ISSUES :
44
45 CHANGE HISTORY : Created 14-MAY-1995 SXLIU
46 ==========================================================================*/
47 FUNCTION confirm_schedule_item(p_schedule_id in NUMBER,
48 p_schedule_item_id in NUMBER,
49 p_vendor_id in NUMBER,
50 p_vendor_site_id in NUMBER,
51 p_organization_id in NUMBER,
52 p_item_id in NUMBER)
53 return boolean ;
54
55 /*===========================================================================
56 PROCEDURE NAME : confirm_schedule_header
57
58 DESCRIPTION : Confirm_schedule_header is a procedure that will confirm
59 the schedule by updating schedule status, calling
60 API to calculate high authorizations, communicating
61 the schedule based on the communication method.
62
63 PARAMETERS : p_schedule_id in NUMBER,
64 p_schedule_type in VARCHAR2,
65 p_communication_code in VARCHAR2 default null,
66 p_confirm_source in VARCHAR2,
67 p_confirmed in out VARCHAR2
68
69 DESIGN REFERENCES :
70
71 ALGORITHM :
72
73 NOTES :
74
75 OPEN ISSUES :
76
77 CLOSED ISSUES :
78
79 CHANGE HISTORY : Created 14-MAY-1995 SXLIU
80 ==========================================================================*/
81 PROCEDURE confirm_schedule_header(p_schedule_id in NUMBER,
82 p_schedule_type in VARCHAR2,
83 p_communication_code in VARCHAR2 default null,
84 p_confirm_source in VARCHAR2,
85 p_confirmed in out NOCOPY VARCHAR2);
86 END CHV_CONFIRM_SCHEDULES;