DBA Data[Home] [Help]

APPS.EAM_WORKORDER_UTIL_PKG dependencies on EAM_WORKORDER_UTIL_PKG

Line 1: PACKAGE BODY EAM_WORKORDER_UTIL_PKG as

1: PACKAGE BODY EAM_WORKORDER_UTIL_PKG as
2: /* $Header: EAMWOUTB.pls 120.24.12020000.3 2012/11/06 14:17:47 vpasupur ship $ */
3: g_supply_type VARCHAR2(30) := EAM_CONSTANTS.G_SUPPLY_TYPE;
4:
5: PROCEDURE retrieve_asset_bom(

Line 682: and eam_workorder_util_pkg.menu_has_function(fr.menu_id, p_function_id) > 0

678: and nvl(fr.end_date, sysdate) >= sysdate
679: and nvl(furg.start_date, sysdate) <= sysdate
680: and nvl(furg.end_date, sysdate) >= sysdate
681: and nvl(p_resp_app_id, fr.application_id) = fr.application_id
682: and eam_workorder_util_pkg.menu_has_function(fr.menu_id, p_function_id) > 0
683: and NVL(l_org_id, fnd_profile.value_specific('ORG_ID', NULL,
684: fr.responsibility_id, furg.responsibility_application_id)) =
685: fnd_profile.value_specific('ORG_ID', NULL,
686: fr.responsibility_id, furg.responsibility_application_id)

Line 729: and eam_workorder_util_pkg.menu_has_function(fr.menu_id, p_function_id) > 0

725: and nvl(fr.end_date, sysdate) >= sysdate
726: and nvl(furg.start_date, sysdate) <= sysdate
727: and nvl(furg.end_date, sysdate) >= sysdate
728: and nvl(p_resp_app_id, fr.application_id) = fr.application_id
729: and eam_workorder_util_pkg.menu_has_function(fr.menu_id, p_function_id) > 0
730: and oav.responsibility_id=fr.responsibility_id
731: and oav.organization_id=l_organization_id
732: and oav.resp_application_id=426
733: and ROWNUM=1;

Line 2039: l_maint_objid_tbl EAM_WORKORDER_UTIL_PKG.REPLACE_REBUILD_TBL_TYPE;

2035: x_replaced_rebuild_tbl OUT NOCOPY REPLACE_REBUILD_TBL_TYPE,
2036: x_return_status OUT NOCOPY VARCHAR2,
2037: x_error_message OUT NOCOPY VARCHAR2
2038: )IS
2039: l_maint_objid_tbl EAM_WORKORDER_UTIL_PKG.REPLACE_REBUILD_TBL_TYPE;
2040: BEGIN
2041: x_return_status := FND_API.G_RET_STS_SUCCESS;
2042:
2043:

Line 2086: END EAM_WORKORDER_UTIL_PKG;

2082: RETURN -2;
2083: END get_msu_resp_id;
2084:
2085:
2086: END EAM_WORKORDER_UTIL_PKG;
2087: