[Home] [Help]
2712: WHERE dist.batch_id = p_batch_id;
2713:
2714:
2715: -- Insert into trx_lines
2716: INSERT INTO fun_trx_lines(LINE_ID,
2717: TRX_ID,
2718: LINE_NUMBER,
2719: LINE_TYPE_FLAG,
2720: INIT_AMOUNT_CR,
2726: CREATION_DATE,
2727: LAST_UPDATED_BY,
2728: LAST_UPDATE_DATE,
2729: LAST_UPDATE_LOGIN)
2730: SELECT fun_trx_lines_s.nextval,
2731: headers.trx_id,
2732: LINE_NUMBER,
2733: LINE_TYPE_FLAG,
2734: DECODE(p_reversal_method, 'CHANGE',DECODE(lines.INIT_AMOUNT_CR, NULL,NULL, (-1) * (lines.INIT_AMOUNT_CR)),
2744: sysdate,
2745: fnd_global.user_id,
2746: sysdate,
2747: fnd_global.user_id
2748: FROM fun_trx_headers headers, fun_trx_lines lines
2749: WHERE headers.batch_id = l_reversed_batch_id
2750: AND headers.original_trx_id = lines.trx_id;
2751:
2752: -- Insert into dist_lines
2820: sysdate,
2821: fnd_global.user_id,
2822: reversed_hdrs.trx_id
2823: FROM fun_trx_headers reversed_hdrs,
2824: fun_trx_lines reversed_lines,
2825: --fun_batch_dists reversed_b_dists,
2826: fun_trx_lines orig_lines,
2827: fun_dist_lines orig_dists
2828: WHERE reversed_hdrs.batch_id = l_reversed_batch_id
2822: reversed_hdrs.trx_id
2823: FROM fun_trx_headers reversed_hdrs,
2824: fun_trx_lines reversed_lines,
2825: --fun_batch_dists reversed_b_dists,
2826: fun_trx_lines orig_lines,
2827: fun_dist_lines orig_dists
2828: WHERE reversed_hdrs.batch_id = l_reversed_batch_id
2829: AND reversed_hdrs.trx_id = reversed_lines.trx_id
2830: AND reversed_hdrs.original_trx_id = orig_lines.trx_id
3219: )
3220: where batch_id=l_reversed_batch_id;
3221:
3222: -- Insert into trx_lines.
3223: INSERT INTO fun_trx_lines(LINE_ID,
3224: TRX_ID,
3225: LINE_NUMBER,
3226: LINE_TYPE_FLAG,
3227: INIT_AMOUNT_CR,
3233: CREATION_DATE,
3234: LAST_UPDATED_BY,
3235: LAST_UPDATE_DATE,
3236: LAST_UPDATE_LOGIN)
3237: SELECT fun_trx_lines_s.nextval,
3238: headers.trx_id,
3239: LINE_NUMBER,
3240: LINE_TYPE_FLAG,
3241: DECODE(p_reversal_method, 'CHANGE', DECODE(lines.INIT_AMOUNT_CR, NULL, NULL, (-1) * (lines.INIT_AMOUNT_CR)),
3252: sysdate,
3253: fnd_global.user_id,
3254: sysdate,
3255: fnd_global.user_id
3256: FROM fun_trx_headers headers, fun_trx_lines lines
3257: WHERE headers.batch_id = l_reversed_batch_id
3258: AND headers.original_trx_id = lines.trx_id;
3259:
3260: -- Insert into dist_lines
3328: sysdate,
3329: fnd_global.user_id,
3330: reversed_hdrs.trx_id
3331: FROM fun_trx_headers reversed_hdrs,
3332: fun_trx_lines reversed_lines,
3333: --fun_batch_dists reversed_b_dists,
3334: fun_trx_lines orig_lines,
3335: fun_dist_lines orig_dists
3336: WHERE reversed_hdrs.batch_id = l_reversed_batch_id
3330: reversed_hdrs.trx_id
3331: FROM fun_trx_headers reversed_hdrs,
3332: fun_trx_lines reversed_lines,
3333: --fun_batch_dists reversed_b_dists,
3334: fun_trx_lines orig_lines,
3335: fun_dist_lines orig_dists
3336: WHERE reversed_hdrs.batch_id = l_reversed_batch_id
3337: AND reversed_hdrs.trx_id = reversed_lines.trx_id
3338: AND reversed_hdrs.original_trx_id = orig_lines.trx_id
4267: dists.amount_dr,
4268: dists.ccid,
4269: hdrs.trx_number
4270: FROM fun_trx_headers hdrs,
4271: fun_trx_lines lines,
4272: fun_dist_lines dists
4273: WHERE hdrs.batch_id = p_batch_id
4274: AND hdrs.trx_id = lines.trx_id
4275: AND lines.line_id = dists.line_id
4376: AND dist_type_flag = 'L'
4377: --AND auto_generate_flag = 'Y'
4378: AND line_id IN
4379: (SELECT line_id
4380: FROM fun_trx_lines trx_lines
4381: WHERE trx_lines.trx_id = p_trx_tbl(i).trx_id);
4382: END LOOP;
4383: END IF;
4384:
4404: FOR t IN p_trx_tbl.first..p_trx_tbl.last
4405: LOOP
4406: SELECT line_id
4407: INTO l_line_id
4408: FROM fun_trx_lines
4409: WHERE trx_id = p_trx_tbl(t).trx_id;
4410:
4411: FOR i IN 1..l_init_dist_count
4412: LOOP