[Home] [Help]
1: PACKAGE BODY fem_ud_pkg AS
2: -- $Header: fem_ud_eng.plb 120.13.12010000.2 2008/10/08 18:47:40 huli ship $ */
3: -- ***********************
4: -- Package constants
5: -- ***********************
2: -- $Header: fem_ud_eng.plb 120.13.12010000.2 2008/10/08 18:47:40 huli ship $ */
3: -- ***********************
4: -- Package constants
5: -- ***********************
6: pc_pkg_name CONSTANT VARCHAR2(30) := 'fem_ud_pkg';
7:
8: G_FEM constant varchar2(3) := 'FEM';
9: G_YES CONSTANT VARCHAR2(1) := 'Y';
10: G_NO CONSTANT VARCHAR2(1) := 'N';
263: -- p_object_id - Object ID of the rule execution being removed
264: -- ============================================================================
265:
266: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
267: 'fem.plsql.fem_ud_pkg.raise_undo_business_event';
268: C_API_NAME CONSTANT VARCHAR2(30) := 'Raise_Undo_Business_Event';
269: v_calendar_id NUMBER;
270: v_cal_period_id NUMBER;
271: v_ledger_id NUMBER;
6647: -- Otherwise, set x_return_status to 'S' (Success) after deleting the
6648: -- balances and all related Process Locks and Data Locations related data.
6649: -- =========================================================================
6650: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
6651: 'fem.plsql.fem_ud_pkg.delete_balances';
6652: C_API_NAME CONSTANT VARCHAR2(30) := 'Delete_Balances';
6653: C_API_VERSION CONSTANT NUMBER := 1.0;
6654: C_FEM_BALANCES CONSTANT VARCHAR2(30) := 'FEM_BALANCES';
6655: --
6957: -- Purpose
6958: -- Removes all process locks and all registered temporary objects for
6959: -- those rules that register with the Process Locks framework but is
6960: -- not removed as part of the Undo framework. This API calls the
6961: -- existing private procedure FEM_UD_PKG.Delete_Execution_Log once it
6962: -- verifies that the rule execution being passed in belongs to a rule
6963: -- type that has its Undo Flag attribute set to No, has not registered
6964: -- any tables in FEM_PL_TABLES (i.e. has not output data), and is not
6965: -- still running.
6975: -- Otherwise, set x_return_status to 'S' (Success) after deleting
6976: -- all Process Locks data.
6977: -- =========================================================================
6978: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
6979: 'fem.plsql.fem_ud_pkg.remove_process_locks';
6980: C_API_NAME CONSTANT VARCHAR2(30) := 'Remove_Process_Locks';
6981: C_API_VERSION CONSTANT NUMBER := 1.0;
6982: --
6983: e_api_error EXCEPTION;
8226: END write_debug;
8227:
8228: -- ****************************************************************************
8229:
8230: END fem_ud_pkg;