[Home] [Help]
1239: sysdate,
1240: g_user_id,
1241: sysdate,
1242: g_user_id,
1243: fnd_global.login_id,
1244: p1.group_line_id,
1245: p1.clm_info_flag,
1246: p1.clm_base_line_num,
1247: p1.clm_option_indicator,
1506: sysdate,
1507: g_user_id,
1508: sysdate,
1509: g_user_id,
1510: fnd_global.login_id
1511: from
1512: pon_auc_price_differ_int pdf_int,
1513: pon_item_prices_interface p1
1514: where
2086: PROJECT_EXPENDITURE_ITEM_DATE = l_project_expenditure_item_dt(x),
2087: WORK_APPROVER_USER_ID = l_work_approver_user_id(x),
2088: LAST_UPDATE_DATE = sysdate,
2089: LAST_UPDATED_BY = g_user_id,
2090: LAST_UPDATE_LOGIN = fnd_global.login_id,
2091: -- CLM: Event Based Delivery Project
2092: CLM_DELIVERY_EVENT_CODE = l_clm_delivery_event_code(x),
2093: CLM_DELIVERY_PERIOD = l_clm_delivery_period(x),
2094: CLM_DELIVERY_PERIOD_UOM = l_clm_delivery_period_uom(x),
2217: sysdate,
2218: g_user_id,
2219: sysdate,
2220: g_user_id,
2221: fnd_global.login_id
2222: FROM
2223: pon_item_prices_interface paip_int,
2224: pon_auc_price_differ_int price_diff_int
2225: WHERE
2806: sysdate,
2807: g_user_id,
2808: sysdate,
2809: g_user_id,
2810: fnd_global.login_id
2811: from
2812: PON_BIDDING_PARTIES PBP
2813: where
2814: PBP.auction_header_id = g_auction_header_id and
2842: tables in the transaction tables.
2843:
2844: IN : p_user_id NUMBER User id of the person who uploaded the spreadsheet
2845: This will be used to update the standard who columns.
2846: We will not use the fnd_global.user_id as this will also
2847: be called from the concurrent program.
2848:
2849: IN : p_party_id NUMBER party id of the person who uploaded the spreadsheet.
2850:
3369: paps.project_exp_organization_id = papi.project_exp_organization_id,
3370: paps.project_expenditure_type = papi.project_expenditure_type,
3371: paps.project_expenditure_item_date = papi.project_expenditure_item_date,
3372: paps.last_update_date = sysdate,
3373: paps.last_updated_by = fnd_global.user_id,
3374: paps.last_update_login = fnd_global.login_id
3375: WHEN NOT MATCHED THEN
3376: INSERT (
3377: PAYMENT_ID ,
3370: paps.project_expenditure_type = papi.project_expenditure_type,
3371: paps.project_expenditure_item_date = papi.project_expenditure_item_date,
3372: paps.last_update_date = sysdate,
3373: paps.last_updated_by = fnd_global.user_id,
3374: paps.last_update_login = fnd_global.login_id
3375: WHEN NOT MATCHED THEN
3376: INSERT (
3377: PAYMENT_ID ,
3378: AUCTION_HEADER_ID ,
3419: papi.PROJECT_EXPENDITURE_TYPE ,
3420: papi.PROJECT_EXP_ORGANIZATION_ID ,
3421: papi.PROJECT_EXPENDITURE_ITEM_DATE ,
3422: SYSDATE ,
3423: fnd_global.user_id ,
3424: SYSDATE ,
3425: fnd_global.user_id ,
3426: fnd_global.login_id
3427: ) ;
3421: papi.PROJECT_EXPENDITURE_ITEM_DATE ,
3422: SYSDATE ,
3423: fnd_global.user_id ,
3424: SYSDATE ,
3425: fnd_global.user_id ,
3426: fnd_global.login_id
3427: ) ;
3428:
3429:
3422: SYSDATE ,
3423: fnd_global.user_id ,
3424: SYSDATE ,
3425: fnd_global.user_id ,
3426: fnd_global.login_id
3427: ) ;
3428:
3429:
3430: IF (g_fnd_debug = 'Y' and FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
3479: UPDATE pon_auction_item_prices_all al
3480: SET modified_flag = 'Y'
3481: , modified_date = SYSDATE
3482: , last_update_date = SYSDATE
3483: , last_updated_by = fnd_global.user_id
3484: , last_update_login = fnd_global.login_id
3485: WHERE al.auction_header_id = p_auction_header_id
3486: AND (EXISTS (
3487: SELECT 1
3480: SET modified_flag = 'Y'
3481: , modified_date = SYSDATE
3482: , last_update_date = SYSDATE
3483: , last_updated_by = fnd_global.user_id
3484: , last_update_login = fnd_global.login_id
3485: WHERE al.auction_header_id = p_auction_header_id
3486: AND (EXISTS (
3487: SELECT 1
3488: FROM pon_auc_payments_shipments pap1,
3756: l_CREATION_DATE(x),
3757: l_LAST_UPDATED_BY(x),
3758: l_LAST_UPDATE_DATE(x),
3759: l_LAST_UPDATE_LOGIN(x),
3760: fnd_global.conc_request_id,
3761: l_ENTITY_TYPE(x),
3762: l_ENTITY_ATTR_NAME(x),
3763: l_ERROR_VALUE_DATE(x),
3764: l_ERROR_VALUE_NUMBER(x),