234: RETURN;
235:
236: END IF;
237:
238: l_user_id := fnd_global.user_id;
239: l_login_id := fnd_global.login_id;
240: l_exp_date := SYSDATE+7;
241:
242: select paha.auction_header_id , paha.request_id, paha.contract_type, paha.price_tiers_indicator
235:
236: END IF;
237:
238: l_user_id := fnd_global.user_id;
239: l_login_id := fnd_global.login_id;
240: l_exp_date := SYSDATE+7;
241:
242: select paha.auction_header_id , paha.request_id, paha.contract_type, paha.price_tiers_indicator
243: into l_auction_id, l_request_id, l_contract_type, l_price_tiers_indicator
769: AND pipi.project_exp_organization_id IS NOT NULL
770: AND pipi.project_expenditure_item_date IS NOT NULL;
771:
772: BEGIN
773: l_userid := fnd_global.user_id;
774: l_loginid := fnd_global.login_id;
775: l_exp_date := SYSDATE+7;
776:
777:
770: AND pipi.project_expenditure_item_date IS NOT NULL;
771:
772: BEGIN
773: l_userid := fnd_global.user_id;
774: l_loginid := fnd_global.login_id;
775: l_exp_date := SYSDATE+7;
776:
777:
778: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN