APPS.IBY_BEPLANGS_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 17

** delete all the rows that blong to this bep.
*/
    delete from iby_beplangs
    where bepid = i_bepid;

Line: 22

** insert preferred language entry in the table.
*/
    insert into iby_beplangs( bepid, beplang, preferred,
	last_update_date, last_updated_by,
	creation_date, created_by,
	last_update_login, object_version_number)
    values (i_bepid, i_preNLSLang, 0,
	 sysdate, fnd_global.user_id,
	 sysdate, fnd_global.user_id,
	fnd_global.login_id, 1);

Line: 34

** insert optional language 1 entry in the table.
*/
    insert into iby_beplangs( bepid, beplang, preferred,
	last_update_date, last_updated_by,
	creation_date, created_by,
	last_update_login, object_version_number)
    values (i_bepid, i_opt1NLSLang, 1,
	 sysdate, fnd_global.user_id,
	 sysdate, fnd_global.user_id,
	fnd_global.login_id, 1);

Line: 45

** insert optional language 2 entry in the table.
*/
    insert into iby_beplangs( bepid, beplang, preferred,
	last_update_date, last_updated_by,
	creation_date, created_by,
	last_update_login, object_version_number)
    values (i_bepid, i_opt2NLSLang, 2,
	 sysdate, fnd_global.user_id,
	 sysdate, fnd_global.user_id,
	fnd_global.login_id, 1);