APPS.RLM_CUM_SV dependencies on RLM_CUST_ITEM_CUM_KEYS_ALL

Line 573: INSERT INTO rlm_cust_item_cum_keys_all(

569: x_cum_record.cum_qty := 0;
570: x_cum_record.cum_qty_to_be_accumulated := 0;
571: x_cum_record.cum_qty_after_cutoff := 0;
572: --
573: INSERT INTO rlm_cust_item_cum_keys_all(
574: cum_key_id,
575: cum_qty,
576: cum_qty_to_be_accumulated,
577: cum_qty_after_cutoff,

Line 2005: UPDATE RLM_CUST_ITEM_CUM_KEYS_ALL

2001:
2002: /* Update the CUM related quantity in
2003: RLM_CUS_ITEM_CUM_KEY_ALL table */
2004: --
2005: UPDATE RLM_CUST_ITEM_CUM_KEYS_ALL
2006: SET cum_qty = v_cum_record.cum_qty,
2007: cum_qty_to_be_accumulated = v_cum_record.cum_qty_to_be_accumulated,
2008: cum_qty_after_cutoff = v_cum_record.cum_qty_after_cutoff,
2009: last_cum_qty_update_date = sysdate,

Line 7138: FROM RLM_CUST_ITEM_CUM_KEYS_ALL

7134: IS
7135: --
7136: CURSOR c IS
7137: SELECT *
7138: FROM RLM_CUST_ITEM_CUM_KEYS_ALL
7139: WHERE cum_key_id = x_CumKeyId
7140: FOR UPDATE NOWAIT;
7141: --
7142:

Line 7147: rlm_core_sv.dlog(C_DEBUG,'Locking RLM_CUST_ITEM_CUM_KEYS_ALL');

7143: BEGIN
7144: --
7145: IF (l_debug <> -1) THEN
7146: rlm_core_sv.dpush(C_SDEBUG,'LockCumKey');
7147: rlm_core_sv.dlog(C_DEBUG,'Locking RLM_CUST_ITEM_CUM_KEYS_ALL');
7148: END IF;
7149: --
7150: OPEN c;
7151: CLOSE c;

Line 7164: rlm_core_sv.dlog(C_DEBUG,'Cum Key Record in RLM_CUST_ITEM_CUM_KEYS_ALL cannot be locked');

7160: --
7161: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
7162: --
7163: IF (l_debug <> -1) THEN
7164: rlm_core_sv.dlog(C_DEBUG,'Cum Key Record in RLM_CUST_ITEM_CUM_KEYS_ALL cannot be locked');
7165: rlm_core_sv.dpop(C_SDEBUG);
7166: END IF;
7167: --
7168: RETURN(FALSE);