APPS.FND_OAM_DSCRAM_DIAG_PKG dependencies on FND_OAM_DSCRAM_DMLS

Line 666: FROM fnd_oam_dscram_dmls

662:
663: --query out the run's final status
664: SELECT finished_ret_sts, rows_processed
665: INTO l_status, l_rows_processed
666: FROM fnd_oam_dscram_dmls
667: WHERE dml_id = p_dml_id;
668:
669: --status check
670: IF l_status IS NULL OR l_status <> p_target_status THEN

Line 967: FROM fnd_oam_dscram_dmls

963: IF p_num_dmls >= 0 THEN
964: --now query child dmls
965: SELECT dml_id
966: BULK COLLECT INTO l_ids
967: FROM fnd_oam_dscram_dmls
968: WHERE unit_id = p_unit_id;
969:
970: l_count := 0;
971: k := l_ids.FIRST;

Line 1387: INSERT INTO FND_OAM_DSCRAM_DMLS (DML_ID,

1383: l_retval NUMBER;
1384: BEGIN
1385: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
1386:
1387: INSERT INTO FND_OAM_DSCRAM_DMLS (DML_ID,
1388: UNIT_ID,
1389: PRIORITY,
1390: WEIGHT,
1391: DML_STMT,

Line 1400: (fnd_oam_dscram_dmls_s.nextval,

1396: LAST_UPDATE_DATE,
1397: LAST_UPDATE_LOGIN
1398: )
1399: VALUES
1400: (fnd_oam_dscram_dmls_s.nextval,
1401: p_unit_id,
1402: p_priority,
1403: p_weight,
1404: p_dml_stmt,