1 PACKAGE EAM_OTL_TIMECARD_PUB as
2 /* $Header: EAMOTLTS.pls 120.0 2005/05/25 15:57:23 appldev noship $ */
3
4 PROCEDURE get_attribute_id (p_att_table IN HXC_USER_TYPE_DEFINITION_GRP.t_time_attribute,
5 p_bb_id IN number,
6 p_last_att_index IN OUT NOCOPY BINARY_INTEGER,
7 x_workorder OUT NOCOPY NUMBER,
8 x_operation OUT NOCOPY NUMBER,
9 x_resource OUT NOCOPY NUMBER,
10 x_charge_department OUT NOCOPY NUMBER,
11 x_asset_group_id OUT NOCOPY NUMBER,
12 x_owning_department OUT NOCOPY NUMBER,
13 x_asset_number OUT NOCOPY VARCHAR2) ;
14
15 PROCEDURE perform_res_txn (p_wip_entity_id IN NUMBER,
16 p_operation_seq_num IN NUMBER,
17 p_resource_id IN NUMBER,
18 p_instance_id IN NUMBER,
19 p_charge_department_id IN NUMBER,
20 p_bb_id IN NUMBER,
21 p_transaction_qty IN NUMBER,
22 p_start_time IN DATE);
23
24 FUNCTION where_clause (p_asset_group_id IN NUMBER,
25 p_asset_number IN VARCHAR2,
26 p_owning_department IN NUMBER,
27 p_charge_department IN NUMBER,
28 p_resource_id IN NUMBER,
29 p_wip_entity_id IN NUMBER,
30 p_operation_seq_num IN NUMBER,
31 p_organization_id IN NUMBER,
32 p_person_id IN NUMBER,
33 --p_project_id IN NUMBER,
34 --p_task_id IN NUMBER,
35 p_where_clause IN OUT NOCOPY VARCHAR2) RETURN VARCHAR2;
36
37 PROCEDURE retrieve_process (
38 errbuf out NOCOPY varchar2,
39 retcode out NOCOPY varchar2,
40 p_start_date IN varchar2,
41 p_end_date IN varchar2,
42 p_organization_id IN NUMBER,
43 p_asset_group_id IN NUMBER,
44 p_asset_number IN VARCHAR2,
45 --p_project_id IN NUMBER,
46 --p_task_id IN NUMBER,
47 p_resource_id IN NUMBER,
48 p_person_id IN NUMBER,
49 p_owning_department IN NUMBER,
50 p_wip_entity_id IN NUMBER,
51 p_operation_seq_num IN NUMBER,
52 p_charge_department IN NUMBER,
53 p_transaction_code IN VARCHAR2
54 );
55
56 FUNCTION get_person_id RETURN VARCHAR2;
57
58 PROCEDURE validate_work_day
59 (p_date IN DATE,
60 p_organization_id IN NUMBER,
61 x_status OUT NOCOPY NUMBER);
62
63 FUNCTION get_retrieval_function RETURN VARCHAR2;
64
65 TYPE Message_Token IS RECORD (
66 Token_Name VARCHAR2(30),
67 Token_Value VARCHAR2(255));
68
69 TYPE Message_Tokens IS TABLE OF Message_Token
70 INDEX BY BINARY_INTEGER;
71
72 procedure validate_process(p_operation IN varchar2);
73
74 procedure eam_validate_timecard(p_operation IN varchar2,
75 p_time_building_blocks IN HXC_USER_TYPE_DEFINITION_GRP.timecard_info,
76 p_time_attributes IN HXC_USER_TYPE_DEFINITION_GRP.app_attributes_info,
77 p_messages IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.message_table);
78
79
80 PROCEDURE add_error_to_table (
81 p_message_table IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.MESSAGE_TABLE
82 ,p_message_name IN FND_NEW_MESSAGES.MESSAGE_NAME%TYPE
83 ,p_message_token IN VARCHAR2
84 ,p_message_level IN VARCHAR2
85 ,p_message_field IN VARCHAR2
86 ,p_application_short_name IN VARCHAR2 default 'EAM'
87 ,p_timecard_bb_id IN NUMBER
88 ,p_time_attribute_id IN NUMBER);
89
90
91
92
93
94
95 END EAM_OTL_TIMECARD_PUB; -- Package spec