APPS.RLM_PS_SV dependencies on RLM_INTERFACE_LINES

Line 124: from rlm_interface_headers rh, rlm_interface_lines_all rl '

120: || ' and rh.process_status = :k_ps_5'
121: || ' and rh.org_id = rl.org_id';
122:
123: v_int_statement := 'select distinct rh.header_id
124: from rlm_interface_headers rh, rlm_interface_lines_all rl '
125: || v_where_clause
126: ||' and 5 = :k_ps_5'
127: ||' and rh.org_id = rl.org_id';
128:

Line 824: select count(*) into v_line_count from rlm_interface_lines

820: --check for partially selected schedule
821:
822: IF(p_ship_to_address_id_from IS NOT NULL) THEN
823:
824: select count(*) into v_line_count from rlm_interface_lines
825: where header_id = v_sched_header_id
826: AND ship_to_address_id between p_ship_to_address_id_from
827: AND nvl(p_ship_to_address_id_to, p_ship_to_address_id_from);
828:

Line 833: select count(*) into v_line_count2 from rlm_interface_lines

829: IF (l_debug <> -1) THEN
830: rlm_core_sv.dlog(C_DEBUG,'v_line_count1',v_line_count);
831: END IF;
832:
833: select count(*) into v_line_count2 from rlm_interface_lines
834: where header_id = v_sched_header_id;
835:
836: IF (l_debug <> -1) THEN
837: rlm_core_sv.dlog(C_DEBUG,'v_line_count2',v_line_count2);

Line 919: delete from rlm_interface_lines where header_id = v_sched_header_id;

915: x_conc_req_id => fnd_global.conc_request_id,
916: x_PurgeStatus => 'Y',
917: x_PurgeExp_rec=>x_purge_rec );
918: --
919: delete from rlm_interface_lines where header_id = v_sched_header_id;
920: delete from rlm_interface_headers where header_id = v_sched_header_id;
921: --
922: --delete from archive as well
923: --

Line 937: select count(*) into v_line_count from rlm_interface_lines where header_id = v_sched_header_id and item_detail_type = '3';

933: g_interface_headers_tab(g_interface_headers_tab.COUNT+1):= v_sched_header_id;
934: --
935: ELSE
936:
937: select count(*) into v_line_count from rlm_interface_lines where header_id = v_sched_header_id and item_detail_type = '3';
938:
939: IF (l_debug <> -1) THEN
940: rlm_core_sv.dlog(C_DEBUG,'v_line_count_detail',v_line_count);
941: END IF;

Line 978: delete from rlm_interface_lines where header_id = v_sched_header_id;

974: IF (l_debug <> -1) THEN
975: rlm_core_sv.dlog(C_DEBUG,'Authorization not found, deleting....',v_sched_header_id);
976: END IF;
977:
978: delete from rlm_interface_lines where header_id = v_sched_header_id;
979: delete from rlm_interface_headers where header_id = v_sched_header_id;
980:
981: --delete from archive as well
982:

Line 1024: select count(*) into v_line_count from rlm_interface_lines where header_id = v_sched_header_id and item_detail_type = '3';

1020: null;
1021:
1022: ELSE
1023:
1024: select count(*) into v_line_count from rlm_interface_lines where header_id = v_sched_header_id and item_detail_type = '3';
1025:
1026: IF (l_debug <> -1) THEN
1027: rlm_core_sv.dlog(C_DEBUG,'v_line_count_detail',v_line_count);
1028: END IF;