APPS.AHL_FMP_MR_HEADER_PVT dependencies on AHL_FMP_MR_HEADER_PVT

Line 1: PACKAGE BODY AHL_FMP_MR_HEADER_PVT AS

1: PACKAGE BODY AHL_FMP_MR_HEADER_PVT AS
2: /* $Header: AHLVMRHB.pls 120.4.12010000.2 2008/12/29 01:01:46 sracha ship $ */
3:
4: G_PKG_NAME VARCHAR2(30):='AHL_FMP_MR_HEADER_PVT';
5: G_APPLN_USAGE VARCHAR2(30):=RTRIM(LTRIM(FND_PROFILE.VALUE('AHL_APPLN_USAGE')));

Line 4: G_PKG_NAME VARCHAR2(30):='AHL_FMP_MR_HEADER_PVT';

1: PACKAGE BODY AHL_FMP_MR_HEADER_PVT AS
2: /* $Header: AHLVMRHB.pls 120.4.12010000.2 2008/12/29 01:01:46 sracha ship $ */
3:
4: G_PKG_NAME VARCHAR2(30):='AHL_FMP_MR_HEADER_PVT';
5: G_APPLN_USAGE VARCHAR2(30):=RTRIM(LTRIM(FND_PROFILE.VALUE('AHL_APPLN_USAGE')));
6: G_DEBUG VARCHAR2(1) :=AHL_DEBUG_PUB.is_log_enabled;
7:
8: PROCEDURE DEFAULT_MISSING_ATTRIBS

Line 9: (p_x_mr_header_rec IN OUT NOCOPY AHL_FMP_MR_HEADER_PVT.MR_HEADER_REC)

5: G_APPLN_USAGE VARCHAR2(30):=RTRIM(LTRIM(FND_PROFILE.VALUE('AHL_APPLN_USAGE')));
6: G_DEBUG VARCHAR2(1) :=AHL_DEBUG_PUB.is_log_enabled;
7:
8: PROCEDURE DEFAULT_MISSING_ATTRIBS
9: (p_x_mr_header_rec IN OUT NOCOPY AHL_FMP_MR_HEADER_PVT.MR_HEADER_REC)
10: AS
11: CURSOR CurHeaderDet(c_mr_header_id NUMBER) IS
12: SELECT MR_HEADER_ID,
13: OBJECT_VERSION_NUMBER,

Line 596: p_x_mr_header_rec IN OUT NOCOPY AHL_FMP_MR_HEADER_PVT.MR_HEADER_REC

592:
593: PROCEDURE TRANSLATE_VALUE_ID
594: (
595: x_return_status OUT NOCOPY VARCHAR2,
596: p_x_mr_header_rec IN OUT NOCOPY AHL_FMP_MR_HEADER_PVT.MR_HEADER_REC
597: )
598: as
599: CURSOR get_lookup_meaning_to_code(c_lookup_type VARCHAR2,c_meaning VARCHAR2)
600: IS

Line 922: p_mr_header_rec IN AHL_FMP_MR_HEADER_PVT.MR_HEADER_REC

918: -- Start of Validate
919: PROCEDURE VALIDATE_MR_TYPE
920: (
921: x_return_status OUT NOCOPY VARCHAR2,
922: p_mr_header_rec IN AHL_FMP_MR_HEADER_PVT.MR_HEADER_REC
923: )
924: as
925: Cursor GetMrdet(C_MR_HEADER_ID NUMBER)
926: IS

Line 1023: p_mr_header_rec IN AHL_FMP_MR_HEADER_PVT.MR_HEADER_REC

1019:
1020: PROCEDURE VALIDATE_MR_HEADER
1021: (
1022: x_return_status OUT NOCOPY VARCHAR2,
1023: p_mr_header_rec IN AHL_FMP_MR_HEADER_PVT.MR_HEADER_REC
1024: )
1025: as
1026:
1027: CURSOR get_lookup_meaning_to_code(c_lookup_type VARCHAR2,c_meaning VARCHAR2)

Line 1132: l_mr_header_rec AHL_FMP_MR_HEADER_PVT.mr_header_Rec:=p_mr_header_rec;

1128: l_appln_code VARCHAR2(80);
1129: l_msg_count NUMBER;
1130: l_msg_data1 VARCHAR2(2000);
1131: l_return_status VARCHAR2(1);
1132: l_mr_header_rec AHL_FMP_MR_HEADER_PVT.mr_header_Rec:=p_mr_header_rec;
1133: l_lookup_var varchar2(1);
1134: l_title_counter NUMBER:=0;
1135: l_check_flag VARCHAR2(1):='Y';
1136: l_counter number:=0;

Line 1966: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_FMP_MR_HEADER_PVT',

1962: ROLLBACK TO CREATE_MR_HEADER_PVT;
1963: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1964: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1965: THEN
1966: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_FMP_MR_HEADER_PVT',
1967: p_procedure_name => 'CREATE_MR_HEADER',
1968: p_error_text => SUBSTR(SQLERRM,1,240));
1969:
1970: END IF;

Line 2539: END AHL_FMP_MR_HEADER_PVT;

2535: END IF;
2536:
2537: END DELETE_MR_HEADER;
2538:
2539: END AHL_FMP_MR_HEADER_PVT;