DBA Data[Home] [Help]

APPS.FUN_TRX_PVT dependencies on FND_GLOBAL

Line 2406: fnd_global.user_id,

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,

Line 2408: 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

Line 2410: fnd_global.user_id,

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

Line 2506: fnd_global.user_id,

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

Line 2508: 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

Line 2510: fnd_global.user_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:

Line 2544: fnd_global.user_id,

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

Line 2546: 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;

Line 2548: fnd_global.user_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

Line 2580: fnd_global.user_id,

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

Line 2582: 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

Line 2584: fnd_global.user_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:

Line 2654: fnd_global.user_id,

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,

Line 2656: 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,

Line 2658: fnd_global.user_id,

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,

Line 2868: fnd_global.user_id,

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,

Line 2870: 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

Line 2872: fnd_global.user_id,

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);

Line 2973: fnd_global.user_id,

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

Line 2975: 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)

Line 2977: fnd_global.user_id

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

Line 3031: fnd_global.user_id,

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

Line 3033: 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

Line 3035: fnd_global.user_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:

Line 3105: fnd_global.user_id,

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,

Line 3107: 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,

Line 3109: fnd_global.user_id,

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,

Line 4157: fnd_global.user_id,

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,

Line 4159: 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

Line 4161: fnd_global.user_id,

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: