APPS.FND_OAM_DSCRAM_DMLS_PKG dependencies on FND_OAM_DSCRAM_DMLS

Line 1: PACKAGE BODY FND_OAM_DSCRAM_DMLS_PKG as

1: PACKAGE BODY FND_OAM_DSCRAM_DMLS_PKG as
2: /* $Header: AFOAMDSDMLB.pls 120.6 2006/06/07 18:02:20 ilawler noship $ */
3:
4: ----------------------------------------
5: -- Private Body Constants

Line 73: FROM fnd_oam_dscram_dmls

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

Line 359: FROM fnd_oam_dscram_dmls

355:
356: --perform a blocking select for update on the DML, allows sequencing of rows_processed updates
357: SELECT finished_ret_sts
358: INTO l_finished_ret_sts
359: FROM fnd_oam_dscram_dmls
360: WHERE dml_id = p_dml_id
361: FOR UPDATE;
362:
363: --make sure it's not already finished, only the last complete_dml should do this

Line 388: UPDATE fnd_oam_dscram_dmls

384:
385: fnd_oam_debug.log(1, l_ctxt, 'Finished DML with Status: '||l_finished_status||'('||l_finished_ret_sts||')');
386:
387: --update the dml
388: UPDATE fnd_oam_dscram_dmls
389: SET finished_ret_sts = l_finished_ret_sts
390: WHERE dml_id = p_dml_id;
391:
392: --dump a stats row as well

Line 403: UPDATE fnd_oam_dscram_dmls

399: l_rows_processed := NVL(b_dml_cache(p_dml_id).rows_processed, 0);
400: END IF;
401:
402: --always update the number of rows processed
403: UPDATE fnd_oam_dscram_dmls
404: SET rows_processed = NVL(rows_processed, 0) + l_rows_processed, --needed since its different for each dml and not stored in AD
405: last_updated_by = fnd_global.user_id,
406: last_update_login = fnd_global.user_id,
407: last_update_date = SYSDATE

Line 484: FROM fnd_oam_dscram_dmls

480:
481: --assume that the check already occured in add_dml_to_cache so proceed right to the lock
482: SELECT dml_stmt, dml_where_clause, dml_final_stmt
483: INTO l_dml_stmt, l_where_clause, l_final_dml_stmt
484: FROM fnd_oam_dscram_dmls
485: WHERE dml_id = p_dml_id
486: FOR UPDATE;
487:
488: --make sure the final stmt's still null

Line 515: UPDATE fnd_oam_dscram_dmls

511: RETURN;
512: END IF;
513:
514: --store this string as the final stmt
515: UPDATE fnd_oam_dscram_dmls
516: SET dml_final_stmt = l_final_dml_stmt,
517: stats_finished = FND_API.G_FALSE,
518: last_updated_by = fnd_global.user_id,
519: last_update_login = fnd_global.user_id,

Line 581: FROM fnd_oam_dscram_dmls

577:
578: --query out the prepared DML statement
579: SELECT dml_final_stmt
580: INTO l_final_dml_stmt
581: FROM fnd_oam_dscram_dmls
582: WHERE dml_id = p_dml_id;
583:
584: --if it's not present, generate it
585: IF l_final_dml_stmt IS NULL THEN

Line 930: END FND_OAM_DSCRAM_DMLS_PKG;

926: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
927: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
928: END;
929:
930: END FND_OAM_DSCRAM_DMLS_PKG;