[Home] [Help]
PACKAGE: APPS.EAM_ESTIMATE_ASSOCIATIONS_PKG
Source
1 PACKAGE EAM_ESTIMATE_ASSOCIATIONS_PKG AUTHID CURRENT_USER AS
2 /* $Header: EAMTESAS.pls 120.0.12010000.1 2008/11/22 00:20:59 fli noship $ */
3 -- Start of Comments
4 -- Package name : EAM_ESTIMATE_ASSOCIATIONS_PKG
5 -- Purpose : Spec of package EAM_ESTIMATE_ASSOCIATIONS_PKG
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10 PROCEDURE INSERT_ROW(
11 px_ESTIMATE_ASSOCIATION_ID IN OUT NOCOPY NUMBER,
12 p_ORGANIZATION_ID NUMBER,
13 p_ESTIMATE_ID NUMBER,
14 p_CU_ID NUMBER,
15 p_CU_QTY NUMBER,
16 p_ACCT_CLASS_CODE VARCHAR2,
17 p_ACTIVITY_ID NUMBER,
18 p_ACTIVITY_QTY NUMBER,
19 p_DIFFICULTY_ID NUMBER,
20 p_RESOURCE_MULTIPLIER NUMBER,
21 p_CREATION_DATE DATE,
22 p_CREATED_BY NUMBER,
23 p_LAST_UPDATE_DATE DATE,
24 p_LAST_UPDATED_BY NUMBER,
25 p_LAST_UPDATE_LOGIN NUMBER
26 );
27
28 PROCEDURE UPDATE_ROW(
29 p_ESTIMATE_ASSOCIATION_ID NUMBER,
30 p_ORGANIZATION_ID NUMBER,
31 p_ESTIMATE_ID NUMBER,
32 p_CU_ID NUMBER,
33 p_CU_QTY NUMBER,
34 p_ACCT_CLASS_CODE VARCHAR2,
35 p_ACTIVITY_ID NUMBER,
36 p_ACTIVITY_QTY NUMBER,
37 p_DIFFICULTY_ID NUMBER,
38 p_RESOURCE_MULTIPLIER NUMBER,
39 p_CREATION_DATE DATE,
40 p_CREATED_BY NUMBER,
41 p_LAST_UPDATE_DATE DATE,
42 p_LAST_UPDATED_BY NUMBER,
43 p_LAST_UPDATE_LOGIN NUMBER
44 );
45
46 PROCEDURE LOCK_ROW(
47 p_ESTIMATE_ASSOCIATION_ID NUMBER,
48 p_ORGANIZATION_ID NUMBER,
49 p_ESTIMATE_ID NUMBER,
50 p_CU_ID NUMBER,
51 p_CU_QTY NUMBER,
52 p_ACCT_CLASS_CODE VARCHAR2,
53 p_ACTIVITY_ID NUMBER,
54 p_ACTIVITY_QTY NUMBER,
55 p_DIFFICULTY_ID NUMBER,
56 p_RESOURCE_MULTIPLIER NUMBER,
57 p_CREATION_DATE DATE,
58 p_CREATED_BY NUMBER,
59 p_LAST_UPDATE_DATE DATE,
60 p_LAST_UPDATED_BY NUMBER,
61 p_LAST_UPDATE_LOGIN NUMBER
62 );
63
64 PROCEDURE DELETE_ROW(
65 p_ESTIMATE_ASSOCIATION_ID NUMBER
66 );
67
68 END EAM_ESTIMATE_ASSOCIATIONS_PKG;