APPS.RLM_WF_SV dependencies on RLM_INTERFACE_HEADERS

Line 23: v_Sch_rec IN OUT NOCOPY rlm_interface_headers%ROWTYPE,

19: --
20: PROCEDURE StartDSPProcess( errbuf OUT NOCOPY VARCHAR2,
21: retcode OUT NOCOPY VARCHAR2,
22: p_Header_Id IN NUMBER,
23: v_Sch_rec IN OUT NOCOPY rlm_interface_headers%ROWTYPE,
24: v_num_child IN NUMBER
25: )
26: IS
27: --

Line 1194: FROM rlm_interface_headers

1190: WHERE header_id = p_header_id;
1191:
1192: CURSOR c_process_status_interface(p_header_id IN NUMBER) is
1193: SELECT process_status
1194: FROM rlm_interface_headers
1195: WHERE header_id = p_header_id;
1196:
1197: v_process_status NUMBER;
1198:

Line 1246: FROM rlm_interface_headers

1242: -- should have been deleted from interface tables.
1243: --
1244: SELECT COUNT(*)
1245: INTO x_errors
1246: FROM rlm_interface_headers
1247: WHERE header_id = v_header_id;
1248: --
1249: IF (l_debug <> -1) THEN
1250: rlm_core_sv.dlog(C_DEBUG,' No of Errors :', x_errors);

Line 1592: from rlm_interface_headers

1588: END IF;
1589: --
1590: select schedule_reference_num, cust_name_ext, sched_generation_date
1591: into x_Schedule_Num, x_Customer_Name , x_Schedule_Gen_Date
1592: from rlm_interface_headers
1593: where header_id = x_Header_Id ;
1594: --
1595: IF (l_debug <> -1) THEN
1596: rlm_core_sv.dlog(C_DEBUG,' Schedule Generation Date :',

Line 1622: v_Sch_rec IN rlm_interface_headers%ROWTYPE,

1618: PROCEDURE StartDSPLoop( errbuf OUT NOCOPY VARCHAR2,
1619: retcode OUT NOCOPY VARCHAR2,
1620: p_Header_Id IN NUMBER,
1621: p_Line_id IN NUMBER,
1622: v_Sch_rec IN rlm_interface_headers%ROWTYPE,
1623: v_Grp_rec IN rlm_dp_sv.t_Group_rec)
1624: IS
1625: --
1626: v_ItemKey VARCHAR2(100) := to_char(p_Header_Id)||

Line 1921: FROM rlm_interface_headers

1917: rlm_core_sv.dlog(C_DEBUG,'Assigning the global variable.');
1918: END IF;
1919: --
1920: SELECT * INTO g_Sch_rec
1921: FROM rlm_interface_headers
1922: WHERE header_id = v_header_id;
1923: --
1924: END IF;
1925: rlm_dp_sv.UpdateHeaderPS(g_Sch_rec.header_id,

Line 2658: FROM rlm_interface_headers rih,

2654: ril.order_header_id,
2655: ril.blanket_number,
2656: min(ril.start_date_time),
2657: ril.ship_to_customer_id
2658: FROM rlm_interface_headers rih,
2659: rlm_interface_lines_all ril
2660: WHERE ril.header_id = v_hdr_id
2661: AND ril.org_id = rih.org_id
2662: AND ril.header_id = rih.header_id

Line 2703: FROM rlm_interface_headers

2699: END IF;
2700: --
2701: SELECT process_status
2702: INTO v_tmp_status
2703: FROM rlm_interface_headers
2704: WHERE header_id = v_Header_Id;
2705: --
2706: IF (l_debug <> -1) THEN
2707: rlm_core_sv.dlog(C_DEBUG,'process status =', v_tmp_status);

Line 3502: FROM rlm_interface_headers

3498: WHERE header_id = p_header_id;
3499:
3500: CURSOR c_process_status_interface(p_header_id IN NUMBER) is
3501: SELECT process_status
3502: FROM rlm_interface_headers
3503: WHERE header_id = p_header_id;
3504:
3505: --
3506: v_header_id NUMBER;