179: -- History
180: --
181:
182: PROCEDURE notify_failed_trx (
183: p_batch_id cn_not_trx_all.batch_id%TYPE,
184: x_start_period cn_periods.period_id%TYPE,
185: x_end_period cn_periods.period_id%TYPE,
186: debug_pipe VARCHAR2 DEFAULT NULL,
187: debug_level NUMBER DEFAULT 1,
191: SELECT distinct original_order_number, ln_num
192: FROM CN_AIA_ORDER_CAPTURE
193: WHERE org_id = x_org_id and trans_seq_id in
194: ( SELECT source_trx_line_id
195: FROM cn_not_trx_all
196: WHERE batch_id = p_batch_id and org_id = x_org_id and source_trx_line_id not in
197: (SELECT source_trx_line_id
198: FROM cn_comm_lines_api_all
199: WHERE process_batch_id = p_batch_id and org_id = x_org_id)