APPS.AHL_ENIGMA_ROUTE_OP_PUB dependencies on AHL_ENIGMA_ROUTE_OP_PUB

Line 1: PACKAGE BODY AHL_ENIGMA_ROUTE_OP_PUB AS

1: PACKAGE BODY AHL_ENIGMA_ROUTE_OP_PUB AS
2: /* $Header: AHLPEROB.pls 120.0.12010000.3 2008/12/14 09:17:20 bachandr noship $ */
3: ------------------------------------
4: -- Common constants and variables --
5: ------------------------------------

Line 11: G_PKG_NAME VARCHAR2(30) := 'AHL_ENIGMA_ROUTE_OP_PUB';

7: l_log_statement NUMBER := fnd_log.level_statement;
8: l_log_procedure NUMBER := fnd_log.level_procedure;
9: l_log_error NUMBER := fnd_log.level_error;
10: l_log_unexpected NUMBER := fnd_log.level_unexpected;
11: G_PKG_NAME VARCHAR2(30) := 'AHL_ENIGMA_ROUTE_OP_PUB';
12:
13: -----------------------------------
14: -- Process Routes Details --
15: ------------------------------------

Line 132: l_debug_module CONSTANT VARCHAR2(100) := 'ahl.plsql.'||'AHL_ENIGMA_ROUTE_OP_PUB'||'.'||l_api_name;

128:
129: -- Declare local variables
130: l_api_name CONSTANT VARCHAR2(30) := 'Process_Route_Operations';
131: l_api_version CONSTANT NUMBER := 1.0;
132: l_debug_module CONSTANT VARCHAR2(100) := 'ahl.plsql.'||'AHL_ENIGMA_ROUTE_OP_PUB'||'.'||l_api_name;
133:
134: l_dummy VARCHAR2(1);
135: l_route_exists VARCHAR2(1) := FND_API.G_FALSE;
136: l_route_id VARCHAR2(2000);

Line 445: l_debug_module CONSTANT VARCHAR2(100) := 'AHL.PLSQL.'||'AHL_ENIGMA_ROUTE_OP_PUB'||'.'||'PROCESS_ROUTE_DETAILS';

441:
442: -- Declare local variables
443: l_api_name CONSTANT VARCHAR2(30) := 'PROCESS_ROUTE_DETAILS';
444: l_api_version CONSTANT NUMBER := 1.0;
445: l_debug_module CONSTANT VARCHAR2(100) := 'AHL.PLSQL.'||'AHL_ENIGMA_ROUTE_OP_PUB'||'.'||'PROCESS_ROUTE_DETAILS';
446:
447: x_route_id NUMBER;
448: l_ovn NUMBER;
449: x_file_id NUMBER;

Line 1979: l_debug_module CONSTANT VARCHAR2(100) := 'ahl.plsql.'||'AHL_ENIGMA_ROUTE_OP_PUB'||'.'||l_api_name;

1975:
1976: -- Declare local variables
1977: l_api_name CONSTANT VARCHAR2(30) := 'Process_OP_Details';
1978: l_api_version CONSTANT NUMBER := 1.0;
1979: l_debug_module CONSTANT VARCHAR2(100) := 'ahl.plsql.'||'AHL_ENIGMA_ROUTE_OP_PUB'||'.'||l_api_name;
1980:
1981: l_get_latest_oper_rev get_latest_oper_rev%ROWTYPE;
1982: p_process_oper_input_rec AHL_RM_OPERATION_PVT.operation_rec_type;
1983: route_operation_tbl_type AHL_RM_OP_ROUTE_AS_PVT.route_operation_tbl_type;

Line 3003: l_debug_module CONSTANT VARCHAR2(100) := 'ahl.plsql.'||'AHL_ENIGMA_ROUTE_OP_PUB'||'.'||l_api_name;

2999: l_contentBlob BLOB;
3000: l_inputFilePtr BFILE;
3001: seqNo NUMBER;
3002: l_api_name CONSTANT VARCHAR2(30) := 'UPLOAD_REVISION_REPORT';
3003: l_debug_module CONSTANT VARCHAR2(100) := 'ahl.plsql.'||'AHL_ENIGMA_ROUTE_OP_PUB'||'.'||l_api_name;
3004:
3005: BEGIN
3006:
3007: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3084: END AHL_ENIGMA_ROUTE_OP_PUB;

3080: END IF;
3081:
3082: END UPLOAD_REVISION_REPORT;
3083:
3084: END AHL_ENIGMA_ROUTE_OP_PUB;