DBA Data[Home] [Help]

APPS.AHL_UC_UNITCONFIG_PUB dependencies on AHL_UNIT_CONFIG_HEADERS

Line 8: -- This API is used to create, update or expire a UC header record in ahl_unit_config_headers

4: -- Define global internal variables
5: G_PKG_NAME VARCHAR2(30) := 'AHL_UC_UNITCONFIG_PUB';
6:
7: -- Define Procedure process_uc_header --
8: -- This API is used to create, update or expire a UC header record in ahl_unit_config_headers
9: PROCEDURE process_uc_header(
10: p_api_version IN NUMBER := 1.0,
11: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
12: p_commit IN VARCHAR2 := FND_API.G_FALSE,

Line 31: FROM ahl_unit_config_headers u,

27:
28: CURSOR get_ovns(c_uc_header_id number) IS
29: SELECT u.object_version_number,
30: c.object_version_number
31: FROM ahl_unit_config_headers u,
32: csi_item_instances c
33: WHERE u.unit_config_header_id = c_uc_header_id
34: AND u.csi_item_instance_id = c.instance_id
35: AND trunc(nvl(u.active_end_date, SYSDATE+1)) > trunc(SYSDATE);