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.9.12020000.2 2012/12/13 05:03:22 shnatu 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.9.12020000.2 2012/12/13 05:03:22 shnatu 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 649: p_x_mr_header_rec IN OUT NOCOPY AHL_FMP_MR_HEADER_PVT.MR_HEADER_REC

645:
646: PROCEDURE TRANSLATE_VALUE_ID
647: (
648: x_return_status OUT NOCOPY VARCHAR2,
649: p_x_mr_header_rec IN OUT NOCOPY AHL_FMP_MR_HEADER_PVT.MR_HEADER_REC
650: )
651: as
652: CURSOR get_lookup_meaning_to_code(c_lookup_type VARCHAR2,c_meaning VARCHAR2)
653: IS

Line 1051: p_mr_header_rec IN AHL_FMP_MR_HEADER_PVT.MR_HEADER_REC

1047: -- Start of Validate
1048: PROCEDURE VALIDATE_MR_TYPE
1049: (
1050: x_return_status OUT NOCOPY VARCHAR2,
1051: p_mr_header_rec IN AHL_FMP_MR_HEADER_PVT.MR_HEADER_REC
1052: )
1053: as
1054: Cursor GetMrdet(C_MR_HEADER_ID NUMBER)
1055: IS

Line 1153: p_mr_header_rec IN AHL_FMP_MR_HEADER_PVT.MR_HEADER_REC

1149:
1150: PROCEDURE VALIDATE_MR_HEADER
1151: (
1152: x_return_status OUT NOCOPY VARCHAR2,
1153: p_mr_header_rec IN AHL_FMP_MR_HEADER_PVT.MR_HEADER_REC
1154: )
1155: as
1156:
1157: CURSOR get_lookup_meaning_to_code(c_lookup_type VARCHAR2,c_meaning VARCHAR2)

Line 1262: l_mr_header_rec AHL_FMP_MR_HEADER_PVT.mr_header_Rec:=p_mr_header_rec;

1258: l_appln_code VARCHAR2(80);
1259: l_msg_count NUMBER;
1260: l_msg_data1 VARCHAR2(2000);
1261: l_return_status VARCHAR2(1);
1262: l_mr_header_rec AHL_FMP_MR_HEADER_PVT.mr_header_Rec:=p_mr_header_rec;
1263: l_lookup_var varchar2(1);
1264: l_title_counter NUMBER:=0;
1265: l_check_flag VARCHAR2(1):='Y';
1266: l_counter number:=0;

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

2295: ROLLBACK TO CREATE_MR_HEADER_PVT;
2296: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2297: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2298: THEN
2299: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_FMP_MR_HEADER_PVT',
2300: p_procedure_name => 'CREATE_MR_HEADER',
2301: p_error_text => SUBSTR(SQLERRM,1,240));
2302:
2303: END IF;

Line 2975: END AHL_FMP_MR_HEADER_PVT;

2971: END IF;
2972:
2973: END DELETE_MR_HEADER;
2974:
2975: END AHL_FMP_MR_HEADER_PVT;