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.18.12020000.2 2012/12/11 03:23:54 prakkum 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 748: -- p_x_sr_mr_association_tbl IN OUT AHL_UMP_SR_PVT.SR_MR_Association_Tbl_Type Required

744: -- p_object_version_number IN NUMBER Required
745: -- The object version number of the Service Request
746: -- p_request_number IN VARCHAR2 Required if p_request_id is not given
747: -- The request number of the Service Request
748: -- p_x_sr_mr_association_tbl IN OUT AHL_UMP_SR_PVT.SR_MR_Association_Tbl_Type Required
749: -- The Table of records containing the details about the associations and disassociations
750: --
751: -- Version :
752: -- Initial Version 1.0

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

766: p_login_id IN NUMBER,
767: p_request_id IN NUMBER,
768: p_object_version_number IN NUMBER,
769: p_request_number IN VARCHAR2,
770: p_x_sr_mr_association_tbl IN OUT NOCOPY AHL_UMP_SR_PVT.SR_MR_Association_Tbl_Type) IS
771:
772: l_api_version CONSTANT NUMBER := 1.0;
773: l_api_name CONSTANT VARCHAR2(30) := 'Process_SR_MR_Associations';
774: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.Process_SR_MR_Associations';

Line 3296: END AHL_UMP_SR_PVT;

3292: -------------------------------------
3293: -- End Local Procedure Definitions --
3294: -------------------------------------
3295:
3296: END AHL_UMP_SR_PVT;