APPS.FND_OAM_DSCRAM_PLSQLS_PKG dependencies on FND_OAM_DSCRAM_UNITS_PKG

Line 52: x_work_queue OUT NOCOPY FND_OAM_DSCRAM_UNITS_PKG.ordered_work_queue_type,

48: END;
49:
50: -- Public
51: PROCEDURE FETCH_PLSQL_IDS(p_unit_id IN NUMBER,
52: x_work_queue OUT NOCOPY FND_OAM_DSCRAM_UNITS_PKG.ordered_work_queue_type,
53: x_return_status OUT NOCOPY VARCHAR2,
54: x_return_msg OUT NOCOPY VARCHAR2)
55: IS
56: l_ctxt VARCHAR2(60) := PKG_NAME||'FETCH_PLSQL_IDS';

Line 62: l_work_queue FND_OAM_DSCRAM_UNITS_PKG.ordered_work_queue_type := FND_OAM_DSCRAM_UNITS_PKG.ordered_work_queue_type();

58: l_ids DBMS_SQL.NUMBER_TABLE;
59: l_priorities DBMS_SQL.NUMBER_TABLE;
60: l_weights DBMS_SQL.NUMBER_TABLE;
61:
62: l_work_queue FND_OAM_DSCRAM_UNITS_PKG.ordered_work_queue_type := FND_OAM_DSCRAM_UNITS_PKG.ordered_work_queue_type();
63: k NUMBER;
64: BEGIN
65: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
66: x_return_status := FND_API.G_RET_STS_ERROR;

Line 83: l_work_queue(k) := FND_OAM_DSCRAM_UNITS_PKG.CREATE_WORK_ITEM(l_priorities(k),

79:
80: --since we select them in the proper order, construct the work queue by traversing the arrays
81: k := l_ids.FIRST;
82: WHILE k IS NOT NULL LOOP
83: l_work_queue(k) := FND_OAM_DSCRAM_UNITS_PKG.CREATE_WORK_ITEM(l_priorities(k),
84: l_weights(k),
85: FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_PLSQL,
86: l_ids(k));
87: k := l_ids.NEXT(k);