eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_RA_SETUPS_PVT dependencies on AHL_RA_SETUPS_PVT

Line 1: PACKAGE BODY AHL_RA_SETUPS_PVT AS

1: PACKAGE BODY AHL_RA_SETUPS_PVT AS
2: /* $Header: AHLVRASB.pls 120.13 2006/02/16 01:59 sagarwal noship $*/
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_RA_SETUPS_PVT';
5: G_DML_CREATE CONSTANT VARCHAR2(1) := 'C';

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

1: PACKAGE BODY AHL_RA_SETUPS_PVT AS
2: /* $Header: AHLVRASB.pls 120.13 2006/02/16 01:59 sagarwal noship $*/
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_RA_SETUPS_PVT';
5: G_DML_CREATE CONSTANT VARCHAR2(1) := 'C';
6: G_DML_UPDATE CONSTANT VARCHAR2(1) := 'U';
7: G_DML_DELETE CONSTANT VARCHAR2(1) := 'D';
8:

Line 43: p_x_setup_data_rec IN OUT NOCOPY AHL_RA_SETUPS_PVT.RA_SETUP_DATA_REC_TYPE) IS

39: p_module_type IN VARCHAR2,
40: x_return_status OUT NOCOPY VARCHAR2,
41: x_msg_count OUT NOCOPY NUMBER,
42: x_msg_data OUT NOCOPY VARCHAR2,
43: p_x_setup_data_rec IN OUT NOCOPY AHL_RA_SETUPS_PVT.RA_SETUP_DATA_REC_TYPE) IS
44:
45: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_SETUP_DATA';
46: l_api_version CONSTANT NUMBER := 1.0;
47: l_full_name CONSTANT VARCHAR2(60) := 'ahl.plsql.'||g_pkg_name || '.' || l_api_name;

Line 49: l_setup_data_rec AHL_RA_SETUPS_PVT.RA_SETUP_DATA_REC_TYPE DEFAULT p_x_setup_data_rec;

45: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_SETUP_DATA';
46: l_api_version CONSTANT NUMBER := 1.0;
47: l_full_name CONSTANT VARCHAR2(60) := 'ahl.plsql.'||g_pkg_name || '.' || l_api_name;
48:
49: l_setup_data_rec AHL_RA_SETUPS_PVT.RA_SETUP_DATA_REC_TYPE DEFAULT p_x_setup_data_rec;
50: l_dummy VARCHAR2(1);
51: l_code VARCHAR2(30); -- dummy variable used for token storage.
52:
53: BEGIN

Line 369: p_setup_data_rec IN AHL_RA_SETUPS_PVT.RA_SETUP_DATA_REC_TYPE) IS

365: p_module_type IN VARCHAR2,
366: x_return_status OUT NOCOPY VARCHAR2,
367: x_msg_count OUT NOCOPY NUMBER,
368: x_msg_data OUT NOCOPY VARCHAR2,
369: p_setup_data_rec IN AHL_RA_SETUPS_PVT.RA_SETUP_DATA_REC_TYPE) IS
370:
371: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_SETUP_DATA';
372: l_api_version CONSTANT NUMBER := 1.0;
373: L_FULL_NAME CONSTANT VARCHAR2(60) := 'ahl.plsql.'||G_PKG_NAME || '.' || L_API_NAME;

Line 542: p_x_reliability_data_rec IN OUT NOCOPY AHL_RA_SETUPS_PVT.RA_DEFINITION_HDR_REC_TYPE)

538: p_module_type IN VARCHAR2,
539: x_return_status OUT NOCOPY VARCHAR2,
540: x_msg_count OUT NOCOPY NUMBER,
541: x_msg_data OUT NOCOPY VARCHAR2,
542: p_x_reliability_data_rec IN OUT NOCOPY AHL_RA_SETUPS_PVT.RA_DEFINITION_HDR_REC_TYPE)
543: IS
544:
545: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RELIABILITY_DATA';
546: l_api_version CONSTANT NUMBER := 1.0;

Line 548: l_ra_def_hdr_rec AHL_RA_SETUPS_PVT.RA_DEFINITION_HDR_REC_TYPE DEFAULT p_x_reliability_data_rec;

544:
545: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RELIABILITY_DATA';
546: l_api_version CONSTANT NUMBER := 1.0;
547: L_FULL_NAME CONSTANT VARCHAR2(60) := 'ahl.plsql.'||G_PKG_NAME || '.' || L_API_NAME;
548: l_ra_def_hdr_rec AHL_RA_SETUPS_PVT.RA_DEFINITION_HDR_REC_TYPE DEFAULT p_x_reliability_data_rec;
549: l_dummy VARCHAR2(1);
550:
551: BEGIN
552:

Line 891: p_reliability_data_rec IN AHL_RA_SETUPS_PVT.RA_DEFINITION_HDR_REC_TYPE) IS

887: p_module_type IN VARCHAR2,
888: x_return_status OUT NOCOPY VARCHAR2,
889: x_msg_count OUT NOCOPY NUMBER,
890: x_msg_data OUT NOCOPY VARCHAR2,
891: p_reliability_data_rec IN AHL_RA_SETUPS_PVT.RA_DEFINITION_HDR_REC_TYPE) IS
892:
893: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_RELIABILITY_DATA';
894: l_api_version CONSTANT NUMBER := 1.0;
895: L_FULL_NAME CONSTANT VARCHAR2(60) := 'ahl.plsql.'||G_PKG_NAME || '.' || L_API_NAME;

Line 1087: p_x_reliability_data_rec IN OUT NOCOPY AHL_RA_SETUPS_PVT.RA_DEFINITION_HDR_REC_TYPE,

1083: p_module_type IN VARCHAR2,
1084: x_return_status OUT NOCOPY VARCHAR2,
1085: x_msg_count OUT NOCOPY NUMBER,
1086: x_msg_data OUT NOCOPY VARCHAR2,
1087: p_x_reliability_data_rec IN OUT NOCOPY AHL_RA_SETUPS_PVT.RA_DEFINITION_HDR_REC_TYPE,
1088: p_x_mtbf_data_rec IN OUT NOCOPY AHL_RA_SETUPS_PVT.RA_DEFINITION_DTLS_REC_TYPE) IS
1089:
1090: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_MTBF_DATA';
1091: l_api_version CONSTANT NUMBER := 1.0;

Line 1088: p_x_mtbf_data_rec IN OUT NOCOPY AHL_RA_SETUPS_PVT.RA_DEFINITION_DTLS_REC_TYPE) IS

1084: x_return_status OUT NOCOPY VARCHAR2,
1085: x_msg_count OUT NOCOPY NUMBER,
1086: x_msg_data OUT NOCOPY VARCHAR2,
1087: p_x_reliability_data_rec IN OUT NOCOPY AHL_RA_SETUPS_PVT.RA_DEFINITION_HDR_REC_TYPE,
1088: p_x_mtbf_data_rec IN OUT NOCOPY AHL_RA_SETUPS_PVT.RA_DEFINITION_DTLS_REC_TYPE) IS
1089:
1090: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_MTBF_DATA';
1091: l_api_version CONSTANT NUMBER := 1.0;
1092: L_FULL_NAME CONSTANT VARCHAR2(60) := 'ahl.plsql.'||G_PKG_NAME || '.' || L_API_NAME;

Line 1094: l_ra_def_hdr_rec AHL_RA_SETUPS_PVT.RA_DEFINITION_HDR_REC_TYPE DEFAULT p_x_reliability_data_rec;

1090: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_MTBF_DATA';
1091: l_api_version CONSTANT NUMBER := 1.0;
1092: L_FULL_NAME CONSTANT VARCHAR2(60) := 'ahl.plsql.'||G_PKG_NAME || '.' || L_API_NAME;
1093:
1094: l_ra_def_hdr_rec AHL_RA_SETUPS_PVT.RA_DEFINITION_HDR_REC_TYPE DEFAULT p_x_reliability_data_rec;
1095: l_ra_def_dtl_rec AHL_RA_SETUPS_PVT.RA_DEFINITION_DTLS_REC_TYPE DEFAULT p_x_mtbf_data_rec;
1096: l_m_obj_version_num AHL_RA_DEFINITION_HDR.OBJECT_VERSION_NUMBER%TYPE;
1097: l_cou_name CSI_COUNTER_TEMPLATE_VL.NAME%TYPE;
1098: l_dummy VARCHAR2(1);

Line 1095: l_ra_def_dtl_rec AHL_RA_SETUPS_PVT.RA_DEFINITION_DTLS_REC_TYPE DEFAULT p_x_mtbf_data_rec;

1091: l_api_version CONSTANT NUMBER := 1.0;
1092: L_FULL_NAME CONSTANT VARCHAR2(60) := 'ahl.plsql.'||G_PKG_NAME || '.' || L_API_NAME;
1093:
1094: l_ra_def_hdr_rec AHL_RA_SETUPS_PVT.RA_DEFINITION_HDR_REC_TYPE DEFAULT p_x_reliability_data_rec;
1095: l_ra_def_dtl_rec AHL_RA_SETUPS_PVT.RA_DEFINITION_DTLS_REC_TYPE DEFAULT p_x_mtbf_data_rec;
1096: l_m_obj_version_num AHL_RA_DEFINITION_HDR.OBJECT_VERSION_NUMBER%TYPE;
1097: l_cou_name CSI_COUNTER_TEMPLATE_VL.NAME%TYPE;
1098: l_dummy VARCHAR2(1);
1099:

Line 1468: p_x_reliability_data_rec IN OUT NOCOPY AHL_RA_SETUPS_PVT.RA_DEFINITION_HDR_REC_TYPE,

1464: p_module_type IN VARCHAR2,
1465: x_return_status OUT NOCOPY VARCHAR2,
1466: x_msg_count OUT NOCOPY NUMBER,
1467: x_msg_data OUT NOCOPY VARCHAR2,
1468: p_x_reliability_data_rec IN OUT NOCOPY AHL_RA_SETUPS_PVT.RA_DEFINITION_HDR_REC_TYPE,
1469: p_x_mtbf_data_rec IN OUT NOCOPY AHL_RA_SETUPS_PVT.RA_DEFINITION_DTLS_REC_TYPE) IS
1470:
1471: CURSOR get_mtbf_data_cur(p_ra_definition_dtl_id IN NUMBER) IS
1472: SELECT RA_DEFINITION_DTL_ID,

Line 1469: p_x_mtbf_data_rec IN OUT NOCOPY AHL_RA_SETUPS_PVT.RA_DEFINITION_DTLS_REC_TYPE) IS

1465: x_return_status OUT NOCOPY VARCHAR2,
1466: x_msg_count OUT NOCOPY NUMBER,
1467: x_msg_data OUT NOCOPY VARCHAR2,
1468: p_x_reliability_data_rec IN OUT NOCOPY AHL_RA_SETUPS_PVT.RA_DEFINITION_HDR_REC_TYPE,
1469: p_x_mtbf_data_rec IN OUT NOCOPY AHL_RA_SETUPS_PVT.RA_DEFINITION_DTLS_REC_TYPE) IS
1470:
1471: CURSOR get_mtbf_data_cur(p_ra_definition_dtl_id IN NUMBER) IS
1472: SELECT RA_DEFINITION_DTL_ID,
1473: RA_DEFINITION_HDR_ID,

Line 1485: l_ra_def_dtl_rec AHL_RA_SETUPS_PVT.RA_DEFINITION_DTLS_REC_TYPE DEFAULT p_x_mtbf_data_rec;

1481: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_MTBF_DATA';
1482: l_api_version CONSTANT NUMBER := 1.0;
1483: L_FULL_NAME CONSTANT VARCHAR2(60) := 'ahl.plsql.'||G_PKG_NAME || '.' || L_API_NAME || ' : ';
1484: l_mtbf_data_old_rec get_mtbf_data_cur%ROWTYPE;
1485: l_ra_def_dtl_rec AHL_RA_SETUPS_PVT.RA_DEFINITION_DTLS_REC_TYPE DEFAULT p_x_mtbf_data_rec;
1486: l_ra_def_hdr_rec AHL_RA_SETUPS_PVT.RA_DEFINITION_HDR_REC_TYPE DEFAULT p_x_reliability_data_rec;
1487: l_m_obj_version_num AHL_RA_DEFINITION_HDR.OBJECT_VERSION_NUMBER%TYPE;
1488: l_cou_name CSI_COUNTER_TEMPLATE_VL.NAME%TYPE;
1489:

Line 1486: l_ra_def_hdr_rec AHL_RA_SETUPS_PVT.RA_DEFINITION_HDR_REC_TYPE DEFAULT p_x_reliability_data_rec;

1482: l_api_version CONSTANT NUMBER := 1.0;
1483: L_FULL_NAME CONSTANT VARCHAR2(60) := 'ahl.plsql.'||G_PKG_NAME || '.' || L_API_NAME || ' : ';
1484: l_mtbf_data_old_rec get_mtbf_data_cur%ROWTYPE;
1485: l_ra_def_dtl_rec AHL_RA_SETUPS_PVT.RA_DEFINITION_DTLS_REC_TYPE DEFAULT p_x_mtbf_data_rec;
1486: l_ra_def_hdr_rec AHL_RA_SETUPS_PVT.RA_DEFINITION_HDR_REC_TYPE DEFAULT p_x_reliability_data_rec;
1487: l_m_obj_version_num AHL_RA_DEFINITION_HDR.OBJECT_VERSION_NUMBER%TYPE;
1488: l_cou_name CSI_COUNTER_TEMPLATE_VL.NAME%TYPE;
1489:
1490: BEGIN

Line 1848: p_x_reliability_data_rec IN OUT NOCOPY AHL_RA_SETUPS_PVT.RA_DEFINITION_HDR_REC_TYPE,

1844: p_module_type IN VARCHAR2,
1845: x_return_status OUT NOCOPY VARCHAR2,
1846: x_msg_count OUT NOCOPY NUMBER,
1847: x_msg_data OUT NOCOPY VARCHAR2,
1848: p_x_reliability_data_rec IN OUT NOCOPY AHL_RA_SETUPS_PVT.RA_DEFINITION_HDR_REC_TYPE,
1849: p_mtbf_data_rec IN AHL_RA_SETUPS_PVT.RA_DEFINITION_DTLS_REC_TYPE) IS
1850:
1851: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_MTBF_DATA';
1852: l_api_version CONSTANT NUMBER := 1.0;

Line 1849: p_mtbf_data_rec IN AHL_RA_SETUPS_PVT.RA_DEFINITION_DTLS_REC_TYPE) IS

1845: x_return_status OUT NOCOPY VARCHAR2,
1846: x_msg_count OUT NOCOPY NUMBER,
1847: x_msg_data OUT NOCOPY VARCHAR2,
1848: p_x_reliability_data_rec IN OUT NOCOPY AHL_RA_SETUPS_PVT.RA_DEFINITION_HDR_REC_TYPE,
1849: p_mtbf_data_rec IN AHL_RA_SETUPS_PVT.RA_DEFINITION_DTLS_REC_TYPE) IS
1850:
1851: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_MTBF_DATA';
1852: l_api_version CONSTANT NUMBER := 1.0;
1853: L_FULL_NAME CONSTANT VARCHAR2(60) := 'ahl.plsql.'||G_PKG_NAME || '.' || L_API_NAME;

Line 1856: l_ra_def_hdr_rec AHL_RA_SETUPS_PVT.RA_DEFINITION_HDR_REC_TYPE DEFAULT p_x_reliability_data_rec;

1852: l_api_version CONSTANT NUMBER := 1.0;
1853: L_FULL_NAME CONSTANT VARCHAR2(60) := 'ahl.plsql.'||G_PKG_NAME || '.' || L_API_NAME;
1854:
1855: l_obj_version_num AHL_RA_CTR_ASSOCIATIONS.OBJECT_VERSION_NUMBER%TYPE;
1856: l_ra_def_hdr_rec AHL_RA_SETUPS_PVT.RA_DEFINITION_HDR_REC_TYPE DEFAULT p_x_reliability_data_rec;
1857: l_ra_def_dtl_rec AHL_RA_SETUPS_PVT.RA_DEFINITION_DTLS_REC_TYPE DEFAULT p_mtbf_data_rec;
1858: l_m_obj_version_num AHL_RA_DEFINITION_HDR.OBJECT_VERSION_NUMBER%TYPE;
1859:
1860: BEGIN

Line 1857: l_ra_def_dtl_rec AHL_RA_SETUPS_PVT.RA_DEFINITION_DTLS_REC_TYPE DEFAULT p_mtbf_data_rec;

1853: L_FULL_NAME CONSTANT VARCHAR2(60) := 'ahl.plsql.'||G_PKG_NAME || '.' || L_API_NAME;
1854:
1855: l_obj_version_num AHL_RA_CTR_ASSOCIATIONS.OBJECT_VERSION_NUMBER%TYPE;
1856: l_ra_def_hdr_rec AHL_RA_SETUPS_PVT.RA_DEFINITION_HDR_REC_TYPE DEFAULT p_x_reliability_data_rec;
1857: l_ra_def_dtl_rec AHL_RA_SETUPS_PVT.RA_DEFINITION_DTLS_REC_TYPE DEFAULT p_mtbf_data_rec;
1858: l_m_obj_version_num AHL_RA_DEFINITION_HDR.OBJECT_VERSION_NUMBER%TYPE;
1859:
1860: BEGIN
1861:

Line 2103: p_x_counter_assoc_rec IN OUT NOCOPY AHL_RA_SETUPS_PVT.RA_COUNTER_ASSOC_REC_TYPE) IS

2099: p_module_type IN VARCHAR2,
2100: x_return_status OUT NOCOPY VARCHAR2,
2101: x_msg_count OUT NOCOPY NUMBER,
2102: x_msg_data OUT NOCOPY VARCHAR2,
2103: p_x_counter_assoc_rec IN OUT NOCOPY AHL_RA_SETUPS_PVT.RA_COUNTER_ASSOC_REC_TYPE) IS
2104:
2105: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_COUNTER_ASSOC';
2106: l_api_version CONSTANT NUMBER := 1.0;
2107: L_FULL_NAME CONSTANT VARCHAR2(60) := 'ahl.plsql.'||G_PKG_NAME || '.' || L_API_NAME;

Line 2109: l_counter_assoc_rec AHL_RA_SETUPS_PVT.RA_COUNTER_ASSOC_REC_TYPE DEFAULT p_x_counter_assoc_rec;

2105: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_COUNTER_ASSOC';
2106: l_api_version CONSTANT NUMBER := 1.0;
2107: L_FULL_NAME CONSTANT VARCHAR2(60) := 'ahl.plsql.'||G_PKG_NAME || '.' || L_API_NAME;
2108:
2109: l_counter_assoc_rec AHL_RA_SETUPS_PVT.RA_COUNTER_ASSOC_REC_TYPE DEFAULT p_x_counter_assoc_rec;
2110: l_dummy VARCHAR2(1);
2111: l_new_cou_name CSI_COUNTER_TEMPLATE_VL.NAME%TYPE := NULL;
2112: l_overhaul_cou_name CSI_COUNTER_TEMPLATE_VL.NAME%TYPE := NULL;
2113: l_new_cou_uom CSI_COUNTER_TEMPLATE_VL.UOM_CODE%TYPE := NULL;

Line 2509: p_counter_assoc_rec IN AHL_RA_SETUPS_PVT.RA_COUNTER_ASSOC_REC_TYPE) IS

2505: p_module_type IN VARCHAR2,
2506: x_return_status OUT NOCOPY VARCHAR2,
2507: x_msg_count OUT NOCOPY NUMBER,
2508: x_msg_data OUT NOCOPY VARCHAR2,
2509: p_counter_assoc_rec IN AHL_RA_SETUPS_PVT.RA_COUNTER_ASSOC_REC_TYPE) IS
2510:
2511: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_COUNTER_ASSOC';
2512: l_api_version CONSTANT NUMBER := 1.0;
2513: L_FULL_NAME CONSTANT VARCHAR2(60) := 'ahl.plsql.'||G_PKG_NAME || '.' || L_API_NAME;

Line 2686: p_x_fct_assoc_rec IN OUT NOCOPY AHL_RA_SETUPS_PVT.RA_FCT_ASSOC_REC_TYPE) IS

2682: p_module_type IN VARCHAR2,
2683: x_return_status OUT NOCOPY VARCHAR2,
2684: x_msg_count OUT NOCOPY NUMBER,
2685: x_msg_data OUT NOCOPY VARCHAR2,
2686: p_x_fct_assoc_rec IN OUT NOCOPY AHL_RA_SETUPS_PVT.RA_FCT_ASSOC_REC_TYPE) IS
2687:
2688: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_FCT_ASSOC_DATA';
2689: l_api_version CONSTANT NUMBER := 1.0;
2690: L_FULL_NAME CONSTANT VARCHAR2(60) := 'ahl.plsql.'||G_PKG_NAME || '.' || L_API_NAME;

Line 2692: l_fct_assoc_rec AHL_RA_SETUPS_PVT.RA_FCT_ASSOC_REC_TYPE DEFAULT p_x_fct_assoc_rec;

2688: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_FCT_ASSOC_DATA';
2689: l_api_version CONSTANT NUMBER := 1.0;
2690: L_FULL_NAME CONSTANT VARCHAR2(60) := 'ahl.plsql.'||G_PKG_NAME || '.' || L_API_NAME;
2691:
2692: l_fct_assoc_rec AHL_RA_SETUPS_PVT.RA_FCT_ASSOC_REC_TYPE DEFAULT p_x_fct_assoc_rec;
2693: l_dummy VARCHAR2(1);
2694:
2695: BEGIN
2696:

Line 3079: p_x_fct_assoc_rec IN OUT NOCOPY AHL_RA_SETUPS_PVT.RA_FCT_ASSOC_REC_TYPE) IS

3075: p_module_type IN VARCHAR2,
3076: x_return_status OUT NOCOPY VARCHAR2,
3077: x_msg_count OUT NOCOPY NUMBER,
3078: x_msg_data OUT NOCOPY VARCHAR2,
3079: p_x_fct_assoc_rec IN OUT NOCOPY AHL_RA_SETUPS_PVT.RA_FCT_ASSOC_REC_TYPE) IS
3080:
3081: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_FCT_ASSOC_DATA';
3082: l_api_version CONSTANT NUMBER := 1.0;
3083: L_FULL_NAME CONSTANT VARCHAR2(60) := 'ahl.plsql.'||G_PKG_NAME || '.' || L_API_NAME;

Line 3085: l_fct_assoc_rec AHL_RA_SETUPS_PVT.RA_FCT_ASSOC_REC_TYPE DEFAULT p_x_fct_assoc_rec;

3081: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_FCT_ASSOC_DATA';
3082: l_api_version CONSTANT NUMBER := 1.0;
3083: L_FULL_NAME CONSTANT VARCHAR2(60) := 'ahl.plsql.'||G_PKG_NAME || '.' || L_API_NAME;
3084:
3085: l_fct_assoc_rec AHL_RA_SETUPS_PVT.RA_FCT_ASSOC_REC_TYPE DEFAULT p_x_fct_assoc_rec;
3086: l_obj_version_num AHL_RA_FCT_ASSOCIATIONS.OBJECT_VERSION_NUMBER%TYPE;
3087: l_dummy varchar2(1);
3088:
3089: BEGIN

Line 3545: p_fct_assoc_rec IN AHL_RA_SETUPS_PVT.RA_FCT_ASSOC_REC_TYPE) IS

3541: p_module_type IN VARCHAR2,
3542: x_return_status OUT NOCOPY VARCHAR2,
3543: x_msg_count OUT NOCOPY NUMBER,
3544: x_msg_data OUT NOCOPY VARCHAR2,
3545: p_fct_assoc_rec IN AHL_RA_SETUPS_PVT.RA_FCT_ASSOC_REC_TYPE) IS
3546:
3547: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_FCT_ASSOC_DATA';
3548: l_api_version CONSTANT NUMBER := 1.0;
3549: L_FULL_NAME CONSTANT VARCHAR2(60) := 'ahl.plsql.'||G_PKG_NAME || '.' || L_API_NAME;

Line 3681: END AHL_RA_SETUPS_PVT;

3677: p_encoded => fnd_api.g_false);
3678:
3679: END DELETE_FCT_ASSOC_DATA;
3680:
3681: END AHL_RA_SETUPS_PVT;