DBA Data[Home] [Help]

APPS.PO_NEGOTIATIONS_SV1 dependencies on FND_PROFILE

Line 544: , p_buyer_id => to_number(FND_PROFILE.VALUE('user_id')) -- IN

540: , p_document_type => x_negotiation_type -- -- IN
541: , p_contract_type => p_neg_outcome -- IN
542: , p_origination_code => 'REQUISITION' -- IN
543: , p_org_id => x_org_id -- IN
544: , p_buyer_id => to_number(FND_PROFILE.VALUE('user_id')) -- IN
545: --
546: , p_neg_style_id => p_neg_style_id -- -- IN
547: , p_po_style_id => p_outcome_style_id -- -- IN
548: , p_fair_opp_notice_flag => p_fair_opp_notice_flag -- IN

Line 1083: , p_buyer_id => to_number(FND_PROFILE.VALUE('user_id'))

1079: ( p_document_number => x_negotiation_id
1080: , p_contract_type => p_neg_outcome
1081: , p_origination_code => 'REQUISITION'
1082: , p_org_id => x_org_id
1083: , p_buyer_id => to_number(FND_PROFILE.VALUE('user_id'))
1084: , p_grouping_type => x_grouping_method
1085: , p_requisition_header_id => x_req_header_id
1086: , p_requisition_number => x_req_num
1087: , p_requisition_line_id => x_req_line_id

Line 1142: -- ' to_number(FND_PROFILE.VALUE(user_id)) = ' || to_number(FND_PROFILE.VALUE('user_id'))

1138:
1139: x_progress := '008';
1140: -- logme( '008 : x_negotiation_id = '|| x_negotiation_id || ' to_char(x_negotiation_id) = ' || to_char(x_negotiation_id)
1141: -- || ' x_negotiation_line_num = '|| x_negotiation_line_num || ' sysdate = '|| SYSDATE ||
1142: -- ' to_number(FND_PROFILE.VALUE(user_id)) = ' || to_number(FND_PROFILE.VALUE('user_id'))
1143: -- || ' x_req_line_id = ' || x_req_line_id);
1144: update po_requisition_lines_all --
1145: set on_rfq_flag = 'Y',
1146: auction_header_id = x_negotiation_id,

Line 1152: last_updated_by = to_number(FND_PROFILE.VALUE('user_id')),

1148: auction_line_number = x_negotiation_line_num,
1149: at_sourcing_flag = 'Y', --
1150: reqs_in_pool_flag = NULL, --
1151: last_update_date = sysdate,
1152: last_updated_by = to_number(FND_PROFILE.VALUE('user_id')),
1153: last_update_login = to_number(FND_PROFILE.VALUE('user_id'))
1154: where requisition_line_id = x_req_line_id ; --5841426
1155:
1156: -- bug# 9887326

Line 1153: last_update_login = to_number(FND_PROFILE.VALUE('user_id'))

1149: at_sourcing_flag = 'Y', --
1150: reqs_in_pool_flag = NULL, --
1151: last_update_date = sysdate,
1152: last_updated_by = to_number(FND_PROFILE.VALUE('user_id')),
1153: last_update_login = to_number(FND_PROFILE.VALUE('user_id'))
1154: where requisition_line_id = x_req_line_id ; --5841426
1155:
1156: -- bug# 9887326
1157: IF ( PON_CLM_UTIL_PKG.IS_NEG_DOCUMENT_FEDERAL(x_negotiation_id) = 1 ) THEN

Line 1187: , p_buyer_id => FND_PROFILE.value('user_id')

1183: , p_line_number => x_negotiation_line_num
1184: , p_shipment_number => -1
1185: , p_price_type => l_price_diff_rec.price_type
1186: , p_multiplier => l_price_diff_rec.min_multiplier
1187: , p_buyer_id => FND_PROFILE.value('user_id')
1188: , p_price_differential_number => l_price_diff_rec.price_differential_num
1189: , p_result => api_result
1190: , p_error_code => api_error_code
1191: , p_error_message => api_error_msg

Line 1308: , p_buyer_id => to_number(FND_PROFILE.VALUE('user_id')) -- IN

1304: , x_return_status => l_return_status -- OUT
1305: , x_msg_count => l_msg_count -- OUT
1306: , x_msg_data => l_msg_data -- OUT
1307: , p_document_number => x_negotiation_id -- IN
1308: , p_buyer_id => to_number(FND_PROFILE.VALUE('user_id')) -- IN
1309: );
1310:
1311: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1312: fnd_log.string(fnd_log.level_statement,g_log_head,'After PON_AUCTION_INTERFACE_PKG.add_negotiation_invitees');

Line 2932: , p_buyer_id => to_number(FND_PROFILE.VALUE('user_id'))

2928: ( p_document_number => p_auction_header_id
2929: , p_contract_type => l_contract_type
2930: , p_origination_code => 'REQUISITION'
2931: , p_org_id => x_org_id
2932: , p_buyer_id => to_number(FND_PROFILE.VALUE('user_id'))
2933: , p_grouping_type => x_grouping_method
2934: , p_requisition_header_id => x_req_header_id
2935: , p_requisition_number => x_req_num
2936: , p_requisition_line_id => x_req_line_id

Line 2990: -- ' to_number(FND_PROFILE.VALUE(user_id)) = ' || to_number(FND_PROFILE.VALUE('user_id'))

2986:
2987: x_progress := '008';
2988: -- logme( '008 : x_negotiation_id = '|| x_negotiation_id || ' to_char(x_negotiation_id) = ' || to_char(x_negotiation_id)
2989: -- || ' x_negotiation_line_num = '|| x_negotiation_line_num || ' sysdate = '|| SYSDATE ||
2990: -- ' to_number(FND_PROFILE.VALUE(user_id)) = ' || to_number(FND_PROFILE.VALUE('user_id'))
2991: -- || ' x_req_line_id = ' || x_req_line_id);
2992: update po_requisition_lines_all --
2993: set on_rfq_flag = 'Y',
2994: auction_header_id = p_auction_header_id,

Line 3000: last_updated_by = to_number(FND_PROFILE.VALUE('user_id')),

2996: auction_line_number = x_negotiation_line_num,
2997: at_sourcing_flag = 'Y', --
2998: reqs_in_pool_flag = NULL, --
2999: last_update_date = sysdate,
3000: last_updated_by = to_number(FND_PROFILE.VALUE('user_id')),
3001: last_update_login = to_number(FND_PROFILE.VALUE('user_id'))
3002: where requisition_line_id = x_req_line_id ;
3003:
3004: -- bug# 9887326

Line 3001: last_update_login = to_number(FND_PROFILE.VALUE('user_id'))

2997: at_sourcing_flag = 'Y', --
2998: reqs_in_pool_flag = NULL, --
2999: last_update_date = sysdate,
3000: last_updated_by = to_number(FND_PROFILE.VALUE('user_id')),
3001: last_update_login = to_number(FND_PROFILE.VALUE('user_id'))
3002: where requisition_line_id = x_req_line_id ;
3003:
3004: -- bug# 9887326
3005: IF ( PON_CLM_UTIL_PKG.IS_NEG_DOCUMENT_FEDERAL(p_auction_header_id) = 1 ) THEN

Line 3030: , p_buyer_id => FND_PROFILE.value('user_id')

3026: , p_line_number => x_negotiation_line_num
3027: , p_shipment_number => -1
3028: , p_price_type => l_price_diff_rec.price_type
3029: , p_multiplier => l_price_diff_rec.min_multiplier
3030: , p_buyer_id => FND_PROFILE.value('user_id')
3031: , p_price_differential_number => l_price_diff_rec.price_differential_num
3032: , p_result => api_result
3033: , p_error_code => api_error_code
3034: , p_error_message => api_error_msg