APPS.PON_VALIDATE_PAYMENTS_INT dependencies on FND_GLOBAL

Line 28: l_userid := fnd_global.user_id;

24: l_entity_name PON_INTERFACE_ERRORS.entity_message_code%TYPE;
25:
26: BEGIN
27:
28: l_userid := fnd_global.user_id;
29: l_loginid := fnd_global.login_id;
30: l_exp_date := SYSDATE + 7;
31: l_interface_type := 'BIDPYMTUPLOAD'; --Radhika-- do i need to change this for Xml upload?
32: l_entity_name := 'PON_AUC_PAYMENTS';

Line 29: l_loginid := fnd_global.login_id;

25:
26: BEGIN
27:
28: l_userid := fnd_global.user_id;
29: l_loginid := fnd_global.login_id;
30: l_exp_date := SYSDATE + 7;
31: l_interface_type := 'BIDPYMTUPLOAD'; --Radhika-- do i need to change this for Xml upload?
32: l_entity_name := 'PON_AUC_PAYMENTS';
33:

Line 651: l_userid := fnd_global.user_id;

647: AND papi.project_expenditure_item_date IS NOT NULL;
648:
649: BEGIN
650:
651: l_userid := fnd_global.user_id;
652: l_loginid := fnd_global.login_id;
653: l_exp_date := SYSDATE + 7;
654: l_interface_type := 'NEGPYMTUPLOAD';
655:

Line 652: l_loginid := fnd_global.login_id;

648:
649: BEGIN
650:
651: l_userid := fnd_global.user_id;
652: l_loginid := fnd_global.login_id;
653: l_exp_date := SYSDATE + 7;
654: l_interface_type := 'NEGPYMTUPLOAD';
655:
656: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

Line 1431: bl.last_updated_by = fnd_global.user_id,

1427: bl.bid_currency_price = bli.bid_currency_price,
1428: bl.price = bli.bid_currency_price/nvl(l_rate,1), --auction currency price
1429: bl.promised_date = bli.promised_date,
1430: bl.last_update_date = sysdate,
1431: bl.last_updated_by = fnd_global.user_id,
1432: bl.last_update_login = fnd_global.login_id
1433: WHEN NOT MATCHED THEN
1434: INSERT (
1435: BID_PAYMENT_ID ,

Line 1432: bl.last_update_login = fnd_global.login_id

1428: bl.price = bli.bid_currency_price/nvl(l_rate,1), --auction currency price
1429: bl.promised_date = bli.promised_date,
1430: bl.last_update_date = sysdate,
1431: bl.last_updated_by = fnd_global.user_id,
1432: bl.last_update_login = fnd_global.login_id
1433: WHEN NOT MATCHED THEN
1434: INSERT (
1435: BID_PAYMENT_ID ,
1436: AUCTION_HEADER_ID ,

Line 1469: fnd_global.user_id ,

1465: bli.BID_CURRENCY_PRICE ,
1466: bli.BID_CURRENCY_PRICE/nvl(l_rate,1) , --Auction currency price
1467: bli.PROMISED_DATE ,
1468: SYSDATE ,
1469: fnd_global.user_id ,
1470: SYSDATE ,
1471: fnd_global.user_id ,
1472: fnd_global.login_id
1473: ) ;

Line 1471: fnd_global.user_id ,

1467: bli.PROMISED_DATE ,
1468: SYSDATE ,
1469: fnd_global.user_id ,
1470: SYSDATE ,
1471: fnd_global.user_id ,
1472: fnd_global.login_id
1473: ) ;
1474:
1475: IF (g_fnd_debug = 'Y' and FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

Line 1472: fnd_global.login_id

1468: SYSDATE ,
1469: fnd_global.user_id ,
1470: SYSDATE ,
1471: fnd_global.user_id ,
1472: fnd_global.login_id
1473: ) ;
1474:
1475: IF (g_fnd_debug = 'Y' and FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1476: l_progress := 'Merge into pon_bid_payments_shipments is successful for batch_id = '||p_batch_id;

Line 1547: LAST_UPDATED_BY = FND_GLOBAL.user_id

1543: --before deleting, set the is_changed_line_flag column for the lines for which
1544: --payments are uploaded in this batch
1545: UPDATE pon_bid_item_prices pbip SET pbip.IS_CHANGED_LINE_FLAG = 'Y',
1546: LAST_UPDATE_DATE = sysdate,
1547: LAST_UPDATED_BY = FND_GLOBAL.user_id
1548: WHERE pbip.line_number IN (
1549: SELECT paip.line_number FROM pon_auction_item_prices_all paip, pon_bid_payments_interface pbpi, pon_bid_payments_shipments pbps WHERE
1550: pbpi.batch_id = p_batch_id AND
1551: paip.auction_header_id = pbpi.auction_header_id AND