APPS.AHL_FMP_MR_VISIT_TYPES_PVT dependencies on AHL_FMP_MR_VISIT_TYPES_PVT

Line 1: PACKAGE BODY AHL_FMP_MR_VISIT_TYPES_PVT AS

1: PACKAGE BODY AHL_FMP_MR_VISIT_TYPES_PVT AS
2: /* $Header: AHLVMRVB.pls 120.2 2005/10/13 04:51:25 tamdas noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AHL_FMP_MR_VISIT_TYPES_PVT';
5: G_MODULE_NAME CONSTANT VARCHAR2(60):= 'AHL.PLSQL.AHL_FMP_MR_VISIT_TYPES_PVT';

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AHL_FMP_MR_VISIT_TYPES_PVT';

1: PACKAGE BODY AHL_FMP_MR_VISIT_TYPES_PVT AS
2: /* $Header: AHLVMRVB.pls 120.2 2005/10/13 04:51:25 tamdas noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AHL_FMP_MR_VISIT_TYPES_PVT';
5: G_MODULE_NAME CONSTANT VARCHAR2(60):= 'AHL.PLSQL.AHL_FMP_MR_VISIT_TYPES_PVT';
6: G_DEBUG CONSTANT VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
7: G_APPLN_USAGE CONSTANT VARCHAR2(30) :=LTRIM(RTRIM(FND_PROFILE.value('AHL_APPLN_USAGE')));
8:

Line 5: G_MODULE_NAME CONSTANT VARCHAR2(60):= 'AHL.PLSQL.AHL_FMP_MR_VISIT_TYPES_PVT';

1: PACKAGE BODY AHL_FMP_MR_VISIT_TYPES_PVT AS
2: /* $Header: AHLVMRVB.pls 120.2 2005/10/13 04:51:25 tamdas noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AHL_FMP_MR_VISIT_TYPES_PVT';
5: G_MODULE_NAME CONSTANT VARCHAR2(60):= 'AHL.PLSQL.AHL_FMP_MR_VISIT_TYPES_PVT';
6: G_DEBUG CONSTANT VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
7: G_APPLN_USAGE CONSTANT VARCHAR2(30) :=LTRIM(RTRIM(FND_PROFILE.value('AHL_APPLN_USAGE')));
8:
9: PROCEDURE INSERT_ROW

Line 600: 'ahl.plsql.AHL_FMP_MR_VISIT_TYPES_PVT.process_mr_visit_types',

596: l_mr_visit_type_ID NUMBER:=0;
597: BEGIN
598: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
599: fnd_log.string(fnd_log.level_procedure,
600: 'ahl.plsql.AHL_FMP_MR_VISIT_TYPES_PVT.process_mr_visit_types',
601: 'At the start of PLSQL procedure process_mr_visit_types');
602: END IF;
603:
604:

Line 629: 'Ahl.plsql.AHL_FMP_MR_VISIT_TYPES_PVT.process_mr_visit_types',

625: THEN
626: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
627: THEN
628: fnd_log.string(fnd_log.level_statement,
629: 'Ahl.plsql.AHL_FMP_MR_VISIT_TYPES_PVT.process_mr_visit_types',
630: 'Nothing to process as p_x_mr_visit_type_tbl.COUNT is :'||p_x_mr_visit_type_tbl.COUNT);
631: END IF;
632: --RETURN; -- NOTHING TO PROCESS
633: END IF;

Line 638: 'Ahl.plsql.AHL_FMP_MR_VISIT_TYPES_PVT.sort_records',

634:
635: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
636: THEN
637: fnd_log.string(fnd_log.level_statement,
638: 'Ahl.plsql.AHL_FMP_MR_VISIT_TYPES_PVT.sort_records',
639: 'IF P_MODULE_TYPE IS JSP SET LOV IDS TO NULLIFY ');
640: END IF;
641:
642:

Line 658: 'Ahl.plsql.AHL_FMP_MR_VISIT_TYPES_PVT.DEFAULT_MISSING_ATTRIBS',

654:
655: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
656: THEN
657: fnd_log.string(fnd_log.level_statement,
658: 'Ahl.plsql.AHL_FMP_MR_VISIT_TYPES_PVT.DEFAULT_MISSING_ATTRIBS',
659: 'Start of DEFAULT_MISSING_ATTRIBS');
660: END IF;
661:
662: DEFAULT_MISSING_ATTRIBS

Line 671: 'Ahl.plsql.AHL_FMP_MR_VISIT_TYPES_PVT.DEFAULT_MISSING_ATTRIBS',

667:
668: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
669: THEN
670: fnd_log.string(fnd_log.level_statement,
671: 'Ahl.plsql.AHL_FMP_MR_VISIT_TYPES_PVT.DEFAULT_MISSING_ATTRIBS',
672: 'End of DEFAULT_MISSING_ATTRIBS');
673: END IF;
674:
675: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level

Line 678: 'Ahl.plsql.AHL_FMP_MR_VISIT_TYPES_PVT.sort_records',

674:
675: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
676: THEN
677: fnd_log.string(fnd_log.level_statement,
678: 'Ahl.plsql.AHL_FMP_MR_VISIT_TYPES_PVT.sort_records',
679: 'Start of SORT_RECORDS');
680: END IF;
681:
682: SORT_RECORDS(p_x_mr_visit_type_tbl);

Line 687: 'Ahl.plsql.AHL_FMP_MR_VISIT_TYPES_PVT.sort_records',

683:
684: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
685: THEN
686: fnd_log.string(fnd_log.level_statement,
687: 'Ahl.plsql.AHL_FMP_MR_VISIT_TYPES_PVT.sort_records',
688: 'End of SORT_RECORDS');
689: END IF;
690:
691: -- No need to translate meaning to id if dml operation is delete.

Line 803: END AHL_FMP_MR_VISIT_TYPES_PVT;

799: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
800: p_count => x_msg_count,
801: p_data => X_msg_data);
802: END;
803: END AHL_FMP_MR_VISIT_TYPES_PVT;