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 1183: FROM rlm_interface_headers

1179: WHERE header_id = p_header_id;
1180:
1181: CURSOR c_process_status_interface(p_header_id IN NUMBER) is
1182: SELECT process_status
1183: FROM rlm_interface_headers
1184: WHERE header_id = p_header_id;
1185:
1186: v_process_status NUMBER;
1187:

Line 1235: FROM rlm_interface_headers

1231: -- should have been deleted from interface tables.
1232: --
1233: SELECT COUNT(*)
1234: INTO x_errors
1235: FROM rlm_interface_headers
1236: WHERE header_id = v_header_id;
1237: --
1238: IF (l_debug <> -1) THEN
1239: rlm_core_sv.dlog(C_DEBUG,' No of Errors :', x_errors);

Line 1581: from rlm_interface_headers

1577: END IF;
1578: --
1579: select schedule_reference_num, cust_name_ext, sched_generation_date
1580: into x_Schedule_Num, x_Customer_Name , x_Schedule_Gen_Date
1581: from rlm_interface_headers
1582: where header_id = x_Header_Id ;
1583: --
1584: IF (l_debug <> -1) THEN
1585: rlm_core_sv.dlog(C_DEBUG,' Schedule Generation Date :',

Line 1611: v_Sch_rec IN rlm_interface_headers%ROWTYPE,

1607: PROCEDURE StartDSPLoop( errbuf OUT NOCOPY VARCHAR2,
1608: retcode OUT NOCOPY VARCHAR2,
1609: p_Header_Id IN NUMBER,
1610: p_Line_id IN NUMBER,
1611: v_Sch_rec IN rlm_interface_headers%ROWTYPE,
1612: v_Grp_rec IN rlm_dp_sv.t_Group_rec)
1613: IS
1614: --
1615: v_ItemKey VARCHAR2(100) := to_char(p_Header_Id)||

Line 1910: FROM rlm_interface_headers

1906: rlm_core_sv.dlog(C_DEBUG,'Assigning the global variable.');
1907: END IF;
1908: --
1909: SELECT * INTO g_Sch_rec
1910: FROM rlm_interface_headers
1911: WHERE header_id = v_header_id;
1912: --
1913: END IF;
1914: rlm_dp_sv.UpdateHeaderPS(g_Sch_rec.header_id,

Line 2636: FROM rlm_interface_headers rih,

2632: ril.order_header_id,
2633: ril.blanket_number,
2634: min(ril.start_date_time),
2635: ril.ship_to_customer_id
2636: FROM rlm_interface_headers rih,
2637: rlm_interface_lines_all ril
2638: WHERE ril.header_id = v_hdr_id
2639: AND ril.org_id = rih.org_id
2640: AND ril.header_id = rih.header_id

Line 2681: FROM rlm_interface_headers

2677: END IF;
2678: --
2679: SELECT process_status
2680: INTO v_tmp_status
2681: FROM rlm_interface_headers
2682: WHERE header_id = v_Header_Id;
2683: --
2684: IF (l_debug <> -1) THEN
2685: rlm_core_sv.dlog(C_DEBUG,'process status =', v_tmp_status);

Line 3480: FROM rlm_interface_headers

3476: WHERE header_id = p_header_id;
3477:
3478: CURSOR c_process_status_interface(p_header_id IN NUMBER) is
3479: SELECT process_status
3480: FROM rlm_interface_headers
3481: WHERE header_id = p_header_id;
3482:
3483: --
3484: v_header_id NUMBER;