DBA Data[Home] [Help]

APPS.AHL_UMP_SR_PVT dependencies on AHL_UMP_SR_PVT

Line 1: PACKAGE BODY AHL_UMP_SR_PVT AS

1: PACKAGE BODY AHL_UMP_SR_PVT AS
2: /* $Header: AHLVUSRB.pls 120.12.12000000.4 2007/10/26 09:45:18 bachandr ship $ */
3:
4: -----------------------
5: -- Declare Constants --

Line 7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_UMP_SR_PVT';

3:
4: -----------------------
5: -- Declare Constants --
6: -----------------------
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_UMP_SR_PVT';
8:
9: G_LOG_PREFIX CONSTANT VARCHAR2(100) := 'ahl.plsql.AHL_UMP_SR_PVT';
10:
11: G_NO_FLAG CONSTANT VARCHAR2(1) := 'N';

Line 9: G_LOG_PREFIX CONSTANT VARCHAR2(100) := 'ahl.plsql.AHL_UMP_SR_PVT';

5: -- Declare Constants --
6: -----------------------
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_UMP_SR_PVT';
8:
9: G_LOG_PREFIX CONSTANT VARCHAR2(100) := 'ahl.plsql.AHL_UMP_SR_PVT';
10:
11: G_NO_FLAG CONSTANT VARCHAR2(1) := 'N';
12: G_YES_FLAG CONSTANT VARCHAR2(1) := 'Y';
13: G_SR_CLOSED_FLAG CONSTANT VARCHAR2(1) := 'C';

Line 714: -- p_x_sr_mr_association_tbl IN OUT AHL_UMP_SR_PVT.SR_MR_Association_Tbl_Type Required

710: -- p_object_version_number IN NUMBER Required
711: -- The object version number of the Service Request
712: -- p_request_number IN VARCHAR2 Required if p_request_id is not given
713: -- The request number of the Service Request
714: -- p_x_sr_mr_association_tbl IN OUT AHL_UMP_SR_PVT.SR_MR_Association_Tbl_Type Required
715: -- The Table of records containing the details about the associations and disassociations
716: --
717: -- Version :
718: -- Initial Version 1.0

Line 736: p_x_sr_mr_association_tbl IN OUT NOCOPY AHL_UMP_SR_PVT.SR_MR_Association_Tbl_Type) IS

732: p_login_id IN NUMBER,
733: p_request_id IN NUMBER,
734: p_object_version_number IN NUMBER,
735: p_request_number IN VARCHAR2,
736: p_x_sr_mr_association_tbl IN OUT NOCOPY AHL_UMP_SR_PVT.SR_MR_Association_Tbl_Type) IS
737:
738: l_api_version CONSTANT NUMBER := 1.0;
739: l_api_name CONSTANT VARCHAR2(30) := 'Process_SR_MR_Associations';
740: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.Process_SR_MR_Associations';

Line 3104: END AHL_UMP_SR_PVT;

3100: -------------------------------------
3101: -- End Local Procedure Definitions --
3102: -------------------------------------
3103:
3104: END AHL_UMP_SR_PVT;