DBA Data[Home] [Help]

APPS.AHL_ENIGMA_IPC_PROCS_PVT dependencies on AHL_MC_ITEM_COMP_PVT

Line 1034: -- p_ic_header_rec IN AHL_MC_ITEM_COMP_PVT.Header_Rec_Type Required

1030: -- Parameters :
1031: --
1032: -- Process_Item_Group Parameters:
1033: -- p_report_file_name IN VARCHAR2 Required
1034: -- p_ic_header_rec IN AHL_MC_ITEM_COMP_PVT.Header_Rec_Type Required
1035: -- p_det_tbl IN AHL_MC_ITEM_COMP_PVT.Header_Rec_Type Required
1036: --
1037: -- End of Comments
1038:

Line 1035: -- p_det_tbl IN AHL_MC_ITEM_COMP_PVT.Header_Rec_Type Required

1031: --
1032: -- Process_Item_Group Parameters:
1033: -- p_report_file_name IN VARCHAR2 Required
1034: -- p_ic_header_rec IN AHL_MC_ITEM_COMP_PVT.Header_Rec_Type Required
1035: -- p_det_tbl IN AHL_MC_ITEM_COMP_PVT.Header_Rec_Type Required
1036: --
1037: -- End of Comments
1038:
1039: PROCEDURE Process_Item_Composition (

Line 1047: p_ic_header_rec IN AHL_MC_ITEM_COMP_PVT.Header_Rec_Type,

1043: x_return_status OUT NOCOPY VARCHAR2,
1044: x_msg_count OUT NOCOPY NUMBER,
1045: x_msg_data OUT NOCOPY VARCHAR2,
1046: p_report_file_name IN VARCHAR2 := NULL,
1047: p_ic_header_rec IN AHL_MC_ITEM_COMP_PVT.Header_Rec_Type,
1048: p_det_tbl IN AHL_MC_ITEM_COMP_PVT.Det_Tbl_Type
1049: ) IS
1050:
1051: CURSOR get_ic_id_csr (p_item_name VARCHAR2, p_org_id NUMBER) IS

Line 1048: p_det_tbl IN AHL_MC_ITEM_COMP_PVT.Det_Tbl_Type

1044: x_msg_count OUT NOCOPY NUMBER,
1045: x_msg_data OUT NOCOPY VARCHAR2,
1046: p_report_file_name IN VARCHAR2 := NULL,
1047: p_ic_header_rec IN AHL_MC_ITEM_COMP_PVT.Header_Rec_Type,
1048: p_det_tbl IN AHL_MC_ITEM_COMP_PVT.Det_Tbl_Type
1049: ) IS
1050:
1051: CURSOR get_ic_id_csr (p_item_name VARCHAR2, p_org_id NUMBER) IS
1052: SELECT ahl.item_composition_id,

Line 1079: l_ic_header_rec AHL_MC_ITEM_COMP_PVT.Header_Rec_Type DEFAULT p_ic_header_rec;

1075: l_api_version CONSTANT NUMBER := 1.0;
1076: l_api_name CONSTANT VARCHAR2(30) := 'Process_Item_Composition';
1077: l_full_name CONSTANT VARCHAR2(60) := 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name;
1078:
1079: l_ic_header_rec AHL_MC_ITEM_COMP_PVT.Header_Rec_Type DEFAULT p_ic_header_rec;
1080: l_det_tbl AHL_MC_ITEM_COMP_PVT.Det_Tbl_Type DEFAULT p_det_tbl;
1081: l_org_id NUMBER := NULL;
1082: l_dummy VARCHAR2(1);
1083: l_msg_count NUMBER;

Line 1080: l_det_tbl AHL_MC_ITEM_COMP_PVT.Det_Tbl_Type DEFAULT p_det_tbl;

1076: l_api_name CONSTANT VARCHAR2(30) := 'Process_Item_Composition';
1077: l_full_name CONSTANT VARCHAR2(60) := 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name;
1078:
1079: l_ic_header_rec AHL_MC_ITEM_COMP_PVT.Header_Rec_Type DEFAULT p_ic_header_rec;
1080: l_det_tbl AHL_MC_ITEM_COMP_PVT.Det_Tbl_Type DEFAULT p_det_tbl;
1081: l_org_id NUMBER := NULL;
1082: l_dummy VARCHAR2(1);
1083: l_msg_count NUMBER;
1084: --

Line 1193: 'Calling private API AHL_MC_ITEM_COMP_PVT.Delete_Item_Composition.');

1189: CLOSE get_ic_id_csr;
1190:
1191: IF (l_log_statement >= l_log_current_level) THEN
1192: FND_LOG.string(l_log_statement, l_full_name,
1193: 'Calling private API AHL_MC_ITEM_COMP_PVT.Delete_Item_Composition.');
1194: END IF;
1195:
1196: -- call the private API
1197: AHL_MC_ITEM_COMP_PVT.Delete_Item_Composition(

Line 1197: AHL_MC_ITEM_COMP_PVT.Delete_Item_Composition(

1193: 'Calling private API AHL_MC_ITEM_COMP_PVT.Delete_Item_Composition.');
1194: END IF;
1195:
1196: -- call the private API
1197: AHL_MC_ITEM_COMP_PVT.Delete_Item_Composition(
1198: p_api_version => p_api_version,
1199: p_init_msg_list => p_init_msg_list,
1200: x_return_status => x_return_status,
1201: x_msg_count => x_msg_count,

Line 1209: 'AHL_MC_ITEM_COMP_PVT.Delete_Item_Composition returned x_return_status as ' || x_return_status);

1205: );
1206:
1207: IF (l_log_statement >= l_log_current_level) THEN
1208: FND_LOG.string(l_log_statement, l_full_name,
1209: 'AHL_MC_ITEM_COMP_PVT.Delete_Item_Composition returned x_return_status as ' || x_return_status);
1210: END IF;
1211:
1212: -- check for the return status
1213: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 1274: 'Calling private API AHL_MC_ITEM_COMP_PVT.Create_Item_Composition.');

1270: END IF;
1271:
1272: IF (l_log_statement >= l_log_current_level) THEN
1273: FND_LOG.string(l_log_statement, l_full_name,
1274: 'Calling private API AHL_MC_ITEM_COMP_PVT.Create_Item_Composition.');
1275: END IF;
1276:
1277: -- call the private API
1278: AHL_MC_ITEM_COMP_PVT.Create_Item_Composition(

Line 1278: AHL_MC_ITEM_COMP_PVT.Create_Item_Composition(

1274: 'Calling private API AHL_MC_ITEM_COMP_PVT.Create_Item_Composition.');
1275: END IF;
1276:
1277: -- call the private API
1278: AHL_MC_ITEM_COMP_PVT.Create_Item_Composition(
1279: p_api_version => p_api_version,
1280: p_init_msg_list => p_init_msg_list,
1281: x_return_status => x_return_status,
1282: x_msg_count => x_msg_count,

Line 1290: 'AHL_MC_ITEM_COMP_PVT.Create_Item_Composition returned x_return_status as ' || x_return_status);

1286: );
1287:
1288: IF (l_log_statement >= l_log_current_level) THEN
1289: FND_LOG.string(l_log_statement, l_full_name,
1290: 'AHL_MC_ITEM_COMP_PVT.Create_Item_Composition returned x_return_status as ' || x_return_status);
1291: END IF;
1292:
1293: -- check for the return status
1294: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 1305: 'Calling private API AHL_MC_ITEM_COMP_PVT.Approve_Item_Composiiton.');

1301:
1302: -- move the item composition to Complete status
1303: IF (l_log_statement >= l_log_current_level) THEN
1304: FND_LOG.string(l_log_statement, l_full_name,
1305: 'Calling private API AHL_MC_ITEM_COMP_PVT.Approve_Item_Composiiton.');
1306: END IF;
1307:
1308: -- call the private API
1309: AHL_MC_ITEM_COMP_PVT.Approve_Item_Composiiton(

Line 1309: AHL_MC_ITEM_COMP_PVT.Approve_Item_Composiiton(

1305: 'Calling private API AHL_MC_ITEM_COMP_PVT.Approve_Item_Composiiton.');
1306: END IF;
1307:
1308: -- call the private API
1309: AHL_MC_ITEM_COMP_PVT.Approve_Item_Composiiton(
1310: p_api_version => p_api_version,
1311: p_init_msg_list => p_init_msg_list,
1312: p_module_type => NULL, -- not used in the API
1313: x_return_status => x_return_status,

Line 1323: 'AHL_MC_ITEM_COMP_PVT.Approve_Item_Composiiton returned x_return_status as ' || x_return_status);

1319: );
1320:
1321: IF (l_log_statement >= l_log_current_level) THEN
1322: FND_LOG.string(l_log_statement, l_full_name,
1323: 'AHL_MC_ITEM_COMP_PVT.Approve_Item_Composiiton returned x_return_status as ' || x_return_status);
1324: END IF;
1325:
1326: -- check for the return status
1327: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 1408: 'Calling private API AHL_MC_ITEM_COMP_PVT.Modify_Item_Composition.');

1404: END IF;
1405:
1406: IF (l_log_statement >= l_log_current_level) THEN
1407: FND_LOG.string(l_log_statement, l_full_name,
1408: 'Calling private API AHL_MC_ITEM_COMP_PVT.Modify_Item_Composition.');
1409: END IF;
1410:
1411: -- call the private API
1412: AHL_MC_ITEM_COMP_PVT.Modify_Item_Composition(

Line 1412: AHL_MC_ITEM_COMP_PVT.Modify_Item_Composition(

1408: 'Calling private API AHL_MC_ITEM_COMP_PVT.Modify_Item_Composition.');
1409: END IF;
1410:
1411: -- call the private API
1412: AHL_MC_ITEM_COMP_PVT.Modify_Item_Composition(
1413: p_api_version => p_api_version,
1414: p_init_msg_list => p_init_msg_list,
1415: x_return_status => x_return_status,
1416: x_msg_count => x_msg_count,

Line 1424: 'AHL_MC_ITEM_COMP_PVT.Modify_Item_Composition returned x_return_status as ' || x_return_status);

1420: );
1421:
1422: IF (l_log_statement >= l_log_current_level) THEN
1423: FND_LOG.string(l_log_statement, l_full_name,
1424: 'AHL_MC_ITEM_COMP_PVT.Modify_Item_Composition returned x_return_status as ' || x_return_status);
1425: END IF;
1426:
1427: -- check for the return status
1428: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN