APPS.FND_OAM_DSCRAM_DMLS_PKG dependencies on FND_OAM_DSCRAM_UNITS_PKG

Line 53: x_work_queue OUT NOCOPY FND_OAM_DSCRAM_UNITS_PKG.ordered_work_queue_type,

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

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

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

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

80:
81: --since we select them in the proper order, construct the work queue by doing a single pass of the array
82: k := l_ids.FIRST;
83: WHILE k IS NOT NULL LOOP
84: l_work_queue(k) := FND_OAM_DSCRAM_UNITS_PKG.CREATE_WORK_ITEM(l_priorities(k),
85: l_weights(k),
86: FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_DML,
87: l_ids(k));
88: k := l_ids.NEXT(k);