APPS.FND_OAM_DSCRAM_UNITS_PKG dependencies on FND_OAM_DSCRAM_PLSQLS_PKG

Line 624: FND_OAM_DSCRAM_PLSQLS_PKG.UPDATE_COMP_PLS_WRITABLE_ARGS(px_work_queue_to_complete(k).item_id,

620: l_proposed_ret_sts,
621: l_return_msg);
622:
623: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_PLSQL THEN
624: FND_OAM_DSCRAM_PLSQLS_PKG.UPDATE_COMP_PLS_WRITABLE_ARGS(px_work_queue_to_complete(k).item_id,
625: px_arg_context,
626: b_unit_info.use_splitting,
627: l_proposed_ret_sts,
628: l_return_msg);

Line 673: FND_OAM_DSCRAM_PLSQLS_PKG.COMPLETE_PLSQL(px_work_queue_to_complete(k).item_id,

669:
670: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_PLSQL THEN
671: --since pl/sqls don't write the # of rows processed, they only need to be completed by the last worker
672: IF l_workers_assigned = 1 THEN
673: FND_OAM_DSCRAM_PLSQLS_PKG.COMPLETE_PLSQL(px_work_queue_to_complete(k).item_id,
674: l_proposed_ret_sts,
675: px_work_queue_to_complete(k).item_msg,
676: l_return_status,
677: l_return_msg);

Line 710: FND_OAM_DSCRAM_PLSQLS_PKG.DESTROY_PLSQL_CACHE_ENTRY(px_work_queue_to_complete(k).item_id,

706: l_return_status,
707: l_return_msg);
708:
709: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_PLSQL THEN
710: FND_OAM_DSCRAM_PLSQLS_PKG.DESTROY_PLSQL_CACHE_ENTRY(px_work_queue_to_complete(k).item_id,
711: px_arg_context,
712: l_update_context,
713: l_return_status,
714: l_return_msg);

Line 753: FND_OAM_DSCRAM_PLSQLS_PKG.DESTROY_PLSQL_CACHE(px_arg_context,

749: RAISE COMPLETE_FAILED;
750: END IF;
751:
752: --destroy the PLSQL cache
753: FND_OAM_DSCRAM_PLSQLS_PKG.DESTROY_PLSQL_CACHE(px_arg_context,
754: l_return_status,
755: l_return_msg);
756: IF l_return_status <> FND_API.G_RET_STS_SUCCESS AND
757: NOT FND_OAM_DSCRAM_UTILS_PKG.RUN_IS_NORMAL THEN

Line 1083: FND_OAM_DSCRAM_PLSQLS_PKG.EXECUTE_PLSQL_ON_RANGE(px_work_queue(k).item_id,

1079:
1080: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_PLSQL THEN
1081: --set rows processed to zero sinze pl/sql procedures don't report it
1082: l_rows_processed := 0;
1083: FND_OAM_DSCRAM_PLSQLS_PKG.EXECUTE_PLSQL_ON_RANGE(px_work_queue(k).item_id,
1084: px_arg_context,
1085: l_rowid_lbound,
1086: l_rowid_ubound,
1087: l_return_status,

Line 1168: FND_OAM_DSCRAM_PLSQLS_PKG.EXECUTE_PLSQL(px_work_queue(k).item_id,

1164: l_return_status,
1165: l_return_msg);
1166:
1167: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_PLSQL THEN
1168: FND_OAM_DSCRAM_PLSQLS_PKG.EXECUTE_PLSQL(px_work_queue(k).item_id,
1169: px_arg_context,
1170: l_return_status,
1171: l_return_msg);
1172:

Line 1192: FND_OAM_DSCRAM_PLSQLS_PKG.DESTROY_PLSQL_CACHE_ENTRY(px_work_queue(k).item_id,

1188: l_return_status,
1189: l_return_msg);
1190:
1191: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_PLSQL THEN
1192: FND_OAM_DSCRAM_PLSQLS_PKG.DESTROY_PLSQL_CACHE_ENTRY(px_work_queue(k).item_id,
1193: px_arg_context,
1194: TRUE,
1195: l_return_status,
1196: l_return_msg);

Line 1334: FND_OAM_DSCRAM_PLSQLS_PKG.FETCH_PLSQL_IDS(b_unit_info.unit_id,

1330: x_return_status := FND_API.G_RET_STS_ERROR;
1331: x_return_msg := '';
1332:
1333: --get the list of plsqls as a work queue
1334: FND_OAM_DSCRAM_PLSQLS_PKG.FETCH_PLSQL_IDS(b_unit_info.unit_id,
1335: l_work_queue,
1336: l_return_status,
1337: l_return_msg);
1338: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 1464: FND_OAM_DSCRAM_PLSQLS_PKG.FETCH_PLSQL_IDS(l_unit_ids(k),

1460: l_work_queue,
1461: l_return_status,
1462: l_return_msg);
1463: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_UNIT_TYPE_PLSQL_SET THEN
1464: FND_OAM_DSCRAM_PLSQLS_PKG.FETCH_PLSQL_IDS(l_unit_ids(k),
1465: l_work_queue,
1466: l_return_status,
1467: l_return_msg);
1468: ELSE