101:
102: if (p_select_flag = 'Y') then
103:
104: l_creation_date := SYSDATE;
105: l_created_by := FND_GLOBAL.USER_ID;
106: l_last_update_date := SYSDATE;
107: l_last_updated_by := FND_GLOBAL.USER_ID;
108: l_last_update_login := FND_GLOBAL.USER_ID;
109: l_object_version_number := 1;
103:
104: l_creation_date := SYSDATE;
105: l_created_by := FND_GLOBAL.USER_ID;
106: l_last_update_date := SYSDATE;
107: l_last_updated_by := FND_GLOBAL.USER_ID;
108: l_last_update_login := FND_GLOBAL.USER_ID;
109: l_object_version_number := 1;
110:
111: select amw_account_assertion_s.nextval into l_account_assertion_id from dual;
104: l_creation_date := SYSDATE;
105: l_created_by := FND_GLOBAL.USER_ID;
106: l_last_update_date := SYSDATE;
107: l_last_updated_by := FND_GLOBAL.USER_ID;
108: l_last_update_login := FND_GLOBAL.USER_ID;
109: l_object_version_number := 1;
110:
111: select amw_account_assertion_s.nextval into l_account_assertion_id from dual;
112: