APPS.FND_OAM_DSCRAM_DIAG_PKG dependencies on FND_OAM_DSCRAM_PLSQLS

Line 712: FROM fnd_oam_dscram_plsqls

708:
709: --query out the run's final status
710: SELECT finished_ret_sts
711: INTO l_status
712: FROM fnd_oam_dscram_plsqls
713: WHERE plsql_id = p_plsql_id;
714:
715: --status check
716: IF l_status IS NULL OR l_status <> p_target_status THEN

Line 994: FROM fnd_oam_dscram_plsqls

990: IF p_num_plsqls >= 0 THEN
991: --now query child dmls
992: SELECT plsql_id
993: BULK COLLECT INTO l_ids
994: FROM fnd_oam_dscram_plsqls
995: WHERE unit_id = p_unit_id;
996:
997: l_count := 0;
998: k := l_ids.FIRST;

Line 1437: INSERT INTO FND_OAM_DSCRAM_PLSQLS (PLSQL_ID,

1433: l_retval NUMBER;
1434: BEGIN
1435: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
1436:
1437: INSERT INTO FND_OAM_DSCRAM_PLSQLS (PLSQL_ID,
1438: UNIT_ID,
1439: PRIORITY,
1440: WEIGHT,
1441: PLSQL_TEXT,

Line 1449: (fnd_oam_dscram_plsqls_s.nextval,

1445: LAST_UPDATE_DATE,
1446: LAST_UPDATE_LOGIN
1447: )
1448: VALUES
1449: (fnd_oam_dscram_plsqls_s.nextval,
1450: p_unit_id,
1451: p_priority,
1452: p_weight,
1453: p_plsql_text,

Line 3901: FROM fnd_oam_dscram_plsqls

3897: --check the plsql id
3898: BEGIN
3899: SELECT plsql_id
3900: INTO l_id
3901: FROM fnd_oam_dscram_plsqls
3902: WHERE unit_id = p_unit_id
3903: AND plsql_id = p_plsql_id;
3904: EXCEPTION
3905: WHEN no_data_found THEN