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_UC_UNITCONFIG_PVT dependencies on AHL_UNIT_CONFIG_HEADERS

Line 37: FROM ahl_unit_config_headers_v

33: attribute12,
34: attribute13,
35: attribute14,
36: attribute15
37: FROM ahl_unit_config_headers_v
38: WHERE uc_header_id = c_uc_header_id;
39:
40: -- Procedure to clear the LOV attributes' ID to NULL or G_MISS Values if its
41: -- corresponding displayed field is NULL or G_MISS values

Line 431: FROM ahl_unit_config_headers H

427: AND trunc(nvl(I.active_end_date, SYSDATE+1)) > trunc(SYSDATE))
428: */
429:
430: AND NOT EXISTS (SELECT 'X'
431: FROM ahl_unit_config_headers H
432: WHERE H.csi_item_instance_id = C.instance_id
433: AND trunc(nvl(H.active_end_date, SYSDATE+1)) > trunc(SYSDATE));
434: CURSOR get_rec_from_id(c_instance_id NUMBER, c_relationship_id NUMBER) IS
435: SELECT distinct C.instance_id

Line 463: FROM ahl_unit_config_headers H

459: AND trunc(nvl(I.active_end_date, SYSDATE+1)) > trunc(SYSDATE))
460: */
461:
462: AND NOT EXISTS (SELECT 'X'
463: FROM ahl_unit_config_headers H
464: WHERE H.csi_item_instance_id = C.instance_id
465: AND trunc(nvl(H.active_end_date, SYSDATE+1)) > trunc(SYSDATE));
466: BEGIN
467: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 513: FROM ahl_unit_config_headers

509: x_return_status OUT NOCOPY VARCHAR2)
510: IS
511: CURSOR check_uc_name1(c_uc_name varchar2) IS
512: SELECT 'x'
513: FROM ahl_unit_config_headers
514: WHERE name = c_uc_name;
515: CURSOR check_uc_name2(c_uc_name varchar2, c_uc_header_id number) IS
516: SELECT 'x'
517: FROM ahl_unit_config_headers

Line 517: FROM ahl_unit_config_headers

513: FROM ahl_unit_config_headers
514: WHERE name = c_uc_name;
515: CURSOR check_uc_name2(c_uc_name varchar2, c_uc_header_id number) IS
516: SELECT 'x'
517: FROM ahl_unit_config_headers
518: WHERE name = c_uc_name
519: AND unit_config_header_id <> c_uc_header_id;
520: CURSOR check_uc_name3(c_uc_header_id number) IS
521: SELECT name

Line 522: FROM ahl_unit_config_headers

518: WHERE name = c_uc_name
519: AND unit_config_header_id <> c_uc_header_id;
520: CURSOR check_uc_name3(c_uc_header_id number) IS
521: SELECT name
522: FROM ahl_unit_config_headers
523: WHERE unit_config_header_id = c_uc_header_id;
524: l_dummy varchar2(1);
525: l_name check_uc_name3%ROWTYPE;
526:

Line 595: -- This API is used to create a UC header record in ahl_unit_config_headers

591:
592: END validate_attributes;
593:
594: -- Define Procedure create_uc_header --
595: -- This API is used to create a UC header record in ahl_unit_config_headers
596: PROCEDURE create_uc_header(
597: p_api_version IN NUMBER := 1.0,
598: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
599: p_commit IN VARCHAR2 := FND_API.G_FALSE,

Line 724: SELECT AHL_UNIT_CONFIG_HEADERS_S.NEXTVAL

720: ': aafter validate_attributes');
721: END IF;
722:
723: -- Get the unit_config_header_id from the Sequence
724: SELECT AHL_UNIT_CONFIG_HEADERS_S.NEXTVAL
725: INTO p_x_uc_header_rec.uc_header_id
726: FROM DUAL;
727: p_x_uc_header_rec.object_version_number := 1;
728:

Line 729: -- Insert the record into table ahl_unit_config_headers

725: INTO p_x_uc_header_rec.uc_header_id
726: FROM DUAL;
727: p_x_uc_header_rec.object_version_number := 1;
728:
729: -- Insert the record into table ahl_unit_config_headers
730: INSERT INTO ahl_unit_config_headers(
731: unit_config_header_id,
732: object_version_number,
733: creation_date,

Line 730: INSERT INTO ahl_unit_config_headers(

726: FROM DUAL;
727: p_x_uc_header_rec.object_version_number := 1;
728:
729: -- Insert the record into table ahl_unit_config_headers
730: INSERT INTO ahl_unit_config_headers(
731: unit_config_header_id,
732: object_version_number,
733: creation_date,
734: created_by,

Line 797: -- Insert into the exactly same record into ahl_unit_config_headers_h

793: p_x_uc_header_rec.attribute13,
794: p_x_uc_header_rec.attribute14,
795: p_x_uc_header_rec.attribute15);
796:
797: -- Insert into the exactly same record into ahl_unit_config_headers_h
798: ahl_util_uc_pkg.copy_uc_header_to_history(p_x_uc_header_rec.uc_header_id, l_return_status);
799: --IF history copy failed, then don't raise exception, just add the message to the message stack
800: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
801: FND_MESSAGE.set_name('AHL', 'AHL_UC_HISTORY_COPY_FAILED');

Line 1007: UPDATE ahl_unit_config_headers SET

1003: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API',
1004: ': after validate_attributes');
1005: END IF;
1006:
1007: UPDATE ahl_unit_config_headers SET
1008: object_version_number = object_version_number + 1,
1009: last_update_date = sysdate,
1010: last_updated_by = fnd_global.user_id,
1011: last_update_login = fnd_global.login_id,

Line 1181: l_uc_status ahl_unit_config_headers.unit_config_status_code%TYPE;

1177: l_return_status VARCHAR2(1);
1178: l_msg_count NUMBER;
1179: l_msg_data VARCHAR2(2000);
1180: l_uc_header_rec get_uc_header%ROWTYPE;
1181: l_uc_status ahl_unit_config_headers.unit_config_status_code%TYPE;
1182: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
1183: l_csi_upd_transaction_rec csi_datastructures_pub.transaction_rec;
1184: l_csi_instance_rec csi_datastructures_pub.instance_rec;
1185: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;

Line 1202: FROM ahl_unit_config_headers

1198: AND trunc(nvl(active_start_date, SYSDATE)) <= trunc(SYSDATE)
1199: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
1200: CURSOR get_all_subunits(c_uc_header_id NUMBER) IS
1201: SELECT parent_uc_header_id, unit_config_header_id
1202: FROM ahl_unit_config_headers
1203: START WITH unit_config_header_id = c_uc_header_id
1204: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE)
1205: CONNECT BY parent_uc_header_id = PRIOR unit_config_header_id
1206: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE)

Line 1210: FROM ahl_unit_config_headers

1206: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE)
1207: FOR UPDATE OF unit_config_header_id;
1208: CURSOR get_top_unit(c_uc_header_id NUMBER) IS
1209: SELECT unit_config_header_id, unit_config_status_code
1210: FROM ahl_unit_config_headers
1211: WHERE parent_uc_header_id IS NULL
1212: START WITH unit_config_header_id = c_uc_header_id
1213: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE)
1214: CONNECT BY unit_config_header_id = PRIOR parent_uc_header_id

Line 1279: --Get p_uc_header_id its own attribute from ahl_unit_config_headers_v

1275: FND_MSG_PUB.add;
1276: RAISE FND_API.G_EXC_ERROR;
1277: END IF;
1278:
1279: --Get p_uc_header_id its own attribute from ahl_unit_config_headers_v
1280: OPEN get_uc_header(p_uc_header_id);
1281: FETCH get_uc_header INTO l_uc_header_rec;
1282: IF get_uc_header%NOTFOUND THEN
1283: CLOSE get_uc_header;

Line 1293: UPDATE ahl_unit_config_headers

1289: ELSE
1290: CLOSE get_uc_header;
1291: END IF;
1292:
1293: UPDATE ahl_unit_config_headers
1294: SET active_end_date = SYSDATE,
1295: parent_uc_header_id = NULL,
1296: --Suitable for both standalone units and sub units
1297: object_version_number = object_version_number + 1,

Line 1410: UPDATE ahl_unit_config_headers

1406: --Then expire all of the subunit headers. Here don't need to worry about the status of subunit.
1407: --because all the Draft units can only have Draft subunits and only separate units are allowed
1408: --to be submitted for approval
1409: FOR l_subunits IN get_all_subunits(l_uc_header_rec.uc_header_id) LOOP
1410: UPDATE ahl_unit_config_headers
1411: SET active_end_date = sysdate,
1412: object_version_number = object_version_number + 1,
1413: last_update_date = sysdate,
1414: last_updated_by = fnd_global.user_id,