[Home] [Help]
PACKAGE: APPS.MSC_UPDATE_RESOURCE
Source
1 PACKAGE Msc_UPDATE_RESOURCE AUTHID CURRENT_USER 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;