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.WSH_RLM_INTERFACE dependencies on RLM_CORE_SV

Line 7: g_col_tab RLM_CORE_SV.t_dynamic_tab;

3:
4: --
5: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_RLM_INTERFACE';
6:
7: g_col_tab RLM_CORE_SV.t_dynamic_tab;
8:
9: PROCEDURE BuildQuery(
10: p_customer_id IN NUMBER,
11: p_ship_to_location_id IN NUMBER,

Line 20: p_match_within_rule IN RLM_CORE_SV.t_match_rec,

16: p_order_header_id IN NUMBER,
17: p_blanket_number IN NUMBER,
18: p_org_id IN NUMBER,
19: p_schedule_type IN VARCHAR2,
20: p_match_within_rule IN RLM_CORE_SV.t_match_rec,
21: p_match_across_rule IN RLM_CORE_SV.t_match_rec,
22: p_optional_match_rec IN t_optional_match_rec,
23: x_c_transit_detail OUT NOCOPY VARCHAR2)
24: IS

Line 21: p_match_across_rule IN RLM_CORE_SV.t_match_rec,

17: p_blanket_number IN NUMBER,
18: p_org_id IN NUMBER,
19: p_schedule_type IN VARCHAR2,
20: p_match_within_rule IN RLM_CORE_SV.t_match_rec,
21: p_match_across_rule IN RLM_CORE_SV.t_match_rec,
22: p_optional_match_rec IN t_optional_match_rec,
23: x_c_transit_detail OUT NOCOPY VARCHAR2)
24: IS
25: v_select_clause VARCHAR2(32000);

Line 31: rlm_core_sv.dlog('Entering WSH_RLM_INTERFACE.BuildQuery');

27: v_request_date_str VARCHAR2(30);
28: v_schedule_date_str VARCHAR2(30);
29: BEGIN
30: --
31: rlm_core_sv.dlog('Entering WSH_RLM_INTERFACE.BuildQuery');
32: --
33: -- Starting where-clause
34:
35: v_where_clause :=

Line 944: rlm_core_sv.dlog('g_col_tab.count', g_col_tab.COUNT);

940: END IF;
941: --
942: x_c_transit_detail := v_select_clause || v_where_clause;
943: --
944: rlm_core_sv.dlog('g_col_tab.count', g_col_tab.COUNT);
945: rlm_core_sv.dlog('x_c_transit_detail', substr(x_c_transit_detail,1,800));
946: rlm_core_sv.dlog('x_c_transit_detail Contd.', substr(x_c_transit_detail,801,1600));
947: rlm_core_sv.dlog('x_c_transit_detail Contd.', substr(x_c_transit_detail,1601,2400));
948: rlm_core_sv.dlog('x_c_transit_detail Contd.', substr(x_c_transit_detail,2401,3200));

Line 945: rlm_core_sv.dlog('x_c_transit_detail', substr(x_c_transit_detail,1,800));

941: --
942: x_c_transit_detail := v_select_clause || v_where_clause;
943: --
944: rlm_core_sv.dlog('g_col_tab.count', g_col_tab.COUNT);
945: rlm_core_sv.dlog('x_c_transit_detail', substr(x_c_transit_detail,1,800));
946: rlm_core_sv.dlog('x_c_transit_detail Contd.', substr(x_c_transit_detail,801,1600));
947: rlm_core_sv.dlog('x_c_transit_detail Contd.', substr(x_c_transit_detail,1601,2400));
948: rlm_core_sv.dlog('x_c_transit_detail Contd.', substr(x_c_transit_detail,2401,3200));
949: rlm_core_sv.dlog('x_c_transit_detail Contd.', substr(x_c_transit_detail,3201,4000));

Line 946: rlm_core_sv.dlog('x_c_transit_detail Contd.', substr(x_c_transit_detail,801,1600));

942: x_c_transit_detail := v_select_clause || v_where_clause;
943: --
944: rlm_core_sv.dlog('g_col_tab.count', g_col_tab.COUNT);
945: rlm_core_sv.dlog('x_c_transit_detail', substr(x_c_transit_detail,1,800));
946: rlm_core_sv.dlog('x_c_transit_detail Contd.', substr(x_c_transit_detail,801,1600));
947: rlm_core_sv.dlog('x_c_transit_detail Contd.', substr(x_c_transit_detail,1601,2400));
948: rlm_core_sv.dlog('x_c_transit_detail Contd.', substr(x_c_transit_detail,2401,3200));
949: rlm_core_sv.dlog('x_c_transit_detail Contd.', substr(x_c_transit_detail,3201,4000));
950: rlm_core_sv.dlog('Exiting WSH_RLM_INTERFACE.BuildQuery');

Line 947: rlm_core_sv.dlog('x_c_transit_detail Contd.', substr(x_c_transit_detail,1601,2400));

943: --
944: rlm_core_sv.dlog('g_col_tab.count', g_col_tab.COUNT);
945: rlm_core_sv.dlog('x_c_transit_detail', substr(x_c_transit_detail,1,800));
946: rlm_core_sv.dlog('x_c_transit_detail Contd.', substr(x_c_transit_detail,801,1600));
947: rlm_core_sv.dlog('x_c_transit_detail Contd.', substr(x_c_transit_detail,1601,2400));
948: rlm_core_sv.dlog('x_c_transit_detail Contd.', substr(x_c_transit_detail,2401,3200));
949: rlm_core_sv.dlog('x_c_transit_detail Contd.', substr(x_c_transit_detail,3201,4000));
950: rlm_core_sv.dlog('Exiting WSH_RLM_INTERFACE.BuildQuery');
951: --

Line 948: rlm_core_sv.dlog('x_c_transit_detail Contd.', substr(x_c_transit_detail,2401,3200));

944: rlm_core_sv.dlog('g_col_tab.count', g_col_tab.COUNT);
945: rlm_core_sv.dlog('x_c_transit_detail', substr(x_c_transit_detail,1,800));
946: rlm_core_sv.dlog('x_c_transit_detail Contd.', substr(x_c_transit_detail,801,1600));
947: rlm_core_sv.dlog('x_c_transit_detail Contd.', substr(x_c_transit_detail,1601,2400));
948: rlm_core_sv.dlog('x_c_transit_detail Contd.', substr(x_c_transit_detail,2401,3200));
949: rlm_core_sv.dlog('x_c_transit_detail Contd.', substr(x_c_transit_detail,3201,4000));
950: rlm_core_sv.dlog('Exiting WSH_RLM_INTERFACE.BuildQuery');
951: --
952: EXCEPTION

Line 949: rlm_core_sv.dlog('x_c_transit_detail Contd.', substr(x_c_transit_detail,3201,4000));

945: rlm_core_sv.dlog('x_c_transit_detail', substr(x_c_transit_detail,1,800));
946: rlm_core_sv.dlog('x_c_transit_detail Contd.', substr(x_c_transit_detail,801,1600));
947: rlm_core_sv.dlog('x_c_transit_detail Contd.', substr(x_c_transit_detail,1601,2400));
948: rlm_core_sv.dlog('x_c_transit_detail Contd.', substr(x_c_transit_detail,2401,3200));
949: rlm_core_sv.dlog('x_c_transit_detail Contd.', substr(x_c_transit_detail,3201,4000));
950: rlm_core_sv.dlog('Exiting WSH_RLM_INTERFACE.BuildQuery');
951: --
952: EXCEPTION
953: --

Line 950: rlm_core_sv.dlog('Exiting WSH_RLM_INTERFACE.BuildQuery');

946: rlm_core_sv.dlog('x_c_transit_detail Contd.', substr(x_c_transit_detail,801,1600));
947: rlm_core_sv.dlog('x_c_transit_detail Contd.', substr(x_c_transit_detail,1601,2400));
948: rlm_core_sv.dlog('x_c_transit_detail Contd.', substr(x_c_transit_detail,2401,3200));
949: rlm_core_sv.dlog('x_c_transit_detail Contd.', substr(x_c_transit_detail,3201,4000));
950: rlm_core_sv.dlog('Exiting WSH_RLM_INTERFACE.BuildQuery');
951: --
952: EXCEPTION
953: --
954: WHEN OTHERS THEN

Line 955: rlm_core_sv.dlog('When others exception');

951: --
952: EXCEPTION
953: --
954: WHEN OTHERS THEN
955: rlm_core_sv.dlog('When others exception');
956: RAISE;
957:
958: END BuildQuery;
959:

Line 974: p_match_within_rule IN RLM_CORE_SV.t_match_rec,

970: p_org_id IN NUMBER DEFAULT NULL,
971: p_schedule_type IN VARCHAR2,
972: p_shipper_recs IN t_shipper_rec,
973: p_shipment_date IN DATE,
974: p_match_within_rule IN RLM_CORE_SV.t_match_rec,
975: p_match_across_rule IN RLM_CORE_SV.t_match_rec,
976: p_optional_match_rec IN t_optional_match_rec,
977: x_in_transit_qty OUT NOCOPY NUMBER,
978: x_return_status OUT NOCOPY VARCHAR2)

Line 975: p_match_across_rule IN RLM_CORE_SV.t_match_rec,

971: p_schedule_type IN VARCHAR2,
972: p_shipper_recs IN t_shipper_rec,
973: p_shipment_date IN DATE,
974: p_match_within_rule IN RLM_CORE_SV.t_match_rec,
975: p_match_across_rule IN RLM_CORE_SV.t_match_rec,
976: p_optional_match_rec IN t_optional_match_rec,
977: x_in_transit_qty OUT NOCOPY NUMBER,
978: x_return_status OUT NOCOPY VARCHAR2)
979:

Line 1060: rlm_core_sv.dlog('Entering WSH_RLM_INTERFACE.Get_In_Transit_Qty');

1056: WSH_DEBUG_SV.log(l_module_name,'P_OPTIONAL_MATCH_REC.CUST_MODEL_SERIAL_NUMBER',P_OPTIONAL_MATCH_REC.CUST_MODEL_SERIAL_NUMBER);
1057: WSH_DEBUG_SV.log(l_module_name,'P_OPTIONAL_MATCH_REC.CUST_PRODUCTION_SEQ_NUM',P_OPTIONAL_MATCH_REC.CUST_PRODUCTION_SEQ_NUM);
1058: END IF;
1059: --
1060: rlm_core_sv.dlog('Entering WSH_RLM_INTERFACE.Get_In_Transit_Qty');
1061: rlm_core_sv.dlog('Blanket Number = ' || p_blanket_number);
1062: --
1063: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1064: l_total_qty_in_transit := 0;

Line 1061: rlm_core_sv.dlog('Blanket Number = ' || p_blanket_number);

1057: WSH_DEBUG_SV.log(l_module_name,'P_OPTIONAL_MATCH_REC.CUST_PRODUCTION_SEQ_NUM',P_OPTIONAL_MATCH_REC.CUST_PRODUCTION_SEQ_NUM);
1058: END IF;
1059: --
1060: rlm_core_sv.dlog('Entering WSH_RLM_INTERFACE.Get_In_Transit_Qty');
1061: rlm_core_sv.dlog('Blanket Number = ' || p_blanket_number);
1062: --
1063: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1064: l_total_qty_in_transit := 0;
1065: --

Line 1071: rlm_core_sv.dlog('Intransit Calculation for ATP Item');

1067: -- global_atp
1068: l_ship_from_location_id := NULL;
1069: l_location_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1070: --
1071: rlm_core_sv.dlog('Intransit Calculation for ATP Item');
1072: ELSE
1073: --
1074: IF l_debug_on THEN
1075: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_LOCATION_ID',WSH_DEBUG_SV.C_PROC_LEVEL);

Line 1128: rlm_core_sv.dlog('Shipper ID1 = ' || p_shipper_Recs.shipper_id1);

1124: END IF;
1125:
1126: IF (p_shipper_Recs.shipper_id1 is not null) THEN
1127: --
1128: rlm_core_sv.dlog('Shipper ID1 = ' || p_shipper_Recs.shipper_id1);
1129: OPEN c_get_actual_departure_date(p_shipper_Recs.shipper_id1);
1130: FETCH c_get_actual_departure_date INTO l_departure_date;
1131: CLOSE c_get_actual_departure_date;
1132: IF l_departure_date IS NOT NULL THEN

Line 1140: rlm_core_sv.dlog('Shipper ID2 = '|| p_shipper_Recs.shipper_id2);

1136: END IF;
1137:
1138: IF (p_shipper_Recs.shipper_id2 is not null) THEN
1139: --
1140: rlm_core_sv.dlog('Shipper ID2 = '|| p_shipper_Recs.shipper_id2);
1141: l_departure_date := NULL;
1142: OPEN c_get_actual_departure_date(p_shipper_Recs.shipper_id2);
1143: FETCH c_get_actual_departure_date INTO l_departure_date;
1144: CLOSE c_get_actual_departure_date;

Line 1155: rlm_core_sv.dlog('Shipper ID3 = '|| p_shipper_Recs.shipper_id3);

1151: END IF;
1152:
1153: IF (p_shipper_Recs.shipper_id3 is not null) THEN
1154: --
1155: rlm_core_sv.dlog('Shipper ID3 = '|| p_shipper_Recs.shipper_id3);
1156: l_departure_date := NULL;
1157: OPEN c_get_actual_departure_date(p_shipper_Recs.shipper_id3);
1158: FETCH c_get_actual_departure_date INTO l_departure_date;
1159: CLOSE c_get_actual_departure_date;

Line 1169: rlm_core_sv.dlog('Shipper ID4 = '|| p_shipper_Recs.shipper_id4);

1165: END IF;
1166:
1167: IF (p_shipper_Recs.shipper_id4 is not null) THEN
1168: --
1169: rlm_core_sv.dlog('Shipper ID4 = '|| p_shipper_Recs.shipper_id4);
1170: l_departure_date := NULL;
1171: OPEN c_get_actual_departure_date(p_shipper_Recs.shipper_id4);
1172: FETCH c_get_actual_departure_date INTO l_departure_date;
1173: CLOSE c_get_actual_departure_date;

Line 1183: rlm_core_sv.dlog('Shipper ID5 = '|| p_shipper_Recs.shipper_id5);

1179: END IF;
1180:
1181: IF (p_shipper_Recs.shipper_id5 is not null) THEN
1182: --
1183: rlm_core_sv.dlog('Shipper ID5 = '|| p_shipper_Recs.shipper_id5);
1184: l_departure_date := NULL;
1185: OPEN c_get_actual_departure_date(p_shipper_Recs.shipper_id5);
1186: FETCH c_get_actual_departure_date INTO l_departure_date;
1187: CLOSE c_get_actual_departure_date;

Line 1200: rlm_core_sv.dlog('Latest Departure date ' ||

1196: IF (l_latest_departure_date IS NULL) AND (p_shipment_date IS NOT NULL) THEN
1197: l_latest_departure_date := p_shipment_date;
1198: END IF;
1199: --
1200: rlm_core_sv.dlog('Latest Departure date ' ||
1201: to_char(l_latest_departure_date, 'MM/DD/YYYY HH24:MI:SS'));
1202: --
1203: IF (l_latest_departure_date IS NOT NULL ) THEN
1204: --

Line 1205: rlm_core_sv.dlog('Get intransits for this Order : ' || p_order_header_id);

1201: to_char(l_latest_departure_date, 'MM/DD/YYYY HH24:MI:SS'));
1202: --
1203: IF (l_latest_departure_date IS NOT NULL ) THEN
1204: --
1205: rlm_core_sv.dlog('Get intransits for this Order : ' || p_order_header_id);
1206: --
1207: g_col_tab.DELETE; /* Bug 2946919 */
1208: --
1209: BuildQuery(p_customer_id,

Line 1224: RLM_CORE_SV.OpenDynamicCursor(c_transit_detail,x_c_transit_detail,g_col_tab);

1220: p_match_across_rule,
1221: p_optional_match_rec,
1222: x_c_transit_detail);
1223: --
1224: RLM_CORE_SV.OpenDynamicCursor(c_transit_detail,x_c_transit_detail,g_col_tab);
1225: --
1226: FETCH c_transit_detail INTO l_transit_detail;
1227: --
1228: WHILE c_transit_detail%FOUND LOOP

Line 1230: rlm_core_sv.dlog('Delivery name ' || l_transit_detail.name);

1226: FETCH c_transit_detail INTO l_transit_detail;
1227: --
1228: WHILE c_transit_detail%FOUND LOOP
1229: --
1230: rlm_core_sv.dlog('Delivery name ' || l_transit_detail.name);
1231: rlm_core_sv.dlog('Actual dep date ' ||
1232: to_char(l_transit_detail.actual_departure_date, 'MM/DD/YYYY HH24:MI:SS'));
1233: rlm_core_sv.dlog('Quantity shipped ' || l_transit_detail.shipped_quantity);
1234: --

Line 1231: rlm_core_sv.dlog('Actual dep date ' ||

1227: --
1228: WHILE c_transit_detail%FOUND LOOP
1229: --
1230: rlm_core_sv.dlog('Delivery name ' || l_transit_detail.name);
1231: rlm_core_sv.dlog('Actual dep date ' ||
1232: to_char(l_transit_detail.actual_departure_date, 'MM/DD/YYYY HH24:MI:SS'));
1233: rlm_core_sv.dlog('Quantity shipped ' || l_transit_detail.shipped_quantity);
1234: --
1235: IF l_transit_detail.actual_departure_date > l_latest_departure_date THEN

Line 1233: rlm_core_sv.dlog('Quantity shipped ' || l_transit_detail.shipped_quantity);

1229: --
1230: rlm_core_sv.dlog('Delivery name ' || l_transit_detail.name);
1231: rlm_core_sv.dlog('Actual dep date ' ||
1232: to_char(l_transit_detail.actual_departure_date, 'MM/DD/YYYY HH24:MI:SS'));
1233: rlm_core_sv.dlog('Quantity shipped ' || l_transit_detail.shipped_quantity);
1234: --
1235: IF l_transit_detail.actual_departure_date > l_latest_departure_date THEN
1236: --
1237: l_total_qty_in_transit := l_total_qty_in_transit + l_transit_detail.shipped_quantity;

Line 1261: rlm_core_sv.dlog('intransit qty = '|| x_in_transit_qty);

1257: x_in_transit_qty := 0;
1258: --
1259: END IF; /* source code = 'OE' */
1260: --
1261: rlm_core_sv.dlog('intransit qty = '|| x_in_transit_qty);
1262: rlm_core_sv.dlog('Exiting WSH_RLM_INTERFACE.get_in_transit_qty');
1263: --
1264: IF l_debug_on THEN
1265: WSH_DEBUG_SV.log(l_module_name,'X_INTRANSIT_QTY',x_in_transit_qty);

Line 1262: rlm_core_sv.dlog('Exiting WSH_RLM_INTERFACE.get_in_transit_qty');

1258: --
1259: END IF; /* source code = 'OE' */
1260: --
1261: rlm_core_sv.dlog('intransit qty = '|| x_in_transit_qty);
1262: rlm_core_sv.dlog('Exiting WSH_RLM_INTERFACE.get_in_transit_qty');
1263: --
1264: IF l_debug_on THEN
1265: WSH_DEBUG_SV.log(l_module_name,'X_INTRANSIT_QTY',x_in_transit_qty);
1266: WSH_DEBUG_SV.pop(l_module_name);