DBA Data[Home] [Help]

APPS.ARP_CONFIRMATION dependencies on FND_GLOBAL

Line 794: last_updated_by = FND_GLOBAL.user_id

790: freight_uediscounted = l_freight_uediscounted,
791: charges_uediscounted = l_charges_uediscounted,
792: rule_set_id = l_rule_set_id,
793: last_update_date = TRUNC(SYSDATE),
794: last_updated_by = FND_GLOBAL.user_id
795: WHERE
796: receivable_application_id = l_ra_rec.receivable_application_id;
797:
798: arp_standard.debug('-- ra record updated.');

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

1122: l_dist_rec.source_id := l_crh_id_new;
1123: l_dist_rec.source_table := 'CRH';
1124: l_dist_rec.source_type := 'CONFIRMATION';
1125: l_dist_rec.last_update_date := SYSDATE;
1126: l_dist_rec.last_updated_by := FND_GLOBAL.user_id;
1127: l_dist_rec.creation_date := SYSDATE;
1128: l_dist_rec.created_by := FND_GLOBAL.user_id;
1129: l_dist_rec.code_combination_id := p_receipt_clearing_ccid;
1130:

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

1124: l_dist_rec.source_type := 'CONFIRMATION';
1125: l_dist_rec.last_update_date := SYSDATE;
1126: l_dist_rec.last_updated_by := FND_GLOBAL.user_id;
1127: l_dist_rec.creation_date := SYSDATE;
1128: l_dist_rec.created_by := FND_GLOBAL.user_id;
1129: l_dist_rec.code_combination_id := p_receipt_clearing_ccid;
1130:
1131: -- Populate additional value for 11.5 VAT project
1132: -- populate the exchange rate info from the crh record.

Line 1336: last_updated_by = FND_GLOBAL.user_id

1332: acctd_amount_applied_from = p_acctd_amount_applied,
1333: confirmed_flag = 'Y',
1334: postable = 'Y',
1335: last_update_date = TRUNC(SYSDATE),
1336: last_updated_by = FND_GLOBAL.user_id
1337: WHERE receivable_application_id = l_receivable_application_id;
1338:
1339: -- call mrc to replicate the data
1340: ar_mrc_engine3.confirm_ra_rec_update(

Line 1541: FND_GLOBAL.user_id,

1537: '40.4',
1538: l_unapp_rec.app_type,
1539: l_unapp_rec.app_date,
1540: l_unapp_rec.unapp_cc_id,
1541: FND_GLOBAL.user_id,
1542: TRUNC(sysdate),
1543: 'N',
1544: l_unapp_rec.app_gl_date,
1545: FND_GLOBAL.user_id,

Line 1545: FND_GLOBAL.user_id,

1541: FND_GLOBAL.user_id,
1542: TRUNC(sysdate),
1543: 'N',
1544: l_unapp_rec.app_gl_date,
1545: FND_GLOBAL.user_id,
1546: TRUNC(sysdate),
1547: l_unapp_rec.app_ps_id,
1548: l_unapp_rec.app_sob,
1549: 'UNAPP',

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

1829: l_dist_rec.source_id := l_crh_id_new;
1830: l_dist_rec.source_table := 'CRH';
1831: l_dist_rec.source_type := 'CONFIRMATION';
1832: l_dist_rec.last_update_date := SYSDATE;
1833: l_dist_rec.last_updated_by := FND_GLOBAL.user_id;
1834: l_dist_rec.creation_date := SYSDATE;
1835: l_dist_rec.created_by := FND_GLOBAL.user_id;
1836:
1837: IF p_cr_rec.amount < 0 THEN

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

1831: l_dist_rec.source_type := 'CONFIRMATION';
1832: l_dist_rec.last_update_date := SYSDATE;
1833: l_dist_rec.last_updated_by := FND_GLOBAL.user_id;
1834: l_dist_rec.creation_date := SYSDATE;
1835: l_dist_rec.created_by := FND_GLOBAL.user_id;
1836:
1837: IF p_cr_rec.amount < 0 THEN
1838: l_dist_rec.amount_dr := -p_cr_rec.amount;
1839: l_dist_rec.amount_cr := NULL;

Line 1974: FND_GLOBAL.user_id,

1970: nvl(ps2.freight_remaining,0) + nvl(ra.freight_applied,0),
1971: nvl(ps2.receivables_charges_remaining,0) +
1972: nvl(ra.receivables_charges_applied,0),
1973: p_batch_id,
1974: FND_GLOBAL.user_id,
1975: trunc(sysdate),
1976: FND_GLOBAL.user_id
1977: FROM
1978: ar_receivable_applications ra,

Line 1976: FND_GLOBAL.user_id

1972: nvl(ra.receivables_charges_applied,0),
1973: p_batch_id,
1974: FND_GLOBAL.user_id,
1975: trunc(sysdate),
1976: FND_GLOBAL.user_id
1977: FROM
1978: ar_receivable_applications ra,
1979: ar_payment_schedules ps2,
1980: ar_adjustments adj2,

Line 2177: FND_GLOBAL.user_id,

2173: '40.2',
2174: application_type,
2175: p_confirm_gl_date,
2176: code_combination_id,
2177: FND_GLOBAL.user_id,
2178: TRUNC(SYSDATE),
2179: 'N',
2180: p_confirm_gl_date,
2181: FND_GLOBAL.user_id,

Line 2181: FND_GLOBAL.user_id,

2177: FND_GLOBAL.user_id,
2178: TRUNC(SYSDATE),
2179: 'N',
2180: p_confirm_gl_date,
2181: FND_GLOBAL.user_id,
2182: TRUNC(SYSDATE),
2183: payment_schedule_id,
2184: set_of_books_id,
2185: status,

Line 2283: FND_GLOBAL.user_id,

2279: '40.3'),
2280: application_type,
2281: p_confirm_gl_date,
2282: code_combination_id,
2283: FND_GLOBAL.user_id,
2284: TRUNC(SYSDATE),
2285: display,
2286: p_confirm_gl_date,
2287: FND_GLOBAL.user_id,

Line 2287: FND_GLOBAL.user_id,

2283: FND_GLOBAL.user_id,
2284: TRUNC(SYSDATE),
2285: display,
2286: p_confirm_gl_date,
2287: FND_GLOBAL.user_id,
2288: TRUNC(SYSDATE),
2289: payment_schedule_id,
2290: set_of_books_id,
2291: status,

Line 2597: last_updated_by = FND_GLOBAL.user_id

2593: UPDATE ar_receivable_applications
2594: SET reversal_gl_date = p_confirm_gl_date,
2595: display = 'N',
2596: last_update_date = TRUNC(SYSDATE),
2597: last_updated_by = FND_GLOBAL.user_id
2598: WHERE cash_receipt_id = p_cr_rec.cash_receipt_id
2599: AND nvl(confirmed_flag,'Y') = 'Y'
2600: AND reversal_gl_date IS NULL;
2601: