APPS.RLM_PS_SV dependencies on RLM_SCHEDULE_HEADERS

Line 118: from rlm_schedule_headers rh, rlm_schedule_lines_all rl '

114: --
115: -- Final Queries
116: --
117: v_arch_statement := 'select distinct rh.header_id
118: from rlm_schedule_headers rh, rlm_schedule_lines_all rl '
119: || v_where_clause
120: || ' and rh.process_status = :k_ps_5'
121: || ' and rh.org_id = rl.org_id';
122:

Line 433: FROM rlm_schedule_headers

429: x_purge_rec.SCHEDULE_TYPE,
430: x_purge_rec.SCHED_GENERATION_DATE,
431: x_purge_rec.ORIGIN_TABLE,/*2261812*/
432: v_process_status
433: FROM rlm_schedule_headers
434: WHERE header_id = v_sched_header_id;
435:
436: --check for partially selected schedule
437:

Line 513: select count(*) into v_line_count from rlm_schedule_headers where header_id = v_sched_header_id;

509: END IF;
510:
511: --delete schedules
512:
513: select count(*) into v_line_count from rlm_schedule_headers where header_id = v_sched_header_id;
514:
515: IF (l_debug <> -1) THEN
516: rlm_core_sv.dlog(C_DEBUG,'v_line_count_process',v_line_count);
517: END IF;

Line 545: delete from rlm_schedule_headers where header_id = v_sched_header_id;

541: x_PurgeExp_rec=>x_purge_rec );
542:
543:
544: delete from rlm_schedule_lines where header_id = v_sched_header_id;
545: delete from rlm_schedule_headers where header_id = v_sched_header_id;
546: g_schedule_headers_tab(g_schedule_headers_tab.COUNT+1):= v_sched_header_id;
547:
548: ELSE
549:

Line 595: delete from rlm_schedule_headers where header_id = v_sched_header_id;

591: rlm_core_sv.dlog(C_DEBUG,'Authorization not found, deleting....',v_sched_header_id);
592: END IF;
593:
594: delete from rlm_schedule_lines where header_id = v_sched_header_id;
595: delete from rlm_schedule_headers where header_id = v_sched_header_id;
596:
597:
598: --delete exceptions associated with the schedule
599:

Line 619: select count(*) into v_line_count from rlm_schedule_headers where header_id = v_sched_header_id;

615: END IF;
616:
617: --check for process status in view mode
618:
619: select count(*) into v_line_count from rlm_schedule_headers where header_id = v_sched_header_id;
620:
621: IF (l_debug <> -1) THEN
622: rlm_core_sv.dlog(C_DEBUG,'v_line_count_status',v_line_count);
623: END IF;

Line 876: from rlm_schedule_headers

872: BEGIN
873: --
874: select header_id
875: into v_sched_id
876: from rlm_schedule_headers
877: where interface_header_id = v_sched_header_id;
878: --
879: v_order_exists := CheckOpenOrder(v_sched_id,x_purge_rec);
880: --

Line 926: from rlm_schedule_headers

922: --delete from archive as well
923: --
924: delete from rlm_schedule_lines_all
925: where header_id = (select header_id
926: from rlm_schedule_headers
927: where interface_header_id = v_sched_header_id);
928: --
929: delete from rlm_schedule_headers where interface_header_id = v_sched_header_id;
930: --

Line 929: delete from rlm_schedule_headers where interface_header_id = v_sched_header_id;

925: where header_id = (select header_id
926: from rlm_schedule_headers
927: where interface_header_id = v_sched_header_id);
928: --
929: delete from rlm_schedule_headers where interface_header_id = v_sched_header_id;
930: --
931: --delete exceptions associated with the schedule
932: --
933: g_interface_headers_tab(g_interface_headers_tab.COUNT+1):= v_sched_header_id;

Line 983: delete from rlm_schedule_lines where header_id = (select header_id from rlm_schedule_headers where interface_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:
983: delete from rlm_schedule_lines where header_id = (select header_id from rlm_schedule_headers where interface_header_id = v_sched_header_id);
984:
985: delete from rlm_schedule_headers where interface_header_id = v_sched_header_id;
986:
987: --delete exceptions associated with the schedule

Line 985: delete from rlm_schedule_headers where interface_header_id = v_sched_header_id;

981: --delete from archive as well
982:
983: delete from rlm_schedule_lines where header_id = (select header_id from rlm_schedule_headers where interface_header_id = v_sched_header_id);
984:
985: delete from rlm_schedule_headers where interface_header_id = v_sched_header_id;
986:
987: --delete exceptions associated with the schedule
988: g_interface_headers_tab(g_interface_headers_tab.COUNT+1):= v_sched_header_id;
989: