2402: ATTRIBUTE13,
2403: ATTRIBUTE14,
2404: ATTRIBUTE15,
2405: ATTRIBUTE_CATEGORY,
2406: fnd_global.user_id,
2407: sysdate,
2408: fnd_global.user_id,
2409: sysdate,
2410: fnd_global.user_id,
2404: ATTRIBUTE15,
2405: ATTRIBUTE_CATEGORY,
2406: fnd_global.user_id,
2407: sysdate,
2408: fnd_global.user_id,
2409: sysdate,
2410: fnd_global.user_id,
2411: auto_proration_flag
2412: FROM fun_trx_batches
2406: fnd_global.user_id,
2407: sysdate,
2408: fnd_global.user_id,
2409: sysdate,
2410: fnd_global.user_id,
2411: auto_proration_flag
2412: FROM fun_trx_batches
2413: WHERE batch_id = p_batch_id;
2414: -- Insert into transaction with status sent, ignore the rejected ones
2502: ATTRIBUTE13,
2503: ATTRIBUTE14,
2504: ATTRIBUTE15,
2505: ATTRIBUTE_CATEGORY,
2506: fnd_global.user_id,
2507: sysdate,
2508: fnd_global.user_id,
2509: sysdate,
2510: fnd_global.user_id
2504: ATTRIBUTE15,
2505: ATTRIBUTE_CATEGORY,
2506: fnd_global.user_id,
2507: sysdate,
2508: fnd_global.user_id,
2509: sysdate,
2510: fnd_global.user_id
2511: FROM fun_trx_headers
2512: WHERE batch_id = p_batch_id
2506: fnd_global.user_id,
2507: sysdate,
2508: fnd_global.user_id,
2509: sysdate,
2510: fnd_global.user_id
2511: FROM fun_trx_headers
2512: WHERE batch_id = p_batch_id
2513: AND STATUS in ('COMPLETE', 'APPROVED'); -- Bug: 6625360. AND STATUS = 'COMPLETE';
2514:
2540: AMOUNT_DR),
2541: DECODE(p_reversal_method, 'CHANGE', (-1) *(nvl(AMOUNT_DR,0)),
2542: AMOUNT_CR),
2543: DESCRIPTION,
2544: fnd_global.user_id,
2545: sysdate,
2546: fnd_global.user_id,
2547: sysdate,
2548: fnd_global.user_id
2542: AMOUNT_CR),
2543: DESCRIPTION,
2544: fnd_global.user_id,
2545: sysdate,
2546: fnd_global.user_id,
2547: sysdate,
2548: fnd_global.user_id
2549: FROM fun_batch_dists dist
2550: WHERE dist.batch_id = p_batch_id;
2544: fnd_global.user_id,
2545: sysdate,
2546: fnd_global.user_id,
2547: sysdate,
2548: fnd_global.user_id
2549: FROM fun_batch_dists dist
2550: WHERE dist.batch_id = p_batch_id;
2551:
2552: -- Insert into trx_lines
2576: lines.RECI_AMOUNT_DR),
2577: DECODE(p_reversal_method, 'CHANGE', DECODE(lines.RECI_AMOUNT_DR, NULL, NULL, (-1) * (lines.RECI_AMOUNT_DR)),
2578: lines.RECI_AMOUNT_CR),
2579: lines.DESCRIPTION,
2580: fnd_global.user_id,
2581: sysdate,
2582: fnd_global.user_id,
2583: sysdate,
2584: fnd_global.user_id
2578: lines.RECI_AMOUNT_CR),
2579: lines.DESCRIPTION,
2580: fnd_global.user_id,
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
2580: fnd_global.user_id,
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:
2650: orig_dists.ATTRIBUTE13,
2651: orig_dists.ATTRIBUTE14,
2652: orig_dists.ATTRIBUTE15,
2653: orig_dists.ATTRIBUTE_CATEGORY,
2654: fnd_global.user_id,
2655: sysdate,
2656: fnd_global.user_id,
2657: sysdate,
2658: fnd_global.user_id,
2652: orig_dists.ATTRIBUTE15,
2653: orig_dists.ATTRIBUTE_CATEGORY,
2654: fnd_global.user_id,
2655: sysdate,
2656: fnd_global.user_id,
2657: sysdate,
2658: fnd_global.user_id,
2659: reversed_hdrs.trx_id
2660: FROM fun_trx_headers reversed_hdrs,
2654: fnd_global.user_id,
2655: sysdate,
2656: fnd_global.user_id,
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,
2864: batches.ATTRIBUTE13,
2865: batches.ATTRIBUTE14,
2866: batches.ATTRIBUTE15,
2867: batches.ATTRIBUTE_CATEGORY,
2868: fnd_global.user_id,
2869: sysdate,
2870: fnd_global.user_id,
2871: sysdate,
2872: fnd_global.user_id,
2866: batches.ATTRIBUTE15,
2867: batches.ATTRIBUTE_CATEGORY,
2868: fnd_global.user_id,
2869: sysdate,
2870: fnd_global.user_id,
2871: sysdate,
2872: fnd_global.user_id,
2873: batches.auto_proration_flag
2874: FROM fun_trx_batches batches, fun_trx_headers headers
2868: fnd_global.user_id,
2869: sysdate,
2870: fnd_global.user_id,
2871: sysdate,
2872: fnd_global.user_id,
2873: batches.auto_proration_flag
2874: FROM fun_trx_batches batches, fun_trx_headers headers
2875: WHERE batches.batch_id = headers.batch_id
2876: AND headers.trx_id = p_trx_tbl_id(1);
2969: ATTRIBUTE13,
2970: ATTRIBUTE14,
2971: ATTRIBUTE15,
2972: ATTRIBUTE_CATEGORY,
2973: fnd_global.user_id,
2974: sysdate,
2975: fnd_global.user_id,
2976: sysdate,
2977: fnd_global.user_id
2971: ATTRIBUTE15,
2972: ATTRIBUTE_CATEGORY,
2973: fnd_global.user_id,
2974: sysdate,
2975: fnd_global.user_id,
2976: sysdate,
2977: fnd_global.user_id
2978: FROM fun_trx_headers
2979: WHERE trx_id = p_trx_tbl_id(i)
2973: fnd_global.user_id,
2974: sysdate,
2975: fnd_global.user_id,
2976: sysdate,
2977: fnd_global.user_id
2978: FROM fun_trx_headers
2979: WHERE trx_id = p_trx_tbl_id(i)
2980: AND STATUS in ('COMPLETE', 'APPROVED'); --Bug: 6625360. AND STATUS = 'COMPLETE';
2981: -- Update reversed_trx_id with fun_trx_headers
3027: DECODE(p_reversal_method, 'CHANGE', DECODE(lines.RECI_AMOUNT_DR, NULL, NULL, (-1) * (lines.RECI_AMOUNT_DR)),
3028: lines.RECI_AMOUNT_CR),
3029:
3030: lines.DESCRIPTION,
3031: fnd_global.user_id,
3032: sysdate,
3033: fnd_global.user_id,
3034: sysdate,
3035: fnd_global.user_id
3029:
3030: lines.DESCRIPTION,
3031: fnd_global.user_id,
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
3031: fnd_global.user_id,
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:
3101: orig_dists.ATTRIBUTE13,
3102: orig_dists.ATTRIBUTE14,
3103: orig_dists.ATTRIBUTE15,
3104: orig_dists.ATTRIBUTE_CATEGORY,
3105: fnd_global.user_id,
3106: sysdate,
3107: fnd_global.user_id,
3108: sysdate,
3109: fnd_global.user_id,
3103: orig_dists.ATTRIBUTE15,
3104: orig_dists.ATTRIBUTE_CATEGORY,
3105: fnd_global.user_id,
3106: sysdate,
3107: fnd_global.user_id,
3108: sysdate,
3109: fnd_global.user_id,
3110: reversed_hdrs.trx_id
3111: FROM fun_trx_headers reversed_hdrs,
3105: fnd_global.user_id,
3106: sysdate,
3107: fnd_global.user_id,
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,
4153: l_amount_dr,
4154: p_init_dist_tbl(i).ccid,
4155: p_init_dist_tbl(i).description,
4156: 'Y',
4157: fnd_global.user_id,
4158: sysdate,
4159: fnd_global.user_id,
4160: sysdate,
4161: fnd_global.user_id,
4155: p_init_dist_tbl(i).description,
4156: 'Y',
4157: fnd_global.user_id,
4158: sysdate,
4159: fnd_global.user_id,
4160: sysdate,
4161: fnd_global.user_id,
4162: p_trx_tbl(t).trx_id);
4163: END LOOP; -- batch distributions
4157: fnd_global.user_id,
4158: sysdate,
4159: fnd_global.user_id,
4160: sysdate,
4161: fnd_global.user_id,
4162: p_trx_tbl(t).trx_id);
4163: END LOOP; -- batch distributions
4164: END LOOP; -- recipient
4165: