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 2014: UPDATE RLM_CUST_ITEM_CUM_KEYS_ALL

2010:
2011: /* Update the CUM related quantity in
2012: RLM_CUS_ITEM_CUM_KEY_ALL table */
2013: --
2014: UPDATE RLM_CUST_ITEM_CUM_KEYS_ALL
2015: SET cum_qty = v_cum_record.cum_qty,
2016: cum_qty_to_be_accumulated = v_cum_record.cum_qty_to_be_accumulated,
2017: cum_qty_after_cutoff = v_cum_record.cum_qty_after_cutoff,
2018: --last_cum_qty_update_date = sysdate, --Bugfix 10053830

Line 7154: FROM RLM_CUST_ITEM_CUM_KEYS_ALL

7150: IS
7151: --
7152: CURSOR c IS
7153: SELECT *
7154: FROM RLM_CUST_ITEM_CUM_KEYS_ALL
7155: WHERE cum_key_id = x_CumKeyId
7156: FOR UPDATE NOWAIT;
7157: --
7158:

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

7159: BEGIN
7160: --
7161: IF (l_debug <> -1) THEN
7162: rlm_core_sv.dpush(C_SDEBUG,'LockCumKey');
7163: rlm_core_sv.dlog(C_DEBUG,'Locking RLM_CUST_ITEM_CUM_KEYS_ALL');
7164: END IF;
7165: --
7166: OPEN c;
7167: CLOSE c;

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

7176: --
7177: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
7178: --
7179: IF (l_debug <> -1) THEN
7180: rlm_core_sv.dlog(C_DEBUG,'Cum Key Record in RLM_CUST_ITEM_CUM_KEYS_ALL cannot be locked');
7181: rlm_core_sv.dpop(C_SDEBUG);
7182: END IF;
7183: --
7184: RETURN(FALSE);