1 PACKAGE WIP_REPETITIVE_UTILITIES AUTHID CURRENT_USER AS
2 /* $Header: wipreuts.pls 115.8 2002/11/29 15:29:22 rmahidha ship $ */
3
4 /*============================================================================
5 SPLIT_SCHEDULE
6 This procedure split a schedule into two consecutive schedules.
7 A new schedule is created and the new schedule id is returned.
8
9 PARAMETERS
10 p_sched_id Id of the schedule to be split
11 p_org_id Organization Id
12 p_new_sched_id Id of the new schedule that was split from the old schedule
13
14 ASUMMPTION
15 Schedule is released.
16 =============================================================================*/
17
18 PROCEDURE split_schedule
19 (p_sched_id IN NUMBER,
20 p_org_id IN NUMBER,
21 p_new_sched_id IN OUT NOCOPY NUMBER);
22
23
24 /*============================================================================
25 ROLL_FORWARD
26 This schedule will release the next schedule defined for a
27 production line/assembly association if one is defined.
28 If the p_update_status parameter is TRUE, it will change the status of the
29 closed schedule to Complete-No Charges if there is a defined schedule or
30 Complete-Charges if there isn't a schedule defined.
31
32 PARAMETERS
33 p_closed_sched_id Id of schedule to be closed
34 p_rollfwd_sched_id Id of schedule being roll forward
35 p_rollfwd_type Type of roll forward being done
36 includes
37 WIP_CONSTANTS.ROLL_COMPLETE
38 WIP_CONSTANTS.ROLL_CANCEL
39 WIP_CONSTANTS.ROLL_EC_IMP
40 p_org_id Organization Id
41 p_update_status Boolean indicating if status should be updated
42
43 =============================================================================*/
44
45 PROCEDURE roll_forward
46 (p_closed_sched_id IN NUMBER,
47 p_rollfwd_sched_id IN OUT NOCOPY NUMBER,
48 p_rollfwd_type IN NUMBER,
49 p_org_id IN NUMBER,
50 p_update_status IN BOOLEAN);
51
52 PROCEDURE ROLL_FORWARD_COVER
53 (p_closed_sched_id IN NUMBER,
54 p_rollfwd_sched_id IN NUMBER,
55 p_rollfwd_type IN NUMBER,
56 p_org_id IN NUMBER,
57 p_update_status IN NUMBER,
58 p_success_flag OUT NOCOPY NUMBER,
59 p_error_msg OUT NOCOPY VARCHAR2);
60
61 PROCEDURE get_first_last_sched
62 ( p_wip_entity_id IN NUMBER,
63 p_org_id IN NUMBER,
64 p_line_id IN NUMBER,
65 x_first_sched_id OUT NOCOPY NUMBER,
66 x_last_sched_id OUT NOCOPY NUMBER,
67 x_error_mesg OUT NOCOPY VARCHAR2);
68
69 FUNCTION get_line_id
70 ( p_rep_sched_id IN NUMBER,
71 p_org_id IN NUMBER) RETURN NUMBER;
72
73 END WIP_REPETITIVE_UTILITIES;
|
|
|