eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.RLM_CUM_SV dependencies on RLM_DP_SV

Line 606: nvl(rlm_dp_sv.g_dsp_start_time,sysdate), --sysdate, --Bugfix 10053830

602: p_ship_from_org_id,
603: p_cum_start_date,
604: p_cust_record_year,
605: p_purchase_order_number,
606: nvl(rlm_dp_sv.g_dsp_start_time,sysdate), --sysdate, --Bugfix 10053830
607: fnd_global.user_id,
608: sysdate,
609: fnd_global.user_id,
610: sysdate,

Line 622: x_cum_record.last_cum_qty_update_date := nvl(rlm_dp_sv.g_dsp_start_time,sysdate); --Bugfix 10053830

618: x_cum_record.cum_start_date := p_cum_start_date;
619: x_cum_record.cum_key_created_flag := TRUE;
620: x_cum_record.record_return_status := TRUE;
621: --x_cum_record.last_cum_qty_update_date := SYSDATE; --Bugfix 10053830
622: x_cum_record.last_cum_qty_update_date := nvl(rlm_dp_sv.g_dsp_start_time,sysdate); --Bugfix 10053830
623: --
624: x_cum_record.msg_name := 'RLM_CUM_KEY_ID_CREATED';
625: --
626: rlm_message_sv.get_msg_text(

Line 787: x_cum_record.actual_shipment_date := nvl(rlm_dp_sv.g_dsp_start_time,sysdate);

783: --Bugfix 10053830 Start
784: /*SELECT SYSDATE
785: INTO x_cum_record.actual_shipment_date
786: FROM DUAL;*/
787: x_cum_record.actual_shipment_date := nvl(rlm_dp_sv.g_dsp_start_time,sysdate);
788: --Bugfix 10053830 End
789: --
790: END IF;
791: --

Line 1078: SELECT TO_DATE(TO_CHAR(nvl(rlm_dp_sv.g_dsp_start_time,sysdate)-1, 'DD/MM/YYYY') --Bugfix 10053830

1074: --
1075: IF x_cum_record.as_of_date_time IS NULL THEN
1076: --
1077: --SELECT TO_DATE(TO_CHAR(SYSDATE-1, 'DD/MM/YYYY') --Bugfix 10053830
1078: SELECT TO_DATE(TO_CHAR(nvl(rlm_dp_sv.g_dsp_start_time,sysdate)-1, 'DD/MM/YYYY') --Bugfix 10053830
1079: ||
1080: DECODE(SIGN(rlm_setup_record.cum_yesterd_time_cutoff/1000-1),
1081: -1, '0'||to_char(rlm_setup_record.cum_yesterd_time_cutoff),
1082: to_char(rlm_setup_record.cum_yesterd_time_cutoff)),

Line 1094: IF (nvl(rlm_dp_sv.g_dsp_start_time,sysdate)-1) < (x_cum_record.yesterday_time_cutoff) THEN --Bugfix 10053830

1090: since CUM start date excluding the shipments since yesterday
1091: cutoff time. */
1092: --
1093: --IF (SYSDATE-1) < (x_cum_record.yesterday_time_cutoff) THEN --Bugfix 10053830
1094: IF (nvl(rlm_dp_sv.g_dsp_start_time,sysdate)-1) < (x_cum_record.yesterday_time_cutoff) THEN --Bugfix 10053830
1095: --
1096: --IF TRUNC(x_cum_record.last_cum_qty_update_date) < TRUNC(SYSDATE) THEN --Bugfix 10053830
1097: IF TRUNC(x_cum_record.last_cum_qty_update_date) < TRUNC(nvl(rlm_dp_sv.g_dsp_start_time,sysdate)) THEN --Bugfix 10053830
1098: --

Line 1097: IF TRUNC(x_cum_record.last_cum_qty_update_date) < TRUNC(nvl(rlm_dp_sv.g_dsp_start_time,sysdate)) THEN --Bugfix 10053830

1093: --IF (SYSDATE-1) < (x_cum_record.yesterday_time_cutoff) THEN --Bugfix 10053830
1094: IF (nvl(rlm_dp_sv.g_dsp_start_time,sysdate)-1) < (x_cum_record.yesterday_time_cutoff) THEN --Bugfix 10053830
1095: --
1096: --IF TRUNC(x_cum_record.last_cum_qty_update_date) < TRUNC(SYSDATE) THEN --Bugfix 10053830
1097: IF TRUNC(x_cum_record.last_cum_qty_update_date) < TRUNC(nvl(rlm_dp_sv.g_dsp_start_time,sysdate)) THEN --Bugfix 10053830
1098: --
1099: x_cum_record.cum_qty := NVL(x_cum_record.cum_qty,0) + NVL(x_cum_record.cum_qty_to_be_accumulated,0);
1100: x_cum_record.cum_qty_to_be_accumulated := NVL(x_cum_record.shipped_quantity,0) + NVL(x_cum_record.cum_qty_after_cutoff,0);
1101: x_cum_record.cum_qty_after_cutoff := 0;

Line 1112: IF TRUNC(x_cum_record.last_cum_qty_update_date) < TRUNC(nvl(rlm_dp_sv.g_dsp_start_time,sysdate)) THEN --Bugfix 10053830

1108: --
1109: ELSE
1110: --
1111: --IF TRUNC(x_cum_record.last_cum_qty_update_date) < TRUNC(SYSDATE) THEN --Bugfix 10053830
1112: IF TRUNC(x_cum_record.last_cum_qty_update_date) < TRUNC(nvl(rlm_dp_sv.g_dsp_start_time,sysdate)) THEN --Bugfix 10053830
1113: --
1114: x_cum_record.cum_qty := NVL(x_cum_record.cum_qty,0) + NVL(x_cum_record.cum_qty_to_be_accumulated,0);
1115: x_cum_record.cum_qty_to_be_accumulated := NVL(x_cum_record.cum_qty_after_cutoff,0);
1116: x_cum_record.cum_qty_after_cutoff := 0;

Line 1132: IF TRUNC(x_cum_record.actual_shipment_date) < TRUNC(nvl(rlm_dp_sv.g_dsp_start_time,sysdate)) THEN --Bugfix 10053830

1128: x_cum_record.cum_qty := NVL(x_cum_record.cum_qty,0) + NVL(x_cum_record.shipped_quantity,0);
1129: ELSE
1130: --
1131: --IF TRUNC(x_cum_record.actual_shipment_date) < TRUNC(SYSDATE) THEN --Bugfix 10053830
1132: IF TRUNC(x_cum_record.actual_shipment_date) < TRUNC(nvl(rlm_dp_sv.g_dsp_start_time,sysdate)) THEN --Bugfix 10053830
1133: --
1134: x_cum_record.cum_qty_to_be_accumulated := NVL(x_cum_record.cum_qty_to_be_accumulated,0) + NVL(x_cum_record.shipped_quantity,0);
1135: --
1136: ELSE

Line 2019: last_cum_qty_update_date = nvl(rlm_dp_sv.g_dsp_start_time,sysdate), --Bugfix 10053830

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
2019: last_cum_qty_update_date = nvl(rlm_dp_sv.g_dsp_start_time,sysdate), --Bugfix 10053830
2020: last_update_login = fnd_global.login_id,
2021: last_update_date = sysdate,
2022: last_updated_by = fnd_global.user_id
2023: WHERE cum_key_id = v_cum_record.cum_key_id;

Line 6570: AND (cum_start_date < nvl(rlm_dp_sv.g_dsp_start_time,sysdate) --Bugfix 10053830

6566: AND NVL(bill_to_address_id,0)= NVL(p_bill_to_address_id,0)
6567: AND NVL(customer_item_id,0) = NVL(p_customer_item_id,0)
6568: AND cum_start_date IS NOT NULL
6569: --AND (cum_start_date < SYSDATE --Bugfix 10053830
6570: AND (cum_start_date < nvl(rlm_dp_sv.g_dsp_start_time,sysdate) --Bugfix 10053830
6571: OR x_called_from_vd = rlm_cum_sv.k_CalledByVD
6572: )
6573: AND purchase_order_number IS NULL
6574: AND cust_record_year IS NULL

Line 6602: AND (cum_start_date < nvl(rlm_dp_sv.g_dsp_start_time,sysdate) --Bugfix 10053830

6598: AND NVL(bill_to_address_id,0) = NVL(p_bill_to_address_id,0)
6599: AND NVL(customer_item_id,0)= NVL(p_customer_item_id,0)
6600: AND cum_start_date IS NOT NULL
6601: --AND (cum_start_date < SYSDATE --Bugfix 10053830
6602: AND (cum_start_date < nvl(rlm_dp_sv.g_dsp_start_time,sysdate) --Bugfix 10053830
6603: OR x_called_from_vd = rlm_cum_sv.k_CalledByVD
6604: )
6605: AND purchase_order_number IS NULL
6606: AND cust_record_year IS NULL

Line 6634: AND (cum_start_date < nvl(rlm_dp_sv.g_dsp_start_time,sysdate) --Bugfix 10053830

6630: AND NVL(bill_to_address_id,0)= NVL(p_bill_to_address_id,0)
6631: AND NVL(customer_item_id,0)= NVL(p_customer_item_id,0)
6632: AND cum_start_date IS NOT NULL
6633: --AND (cum_start_date < SYSDATE --Bugfix 10053830
6634: AND (cum_start_date < nvl(rlm_dp_sv.g_dsp_start_time,sysdate) --Bugfix 10053830
6635: OR x_called_from_vd = rlm_cum_sv.k_CalledByVD
6636: )
6637: AND purchase_order_number IS NULL
6638: AND cust_record_year IS NOT NULL

Line 6669: AND (cum_start_date < nvl(rlm_dp_sv.g_dsp_start_time,sysdate) --Bugfix 10053830

6665: AND NVL(bill_to_address_id,0) = NVL(p_bill_to_address_id,0)
6666: AND NVL(customer_item_id,0) = NVL(p_customer_item_id,0)
6667: AND cum_start_date IS NOT NULL
6668: --AND (cum_start_date < SYSDATE --Bugfix 10053830
6669: AND (cum_start_date < nvl(rlm_dp_sv.g_dsp_start_time,sysdate) --Bugfix 10053830
6670: OR x_called_from_vd = rlm_cum_sv.k_CalledByVD
6671: )
6672: AND purchase_order_number IS NULL
6673: AND cust_record_year IS NOT NULL

Line 6704: AND (cum_start_date < nvl(rlm_dp_sv.g_dsp_start_time,sysdate) --Bugfix 10053830

6700: AND NVL(bill_to_address_id,0)= NVL(p_bill_to_address_id,0)
6701: AND NVL(customer_item_id,0) = NVL(p_customer_item_id,0)
6702: AND cum_start_date IS NOT NULL
6703: --AND (cum_start_date < SYSDATE --Bugfix 10053830
6704: AND (cum_start_date < nvl(rlm_dp_sv.g_dsp_start_time,sysdate) --Bugfix 10053830
6705: OR x_called_from_vd = rlm_cum_sv.k_CalledByVD
6706: )
6707: AND purchase_order_number IS NOT NULL
6708: AND (purchase_order_number = p_purchase_order_number

Line 6739: AND (cum_start_date < nvl(rlm_dp_sv.g_dsp_start_time,sysdate) --Bugfix 10053830

6735: AND NVL(bill_to_address_id,0) = NVL(p_bill_to_address_id,0)
6736: AND NVL(customer_item_id,0)= NVL(p_customer_item_id,0)
6737: AND cum_start_date IS NOT NULL
6738: --AND (cum_start_date < SYSDATE --Bugfix 10053830
6739: AND (cum_start_date < nvl(rlm_dp_sv.g_dsp_start_time,sysdate) --Bugfix 10053830
6740: OR x_called_from_vd = rlm_cum_sv.k_CalledByVD
6741: )
6742:
6743: AND purchase_order_number IS NOT NULL