[Home] [Help]
2549: FROM fun_batch_dists dist
2550: WHERE dist.batch_id = p_batch_id;
2551:
2552: -- Insert into trx_lines
2553: INSERT INTO fun_trx_lines(LINE_ID,
2554: TRX_ID,
2555: LINE_NUMBER,
2556: LINE_TYPE_FLAG,
2557: INIT_AMOUNT_CR,
2563: CREATION_DATE,
2564: LAST_UPDATED_BY,
2565: LAST_UPDATE_DATE,
2566: LAST_UPDATE_LOGIN)
2567: SELECT fun_trx_lines_s.nextval,
2568: headers.trx_id,
2569: LINE_NUMBER,
2570: LINE_TYPE_FLAG,
2571: DECODE(p_reversal_method, 'CHANGE',DECODE(lines.INIT_AMOUNT_CR, NULL,NULL, (-1) * (lines.INIT_AMOUNT_CR)),
2581: sysdate,
2582: fnd_global.user_id,
2583: sysdate,
2584: fnd_global.user_id
2585: FROM fun_trx_headers headers, fun_trx_lines lines
2586: WHERE headers.batch_id = l_reversed_batch_id
2587: AND headers.original_trx_id = lines.trx_id;
2588:
2589: -- Insert into dist_lines
2657: sysdate,
2658: fnd_global.user_id,
2659: reversed_hdrs.trx_id
2660: FROM fun_trx_headers reversed_hdrs,
2661: fun_trx_lines reversed_lines,
2662: --fun_batch_dists reversed_b_dists,
2663: fun_trx_lines orig_lines,
2664: fun_dist_lines orig_dists
2665: WHERE reversed_hdrs.batch_id = l_reversed_batch_id
2659: reversed_hdrs.trx_id
2660: FROM fun_trx_headers reversed_hdrs,
2661: fun_trx_lines reversed_lines,
2662: --fun_batch_dists reversed_b_dists,
2663: fun_trx_lines orig_lines,
2664: fun_dist_lines orig_dists
2665: WHERE reversed_hdrs.batch_id = l_reversed_batch_id
2666: AND reversed_hdrs.trx_id = reversed_lines.trx_id
2667: AND reversed_hdrs.original_trx_id = orig_lines.trx_id
2999: )
3000: where batch_id=l_reversed_batch_id;
3001:
3002: -- Insert into trx_lines.
3003: INSERT INTO fun_trx_lines(LINE_ID,
3004: TRX_ID,
3005: LINE_NUMBER,
3006: LINE_TYPE_FLAG,
3007: INIT_AMOUNT_CR,
3013: CREATION_DATE,
3014: LAST_UPDATED_BY,
3015: LAST_UPDATE_DATE,
3016: LAST_UPDATE_LOGIN)
3017: SELECT fun_trx_lines_s.nextval,
3018: headers.trx_id,
3019: LINE_NUMBER,
3020: LINE_TYPE_FLAG,
3021: DECODE(p_reversal_method, 'CHANGE', DECODE(lines.INIT_AMOUNT_CR, NULL, NULL, (-1) * (lines.INIT_AMOUNT_CR)),
3032: sysdate,
3033: fnd_global.user_id,
3034: sysdate,
3035: fnd_global.user_id
3036: FROM fun_trx_headers headers, fun_trx_lines lines
3037: WHERE headers.batch_id = l_reversed_batch_id
3038: AND headers.original_trx_id = lines.trx_id;
3039:
3040: -- Insert into dist_lines
3108: sysdate,
3109: fnd_global.user_id,
3110: reversed_hdrs.trx_id
3111: FROM fun_trx_headers reversed_hdrs,
3112: fun_trx_lines reversed_lines,
3113: --fun_batch_dists reversed_b_dists,
3114: fun_trx_lines orig_lines,
3115: fun_dist_lines orig_dists
3116: WHERE reversed_hdrs.batch_id = l_reversed_batch_id
3110: reversed_hdrs.trx_id
3111: FROM fun_trx_headers reversed_hdrs,
3112: fun_trx_lines reversed_lines,
3113: --fun_batch_dists reversed_b_dists,
3114: fun_trx_lines orig_lines,
3115: fun_dist_lines orig_dists
3116: WHERE reversed_hdrs.batch_id = l_reversed_batch_id
3117: AND reversed_hdrs.trx_id = reversed_lines.trx_id
3118: AND reversed_hdrs.original_trx_id = orig_lines.trx_id
3981: dists.amount_dr,
3982: dists.ccid,
3983: hdrs.trx_number
3984: FROM fun_trx_headers hdrs,
3985: fun_trx_lines lines,
3986: fun_dist_lines dists
3987: WHERE hdrs.batch_id = p_batch_id
3988: AND hdrs.trx_id = lines.trx_id
3989: AND lines.line_id = dists.line_id
4087: AND dist_type_flag = 'L'
4088: --AND auto_generate_flag = 'Y'
4089: AND line_id IN
4090: (SELECT line_id
4091: FROM fun_trx_lines trx_lines
4092: WHERE trx_lines.trx_id = p_trx_tbl(i).trx_id);
4093: END LOOP;
4094: END IF;
4095:
4115: FOR t IN p_trx_tbl.first..p_trx_tbl.last
4116: LOOP
4117: SELECT line_id
4118: INTO l_line_id
4119: FROM fun_trx_lines
4120: WHERE trx_id = p_trx_tbl(t).trx_id;
4121:
4122: FOR i IN 1..l_init_dist_count
4123: LOOP