DBA Data[Home] [Help]

APPS.FUN_TRX_PVT dependencies on FND_GLOBAL

Line 2568: fnd_global.user_id,

2564: ATTRIBUTE13,
2565: ATTRIBUTE14,
2566: ATTRIBUTE15,
2567: ATTRIBUTE_CATEGORY,
2568: fnd_global.user_id,
2569: sysdate,
2570: fnd_global.user_id,
2571: sysdate,
2572: fnd_global.user_id,

Line 2570: fnd_global.user_id,

2566: ATTRIBUTE15,
2567: ATTRIBUTE_CATEGORY,
2568: fnd_global.user_id,
2569: sysdate,
2570: fnd_global.user_id,
2571: sysdate,
2572: fnd_global.user_id,
2573: auto_proration_flag
2574: FROM fun_trx_batches

Line 2572: fnd_global.user_id,

2568: fnd_global.user_id,
2569: sysdate,
2570: fnd_global.user_id,
2571: sysdate,
2572: fnd_global.user_id,
2573: auto_proration_flag
2574: FROM fun_trx_batches
2575: WHERE batch_id = p_batch_id;
2576: -- Insert into transaction with status sent, ignore the rejected ones

Line 2668: fnd_global.user_id,

2664: ATTRIBUTE13,
2665: ATTRIBUTE14,
2666: ATTRIBUTE15,
2667: ATTRIBUTE_CATEGORY,
2668: fnd_global.user_id,
2669: sysdate,
2670: fnd_global.user_id,
2671: sysdate,
2672: fnd_global.user_id

Line 2670: fnd_global.user_id,

2666: ATTRIBUTE15,
2667: ATTRIBUTE_CATEGORY,
2668: fnd_global.user_id,
2669: sysdate,
2670: fnd_global.user_id,
2671: sysdate,
2672: fnd_global.user_id
2673: FROM fun_trx_headers
2674: WHERE batch_id = p_batch_id

Line 2672: fnd_global.user_id

2668: fnd_global.user_id,
2669: sysdate,
2670: fnd_global.user_id,
2671: sysdate,
2672: fnd_global.user_id
2673: FROM fun_trx_headers
2674: WHERE batch_id = p_batch_id
2675: AND STATUS in ('COMPLETE', 'APPROVED'); -- Bug: 6625360. AND STATUS = 'COMPLETE';
2676:

Line 2706: fnd_global.user_id,

2702: AMOUNT_DR),
2703: DECODE(p_reversal_method, 'CHANGE', (-1) *(nvl(AMOUNT_DR,0)),
2704: AMOUNT_CR),
2705: DESCRIPTION,
2706: fnd_global.user_id,
2707: sysdate,
2708: fnd_global.user_id,
2709: sysdate,
2710: fnd_global.user_id

Line 2708: fnd_global.user_id,

2704: AMOUNT_CR),
2705: DESCRIPTION,
2706: fnd_global.user_id,
2707: sysdate,
2708: fnd_global.user_id,
2709: sysdate,
2710: fnd_global.user_id
2711: FROM fun_batch_dists dist
2712: WHERE dist.batch_id = p_batch_id;

Line 2710: fnd_global.user_id

2706: fnd_global.user_id,
2707: sysdate,
2708: fnd_global.user_id,
2709: sysdate,
2710: fnd_global.user_id
2711: FROM fun_batch_dists dist
2712: WHERE dist.batch_id = p_batch_id;
2713:
2714:

Line 2743: fnd_global.user_id,

2739: lines.RECI_AMOUNT_DR),
2740: DECODE(p_reversal_method, 'CHANGE', DECODE(lines.RECI_AMOUNT_DR, NULL, NULL, (-1) * (lines.RECI_AMOUNT_DR)),
2741: lines.RECI_AMOUNT_CR),
2742: lines.DESCRIPTION,
2743: fnd_global.user_id,
2744: sysdate,
2745: fnd_global.user_id,
2746: sysdate,
2747: fnd_global.user_id

Line 2745: fnd_global.user_id,

2741: lines.RECI_AMOUNT_CR),
2742: lines.DESCRIPTION,
2743: fnd_global.user_id,
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

Line 2747: fnd_global.user_id

2743: fnd_global.user_id,
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:

Line 2817: fnd_global.user_id,

2813: orig_dists.ATTRIBUTE13,
2814: orig_dists.ATTRIBUTE14,
2815: orig_dists.ATTRIBUTE15,
2816: orig_dists.ATTRIBUTE_CATEGORY,
2817: fnd_global.user_id,
2818: sysdate,
2819: fnd_global.user_id,
2820: sysdate,
2821: fnd_global.user_id,

Line 2819: fnd_global.user_id,

2815: orig_dists.ATTRIBUTE15,
2816: orig_dists.ATTRIBUTE_CATEGORY,
2817: fnd_global.user_id,
2818: sysdate,
2819: fnd_global.user_id,
2820: sysdate,
2821: fnd_global.user_id,
2822: reversed_hdrs.trx_id
2823: FROM fun_trx_headers reversed_hdrs,

Line 2821: fnd_global.user_id,

2817: fnd_global.user_id,
2818: sysdate,
2819: fnd_global.user_id,
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,

Line 3088: fnd_global.user_id,

3084: batches.ATTRIBUTE13,
3085: batches.ATTRIBUTE14,
3086: batches.ATTRIBUTE15,
3087: batches.ATTRIBUTE_CATEGORY,
3088: fnd_global.user_id,
3089: sysdate,
3090: fnd_global.user_id,
3091: sysdate,
3092: fnd_global.user_id,

Line 3090: fnd_global.user_id,

3086: batches.ATTRIBUTE15,
3087: batches.ATTRIBUTE_CATEGORY,
3088: fnd_global.user_id,
3089: sysdate,
3090: fnd_global.user_id,
3091: sysdate,
3092: fnd_global.user_id,
3093: batches.auto_proration_flag
3094: FROM fun_trx_batches batches, fun_trx_headers headers

Line 3092: fnd_global.user_id,

3088: fnd_global.user_id,
3089: sysdate,
3090: fnd_global.user_id,
3091: sysdate,
3092: fnd_global.user_id,
3093: batches.auto_proration_flag
3094: FROM fun_trx_batches batches, fun_trx_headers headers
3095: WHERE batches.batch_id = headers.batch_id
3096: AND headers.trx_id = p_trx_tbl_id(1);

Line 3193: fnd_global.user_id,

3189: ATTRIBUTE13,
3190: ATTRIBUTE14,
3191: ATTRIBUTE15,
3192: ATTRIBUTE_CATEGORY,
3193: fnd_global.user_id,
3194: sysdate,
3195: fnd_global.user_id,
3196: sysdate,
3197: fnd_global.user_id

Line 3195: fnd_global.user_id,

3191: ATTRIBUTE15,
3192: ATTRIBUTE_CATEGORY,
3193: fnd_global.user_id,
3194: sysdate,
3195: fnd_global.user_id,
3196: sysdate,
3197: fnd_global.user_id
3198: FROM fun_trx_headers
3199: WHERE trx_id = p_trx_tbl_id(i)

Line 3197: fnd_global.user_id

3193: fnd_global.user_id,
3194: sysdate,
3195: fnd_global.user_id,
3196: sysdate,
3197: fnd_global.user_id
3198: FROM fun_trx_headers
3199: WHERE trx_id = p_trx_tbl_id(i)
3200: AND STATUS in ('COMPLETE', 'APPROVED'); --Bug: 6625360. AND STATUS = 'COMPLETE';
3201: -- Update reversed_trx_id with fun_trx_headers

Line 3251: fnd_global.user_id,

3247: DECODE(p_reversal_method, 'CHANGE', DECODE(lines.RECI_AMOUNT_DR, NULL, NULL, (-1) * (lines.RECI_AMOUNT_DR)),
3248: lines.RECI_AMOUNT_CR),
3249:
3250: lines.DESCRIPTION,
3251: fnd_global.user_id,
3252: sysdate,
3253: fnd_global.user_id,
3254: sysdate,
3255: fnd_global.user_id

Line 3253: fnd_global.user_id,

3249:
3250: lines.DESCRIPTION,
3251: fnd_global.user_id,
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

Line 3255: fnd_global.user_id

3251: fnd_global.user_id,
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:

Line 3325: fnd_global.user_id,

3321: orig_dists.ATTRIBUTE13,
3322: orig_dists.ATTRIBUTE14,
3323: orig_dists.ATTRIBUTE15,
3324: orig_dists.ATTRIBUTE_CATEGORY,
3325: fnd_global.user_id,
3326: sysdate,
3327: fnd_global.user_id,
3328: sysdate,
3329: fnd_global.user_id,

Line 3327: fnd_global.user_id,

3323: orig_dists.ATTRIBUTE15,
3324: orig_dists.ATTRIBUTE_CATEGORY,
3325: fnd_global.user_id,
3326: sysdate,
3327: fnd_global.user_id,
3328: sysdate,
3329: fnd_global.user_id,
3330: reversed_hdrs.trx_id
3331: FROM fun_trx_headers reversed_hdrs,

Line 3329: fnd_global.user_id,

3325: fnd_global.user_id,
3326: sysdate,
3327: fnd_global.user_id,
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,

Line 3436: SET status = p_update_status_to,last_updated_by = fnd_global.user_id

3432: (l_status = 'XFER_INI_GL' AND p_update_status_to = 'COMPLETE') OR
3433: (l_status = 'XFER_RECI_GL' AND p_update_status_to = 'COMPLETE')
3434: THEN
3435: UPDATE fun_trx_headers
3436: SET status = p_update_status_to,last_updated_by = fnd_global.user_id
3437: WHERE trx_id = p_trx_id;
3438:
3439: SELECT batch_id
3440: INTO l_batch_id

Line 4446: fnd_global.user_id,

4442: l_amount_dr,
4443: p_init_dist_tbl(i).ccid,
4444: p_init_dist_tbl(i).description,
4445: 'Y',
4446: fnd_global.user_id,
4447: sysdate,
4448: fnd_global.user_id,
4449: sysdate,
4450: fnd_global.user_id,

Line 4448: fnd_global.user_id,

4444: p_init_dist_tbl(i).description,
4445: 'Y',
4446: fnd_global.user_id,
4447: sysdate,
4448: fnd_global.user_id,
4449: sysdate,
4450: fnd_global.user_id,
4451: p_trx_tbl(t).trx_id);
4452: END LOOP; -- batch distributions

Line 4450: fnd_global.user_id,

4446: fnd_global.user_id,
4447: sysdate,
4448: fnd_global.user_id,
4449: sysdate,
4450: fnd_global.user_id,
4451: p_trx_tbl(t).trx_id);
4452: END LOOP; -- batch distributions
4453:
4454: --Bug: 9104801