1 PACKAGE EAM_SKILL_INSTANCE AUTHID CURRENT_USER AS
2 /* $Header: EAMSKILS.pls 115.6 2002/11/20 22:31:42 aan ship $ */
3
4
5 /**
6 * This procedure is used to assign an instance to the resource
7 */
8 procedure insert_instance(p_wip_entity_id in number,
9 p_operation_seq_num in number,
10 p_resource_seq_num in number,
11 p_organization_id in number,
12 p_user_id in number,
13 p_instance_id in number,
14 p_start_date in date,
15 p_completion_date in date,
16 p_assigned_units_updated out NOCOPY number);
17
18
19 /**
20 * This function is used to check the duplicate instance assignment
21 */
22 function is_duplicate_instance(p_wip_entity_id in number,
23 p_operation_seq_num in number,
24 p_resource_seq_num in number,
25 p_organization_id in number,
26 p_instance_id in number) return boolean;
27
28 /**
29 * This procedure is used to check the number of assigned units and
30 * increment it if necessary
31 */
32 procedure check_assigned_units(p_wip_entity_id in number,
33 p_operation_seq_num in number,
34 p_resource_seq_num in number,
35 p_organization_id in number,
36 p_assigned_changed out NOCOPY number);
37
38 /**
39 * This procedure is used to firm the work order after assigning an instance
40 * to the work order
41 */
42 procedure firm_work_order(p_wip_entity_id in number,
43 p_organization_id in number);
44
45 /**
46 * This procedure is used to remove an assigned instance from
47 * the resource
48 */
49 procedure remove_instance(p_wip_entity_id in number,
50 p_operation_seq_num in number,
51 p_resource_seq_num in number,
52 p_instance_id in number);
53
54
55 END EAM_SKILL_INSTANCE;