1 PACKAGE EGO_COMMON_PVT AS
2 /* $Header: EGOAPCCS.pls 120.8 2007/03/23 10:08:26 dsakalle ship $ */
3
4
5 FUNCTION Is_EGO_Installed (
6 p_api_version IN NUMBER
7 ,p_release_version IN VARCHAR2
8 ) RETURN VARCHAR2;
9
10 FUNCTION Get_Prod_Schema (
11 p_prod_name IN VARCHAR2
12 ) RETURN VARCHAR2;
13
14
15 /*#
16 *------------------------------------------------------------------------*
17 * This procedure updates the profile value EGO_USER_ORGANIZATION_CONTEXT *
18 * for the current user. Returns S is successful. *
19 * If any other profile id is passed, this API returns U. *
20 * @param P_PROFILE_OPTION_ID: Profile Id *
21 * @param P_PROFILE_OPTION_VALUE: Profile Value *
22 * @return X_RETURN_STATUS: Return Status. U- Unsuccessful. S- Success *
23 * @return X_MSG_DATA: Message indicating wat went wrong incase of U *
24 *------------------------------------------------------------------------*
25 */
26 PROCEDURE SAVE_USR_ORG_CTX_PROF_VAL (
27 P_PROFILE_OPTION_ID IN NUMBER
28 ,P_PROFILE_OPTION_VALUE IN VARCHAR2
29 ,P_MODE IN VARCHAR2
30 ,X_RETURN_STATUS OUT NOCOPY VARCHAR2
31 ,X_MSG_DATA OUT NOCOPY VARCHAR2
32 ) ;
33
34 /*#
35 *------------------------------------------------------------------------*
36 * This procedure calls Change Management procedure to cancel any NIR *
37 * associated with an item being deleted. It is called from *
38 * BOM_DELETE_GROUPS_API.INVOKE_EVENTS. *
39 * @param P_INVENTORY_ITEM_ID: Id of the item being deleted. *
40 * @param P_ORGANIZATION_ID: Organization Id from which the item is being *
41 * deleted.Profile Value *
42 * @param P_ITEM_NUMBER: Item Number of the item being deleted. *
43 *------------------------------------------------------------------------*
44 */
45 PROCEDURE CANCEL_NIR_FOR_DELETE_ITEM (
46 P_INVENTORY_ITEM_ID IN NUMBER,
47 P_ORGANIZATION_ID IN NUMBER,
48 P_ITEM_NUMBER IN VARCHAR2
49 );
50
51 /*#
52 *--------------------------------------------------------------------*
53 * R12C new Function for getting the defaulting options. *
54 * This function takes in the option_code as an input and returns the *
55 * correspondin option value. *
56 * @param OPTION_CODE_IN : option code for which the value is seeked *
57 *--------------------------------------------------------------------*
58 */
59 FUNCTION GET_OPTION_VALUE (
60 OPTION_CODE_IN IN VARCHAR2
61 )RETURN VARCHAR2;
62
63
64 /*
65 * This procedure is used to write the debug messages into FND_LOG
66 * If this is called from within a concurrent program, the request_id
67 * will be prepended in the message.
68 * @param p_log_level: log level, a constant from FND_LOG.
69 * If passed null, then FND_LOG.LEVEL_STATEMENT
70 * will be used for logging.
71 * @param p_module: Name of the calling module
72 * for eg. EGO_IMPORT_PVT.Resolve_Child_Entities
73 * @param p_message: Message text
74 */
75 PROCEDURE WRITE_DIAGNOSTIC(p_log_level NUMBER DEFAULT NULL,
76 p_module VARCHAR2,
77 p_message VARCHAR2);
78
79 END EGO_COMMON_PVT;
80