[Home] [Help]
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:
436: --check for partially selected schedule
437:
438: IF(p_ship_to_address_id_from IS NOT NULL) THEN
439:
440: select count(*) into v_line_count from rlm_schedule_lines
441: where header_id = v_sched_header_id
442: AND ship_to_address_id between p_ship_to_address_id_from
443: AND nvl(p_ship_to_address_id_to, p_ship_to_address_id_from);
444:
445: IF (l_debug <> -1) THEN
446: rlm_core_sv.dlog(C_DEBUG,'v_line_count1',v_line_count);
447: END IF;
448:
449: select count(*) into v_line_count2 from rlm_schedule_lines
450: where header_id = v_sched_header_id;
451:
452: IF (l_debug <> -1) THEN
453: rlm_core_sv.dlog(C_DEBUG,'v_line_count2',v_line_count2);
540: x_PurgeStatus => 'Y',
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
547:
548: ELSE
549:
550:
551: select count(*) into v_line_count from rlm_schedule_lines where header_id = v_sched_header_id and item_detail_type = '3';
552:
553: IF (l_debug <> -1) THEN
554: rlm_core_sv.dlog(C_DEBUG,'v_line_count_detail',v_line_count);
555: END IF;
590: IF (l_debug <> -1) THEN
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
647:
648: ELSE
649:
650:
651: select count(*) into v_line_count from rlm_schedule_lines where header_id = v_sched_header_id and item_detail_type = '3';
652:
653: IF (l_debug <> -1) THEN
654: rlm_core_sv.dlog(C_DEBUG,'v_line_count_detail',v_line_count);
655: END IF;
920: delete from rlm_interface_headers where header_id = v_sched_header_id;
921: --
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: --
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
1482: v_statement_oe :='select oe.open_flag, oe.header_id, oe.line_id ,oe.source_document_line_id
1483: from oe_order_lines_all oe
1484: where (oe.header_id,oe.source_document_id)
1485: IN ( select rlm.order_header_id,rlm.header_id
1486: from rlm_schedule_lines rlm
1487: where rlm.header_id = :p_schedule_header_id)';
1488: **/
1489: --
1490: --Modified the code as per bugfix 6319027
1489: --
1490: --Modified the code as per bugfix 6319027
1491: v_statement_oe :='select oe.open_flag, oe.header_id, oe.line_id ,oe.source_document_line_id, scl.line_number
1492: from oe_order_lines_all oe,
1493: rlm_schedule_lines_all scl
1494: where oe.header_id = scl.order_header_id
1495: and oe.source_document_line_id = scl.line_id
1496: and oe.source_document_type_id = 5
1497: and scl.header_id = :p_schedule_header_id' ;