DBA Data[Home] [Help]

APPS.PON_OA_UTIL_PKG dependencies on FND_GLOBAL

Line 189: AND pstm.user_id = FND_GLOBAL.user_id;

185: WHERE pst.auction_header_id = pstm.auction_header_id
186: AND pst.team_id = pstm.team_id
187: AND pst.price_visible_flag = 'Y'
188: AND pstm.auction_header_id = p_cur_auction_header_id
189: AND pstm.user_id = FND_GLOBAL.user_id;
190:
191: l_team_id pon_scoring_teams.team_id%TYPE;
192: l_menu_name pon_neg_team_members.menu_name%TYPE;
193:

Line 210: AND user_id = FND_GLOBAL.user_id;

206: SELECT menu_name INTO l_menu_name
207: FROM pon_neg_team_members
208: WHERE auction_header_id = p_auction_header_id
209: AND list_id = -1
210: AND user_id = FND_GLOBAL.user_id;
211:
212: IF ((l_menu_name IS NOT NULL) AND (l_menu_name = 'PON_SOURCING_SCORENEG')) THEN
213: -- if user is a scorer check if on a team that has price visibility
214: OPEN c_price_visibility(p_auction_header_id);

Line 1800: x_created_by => fnd_global.user_id ,

1796: x_rowid => l_rowid ,
1797: x_attached_document_id =>l_attached_document_id,
1798: x_document_id => l_document_id ,
1799: x_creation_date => SYSDATE ,
1800: x_created_by => fnd_global.user_id ,
1801: x_last_update_date => SYSDATE ,
1802: x_last_updated_by => fnd_global.user_id ,
1803: x_last_update_login => fnd_global.login_id ,
1804: x_seq_num => p_seq_num ,

Line 1802: x_last_updated_by => fnd_global.user_id ,

1798: x_document_id => l_document_id ,
1799: x_creation_date => SYSDATE ,
1800: x_created_by => fnd_global.user_id ,
1801: x_last_update_date => SYSDATE ,
1802: x_last_updated_by => fnd_global.user_id ,
1803: x_last_update_login => fnd_global.login_id ,
1804: x_seq_num => p_seq_num ,
1805: x_entity_name => p_entity_name ,
1806: x_column1 => NULL ,

Line 1803: x_last_update_login => fnd_global.login_id ,

1799: x_creation_date => SYSDATE ,
1800: x_created_by => fnd_global.user_id ,
1801: x_last_update_date => SYSDATE ,
1802: x_last_updated_by => fnd_global.user_id ,
1803: x_last_update_login => fnd_global.login_id ,
1804: x_seq_num => p_seq_num ,
1805: x_entity_name => p_entity_name ,
1806: x_column1 => NULL ,
1807: x_pk1_value => p_pk1_value ,