DBA Data[Home] [Help]

APPS.AHL_UMP_NONROUTINES_PVT dependencies on STANDARD

Line 76: -- Standard IN params

72: -- Spec Procedure Create_SR --
73: ------------------------------
74: PROCEDURE Create_SR
75: (
76: -- Standard IN params
77: p_api_version IN NUMBER,
78: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
79: p_commit IN VARCHAR2 := FND_API.G_FALSE,
80: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

Line 83: -- Standard OUT params

79: p_commit IN VARCHAR2 := FND_API.G_FALSE,
80: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
81: p_default IN VARCHAR2 := FND_API.G_FALSE,
82: p_module_type IN VARCHAR2 := NULL,
83: -- Standard OUT params
84: x_return_status OUT NOCOPY VARCHAR2,
85: x_msg_count OUT NOCOPY NUMBER,
86: x_msg_data OUT NOCOPY VARCHAR2,
87: -- Procedure IN, OUT, IN/OUT params

Line 126: -- Standard start of API savepoint

122: l_ata_rep_time NUMBER;
123: --SALOGAN added the following for Complex Mx
124: l_item_key VARCHAR2(60);
125: BEGIN
126: -- Standard start of API savepoint
127: SAVEPOINT Create_SR_SP;
128:
129: -- Initialize return status to success before any code logic/validation
130: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

128:
129: -- Initialize return status to success before any code logic/validation
130: x_return_status := FND_API.G_RET_STS_SUCCESS;
131:
132: -- Standard call to check for call compatibility
133: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version, p_api_version, l_api_name, G_PKG_NAME)
134: THEN
135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
136: END IF;

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

528: THEN
529: COMMIT WORK;
530: END IF;
531:
532: -- Standard call to get message count and if count is 1, get message info
533: FND_MSG_PUB.count_and_get
534: (
535: p_count => x_msg_count,
536: p_data => x_msg_data,

Line 586: -- Standard IN params

582: -- Spec Procedure Update_SR --
583: ------------------------------
584: PROCEDURE Update_SR
585: (
586: -- Standard IN params
587: p_api_version IN NUMBER,
588: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
589: p_commit IN VARCHAR2 := FND_API.G_FALSE,
590: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

Line 593: -- Standard OUT params

589: p_commit IN VARCHAR2 := FND_API.G_FALSE,
590: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
591: p_default IN VARCHAR2 := FND_API.G_FALSE,
592: p_module_type IN VARCHAR2 := NULL,
593: -- Standard OUT params
594: x_return_status OUT NOCOPY VARCHAR2,
595: x_msg_count OUT NOCOPY NUMBER,
596: x_msg_data OUT NOCOPY VARCHAR2,
597: -- Procedure IN, OUT, IN/OUT params

Line 674: -- Standard start of API savepoint

670: FROM CS_INCIDENTS
671: WHERE incident_id = c_incident_id;
672: -- End change
673: BEGIN
674: -- Standard start of API savepoint
675: SAVEPOINT Update_SR_SP;
676:
677: -- Initialize return status to success before any code logic/validation
678: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

676:
677: -- Initialize return status to success before any code logic/validation
678: x_return_status := FND_API.G_RET_STS_SUCCESS;
679:
680: -- Standard call to check for call compatibility
681: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version, p_api_version, l_api_name, G_PKG_NAME)
682: THEN
683: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
684: END IF;

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

1177: THEN
1178: COMMIT WORK;
1179: END IF;
1180:
1181: -- Standard call to get message count and if count is 1, get message info
1182: FND_MSG_PUB.count_and_get
1183: (
1184: p_count => x_msg_count,
1185: p_data => x_msg_data,

Line 1235: -- Standard IN params

1231: -- Spec Procedure Initiate_Mel_Cdl_Approval --
1232: ----------------------------------------------
1233: PROCEDURE Initiate_Mel_Cdl_Approval
1234: (
1235: -- Standard IN params
1236: p_api_version IN NUMBER,
1237: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1238: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1239: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

Line 1242: -- Standard OUT params

1238: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1239: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1240: p_default IN VARCHAR2 := FND_API.G_FALSE,
1241: p_module_type IN VARCHAR2 := NULL,
1242: -- Standard OUT params
1243: x_return_status OUT NOCOPY VARCHAR2,
1244: x_msg_count OUT NOCOPY NUMBER,
1245: x_msg_data OUT NOCOPY VARCHAR2,
1246: -- Procedure IN, OUT, IN/OUT params

Line 1386: -- Standard start of API savepoint

1382: l_process_name VARCHAR2(50);
1383: l_item_type VARCHAR2(50);
1384:
1385: BEGIN
1386: -- Standard start of API savepoint
1387: SAVEPOINT Initiate_Mel_Cdl_Approval_SP;
1388:
1389: -- Initialize return status to success before any code logic/validation
1390: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1388:
1389: -- Initialize return status to success before any code logic/validation
1390: x_return_status := FND_API.G_RET_STS_SUCCESS;
1391:
1392: -- Standard call to check for call compatibility
1393: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version, p_api_version, l_api_name, G_PKG_NAME)
1394: THEN
1395: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1396: END IF;

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

1754: THEN
1755: COMMIT WORK;
1756: END IF;
1757:
1758: -- Standard call to get message count and if count is 1, get message info
1759: FND_MSG_PUB.count_and_get
1760: (
1761: p_count => x_msg_count,
1762: p_data => x_msg_data,

Line 1812: -- Standard OUT params

1808: -- Spec Procedure Check_Open_NRs --
1809: ----------------------------------------------
1810: PROCEDURE Check_Open_NRs
1811: (
1812: -- Standard OUT params
1813: x_return_status OUT NOCOPY VARCHAR2,
1814: -- Procedure IN, OUT, IN/OUT params
1815: p_mel_cdl_header_id IN NUMBER DEFAULT NULL,
1816: p_pc_node_id IN NUMBER DEFAULT NULL

Line 4147: -- Standard check of p_commit

4143: RETURN;
4144: END IF;
4145: END IF;
4146:
4147: -- Standard check of p_commit
4148: IF FND_API.TO_BOOLEAN(p_commit) THEN
4149: COMMIT WORK;
4150: END IF;
4151: