[Home] [Help]
PACKAGE: APPS.AHL_PRD_RESOURCE_TRANX_PVT
Source
1 PACKAGE AHL_PRD_RESOURCE_TRANX_PVT AUTHID CURRENT_USER AS
2 /* $Header: AHLVTRSS.pls 120.5 2006/01/19 16:46:02 sikumar noship $ */
3 TYPE PRD_RESOURCE_TXNS_REC IS RECORD
4 (
5 WORKORDER_ID NUMBER,
6 WORKORDER_OPERATION_ID NUMBER,
7 OPERATION_RESOURCE_ID NUMBER,
8 ORGANIZATION_ID NUMBER,
9 OPERATION_SEQUENCE_NUM NUMBER,
10 RESOURCE_SEQUENCE_NUM NUMBER,
11 RESOURCE_NAME VARCHAR2(240),
12 RESOURCE_ID NUMBER,
13 EMPLOYEE_NUM VARCHAR2(30),
14 EMPLOYEE_NAME VARCHAR2(240),
15 PERSON_ID NUMBER,
16 DEPARTMENT_CODE VARCHAR2(80),
17 DEPARTMENT_ID NUMBER,
18 SERIAL_NUMBER VARCHAR2(30),
19 INSTANCE_ID NUMBER,
20 QTY NUMBER,
21 UOM_CODE VARCHAR2(30),
22 UOM_MEANING VARCHAR2(80),
23 ACTIVITY_MEANING VARCHAR2(80),
24 ACTIVITY_ID NUMBER,
25 REASON_ID NUMBER,
26 REASON VARCHAR2(80),
27 REFERENCE VARCHAR2(30),
28 DML_OPERATION VARCHAR2(1),
29 RESOURCE_TYPE_CODE VARCHAR2(30),
30 RESOURCE_TYPE_NAME VARCHAR2(80),
31 DEPARTMENT_NAME VARCHAR2(240),
32 TRANSACTION_DATE DATE,
33 END_DATE DATE
34 );
35
36 TYPE PRD_RESOURCE_TXNS_TBL IS TABLE OF PRD_RESOURCE_TXNS_REC INDEX BY BINARY_INTEGER;
37
38
39 --ADDED BY VSUNDARA FOR TRANSIT CHECK ENHANCEMENTS
40 TYPE PRD_MYWORKORDER_TXNS_REC IS RECORD
41 (
42 WORKORDER_ID NUMBER,
43 WORKORDER_OPERATION_ID NUMBER,
44 ASSIGNMENT_ID NUMBER,
45 RESOURCE_SEQUENCE NUMBER,
46 OPERATION_SEQUENCE NUMBER ,
47 EMPLOYEE_ID NUMBER ,
48 TOTAL_TRANSACTED_HOURS NUMBER,
49 TRANSACTED_HOURS NUMBER,
50 DML_OPERATION VARCHAR2(1),
51 OBJECT_VERSION_NUMBER NUMBER,
52 OP_OBJECT_VERSION_NUMBER NUMBER ,
53 OPERATION_COMPLETE VARCHAR2(1)
54 );
55
56 TYPE PRD_MYWORKORDER_TXNS_TBL IS TABLE OF PRD_MYWORKORDER_TXNS_REC INDEX BY BINARY_INTEGER;
57
58
59
60 PROCEDURE PROCESS_RESOURCE_TXNS
61 (
62 p_api_version IN NUMBER := 1.0,
63 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
64 p_commit IN VARCHAR2 := FND_API.G_FALSE,
65 p_validation_level IN NUMBER:=FND_API.G_VALID_LEVEL_FULL,
66 p_default IN VARCHAR2 := FND_API.G_FALSE,
67 p_module_type IN VARCHAR2 := NULL,
68 x_return_status OUT NOCOPY VARCHAR2,
69 x_msg_count OUT NOCOPY NUMBER,
70 x_msg_data OUT NOCOPY VARCHAR2,
71 p_x_prd_resrc_txn_tbl IN OUT NOCOPY PRD_RESOURCE_TXNS_TBL
72 );
73
74 PROCEDURE PROCESS_MYWORKORDER_TXNS
75 (
76 p_api_version IN NUMBER := 1.0,
77 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
78 p_commit IN VARCHAR2 := FND_API.G_FALSE,
79 p_validation_level IN NUMBER:=FND_API.G_VALID_LEVEL_FULL,
80 p_default IN VARCHAR2 := FND_API.G_FALSE,
81 p_module_type IN VARCHAR2 := NULL,
82 x_return_status OUT NOCOPY VARCHAR2,
83 x_msg_count OUT NOCOPY NUMBER,
84 x_msg_data OUT NOCOPY VARCHAR2,
85 p_x_prd_myworkorder_txn_tbl IN OUT NOCOPY PRD_MYWORKORDER_TXNS_TBL
86 );
87
88
89 FUNCTION Get_transacted_hours
90 (
91 p_wip_entity_id IN NUMBER,
92 p_operation_seq_num IN NUMBER,
93 p_resource_seq_num IN NUMBER,
94 p_employee_id IN NUMBER
95 ) RETURN NUMBER;
96
97 /*
98 -- NAME
99 -- PROCEDURE: Get_Resource_Txn_Defaults
100 -- PARAMETERS
101 -- Standard IN Parameters
102 -- p_api_version IN NUMBER := 1.0
103 -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
104 -- p_module_type IN VARCHAR2 := NULL
105 --
106 -- Standard OUT Parameters
107 -- x_return_status OUT NOCOPY VARCHAR2
108 -- x_msg_count OUT NOCOPY NUMBER
109 -- x_msg_data OUT NOCOPY VARCHAR2
110 --
111 -- Get_Resource_Txn_Defaults Parameters
112 -- p_employee_id IN NUMBER
113 -- p_workorder_id IN NUMBER
114 -- p_operation_seq_num IN NUMBER
115 -- p_function_name IN VARCHAR2 - The function name identifying the type of user
116 -- x_resource_txn_tbl OUT NOCOPY PRD_RESOURCE_TXNS_TBL
117 --
118 -- DESCRIPTION
119 -- This procedure is used to retrieve the default resource transactions based on the user/function name
120 --
121 -- HISTORY
122 -- 16-Jun-2005 rroy Created
123 --*/
124
125 PROCEDURE Get_Resource_Txn_Defaults
126 (
127 p_api_version IN NUMBER := 1.0,
128 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
129 p_module_type IN VARCHAR2 := NULL,
130 x_return_status OUT NOCOPY VARCHAR2,
131 x_msg_count OUT NOCOPY NUMBER,
132 x_msg_data OUT NOCOPY VARCHAR2,
133 p_employee_id IN NUMBER,
134 p_workorder_id IN NUMBER,
135 p_operation_seq_num IN NUMBER,
136 p_function_name IN VARCHAR2,
137 x_resource_txn_tbl OUT NOCOPY PRD_RESOURCE_TXNS_TBL
138 );
139
140 END AHL_PRD_RESOURCE_TRANX_PVT;