DBA Data[Home] [Help]

APPS.ARP_CONFIRMATION dependencies on FND_GLOBAL

Line 811: last_updated_by = FND_GLOBAL.user_id

807: freight_uediscounted = l_freight_uediscounted,
808: charges_uediscounted = l_charges_uediscounted,
809: rule_set_id = l_rule_set_id,
810: last_update_date = TRUNC(SYSDATE),
811: last_updated_by = FND_GLOBAL.user_id
812: WHERE
813: receivable_application_id = l_ra_rec.receivable_application_id;
814:
815: arp_standard.debug('-- ra record updated.');

Line 1143: l_dist_rec.last_updated_by := FND_GLOBAL.user_id;

1139: l_dist_rec.source_id := l_crh_id_new;
1140: l_dist_rec.source_table := 'CRH';
1141: l_dist_rec.source_type := 'CONFIRMATION';
1142: l_dist_rec.last_update_date := SYSDATE;
1143: l_dist_rec.last_updated_by := FND_GLOBAL.user_id;
1144: l_dist_rec.creation_date := SYSDATE;
1145: l_dist_rec.created_by := FND_GLOBAL.user_id;
1146: l_dist_rec.code_combination_id := p_receipt_clearing_ccid;
1147:

Line 1145: l_dist_rec.created_by := FND_GLOBAL.user_id;

1141: l_dist_rec.source_type := 'CONFIRMATION';
1142: l_dist_rec.last_update_date := SYSDATE;
1143: l_dist_rec.last_updated_by := FND_GLOBAL.user_id;
1144: l_dist_rec.creation_date := SYSDATE;
1145: l_dist_rec.created_by := FND_GLOBAL.user_id;
1146: l_dist_rec.code_combination_id := p_receipt_clearing_ccid;
1147:
1148: -- Populate additional value for 11.5 VAT project
1149: -- populate the exchange rate info from the crh record.

Line 1353: last_updated_by = FND_GLOBAL.user_id

1349: acctd_amount_applied_from = p_acctd_amount_applied,
1350: confirmed_flag = 'Y',
1351: postable = 'Y',
1352: last_update_date = TRUNC(SYSDATE),
1353: last_updated_by = FND_GLOBAL.user_id
1354: WHERE receivable_application_id = l_receivable_application_id;
1355:
1356: -- call mrc to replicate the data
1357: ar_mrc_engine3.confirm_ra_rec_update(

Line 1558: FND_GLOBAL.user_id,

1554: '40.4',
1555: l_unapp_rec.app_type,
1556: l_unapp_rec.app_date,
1557: l_unapp_rec.unapp_cc_id,
1558: FND_GLOBAL.user_id,
1559: TRUNC(sysdate),
1560: 'N',
1561: l_unapp_rec.app_gl_date,
1562: FND_GLOBAL.user_id,

Line 1562: FND_GLOBAL.user_id,

1558: FND_GLOBAL.user_id,
1559: TRUNC(sysdate),
1560: 'N',
1561: l_unapp_rec.app_gl_date,
1562: FND_GLOBAL.user_id,
1563: TRUNC(sysdate),
1564: l_unapp_rec.app_ps_id,
1565: l_unapp_rec.app_sob,
1566: 'UNAPP',

Line 1850: l_dist_rec.last_updated_by := FND_GLOBAL.user_id;

1846: l_dist_rec.source_id := l_crh_id_new;
1847: l_dist_rec.source_table := 'CRH';
1848: l_dist_rec.source_type := 'CONFIRMATION';
1849: l_dist_rec.last_update_date := SYSDATE;
1850: l_dist_rec.last_updated_by := FND_GLOBAL.user_id;
1851: l_dist_rec.creation_date := SYSDATE;
1852: l_dist_rec.created_by := FND_GLOBAL.user_id;
1853:
1854: IF p_cr_rec.amount < 0 THEN

Line 1852: l_dist_rec.created_by := FND_GLOBAL.user_id;

1848: l_dist_rec.source_type := 'CONFIRMATION';
1849: l_dist_rec.last_update_date := SYSDATE;
1850: l_dist_rec.last_updated_by := FND_GLOBAL.user_id;
1851: l_dist_rec.creation_date := SYSDATE;
1852: l_dist_rec.created_by := FND_GLOBAL.user_id;
1853:
1854: IF p_cr_rec.amount < 0 THEN
1855: l_dist_rec.amount_dr := -p_cr_rec.amount;
1856: l_dist_rec.amount_cr := NULL;

Line 1991: FND_GLOBAL.user_id,

1987: nvl(ps2.freight_remaining,0) + nvl(ra.freight_applied,0),
1988: nvl(ps2.receivables_charges_remaining,0) +
1989: nvl(ra.receivables_charges_applied,0),
1990: p_batch_id,
1991: FND_GLOBAL.user_id,
1992: trunc(sysdate),
1993: FND_GLOBAL.user_id
1994: FROM
1995: ar_receivable_applications ra,

Line 1993: FND_GLOBAL.user_id

1989: nvl(ra.receivables_charges_applied,0),
1990: p_batch_id,
1991: FND_GLOBAL.user_id,
1992: trunc(sysdate),
1993: FND_GLOBAL.user_id
1994: FROM
1995: ar_receivable_applications ra,
1996: ar_payment_schedules ps2,
1997: ar_adjustments adj2,

Line 2194: FND_GLOBAL.user_id,

2190: '40.2',
2191: application_type,
2192: p_confirm_gl_date,
2193: code_combination_id,
2194: FND_GLOBAL.user_id,
2195: TRUNC(SYSDATE),
2196: 'N',
2197: p_confirm_gl_date,
2198: FND_GLOBAL.user_id,

Line 2198: FND_GLOBAL.user_id,

2194: FND_GLOBAL.user_id,
2195: TRUNC(SYSDATE),
2196: 'N',
2197: p_confirm_gl_date,
2198: FND_GLOBAL.user_id,
2199: TRUNC(SYSDATE),
2200: payment_schedule_id,
2201: set_of_books_id,
2202: status,

Line 2300: FND_GLOBAL.user_id,

2296: '40.3'),
2297: application_type,
2298: p_confirm_gl_date,
2299: code_combination_id,
2300: FND_GLOBAL.user_id,
2301: TRUNC(SYSDATE),
2302: display,
2303: p_confirm_gl_date,
2304: FND_GLOBAL.user_id,

Line 2304: FND_GLOBAL.user_id,

2300: FND_GLOBAL.user_id,
2301: TRUNC(SYSDATE),
2302: display,
2303: p_confirm_gl_date,
2304: FND_GLOBAL.user_id,
2305: TRUNC(SYSDATE),
2306: payment_schedule_id,
2307: set_of_books_id,
2308: status,

Line 2614: last_updated_by = FND_GLOBAL.user_id

2610: UPDATE ar_receivable_applications
2611: SET reversal_gl_date = p_confirm_gl_date,
2612: display = 'N',
2613: last_update_date = TRUNC(SYSDATE),
2614: last_updated_by = FND_GLOBAL.user_id
2615: WHERE cash_receipt_id = p_cr_rec.cash_receipt_id
2616: AND nvl(confirmed_flag,'Y') = 'Y'
2617: AND reversal_gl_date IS NULL;
2618: