APPS.FND_OAM_DSCRAM_PLSQLS_PKG dependencies on FND_OAM_DSCRAM_PLSQLS

Line 1: PACKAGE BODY FND_OAM_DSCRAM_PLSQLS_PKG as

1: PACKAGE BODY FND_OAM_DSCRAM_PLSQLS_PKG as
2: /* $Header: AFOAMDSPLSB.pls 120.2 2006/06/07 18:04:33 ilawler noship $ */
3:
4: ----------------------------------------
5: -- Private Body Constants

Line 72: FROM fnd_oam_dscram_plsqls

68:
69: -- bulk select all valid plsqls with work to do
70: SELECT plsql_id, priority, weight
71: BULK COLLECT INTO l_ids, l_priorities, l_weights
72: FROM fnd_oam_dscram_plsqls
73: WHERE unit_id = p_unit_id
74: AND finished_ret_sts IS NULL
75: ORDER BY priority ASC, weight DESC;
76:

Line 357: FROM fnd_oam_dscram_plsqls

353: --perform a blocking select for update on the PLSQL, shouldn't be contention since complete_plsql is called once
354: --and shouldn't already be finished.
355: SELECT finished_ret_sts
356: INTO l_finished_ret_sts
357: FROM fnd_oam_dscram_plsqls
358: WHERE plsql_id = p_plsql_id
359: FOR UPDATE;
360:
361: --make sure it's not already finished.

Line 385: UPDATE fnd_oam_dscram_plsqls

381:
382: fnd_oam_debug.log(1, l_ctxt, 'Finished PLSQL with Status: '||l_finished_status||'('||l_finished_ret_sts||')');
383:
384: --update the plsql
385: UPDATE fnd_oam_dscram_plsqls
386: SET finished_ret_sts = l_finished_ret_sts,
387: last_updated_by = fnd_global.user_id,
388: last_update_login = fnd_global.user_id,
389: last_update_date = SYSDATE

Line 463: FROM fnd_oam_dscram_plsqls

459:
460: --assume that the check already occured in add_plsql_to_cache so proceed right to the lock
461: SELECT plsql_text, plsql_final_text
462: INTO l_plsql_text, l_final_plsql_text
463: FROM fnd_oam_dscram_plsqls
464: WHERE plsql_id = p_plsql_id
465: FOR UPDATE;
466:
467: --make sure the final text's still null

Line 489: UPDATE fnd_oam_dscram_plsqls

485: END IF;
486: l_final_plsql_text := FND_OAM_DSCRAM_UTILS_PKG.G_PLSQL_PREFIX||l_plsql_text||';'||FND_OAM_DSCRAM_UTILS_PKG.G_PLSQL_SUFFIX;
487:
488: --store this string as the final text
489: UPDATE fnd_oam_dscram_plsqls
490: SET plsql_final_text = l_final_plsql_text,
491: stats_finished = FND_API.G_FALSE,
492: last_updated_by = fnd_global.user_id,
493: last_update_login = fnd_global.user_id,

Line 555: FROM fnd_oam_dscram_plsqls

551:
552: --query out the prepared plsql text
553: SELECT plsql_final_text
554: INTO l_final_plsql_text
555: FROM fnd_oam_dscram_plsqls
556: WHERE plsql_id = p_plsql_id;
557:
558: --if it's not present, generate it
559: IF l_final_plsql_text IS NULL THEN

Line 881: END FND_OAM_DSCRAM_PLSQLS_PKG;

877: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
878: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
879: END;
880:
881: END FND_OAM_DSCRAM_PLSQLS_PKG;