PACKAGE: APPS.MSC_UPDATE_RESOURCE

Source

1 PACKAGE Msc_UPDATE_RESOURCE AS
2 /* $Header: MSCFNAVS.pls 120.1 2007/10/02 02:04:53 eychen ship $ */
3 /*
4    PROCEDURE apply_simulation(p_org_id IN NUMBER,
5                            p_res_group IN VARCHAR2,
6                            p_simulation_set IN VARCHAR2,
7                            p_cutoff_date IN VARCHAR2);
8 */
9    PROCEDURE apply_change(p_query_id IN NUMBER,
10                           p_plan_id IN NUMBER);
11    PROCEDURE initialize_table;
12    PROCEDURE calculate_change;
13    PROCEDURE update_table;
14    PROCEDURE add_new_record(m NUMBER, retain_old boolean default false,
15                          retain_id boolean default false);
16    FUNCTION get_transaction_id RETURN NUMBER;
17    PROCEDURE aggregate_child_records(v_plan_id NUMBER);
18    PROCEDURE aggregate_one_resource(v_plan_id NUMBER,
19                                   p_org_id NUMBER,
20                                   p_instance_id NUMBER,
21                                   p_dept_id NUMBER,
22                                   p_res_id  NUMBER);
23 
24 PROCEDURE aggregate_some_resources(v_plan_id NUMBER,
25                                   p_org_instance_list varchar2,
26                                   p_dept_class_list VARCHAR2,
27                                   p_res_group_list VARCHAR2,
28                                   p_dept_list varchar2,
29                                   p_res_list  varchar2,
30                                   p_line_list VARCHAR2);
31 Function insert_undo_data(undo_type number,
32                          j number default null,
33                          v_undo_parent_id number default null) return number;
34 
35 PROCEDURE refresh_parent_record(p_plan_id number,
36                                 p_instance_id number,
37                                 p_transaction_id number);
38 
39 FUNCTION isFirstOP(p_plan_id number,
40                                 p_supply_id number,
41                                 p_changed_op number,
42                                 p_changed_res number) RETURN boolean;
43 
44 PROCEDURE move_res_req(p_plan_id number,
45                                 p_supply_id number);
46 
47 PROCEDURE get_new_time(p_plan_id NUMBER,
48                                   p_org_id NUMBER,
49                                   p_inst_id NUMBER,
50                                   p_dept_id NUMBER,
51                                   p_res_id  NUMBER,
52                                   p_changed_date date,
53                                   p_res_hours number,
54                                   p_assign_units number,
55                                   p_first_activity boolean,
56                                   p_new_start out nocopy date,
57                                   p_new_end out nocopy date,
58                                   p_error_status out nocopy varchar2);
59 
60 Procedure ProcessDates(p_plan_id in number,
61                             p_supply_id in number,
62                             p_effective_date out nocopy date,
63                             p_disable_date out nocopy date);
64 
65 PROCEDURE calculate_ops(p_plan_id NUMBER,
66                                 p_supply_id number,
67                                 p_changed_op number,
68                                 p_changed_res number,
69                                 p_changed_date date,
70                                 p_new_end_date date,
71                                 p_status out nocopy varchar2 );
72 
73 FUNCTION routing_res_unit(p_plan_id number, p_op_seq_id number,
74                       p_rt_seq_id number, p_res_id number,
75                       p_assign_units number) RETURN number;
76 
77 PROCEDURE reset_changes;
78 
79 PROCEDURE verify_data(p_plan_id number, p_supply_id number);
80 
81 
82 END Msc_UPDATE_RESOURCE;