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_MEL_CDL_HEADERS_PVT dependencies on STANDARD

Line 33: -- Standard IN params

29: -- Spec Procedure Create_Mel_Cdl --
30: -----------------------------------
31: PROCEDURE Create_Mel_Cdl
32: (
33: -- Standard IN params
34: p_api_version IN NUMBER,
35: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
36: p_commit IN VARCHAR2 := FND_API.G_FALSE,
37: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

Line 40: -- Standard OUT params

36: p_commit IN VARCHAR2 := FND_API.G_FALSE,
37: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
38: p_default IN VARCHAR2 := FND_API.G_FALSE,
39: p_module_type IN VARCHAR2 := NULL,
40: -- Standard OUT params
41: x_return_status OUT NOCOPY VARCHAR2,
42: x_msg_count OUT NOCOPY NUMBER,
43: x_msg_data OUT NOCOPY VARCHAR2,
44: -- Procedure IN, OUT, IN/OUT params

Line 76: -- Standard start of API savepoint

72: WHERE pc_node_id = p_x_mel_cdl_header_rec.pc_node_id AND
73: mel_cdl_type_code = p_x_mel_cdl_header_rec.mel_cdl_type_code;
74:
75: BEGIN
76: -- Standard start of API savepoint
77: SAVEPOINT Create_Mel_Cdl_SP;
78:
79: -- Initialize return status to success before any code logic/validation
80: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 82: -- Standard call to check for call compatibility

78:
79: -- Initialize return status to success before any code logic/validation
80: x_return_status := FND_API.G_RET_STS_SUCCESS;
81:
82: -- Standard call to check for call compatibility
83: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version, p_api_version, l_api_name, G_PKG_NAME)
84: THEN
85: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
86: END IF;

Line 282: -- Standard call to get message count and if count is 1, get message info

278: THEN
279: COMMIT WORK;
280: END IF;
281:
282: -- Standard call to get message count and if count is 1, get message info
283: FND_MSG_PUB.count_and_get
284: (
285: p_count => x_msg_count,
286: p_data => x_msg_data,

Line 336: -- Standard IN params

332: -- Spec Procedure Update_Mel_Cdl --
333: -----------------------------------
334: PROCEDURE Update_Mel_Cdl
335: (
336: -- Standard IN params
337: p_api_version IN NUMBER,
338: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
339: p_commit IN VARCHAR2 := FND_API.G_FALSE,
340: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

Line 343: -- Standard OUT params

339: p_commit IN VARCHAR2 := FND_API.G_FALSE,
340: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
341: p_default IN VARCHAR2 := FND_API.G_FALSE,
342: p_module_type IN VARCHAR2 := NULL,
343: -- Standard OUT params
344: x_return_status OUT NOCOPY VARCHAR2,
345: x_msg_count OUT NOCOPY NUMBER,
346: x_msg_data OUT NOCOPY VARCHAR2,
347: -- Procedure IN, OUT, IN/OUT params

Line 397: -- Standard start of API savepoint

393:
394: l_prev_rev_date DATE;
395:
396: BEGIN
397: -- Standard start of API savepoint
398: SAVEPOINT Update_Mel_Cdl_SP;
399:
400: -- Initialize return status to success before any code logic/validation
401: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 403: -- Standard call to check for call compatibility

399:
400: -- Initialize return status to success before any code logic/validation
401: x_return_status := FND_API.G_RET_STS_SUCCESS;
402:
403: -- Standard call to check for call compatibility
404: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version, p_api_version, l_api_name, G_PKG_NAME)
405: THEN
406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
407: END IF;

Line 592: -- Standard call to get message count and if count is 1, get message info

588: THEN
589: COMMIT WORK;
590: END IF;
591:
592: -- Standard call to get message count and if count is 1, get message info
593: FND_MSG_PUB.count_and_get
594: (
595: p_count => x_msg_count,
596: p_data => x_msg_data,

Line 646: -- Standard IN params

642: -- Spec Procedure Delete_Mel_Cdl --
643: -----------------------------------
644: PROCEDURE Delete_Mel_Cdl
645: (
646: -- Standard IN params
647: p_api_version IN NUMBER,
648: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
649: p_commit IN VARCHAR2 := FND_API.G_FALSE,
650: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

Line 653: -- Standard OUT params

649: p_commit IN VARCHAR2 := FND_API.G_FALSE,
650: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
651: p_default IN VARCHAR2 := FND_API.G_FALSE,
652: p_module_type IN VARCHAR2 := NULL,
653: -- Standard OUT params
654: x_return_status OUT NOCOPY VARCHAR2,
655: x_msg_count OUT NOCOPY NUMBER,
656: x_msg_data OUT NOCOPY VARCHAR2,
657: -- Procedure IN, OUT, IN/OUT params

Line 689: -- Standard start of API savepoint

685: ata.mel_cdl_ata_sequence_id = note.source_object_id AND
686: note.source_object_code = 'AHL_MEL_CDL';
687:
688: BEGIN
689: -- Standard start of API savepoint
690: SAVEPOINT Delete_Mel_Cdl_SP;
691:
692: -- Initialize return status to success before any code logic/validation
693: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 695: -- Standard call to check for call compatibility

691:
692: -- Initialize return status to success before any code logic/validation
693: x_return_status := FND_API.G_RET_STS_SUCCESS;
694:
695: -- Standard call to check for call compatibility
696: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version, p_api_version, l_api_name, G_PKG_NAME)
697: THEN
698: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
699: END IF;

Line 882: -- Standard call to get message count and if count is 1, get message info

878: THEN
879: COMMIT WORK;
880: END IF;
881:
882: -- Standard call to get message count and if count is 1, get message info
883: FND_MSG_PUB.count_and_get
884: (
885: p_count => x_msg_count,
886: p_data => x_msg_data,

Line 936: -- Standard IN params

932: -- Spec Procedure Create_Mel_Cdl_Revision --
933: --------------------------------------------
934: PROCEDURE Create_Mel_Cdl_Revision
935: (
936: -- Standard IN params
937: p_api_version IN NUMBER,
938: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
939: p_commit IN VARCHAR2 := FND_API.G_FALSE,
940: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

Line 943: -- Standard OUT params

939: p_commit IN VARCHAR2 := FND_API.G_FALSE,
940: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
941: p_default IN VARCHAR2 := FND_API.G_FALSE,
942: p_module_type IN VARCHAR2 := NULL,
943: -- Standard OUT params
944: x_return_status OUT NOCOPY VARCHAR2,
945: x_msg_count OUT NOCOPY NUMBER,
946: x_msg_data OUT NOCOPY VARCHAR2,
947: -- Procedure IN, OUT, IN/OUT params

Line 1123: -- Standard start of API savepoint

1119: FROM ahl_mel_cdl_relationships
1120: WHERE ata_sequence_id = p_ata_sequence_id;
1121:
1122: BEGIN
1123: -- Standard start of API savepoint
1124: SAVEPOINT Create_Mel_Cdl_Revision_SP;
1125:
1126: -- Initialize return status to success before any code logic/validation
1127: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1129: -- Standard call to check for call compatibility

1125:
1126: -- Initialize return status to success before any code logic/validation
1127: x_return_status := FND_API.G_RET_STS_SUCCESS;
1128:
1129: -- Standard call to check for call compatibility
1130: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version, p_api_version, l_api_name, G_PKG_NAME)
1131: THEN
1132: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1133: END IF;

Line 1662: -- Standard call to get message count and if count is 1, get message info

1658: THEN
1659: COMMIT WORK;
1660: END IF;
1661:
1662: -- Standard call to get message count and if count is 1, get message info
1663: FND_MSG_PUB.count_and_get
1664: (
1665: p_count => x_msg_count,
1666: p_data => x_msg_data,

Line 1716: -- Standard IN params

1712: -- Spec Procedure Initiate_Mel_Cdl_Approval --
1713: ----------------------------------------------
1714: PROCEDURE Initiate_Mel_Cdl_Approval
1715: (
1716: -- Standard IN params
1717: p_api_version IN NUMBER,
1718: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1719: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1720: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

Line 1723: -- Standard OUT params

1719: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1720: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1721: p_default IN VARCHAR2 := FND_API.G_FALSE,
1722: p_module_type IN VARCHAR2 := NULL,
1723: -- Standard OUT params
1724: x_return_status OUT NOCOPY VARCHAR2,
1725: x_msg_count OUT NOCOPY NUMBER,
1726: x_msg_data OUT NOCOPY VARCHAR2,
1727: -- Procedure IN, OUT, IN/OUT params

Line 1801: -- Standard start of API savepoint

1797: l_prev_revision_date DATE;
1798: l_prev_expired_date DATE;
1799:
1800: BEGIN
1801: -- Standard start of API savepoint
1802: SAVEPOINT Initiate_Mel_Cdl_Approval_SP;
1803:
1804: -- Initialize return status to success before any code logic/validation
1805: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1807: -- Standard call to check for call compatibility

1803:
1804: -- Initialize return status to success before any code logic/validation
1805: x_return_status := FND_API.G_RET_STS_SUCCESS;
1806:
1807: -- Standard call to check for call compatibility
1808: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version, p_api_version, l_api_name, G_PKG_NAME)
1809: THEN
1810: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1811: END IF;

Line 2025: -- Standard call to get message count and if count is 1, get message info

2021: THEN
2022: COMMIT WORK;
2023: END IF;
2024:
2025: -- Standard call to get message count and if count is 1, get message info
2026: FND_MSG_PUB.count_and_get
2027: (
2028: p_count => x_msg_count,
2029: p_data => x_msg_data,